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 are the types of data processing you are familiar with?
What dedup-component and replicate component does?
What the difference between “look-up” file and “look is up” in abinitio?
What are the facts that can compromise data integrity?
What is a rollup component? Explain about it.
Why might you create a stored procedure with the with recompile option?
How would you find out whether a sql query is using the indices you expect?
What is the role of co-operating system in abinitio?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
Explain what is sort component in abinitio?
How do you improve the performance of a graph?
how to insert/update a csv file by comparing it with another csv file?
To which project that prefix will set is to private project or public project or both?how and where to set?
How to add default rules in the transformer?
Can you explain the performance and scalability of co> operating system?