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.

Back to top

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