US5862378A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Passing arrays to stored procedures
Assignee: International Business Machines Corp
•
Filing: 1996-05-31
•
Granted: 1999-01-19
•
Expires: 2016-05-31
Abstract
Abstract A method, apparatus, and article of manufacture for passing a VisualBasic array argument to an SQL stored procedure executed by a computer. The VisualBasic array is first created in the memory of the computer and comprises an object. The array is then passed to a C or C++ function in the memory of the computer. The function to which the array is passed is declared as an alias for another function within VisualBasic. Execution of the function by the computer returns a handle for the passed array. Finally, the handle is passed to the SQL stored procedure in the memory of the computer, and is accessed by the stored procedure during execution by the computer.
Inventors
- 👤 I-Shin Andy Wang
- 👤 John Luen Ng
- 👤 Judianto Sidik
- 👤 Frederick Thomas Sharp
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 16:15
CPC Classifications
G; G06; G06F; G06F9/00; G06F9/06; G06F9/44; G06F9/448; G06F9/4482; G06F9/4484; G06F9/4486; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 24
Claim 1
Independent Claim
107 words
A method of passing an array argument to a stored procedure executed by a computer, comprising the steps of: (a) creating the array in a memory of the computer wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is an alias for another function in the memory of the computer; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 2
Independent Claim
107 words
A method of passing an array argument to a stored procedure executed by a computer, comprising the steps of: (a) creating the array in a memory of the computer wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is an alias for another function in the memory of the computer; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 3
Independent Claim
99 words
A method of passing an array argument to a stored procedure executed by a computer, comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object and wherein the array is a VisualBasic array. (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array: and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 4
Independent Claim
99 words
A method of passing an array argument to a stored procedure executed by a computer, comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object and wherein the array is a VisualBasic array. (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array: and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 5
Independent Claim
99 words
A method of passing an array argument to a stored procedure executed by a computer, comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is a C function; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 6
Independent Claim
99 words
A method of passing an array argument to a stored procedure executed by a computer, comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is a C function; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 7
Independent Claim
101 words
A method of passing an array argument to a stored procedure executed by a computer, comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle and wherein the stored procedure is an SQL stored procedure.
Claim 8
Independent Claim
101 words
A method of passing an array argument to a stored procedure executed by a computer, comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle and wherein the stored procedure is an SQL stored procedure.
Claim 9
Independent Claim
128 words
An apparatus for passing an array argument to a stored procedure executed by a computer, comprising: (a) a computer having a memory; (b) means, performed by the computer, for creating the array in a memory of the computer, wherein the array is an object; (c) means, performed by the computer, for passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is an alias for another function in the memory of the computer; and (d) means, performed by the computer, for passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 10
Independent Claim
128 words
An apparatus for passing an array argument to a stored procedure executed by a computer, comprising: (a) a computer having a memory; (b) means, performed by the computer, for creating the array in a memory of the computer, wherein the array is an object; (c) means, performed by the computer, for passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is an alias for another function in the memory of the computer; and (d) means, performed by the computer, for passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 11
Independent Claim
120 words
An apparatus for passing an array argument to a stored procedure executed by a computer, comprising: (a) a computer having a memory; (b) means, performed by the computer, for creating the array in a memory of the computer, wherein the array is an object and wherein the array is a VisualBasic array; (c) means, performed by the computer, for passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (d) means, performed by the computer, for passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 12
Independent Claim
120 words
An apparatus for passing an array argument to a stored procedure executed by a computer, comprising: (a) a computer having a memory; (b) means, performed by the computer, for creating the array in a memory of the computer, wherein the array is an object and wherein the array is a VisualBasic array; (c) means, performed by the computer, for passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (d) means, performed by the computer, for passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 13
Independent Claim
120 words
An apparatus for passing an array argument to a stored procedure executed by a computer, comprising: (a) a computer having a memory; (b) means, performed by the computer, for creating the array in a memory of the computer, wherein the array is an object; (c) means, performed by the computer, for passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is a C function; and (d) means, performed by the computer, for passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 14
Independent Claim
120 words
An apparatus for passing an array argument to a stored procedure executed by a computer, comprising: (a) a computer having a memory; (b) means, performed by the computer, for creating the array in a memory of the computer, wherein the array is an object; (c) means, performed by the computer, for passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is a C function; and (d) means, performed by the computer, for passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 15
Independent Claim
122 words
An apparatus for passing an array argument to a stored procedure executed by a computer, comprising: (a) a computer having a memory; (b) means, performed by the computer, for creating the array in a memory of the computer wherein the array is an object; (c) means, performed by the computer for passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (d) means, performed by the computer, for passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle and wherein the stored procedure is an SQL stored procedure.
Claim 16
Independent Claim
122 words
An apparatus for passing an array argument to a stored procedure executed by a computer, comprising: (a) a computer having a memory; (b) means, performed by the computer, for creating the array in a memory of the computer wherein the array is an object; (c) means, performed by the computer for passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (d) means, performed by the computer, for passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle and wherein the stored procedure is an SQL stored procedure.
Claim 17
Dependent Claim
129 words
A program storage device, readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps for passing an array argument to a stored procedure executed by the computer, the method comprising the steps of: (a) creating the array in a memory of the computer wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is an alias for another function in the memory of the computer; and (c) passing the handle to the stored procedure in the memory of the computer wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 18
Dependent Claim
129 words
A program storage device, readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps for passing an array argument to a stored procedure executed by the computer, the method comprising the steps of: (a) creating the array in a memory of the computer wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array and wherein the function is an alias for another function in the memory of the computer; and (c) passing the handle to the stored procedure in the memory of the computer wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 19
Dependent Claim
121 words
A program storage device, readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps for passing an array argument to a stored procedure executed by the computer the method comprising the steps of: (a) creating the array in a memory of the computer, wherein the away is an object and wherein the array is a VisualBasic array; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 20
Dependent Claim
121 words
A program storage device, readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps for passing an array argument to a stored procedure executed by the computer the method comprising the steps of: (a) creating the array in a memory of the computer, wherein the away is an object and wherein the array is a VisualBasic array; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 21
Dependent Claim
121 words
A program storage device, readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps for passing an array argument to a stored procedure executed by the computer, the method comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object; (b) passing the array to a function in the memory of the computer wherein execution of the function by the computer returns a handle for the passed array and wherein the function is a C function; and (c) passing the handle to the stored procedure in the memory of the computers wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 22
Dependent Claim
121 words
A program storage device, readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps for passing an array argument to a stored procedure executed by the computer, the method comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object; (b) passing the array to a function in the memory of the computer wherein execution of the function by the computer returns a handle for the passed array and wherein the function is a C function; and (c) passing the handle to the stored procedure in the memory of the computers wherein execution of the stored procedure by the computer accesses the passed handle.
Claim 23
Dependent Claim
123 words
A program storage device, readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps for passing an array argument to a stored procedure executed by the computer the method comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle and wherein the stored procedure is an SQL stored procedure.
Claim 24
Dependent Claim
123 words
A program storage device, readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps for passing an array argument to a stored procedure executed by the computer the method comprising the steps of: (a) creating the array in a memory of the computer, wherein the array is an object; (b) passing the array to a function in the memory of the computer, wherein execution of the function by the computer returns a handle for the passed array; and (c) passing the handle to the stored procedure in the memory of the computer, wherein execution of the stored procedure by the computer accesses the passed handle and wherein the stored procedure is an SQL stored procedure.
References Cited (Backward Citations)
US5689709A
Cited
US5469574A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-01-18 | 2002-07-20 | 2003-01-19 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-01-18 | 2006-07-20 | 2007-01-19 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-01-18 | 2010-07-20 | 2011-01-19 | $7700.00 | Window Closed / Lapsed |