Sunday, 25 June 2017

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:
  1. # number of field entries allocated 20, used 4
  2. 0 PIN_FLD_POID POID [0] 0.0.0.4 /procedure -1 0
  3. 0 PIN_FLD_PROC_NAME STR [0] "CUSTOM_STORED_PROC_NAME"
  4. 0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
  5. 1 PIN_FLD_FETCH_SIZE INT [0] 10000
  6. 0 PIN_FLD_RESULTS ARRAY [*] allocated 20, used 3
  7. 1 PIN_FLD_TYPE ENUM [0] 0
  8. 1 PIN_FLD_AMOUNT DECIMAL [0] 0
  9. 1 PIN_FLD_INFO STR [0] ""