How to pass job parameters in Stored Procedure stage?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Josephine
Participant
Posts: 37
Joined: Mon Jun 16, 2008 2:32 am

How to pass job parameters in Stored Procedure stage?

Post by Josephine »

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?
Josephine
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply