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.