How good are you with your PL/SQL?

On the scale of 1-10 say 8.5-9 
  • Interview Candidate
  • 2
  • 2624

Showing Answers 1 - 2 of 2 Answers

padmanabhan.s

  • Jul 29th, 2008
 

Though we dont write the PL/SQL directly, we can write a procedure or a fucntion which determines our needs and then can be called in the datastage ODBC or OCI stage using call() statement. For eg. if the procdeure name is xyz, then we can just call the procedure in the said stage as "call(xyz);" which will invoke the procedure and load the required tables used for the transformation.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions