ksc_run_plsql_procedure
Use this command to call a PLSQL procedure.
Syntax
This command has the following syntax:
ksc_run_plsql_procedure <PL/SQL package name>.<procedure name><PARAMETER_NAME>.<SQLTYPE>.<INOUT or IN or OUT>=<VALUE>ksc_end_plsql_parameters
Note: The SQL parameter only supports the varchar
and integer
data types.
Example
Here's an example using ksc_run_plsql_procedure:
ksc_run_plsql_procedure KCRT_REQUEST_INT.RUN_INTERFACE P_GROUP_ID.INTEGER.INOUT=[P.P_GROUP_ID] P_SOURCE.VARCHAR.IN=[P.P_SOURCE_CODE] P_USR_DBG.INTEGER.IN=0 P_USER_ID.INTEGER.IN=[RP.CREATED_BY] O_MESSAGE_TYPE.INTEGER.OUT o_MESSAGE_NAME.VARCHAR.OUT O_MESSAGE.VARCHAR.OUT ksc_end_plsql_parameters