US7047249B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for executing stored code objects in a database
Assignee: CA Inc
•
Filing: 2000-06-23
•
Granted: 2006-05-16
•
Expires: 2020-06-23
Abstract
Abstract 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.
Inventors
- 👤 John K. Vincent
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 16:02
CPC Classifications
G; G06; G06F; G06F8/00; G06F8/40; G06F8/70; G06F8/74; G06F11/00; G06F11/36; G06F11/3668; G06F11/3672; G06F11/3688; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2433; G06F16/2443; G06F8/30; G06F8/41; G06F8/42; G06F8/427; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99941; Y10S707/99942; Y10S707/99943
Claims Analysis
Total Claims: 3
Claim 1
Independent Claim
78 words
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.
Claim 2
Independent Claim
78 words
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.
Claim 3
Dependent Claim
36 words
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.
References Cited (Backward Citations)
US4953084A
Cited
US5187788A
Cited
US5226162A
Cited
US5361351A
Cited
US5359546A
Cited
US5495571A
Cited
US5519859A
Cited
US5561763A
Cited
US5526485A
Cited
US5701471A
Cited
US5675730A
Cited
US5761510A
Cited
US5664173A
Cited
US5732210A
Cited
US5862378A
Cited
US5802523A
Cited
US5655973A
Cited
US6003039A
Cited
US6108659A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2009-05-15 | 2009-11-14 | 2010-05-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2013-05-15 | 2013-11-14 | 2014-05-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2017-05-15 | 2017-11-14 | 2018-05-16 | $7700.00 | Window Closed / Lapsed |