File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes write a PL-SQL code in java class 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 » Java » Java in General
Bookmark "write a PL-SQL code in java class" Watch "write a PL-SQL code in java class" New topic
Author

write a PL-SQL code in java class

Appu Mehta
Greenhorn

Joined: Jan 06, 2009
Posts: 11
Hi,
Can anyone suggest me how to write a PL-SQL code in java class.
Regards,
Appu
Nitesh Kant
Bartender

Joined: Feb 25, 2007
Posts: 1638

I think what you need is JDBC.

This question suits more in the JDBC forum. CarefullyChooseOneForum while posting. Moving it to the appropriate forum


apigee, a better way to API!
Satya Maheshwari
Ranch Hand

Joined: Jan 01, 2007
Posts: 368
Appu Mehta wrote:Hi,
Can anyone suggest me how to write a PL-SQL code in java class.
Regards,
Appu


Can you please elaborate on your requirement?


Thanks and Regards
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Appu Mehta wrote:Hi,
Can anyone suggest me how to write a PL-SQL code in java class.
Regards,
Appu


PL/SQL is an Oracle proprietary SQL extension... do you mean SQL?
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
The best thing to do is to create the pl/sql stored procedure in your schema and then execute the stored procedure from your java code using a CallableStatement . This is especially true if your writing a lot of pl sql code.

Agador
 
 
subject: write a PL-SQL code in java class
 
Similar Threads
Java wrappers over the PL/SQL packages
How to check which version of Oracle
Accessing Oracle Global variables in Servlets/JSP
WA #1.....word association
Pass ArrayList To Oracle