• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Rob Spoor
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Carey Brown
Bartenders:

StoredProcedure outParameters oracle

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic