# Error "invalid character" when running SQL Script

**URL:** https://www.finalbuilder.com/forums/t/error-invalid-character-when-running-sql-script/4442
**Category:** Discussion
**Created:** [July 12, 2010, 7:17am UTC](https://www.finalbuilder.com/forums/t/error-invalid-character-when-running-sql-script/4442 "2010-07-12T07:17:16Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 12, 2010, 7:17am UTC](https://www.finalbuilder.com/forums/t/error-invalid-character-when-running-sql-script/4442/1 "2010-07-12T07:17:16Z")

</div>

Hi,

&nbsp;

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.

&nbsp;

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

---

<div class="post-metadata">

### Author: ![stephen.ryan](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/s/f14d63/32.png) [@stephen.ryan](https://www.finalbuilder.com/forums/u/stephen.ryan)
#### Post date: [August 5, 2010, 7:07am UTC](https://www.finalbuilder.com/forums/t/error-invalid-character-when-running-sql-script/4442/2 "2010-08-05T07:07:43Z")

</div>

Hi&nbsp;Mick

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

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

Regards,

Steve