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...

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for m_dump in abinitio?

1320


What do you know about partition and also tell us about partition components in abinitio?

805


What exactly do you know about the typical data analysis?

805


What is common among data validity and data integrity?

779


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

854


How does the bre work with the co>operating system?

827


How to create a repository in abinitio for stand-alone system(local nt)?

860


What is the core of co> operating system?

841


Why is data processing considered beneficial?

786


What information is provided by .dbc file extension for connecting to the database?

911


What do you mean by the overflow errors?

1039


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

872


Do you think effective communication is necessary for data processing? What is your strength in terms of same?

885


Mention what is rollup component?

846


What is the difference between rollup and scan?

1523