How to execute stored procedure in Oracle BRM

Opcode name that need to be used to execute the stored procedure in BRM is “PCM_OP_EXEC_SPROC”.

PCM_OP_EXEC_SPROC input flist:

# number of field entries allocated 20, used 4
0 PIN_FLD_POID           POID [0] 0.0.0.4 /procedure -1 0
0 PIN_FLD_PROC_NAME       STR [0] "CUSTOM_STORED_PROC_NAME"
0 PIN_FLD_ARGS          ARRAY [1] allocated 20, used 1
1     PIN_FLD_FETCH_SIZE      INT [0] 10000
0 PIN_FLD_RESULTS       ARRAY [*] allocated 20, used 3
1     PIN_FLD_TYPE           ENUM [0] 0
1     PIN_FLD_AMOUNT       DECIMAL [0] 0
1     PIN_FLD_INFO            STR [0] ""

• Tweet
• Share
• Share
• Share
• Share