| 
		
			| 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
 |  
	|  |  | 
	|  | 
	|  |