aspose file tools*
The moose likes Spring and the fly likes StoredProcedure outParameters oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "StoredProcedure outParameters oracle" Watch "StoredProcedure outParameters oracle" New topic
Author

StoredProcedure outParameters oracle

pichin pichon
Greenhorn

Joined: Oct 06, 2009
Posts: 2
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: StoredProcedure outParameters oracle