This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
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
posted
0
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: 116
posted
0
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
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
