Receiver JDBC Adapter

[Former Member]

I am calling a Oracle Stored Procedure using Receiver JDBC Adapter. If the stored procedure returns a null value JDBC Adapter is throwing a Delivery Exception due to Null pointer Exception.

I would like to get this as a response with blank value in the data.

Any ideas. Please help.

Regards

Mike

[moorthy]

If you want to get blank value, it is better to deal in the stored procedure itself. Because you have more control over there.

Regards,

moorthy

[bhavesh_kantilal]

Mike,

Just an option, in the stored procedure, check if the return value is NULL and send a BLANK STRING instead of a NULL . Am not sure how the same can be handled in the JDBC adapter but this can be easily circumvented in the Stroed Procedure itself right?

Regards,

Bhavesh