Hi,
Please find my mapping and flow below:
Transformer->SP and i pass the dummy variable and gave constraint like '@OUTROWNUM=1'
My procedure has two input parameter.
Now I want to pass the job parameters in procedure parameter.
while running, i got the following error:
ORA-01401: inserted value too large for column ORA-06512: at "OF_DEV.PKG_RANK_RULE", line 306 ORA-00999: invalid view name ORA-06512: at line 1
how to solve this issue?
How to pass job parameters in Stored Procedure stage?
Moderators: chulett, rschirm, roy