Hello, I need help on passing parameter to Oracle Stored Procedure.I am a o

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 / sheker2

1 Answers
10679 Views
I also Faced
E-Mail Answers

Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to us..

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

Post New Answer

More Ab Initio Interview Questions

What is de-partition in abinitio?

0 Answers

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

0 Answers

What are the steps to create a repository in ab initio?

0 Answers

How do we handle if DML changing dynamicaly?

5 Answers GE, HP, IBM, Mannar Company,

Can we specify checkpoints without Phases?

3 Answers IBM, Tech Mahindra,

what is difference between fuse and join? Explain in detail? In which scenario we will use them?

1 Answers IBM,

You can ask about different vector functions. How to use in abinitio graph?

0 Answers IBM, TCL,

How to Create Surrogate Key using Ab Initio?

6 Answers IBM,

what is the use of catlog or catlogfile?

0 Answers

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

0 Answers

What is .abinitiorc and What it contain?

3 Answers CSC,

What is conditional DML and Structured DML?

2 Answers Accenture,

For more Ab Initio Interview Questions Click Here