write a PL-SQL code in java class

Appu Mehta

Greenhorn

Posts: 11

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
Can anyone suggest me how to write a PL-SQL code in java class.
Regards,
Appu

Nitesh Kant

Bartender

Posts: 1638

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 368

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 338

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

What's a year in metric? Do you know this metric stuff tiny ad?

Smokeless wood heat with a rocket mass heater

https://woodheat.net