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
Stored Procedure
Moderators: chulett, rschirm, roy
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?
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?
Pradeep Kumar
You can use OCI stage to do this.Try using the following sqlpradkumar wrote: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?
select function_name('a','b')
from dual
I think this shud work, give it a try.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why? Won't "they" let you use the right tool for the job? Do they require their tradesmen to drive screws with hammers?pradkumar wrote:Moreover I am restricted to use Dynamic RDBMS stage
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.