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

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

1 Answers  


I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

1 Answers  


How to implement the funtionality in the custom component to use in the graph?

1 Answers  


How to move or copy the project parameter or project object to my sandbox?

1 Answers  


What are the factors on which storage of data depends?

1 Answers  


how to insert/update a csv file by comparing it with another csv file?

1 Answers  


Describe the grant/revoke ddl facility and how it is implemented?

1 Answers  


Mention what are the different types of parallelism used in abinitio?

1 Answers  


. What is adhoc multifiles? How to use in abinitio graph?

1 Answers   IBM,


What is Is_defined(), Is_null(), Is_Blank()?

1 Answers   TCS,


Describe which system or process elements you would review when trouble-shooting general server slows ?

1 Answers  


How co>operating system integrates with legacy codes?

1 Answers  


Categories