Hi,
I have a Stored Procedure which needs to be triggered by the datastage job. The Procedure starts based on the sequence number in oracle and inserts records into table.
Procedure has to trigger as the job starts and the Procedure is not having any Input Parameters.
I tried with the STP stage as target passing a dummy column. I got couple of errors like,
STP2..Stored_Procedure_0: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'OD_CL_RMS_QUE_IO' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
The STP which is target will not accept any parameters but still i am getting the above error.
STP2..Stored_Procedure_0: ORA-01036: illegal variable name/number
I am not sure what is happening, can anyone suggest whats going wrong and what to do...
Thanks in advance./
Call STP
Moderators: chulett, rschirm, roy