US 12,730,808 B2
Table-valued parameter for call statement
Daeho Kim, Yongin (KR); Hyojin Ha, Seoul (KR); Hyung Jo Yoon, Yongin (KR); and Kyungwook Ko, Seongnam (KR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Sep. 13, 2024, as Appl. No. 18/884,623.
Prior Publication US 2026/0079935 A1, Mar. 19, 2026
Int. Cl. G06F 16/2453 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01)
CPC G06F 16/24542 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2443 (2019.01)] 8 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving, at a database management system (DBMS), a call to a stored procedure via a structured query language (SQL) query, the call comprising a first table value parameter corresponding to a first external table and a second table value parameter corresponding to a second external table;
receiving a prepare call for the stored procedure that includes the first table value parameter corresponding to the first external table and the second table value parameter corresponding to the second external table;
generating, in response to the prepare call, metadata including metadata indicative of a first format of the first table value parameter and a second format of the second table value parameter;
obtaining, by the DBMS and from a client device storing the first external table and the second external table, a first bit stream of parameters from the first external table using the first table value parameter and a second bit stream of parameters from the second external table using the second table value parameter;
transmitting the metadata to the client device;
decoding, at a session layer, the first bit stream into a first internal table and the second bit stream into a second internal table, wherein the first internal table is mapped to a first query parameter index and the second internal table is mapped to a second query parameter index; and
passing, by the DBMS and to the called stored procedure, the first bit stream of parameters and the second bit stream of parameters for execution of the SQL query.