Call to a stored procedure with a three-part name
C and C++ embedded SQL applications can call a stored procedure with a three-part name when the connected database server supports use of three-part names.
A three-part name consists of
schema_name.module_name.procedure_name,
or
schema_name.package_name.procedure_name.
The Db2®
Version 9.7 and later server supports use of three-part names, containing a package name, only if
the DB2_COMPATIBILITY_VECTOR registry variable is set to
ORA.EXEC SQL CALL schema_name.module_name.procedure_name(:parm);
EXEC SQL CALL schema_name.package_name.procedure_name(:parm);