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


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 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
Passing PL/SQL Datatype in procedure from java
what are procedures in sql ?
business logic (in java or PL/SQL)?
retrieve rows
where to put SQL queries ?