If i cut and paste:
drop table SIMPLE_TEST_TABLE cascade constraints
/
in Oracle Database Express Edition, in html sql control page
it's work, and execute those 2 line
???
may be some code add a strange car. at the end (like a cr /
lf ) ? or ???
On 07-Feb-08, at 5:59 PM, Mike Schrag wrote:
> Is "\" equivalent to an "end command" in Oracle? I suspect it's
> trying to execute "/" as a command, or it's scanning for a
> semicolon and not finding one.
>
> On Feb 8, 2007, at 5:56 PM, jlecuyer wrote:
>
>>
>> Could someone give me a hint on this error ?
>> ___
>> In Eclipse 3.2 (WOLips) (on mac and pc) in Entity Modeler when i clic
>> on sql button and i select only for exemple, the "drop tables"
>> radio selection (on an existing oracle table)
>> the sql is:
>>
>> drop table SIMPLE_TEST_TABLE cascade constraints
>> /
>>
>> on clic "execute SQL" i get:
>> ORA-00933: SQL command not properly ended.
>>
>> If I try in the same in EOModeler, all is OK and
>> the SQL is the same:
>>
>> drop table SIMPLE_TEST_TABLE cascade constraints
>> /
>>
>> no error, and the table is dropped on the pc from the mac on a local
>> network.
>>
>> Help me, please
>> Jean
>>
>> ______
>> If I remove ojdbc14 from /Library/Java/Extensions (on the mac)
>> Eclipse (and EOModeler) generate an error (driver not found)
>>
>> before going to oracle, everything ok with openbase and mysql on mac
>> ___
>>
>> Configuration and version:
>>
>> mac:
>> Dev. Computer: Dual 2GHz PowerPc G5, 10.4.8
>> Eclipse 3.2.1
>> WOLips: 2.0.0.2967
>> java version "1.5.0_06"
>>
>> pc:
>> oracle Express Edition 10g on Pc windows xp pro
>> jdbc driver: ojdbc14.jar (10.2.0.2)
>> java 1.5.0_10
>> ___
>> url from the model:
>> jdbc:oracle:thin:PcIpNumber:1521:xe
>>
>> ____
>>
>> Jean
>
>
This archive was generated by hypermail 2.0.0 : Thu Feb 08 2007 - 20:21:31 EST