DSXchange

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?

So, two problems?

1. Define two fields on the link from the transformer. Set their derivations to the Job Parameters. Use in the proc.

2. Your proc is broken, either by bad params or faulty code I would guess.