Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
sachin kataria
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64700
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3381
Mac MySQL Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic