Skip to Content
0
Former Member
Dec 05, 2011 at 08:42 PM

Help required in executing the stored procedure and capturing the responce

20 Views

Hi,

I have to execute a stored procedure in oracle database and if it successful then have to create a status IDOC.

The stored procedure may throw an exception(it is not an out parameter), in such cases i should capture the exception as part of the response message and send this information while creating the status IDOC.

i would like if the below is possible.

As the stored procedure is not returning( this means if you execute the procedure manually it will display the result), will it be possible to capture the result which has the exception details?

any direction to this will be highly appreciated.

Many thanks.

Regards,

Rahul