STP stage..

[allavivek]

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

[chulett]

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.