Store Procedure

[Abhay Tanaya]

Hello,
I need one help regarding use of store procedure in oracle. My problem is, I have converted java code to store procedure. When we run insert query thro' java we get result set. And by checking return value we update same row. But how we can do it in store procedure? After insertion query i have to run update query. So how I can do this in store procedure.

Thanks
Abhay

[Fatih Keles]

Hi Abhay,

What do you mean by "store procedure"? Is it "stored procedure"?
Do you want to use java inside pl/sql?

If so
1) You created your java source
2) Mapped your java method to a pl/sql function/procedure
3) call the function/procedure

If you are asking passing in and out parameters to java stored procedures then this may help. First check out the tutorials, then samples.

Regards,

Fatih.