Java and JavaScript in the Database

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!

Comments in SQL Statments or SQL Script File and JDBC

mvekslerJan 16 2006 — edited Jan 17 2006

I am using JDBC to execute SQL script file.
What I have in the SQL Script file is bunch of SQL Statements; some create tables, others create packages with functions etc.
The SQL Script files have bunch of comments.

In JDBC I use CollableStatment and then I call prepareCall and execute.
I get SQL Errors and Warnings.
The SQL Script files work just fine if I execute them in third parties APPs like TOAD or something like that.

I know it has been asked for many times.
However, I could not find any definite answer.
Dos anyone know a way or methods I need to sue to execute SQL Statement that for example creates package and contains comments in the SQL.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2006

Added on Jan 16 2006

1 comment

1,395 views