Method and mechanism for providing external procedures to a database system
AssigneeOracle International Corporation
InventorsMichael Chiocca, Nancy Ikeda, Beethoven Cheng
Life of this patent
Estimating the term…
Abstract
The present invention is directed to a method and mechanism for calling on external procedure in a database system in which the external procedure contains embedded database query language statements. According to an aspect of the invention, the external procedure executes using the same database connection and transaction as the original calling entity for that external procedure.
Claims33
A process for executing an external procedure in a database system comprising:
- identifying connection information for an entity that calls an external procedure, said external procedure is a hybrid programming language program, said hybrid programming language program comprising a general purpose programming language statement and an embedded database query language statement, said embedded database query language statement calls into a database system, said connection information identifying a specific session opened by said entity;
- mapping said connection information to equivalent connection data structures maintained for said external procedure;
- and
- executing said embedded database query language statement within said specific session previously opened by said entity.
A process for executing an external procedure in a database system comprising:
- receiving a request to execute an external procedure, said request made by an entity having opened a connection to a database server;
- invoking said external procedure, said external procedure is a hybrid programming language program, said hybrid programming language program comprising a general purpose programming language statement and an embedded database query language statement;
- retrieving runtime context information for said connection;
- and
- executing said external procedure within said connection by using said retrieved runtime context information.
A computer program product that includes a computer readable medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by said processor, causes said processor to execute a process for executing an external procedure in a database system, said process comprising:
- identifying connection information for an entity that calls an external procedure, said connection information identifying a specific session opened by said entity, said external procedure is a hybrid programming language program, said hybrid programming language program comprising a general purpose programming language statement and an embedded database query language statement, said embedded language statement calls into a database system;
- mapping said connection information to equivalent connection data structures maintained for said external procedure;
- and
- executing said embedded database query language statement within said specific session previously opened by said entity.
A computer program product that includes a computer-readable medium usable by a processor, the medium having stored theron a sequence of instructions which, when executed by said processor, causes said processor to execute a process for executing an external procedure in a database system, said process comprising:
- receiving a request to execute an external procedure, said request made by an entity having opened a connection to a database server;
- invoking an external procedure, said external procedure is a hybrid programming language program, said hybrid programming language program comprising a general purpose programming language statement and an embedded database query language statement;
- retrieving runtime context information for said connection;
- and
- executing said exteral procedure within said connection by using said retrieved runtime context information.
Dependencies are inferred from the claim text.