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


Please Help Members By Posting Answers For Below Questions

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2566


Why is data processing considered beneficial?

808


How does the bre work with the co>operating system?

849


What do you know about abinitio?

1001


What is common among data validity and data integrity?

804


What does it mean by the term 'sort component'?

885


What is the importance of eme in abinitio?

905


How can we increase the loading performance of oracle table in AbInitio?

884


What are the fundamental blocks of co> operating system of ab initio?

972


Within a cursor, how would you update fields on the row just fetched?

857


What is abinitio?

931


What are the primary keys and foreign keys?

792


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

1213


What do you mean by the term data warehousing?

848


Explain about ab initio’s dependency analysis?

877