Stored Procedure

[pradkumar]

I used a normal job activity..

I figured it out in one way. I am atatching the file in the notification activity.

Do you suggest anyother way

[pradkumar]

Could anyone let me know, How to call a Function which is in oracle.
Actually First my Stored Procedure has to execute and after the suuccesful execution, the function has to be called.

My function is taking two input parameters
The source code of my function is osmewhat like this:
CREATE OR REPLACE FUNCTION Function_name
(asdsa IN VARCHAR2,
dsdsd IN VARCHAR2
)
RETURN number AS
------
How this can be accomplished?

[dsscholar]

Could anyone let me know, How to call a Function which is in oracle.
Actually First my Stored Procedure has to execute and after the suuccesful execution, the function has to be called.

My function is taking two input parameters
The source code of my function is osmewhat like this:
CREATE OR REPLACE FUNCTION Function_name
(asdsa IN VARCHAR2,
dsdsd IN VARCHAR2
)
RETURN number AS
------
How this can be accomplished?

You can use OCI stage to do this.Try using the following sql

select function_name('a','b')
from dual

I think this shud work, give it a try.

[pradkumar]

But my function has to get executed when my procedure completes its execution.

Moreover I am restricted to use Dynamic RDBMS stage

[ray.wurlod]

Moreover I am restricted to use Dynamic RDBMS stage

Why? Won't "they" let you use the right tool for the job? Do they require their tradesmen to drive screws with hammers?