-
Urgent help ! Error - Fail to convert to internal representation
Hi All,
I'm having an issue regarding reading of reference cursor values in java. When I'm trying to read the values in resultset from the ref cursor,I'm getting "Fail to convert to internal representation error" . I'm calling a procedure which is returning a reference cursor.Here's the code :
cStt = conn.prepareCall("{call Labview_Ph4_Report_Qry.get_contact_info_new(?,?)}") ;
cStt.registerOutParameter(1,OracleTypes.CURSOR) ;
cStt.registerOutParameter(2,OracleTypes.VARCHAR) ;
cStt.execute() ;
if("OK".equals(cStt.getString(2)) == false)
{
return lcReturnValue ;
}
// rSet = (ResultSet)cStt.getObject(1) ;
rSet = ((OracleCallableStatement)cStt).getCursor(1);
if(rSet != null)
{
while(rSet.next())
{
Logwriter.write(rSet.getString(1)+", "+rSet.getString(2));
}
}
When I'm trying to print the values from resultset within the loop, the error is coming up.
Any pointers on this will be higly appreciated.
Thnx,
Shamik
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|