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

[sachin kataria]

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]

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 ]

[Abhishek Asthana]

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]

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.