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.