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

How can I run the 2 gui merge files?

0 Answers  


What do you understand by local lookup?

0 Answers  


Have you ever encountered an error called “depth not equal”?

0 Answers  


What are the operations that support avoiding duplicate record?

0 Answers  


If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.

2 Answers  






I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

0 Answers  


Can we specify checkpoints without Phases?

3 Answers   IBM, Tech Mahindra,


Mention what information does a .dbc file extension provides to connect to the database?

0 Answers  


What is the difference between a DB config and a CFG file?

9 Answers   Wipro,


Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

0 Answers  


What is the use of the co> operating system in ab initio?

0 Answers  


How will you check the latest versions in EME?

6 Answers  


Categories