Problem with multiple sql comands on Oracle Express (apex) [message #216043] |
Wed, 24 January 2007 17:19 |
mundialito
Messages: 2 Registered: January 2007
|
Junior Member |
|
|
I was trying to execute multiple SQL comands in the Oracle Express apex, like I used to do in ISQL Plus, but get the following error:
--------------------------------------------------------------------
create table mytable1 (id number(10) not null );
create table mytable2 (id number(10) not null );
ORA-00911: invalid character
----------------------------------------------------------------------
But if I do each command separated from the other, it works fine:
---------------------------------------------------------------------
create table mytable1 (id number(10) not null );
Table created
0,18 seconds
----------------------------------------------------------------------
create table mytable2 (id number(10) not null );
Table created.
0,02 seconds
I'm sure its a newbie problem, hope someone can help me. tks
|
|
|
|
|