pichin pichon

Greenhorn
+ Follow
since Oct 06, 2009
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
In last 30 days
0
Forums and Threads

Recent posts by pichin pichon

Pradeep Arun wrote:agreed. If not maprow what is the other options available.




Hi Pradeep,
I have read your post and I try to make something similar,

can you read my post and tell me what is my problem?

my post: https://coderanch.com/t/465377/Spring/StoredProcedure-outParameters-oracle

thanks very much.
15 years ago
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.
15 years ago