Error "invalid character" when running SQL Script

Automise Discussion
1

Hi,

 

i try to automize to create tablespace and tables on a Oracle 11g database.

With MSSQL Server 2008 it wasnt a big deal. All is running very well, but with Oracle its horrible.

I managed already to create the tablespace and the dbo user but when i try to run the SQL Script for the tables and stored procedures, i always get a error message "ORA-00911: invalid character"

Some hours later i figured out, that the reason for this might be the ';' inside the script and that the ADO Execute SQL Action or the Oracle DB herself cant handle it. I cant seperate each SQL command from the script.

I should add too, that the Buildserver and the Target DB Server are two different VMs, so i try to install the script via ADO Execute SQL Action with a connection string (which is correct).

If i run the SQL Script directly on the DB Server, its running without errors.

 

Any idea how i can install the script remotely? Maybe without using the ADO action?

2

Hi Mick

Did you create the tablespace and the dbo user via the ADO SQL Execute action or did you do this on the DB server directly?

I am interested to know whether you have any success running scripts/queries on Oracle via Automise.

Regards,

Steve