Dave Tolls wrote:Assuming this "Java Object" is a serialised instance of your DVO then you are going to need to write some Java code to convert that back to a Java object and then pick out the data you want.
I don't know what state Java in Oracle is in, but that would be the place to do it and call that Java stored procedure from your PL/SQL to get the info you need.
As for how to write that, you'll need to dig up the Oracle documentation for your version.
Dave Tolls wrote:Assuming this "Java Object" is a serialised instance of your DVO then you are going to need to write some Java code to convert that back to a Java object and then pick out the data you want.
I don't know what state Java in Oracle is in, but that would be the place to do it and call that Java stored procedure from your PL/SQL to get the info you need.
As for how to write that, you'll need to dig up the Oracle documentation for your version.
Thanks Dave. Yours Assuming is right. "Java Object" is a serialised instance of DVO and it is inserting in table. Below is the code.
Finally arrByteArrOpStrm is inserting in blob column of a table and Yes, java code is there is convert back.
But we need handle this in PL/SQL Procedure.