Hi, I have a java project where I try to obtain a data type from a Oracle Stored Procedure.
My problem is when I recive the Map (the Map is returned by execute method from StoredProcedure of Spring), the object I have received is a $Proxy3 Object and I don't know how to obtain my datas:
In the Oracle data base I have this package:
This procedure can return more of one register. Reason I return a ref cur.
In Java, I try to do this:
1- I have a test class (Test_Example), so I can debug step by step.
2- In class (Example), called from the test class, is where I define the parameters (in and out) and where I compile and where the execute method is called (Actually the method is running the StoredProcedure class of).
3- I have a class (GenericProced) that extends StoredProcedure, where I obtain my datasource.
GenericProced.java:
Example.java:
My RowMapper class MyEntity.java is:
Test_Example.java:
When I debug the code (with Eclipse), when I run the line Map resp= proc.execute(objects); it runs OK, and the resp variable is like:
name....................................value
resp..................................HashMap (id=16)
....[0]...............................HashMap$Entry (id=43)
........key........................"result"
........value...................... $proxy3 (id=47)
This $Proxy3 Object, How can I read It?
There is other way to obtain a cursor??
thanks very much.