Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Problem with multiple sql comands on Oracle Express (apex)
Problem with multiple sql comands on Oracle Express (apex) [message #216043] Wed, 24 January 2007 17:19 Go to next message
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
Re: Problem with multiple sql comands on Oracle Express (apex) [message #216057 is a reply to message #216043] Wed, 24 January 2007 20:12 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
I don't think it is possible in the SQL Commands dialog - I get the same thing.

You can do it in the SQL Script window though, but it runs in batch, not interactively.

Ross Leishman
Re: Problem with multiple sql comands on Oracle Express (apex) [message #216256 is a reply to message #216057] Thu, 25 January 2007 14:47 Go to previous message
mundialito
Messages: 2
Registered: January 2007
Junior Member
tks rleishman, I talked with my database university teacher and he told me that in Oracle Express (apex) Sql command, you cant execute more that one command at a time
Previous Topic: htp.print_header problem
Next Topic: Installing Application Express (Merged)
Goto Forum:
  


Current Time: Thu Apr 18 12:03:49 CDT 2024