Method and apparatus for executing stored code objects in a database
View Patent ↗A system, method and database development tool are disclosed for automatically generating parameters for use in executing a stored code object in a data base, by parsing source code derived from existing data base code which represents the stored code object, wherein the parameters may represent complex data types.
1. A method for executing subprograms in an Oracle database, using a computer which has at least a processor, memory, display input/output devices comprizing the steps of:
a) selecting a subprogram from an Oracle catalog;
b) generating an executable anonymous block using parameter values indicated by data extracted from the subprogram;
c) using the anonymous block to execute the subprogram; and
d) using a program mechanism that outputs OUT parameter values after the execution of the subprogram is completed.
2. The method of claim 1 comprising the additional step of constructing statements to output OUT parameter values by obtaining OUT parameter information from a parameter list that is constructed by extracting parameter information from the subprogram.