Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Java DB... procedures

807603Feb 25 2008 — edited Feb 25 2008

hi all. Does Java DB support ordinary sql stored procedures? I 've seen only one type of create procedure examples

CREATE PROCEDURE SALES.TOTAL_REVENUE(IN S_MONTH INTEGER,
IN S_YEAR INTEGER, OUT TOTAL DECIMAL(10,2))
PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME
'com.acme.sales.calculateRevenueByMonth';
CALL SALES.TOTAL_REVENUE(?,?,?);

What about normal sql procedures like in Oracle?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 24 2008

Added on Feb 25 2008

6 comments

82 views

Java Programming

Java DB... procedures

Comments

Post Details