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

I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?

1 Answers  


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

0 Answers  


What are the components new in 2.14 compared to 1.8 and State the usage of the components?

0 Answers  


In abinitio, what types of parallelism are used?

0 Answers  


Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

0 Answers  






What are the benefits of data analyzing?

0 Answers  


Runtime behavior of Normalize and Reformat

0 Answers  


why Skew should always be 0 ? How to use in abinitio graph?

1 Answers   IBM, TCL,


Mention what is the role of co-operating system in abinitio?

1 Answers  


What is the purpose of having stored procedures in a data-based?

0 Answers  


How can you connect eme to abinitio server?

1 Answers  


Hi friends, i have input like below naresh 10,20 suresh 30,40 i want out put like naresh 10 naresh 20 suresh 30 suresh 40 please help me thank you

3 Answers  


Categories