TOracleScript and Java Stored Procedures

[Cybrey]

We load oracle stored procedures in the following way.. (after a connection is made).

oraclescript1.loadfromfile('c:\temp\aheader.spc');
oraclescript1.execute;

I'm trying to load a JSP in the same manner;

oraclescript1.loadfromfile('c:\temp\ajsp.jsp');
oraclescript1.execute;

The oraclescript is saying theres an error at the end of the first line..

ERROR : ORA-29536: badly formed source: Encountered "" at line 1, column 23.
Was expecting:
";" ...

ERROR : create or replace and compile java source named cdtzip as

import java.util.zip.*

If I load the exact same file in SqlPlus using this command

@c:\temp\ajsp.jsp

It compiles with no problems, am I missing something ??

Thanks in advance
Cybrey.

[This message has been edited by Cybrey (edited 17 February 2003).]

 

[Marco Kalter]

The TOracleScript component does not recognize "create or replace java" commands. I have added this to the enhancement requests.

These commands can be executed in a TOracleQuery or TOracleDataSet though.

------------------
Marco Kalter
Allround Automations

 

[Cybrey]

Thanks.. the solution works.. with the obvious side effect that the files end with a '\' which the component throws out as an error. I'll write something that strips this out first..

Thanks again for the help.
Cybrey