Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

write a PL-SQL code in java class

 
Appu Mehta
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Can anyone suggest me how to write a PL-SQL code in java class.
Regards,
Appu
 
Nitesh Kant
Bartender
Posts: 1638
IntelliJ IDE Java MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think what you need is JDBC.

This question suits more in the JDBC forum. CarefullyChooseOneForum while posting. Moving it to the appropriate forum
 
Satya Maheshwari
Ranch Hand
Posts: 368
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic