Hi Friends,
I had a requirement to fetch image from database table as base64binary and sent it to the third party in the same format.
As we do regularly, i used select query(execute pure sql and select query option in DB adapter) and implemented but it didn't worked as expected. It was returning something like below image in BPEL Console.It was unable to parse in the proper format.
We raised SR with oracle and came to know that this is because of the bug in DB Adapter while using select or execute pure sql option.
To achieve this we need to create a procedure /function from the same sql query and and use the option stored procedure or function execution in DB Adapter. It worked for this option.
Thanks.
I had a requirement to fetch image from database table as base64binary and sent it to the third party in the same format.
As we do regularly, i used select query(execute pure sql and select query option in DB adapter) and implemented but it didn't worked as expected. It was returning something like below image in BPEL Console.It was unable to parse in the proper format.
We raised SR with oracle and came to know that this is because of the bug in DB Adapter while using select or execute pure sql option.
To achieve this we need to create a procedure /function from the same sql query and and use the option stored procedure or function execution in DB Adapter. It worked for this option.
Thanks.
No comments:
Post a Comment