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...
- 1 Answers
- 10147 Views
- I also Faced
- E-Mail Answers
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
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
Why is data processing considered beneficial?
How does the bre work with the co>operating system?
What do you know about abinitio?
What is common among data validity and data integrity?
What does it mean by the term 'sort component'?
What is the importance of eme in abinitio?
How can we increase the loading performance of oracle table in AbInitio?
What are the fundamental blocks of co> operating system of ab initio?
Within a cursor, how would you update fields on the row just fetched?
What is abinitio?
What are the primary keys and foreign keys?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
What do you mean by the term data warehousing?
Explain about ab initio’s dependency analysis?
