wood burning stoves 2.0*
The moose likes JDBC and the fly likes Calling PL/SQL Object Type Member/Static  Procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Calling PL/SQL Object Type Member/Static  Procedures" Watch "Calling PL/SQL Object Type Member/Static  Procedures" New topic
Author

Calling PL/SQL Object Type Member/Static Procedures

Daniel Dor-Chay
Greenhorn

Joined: Feb 29, 2004
Posts: 8
Hi,

I have some Oracle PL/SQL Object Types defined and would like to call its member and/or static procedures using JDBC. How would I go about doing this?
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
Hi Daniel,

I would imagine you could use a java.sql.CallableStatement and just call the methods as if they were stored procedures.

Have you tried this approach?

Regards

Jules
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling PL/SQL Object Type Member/Static Procedures
 
Similar Threads
where to put SQL queries ?
what are procedures in sql ?
retrieve rows
business logic (in java or PL/SQL)?
Passing PL/SQL Datatype in procedure from java