The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 21, 1998
Filed:
Aug. 31, 1995
John Shek-Luen Ng, San Jose, CA (US);
Frederick Thomas Sharp, Menlo Park, CA (US);
Mir Hamid Pirahesh, San Jose, CA (US);
I-Shin Andy Wang, San Jose, CA (US);
Gerald Herman Roth, San Jose, CA (US);
Tak Ming Lo, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A system and method for passing arrays and structures as host variables to a stored procedure. An application program packs an array or structure into a binary large object (BLOB) and sends the BLOB to a database management system. An adapter called by the database management system, and coupled to the stored procedure, passes a reference to the data area in the BLOB to the stored procedure. After completion of the stored procedure, the BLOB is returned to the application program. Finally, upon the return from the stored procedure call, the application program unpacks the BLOB back into the array or structure.