Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10610 Views
- I also Faced
- E-Mail Answers
Answer / cse70938
RUN SQL COMPONENT
exec proc-name (parameters)
exec proc-name ('$DATE')
exec proc-name ('20080101')
| Is This Answer Correct ? | 10 Yes | 2 No |
State the working process of decimal_strip function?
Can you read multiple input files using one input file component ?(same DML)
What is the best way of creating huge test feeds?
What is a partition and what are the different types of partition components in abinitio?
What kind of layouts does abinitio support?
Do you think effective communication is necessary for data processing?
Describe how you would monitor and control database physical file size and growth?
Have you used the rollup component? Describe how?
how can you convert 3 way to 7way partitioning in abinitio?
what is the output when -1 is put in select_expr of FBE?
What is the difference between a utility and api in a RUN SQL component
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
Teradata 
