Hello,

I need help on passing parameter to Oracle Stored
Procedure.I am a oracle DBA,need to use some graphs.
I need help to pass date parameter with format YYYYMMDD
from Ab Initio to Oracle STored Procedure.How to do that
please explain me...



Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to us..

Answer / cse70938

RUN SQL COMPONENT

exec proc-name (parameters)
exec proc-name ('$DATE')
exec proc-name ('20080101')

Is This Answer Correct ?    10 Yes 2 No

Post New Answer

More Ab Initio Interview Questions

Can you explain the co>operating system’s processing model?

0 Answers  


How to create project (public,private,common,client) what are the differences between them?

1 Answers   TCS,


How can we RUN a graph in UNIX?

3 Answers  


What is broadcasting and replicate?

0 Answers  


What is conduct>it?

0 Answers  






What is is a data flow graph?

0 Answers  


What are the key elements of a data processing system?

0 Answers  


What is data mapping and data modelling?

0 Answers  


Can you explain the performance and scalability of co> operating system?

0 Answers  


Difference between output_index and output_indexes in reformat

0 Answers  


How to calculate total memory used my a graph?

1 Answers   IBM,


How you can delete an object from a tag ? How to use in abinitio graph?

1 Answers   IBM, TCL,


Categories