Patent · US Expired

System, method and computer program product for passing host variables to a database management system

US5742810A · kind A · utility

45Cited by
16References
34Claims
0Family size

Assignee

Inventors

Key dates

Filing dateAug 31, 1995
Grant dateApr 21, 1998
Priority date
Expiry dateAug 31, 2015

Classification

  • Technology area (CPC Y)Emerging Cross-Sectional Technologies
  • CPC primaryY10S707/99942
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.