aspose file tools*
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
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
 
Don't get me started about those stupid light bulbs.
 
subject: Calling PL/SQL Object Type Member/Static Procedures