DSXchange

Hi All,

I was going through a job where the target was STP stage...The procedure statement is as follows..

BEGIN #$SPD_USERNAME#.P_SPD_DISASSEMBLY_TRT(:1,:2,:3,:4); END;

the input to this stage have 4 columns..

My doubt is

1.Are the parameters :1,:2,:3,:4 corresponds to input columns..
2.can we use execute statement instead of begin end for storing values..

Thank you...

1. Yes, they are numbered bind parameters that correspond to the column numbers.
2. Why? Using 'anonymous block', i.e. BEGIN/END syntax is the proper way to be doing this. Assuming Oracle here, btw.