Method, system and equipment for returning out parameter value of dynamic SQL (Structured Query Language) statement of database

Abstract

The invention relates to the technical field of database management, and provides an out parameter value returning method, system and equipment for a dynamic SQL (Structured Query Language) statement of a database, which comprises the following steps of: analyzing the dynamic SQL statement, identifying a binding parameter and a parameter mode thereof in a USING clause of the dynamic SQL statement, and generating and initializing a parameter management structure; the parameter management structure is adapted to a parameter format executable by an SQL engine, and a parameter assignment callback function is registered in the parameter management structure; calling an SQL engine to execute the dynamic SQL statement, calling a parameter-out assignment callback function by the SQL engine when a parameter value needs to be transmitted out, writing the transmitted value back to the parameter management structure, and marking an update state; after the dynamic SQL statement is executed, according to the parameter mode state and the value updating state in the parameter management structure, the assigned OUT or IN OUT parameters are screened out, and the values of the OUT or IN OUT parameters are written back to the corresponding PL / SQL program variables. According to the method, completeness and native support of standard parameter passing semantics can be realized, and the function completeness and programming flexibility of a database system are enhanced.

Images