Plz--Urgent: retrieving Hexa decimal value from Stored Procedure

[ Follow Ups ] [ Post Followup ] [ Intranet eXchange ] [ IDM Home ]

Posted by Y.Satish Babu on February 19, 2004 at 6:20:36:

In Reply to: Problem in Retrieving An Array From Oracle Stored Procedure ! posted by Joe on May 22, 2002 at 9:5:36:

Hello ,

i had written a stored procedure in Oracle
which will return Array value.
In Frontend i am using Oracle.sql.ARRAY class to retrieve the returned value ,but it is displaying in Hexadecimal ,
please go through the below code

Oracle procedure

1)create or replace type array_of_value as table of varchar2(20);

create or replace function
return array_of_value
is

decl_array array_of_value := array_of_value();
v_index number:=0;
begin

decl_array.EXTEND;
v_index:=v_index+1;
decl_array(v_index):='Hello';
return decl_array;
end;

class MyJavaClass{

//driver initialization and OracleTypes.ARRAY

oracle.sql.ARRAY output=callablestatementObj.getARRAY(1);
String strarr[]=(String[])output.getArray();
System.out.println(strarr[0]);

}
output displaying as
0x11




Follow Ups:


Post a Followup

Name:     
E-Mail:   
Subject:  
Message:

Optional Link URL: 
Link Title:

[ Follow Ups ] [ Post Followup ] [ Intranet eXchange ] [ IDM Home ]