External Procedures
External Procedures
- Oracle8 provides “call out” ability from server-based Object Type methods and stored procedures to 3GL functions
- Dynamic linking and loading
- Call-outs from PL/SQL stored procedures to 3GL functions
- 3GL function can call-back database via OCI
- Object Type instance attributes and scalar types used for argument passing
- “Secure” external procedure where 3GL executes in separate address space from PL/SQL stored procedure