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
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What happens when we provide null key to sort, merge and pbks in Abinitio ?
What are the features of ab initio?
Explain what is sort component in abinitio?
How can a graph be run infinitely?
What is the difference between dml expression and xfr expression?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What do you understand by local lookup?
What do you understand by overflow errors?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
What is broadcasting and replicate?
How do you add default rules in the transformer?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
Define ramp limit in ab initio?