Skip to Main Content
Forums

Analytics Software

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!

semicolon issue in JAVA running from calc script

mrojik-bubikFeb 16 2010 — edited Feb 16 2010
Hi,

We have our java that we call from calc script that sends SQL commands to Database. Problem is when we want to send execution of a procedure from a package;

e.g.

RUNJAVA ..................... "begin utl_hyp.Init_Load; end;"

Then the scirpt fails because of the semicolon in our text. When sending normal sql without semicolon everything is fine. Is there some escape character that can be used?

Thank you very much

lubos
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2010
Added on Feb 16 2010
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
1 comment
1,121 views