RUN SQL COMPONENT exec proc-name (parameters) exec proc-name ('$DA

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...

Question Posted / cse70938

1 Answers
10581 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

Please Help Members By Posting Answers For Below Questions

Explain what is sort component in abinitio?

1098

What is the function that transfers a string into a decimal?

1149

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

1175

How transaction file different from that of a sort file?

1404

Can you explain the co>operating system’s processing model?

1090

What do you mean by the term data warehousing? Is it different from data mining?

1215

What do you know about partition and also tell us about partition components in abinitio?

1053

Explain data flow graph with an example?

1121

How do you truncate a table?

1167

What is is a data flow graph?

1113

Tell us about the architecture of abinitio.

1093

When we should use 'jobid' for commit table (Output table component??

9080

What is de-partition in abinitio?

1360

How data is processed and what are the fundamentals of this approach?

1140

Explain how you can run a graph infinitely in ab initio?

1113