Method and apparatus for executing stored code objects in a database

• US 7,047,249 B1
• Filed: 06/23/2000
• Issued: 05/16/2006
• Est. Priority Date: 12/22/1998
• Status: Expired due to Term

• Current Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: Vincent, John K.
• Primary Examiner(s): Alam, Hosain T.
• Application Number:
  US09/602,441
• Time in Patent Office: 2,153 Days
• Field of Search: 707 2- 4, 707/10, 707/100, 707/102, 717/106, 717/124, 717/125, 717/130, 717/141, 717/143, 717/151
• US Class Current: 1/1
• CPC Class Codes: G06F 11/3688 for test execution, e.g. scheduling of test suites
• CPC Class Codes: G06F 16/2443 Stored procedures
• CPC Class Codes: G06F 8/30 Creation or generation of source code
• CPC Class Codes: G06F 8/427 Parsing
• CPC Class Codes: G06F 8/74 Reverse engineering; Extracting design information from source code
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

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.

Claims

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.