wood burning stoves*
The moose likes JDBC and the fly likes How to pass class object in call to pl/sql procedure ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to pass class object in call to pl/sql procedure ?" Watch "How to pass class object in call to pl/sql procedure ?" New topic
Author

How to pass class object in call to pl/sql procedure ?

sachin kataria
Ranch Hand

Joined: Mar 27, 2006
Posts: 45
hi, i have to call pl/sql proecedure through java. In pl/sql procedure as "In" parameter i have created "user defined record type" and i am passing class object as "In" parameter in call to pl/sql procedure. but it is giving error.

so, anyone can please tell me how i can pass class object as "In" parameter in call to pl/sql procedure ?

its urgent ...

pls help me...
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60782
    
  65

sachin kataria, here are some tips to help you get the most out of the Ranch as a resource:

Please use real words when posting. "pls" is not a real word. Please read this for more information.

Phrases such as "it's urgent" are more likely to tick people off than to indice them to help you. Please avoid such phrases. Please read this for more information.

Good luck with your question.
[ July 21, 2007: Message edited by: Bear Bibeault ]

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Abhishek Asthana
Ranch Hand

Joined: Sep 08, 2004
Posts: 146
Sachin
you should have told what error you are getting. Meanwhile check this link to know the mapping between PL/SQL and Java. May be your mapping is wrong. http://download-west.oracle.com/docs/cd/B19306_01/java.102/b14355/apxref.htm

Abhishek
Raghavan Muthu
Ranch Hand

Joined: Apr 20, 2006
Posts: 3344

Hello Sachin,

Can you please a bit more specific and clear on what you are doing? It would be helpful if you could post your code!

Just check the Java-SQL Mapping for the first case.


Everything has got its own deadline including one's EGO!
[CodeBarn] [Java Concepts-easily] [Corey's articles] [SCJP-SUN] [Servlet Examples] [Java Beginners FAQ] [Sun-Java Tutorials] [Java Coding Guidelines]
 
Don't get me started about those stupid light bulbs.
 
subject: How to pass class object in call to pl/sql procedure ?
 
Similar Threads
getting the resultset of a stored procedure?
How to pass java objects to PL/SQL procedures?
How to pass BLOB to a PL/SQL Stored Procedure
Passing PL/SQL table from Stored Proc to Java
Passing PL/SQL Datatype in procedure from java