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
What is a partition?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
What does edp stand for?
Describe the evaluation of parameters order in ab initio?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
What is the difference between dml expression and xfr expression?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
can we perform checkin and checkout through sandbox?
What are the facts that can compromise data integrity?
How data is processed and what are the fundamentals of this approach?
What is common among data validity and data integrity?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
Have you ever encountered an error called “depth not equal”?
What metadata importer can do in ab initio?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?