aspose file tools*
The moose likes JDBC and the fly likes Calling Oracle User Define funcation from java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Calling Oracle User Define funcation from java" Watch "Calling Oracle User Define funcation from java" New topic
Author

Calling Oracle User Define funcation from java

Prashant Saraf
Ranch Hand

Joined: Sep 25, 2006
Posts: 52

Hi I have a user define function written in PL/SQL, One of the parameter to the function is list of Oracle User define Object, and here i stuck.. I how pass a user define object list to that function..

here is my PL/SQL



my java calling code




What will be set Parameter for the 3,4. as 3 and 4 are the List(as TABLE in PL/SLQ) of user define object
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling Oracle User Define funcation from java
 
Similar Threads
Array as input to stored procedure.
Execute pl/sql function which is having bind variables in java
Testing a simple Oracle PL SQL function using toad sql client?