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 would be the next step after collecting the data?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What are “business rules” in ab initio business rules environment (bre)?
What do you mean by data sorting?
What is common among data validity and data integrity?
What does edp stand for?
Mention what dedup-component and replicate component does?
What is the purpose of having stored procedures in a database?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
Tell us about the architecture of abinitio.
What is the importance of eme in abinitio?
What is the function that transfers a string into a decimal?
Why do you think data processing is important?
What does de-partition mean in abinitio?
Describe the evaluation of parameters order in ab initio?