cancel
Showing results for 
Search instead for 
Did you mean: 

Help required in executing the stored procedure and capturing the responce

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

>any direction to this will be highly appreciated.

You can write JDBC call using UDF during mapping and based on the resultset value you can decide creating the status of idoc. This is one possible option.

refer these links for UDF codes:

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Former Member
0 Kudos

@Bhaskar,

i need to execute the procedure by sending the input data from a file and capture the result after executing the procedure to create a status idoc

im not sure how the provided links helps me here.

i m not looking for any look ups. i would like to know is there any way that we can capture the result after executing the database procedure?

Edited by: Rahul_10416 on Dec 5, 2011 10:07 PM