RE: PL/SQL in generated Oracle scripts

2005-02-22 Thread Lach, Thierry
That's correct. You can run the scripts just fine if you write your own sql/ block and specify delimiter=/. -Original Message- From: Thomas Fischer [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 5:37 AM To: Apache Torque Users List Subject: Re: PL/SQL in generated Oracle

RE: PL/SQL in generated Oracle scripts

2005-02-16 Thread Thomas Fischer
Hi Paul, I suppose you use Torque 3.1.1. In that version, a change was introduced in order not to let the drop table statements fail if the table is not already there (e.g. if you start with an empty database). But this change produces more problem than it solves, so I removed it again in

RE: PL/SQL in generated Oracle scripts

2005-02-16 Thread Paul Osborne
in generated Oracle scripts Hi Paul, I suppose you use Torque 3.1.1. In that version, a change was introduced in order not to let the drop table statements fail if the table is not already there (e.g. if you start with an empty database). But this change produces more problem than it solves

Re: PL/SQL in generated Oracle scripts

2005-02-16 Thread Thomas Fischer
Nuno Miguel Rodrigues [EMAIL PROTECTED] schrieb am 16.02.2005 10:35:52: On Tue, 15 Feb 2005 23:29:55 -, Paul Osborne [EMAIL PROTECTED] wrote: I am trying to use the Maven Torque plugin to generate and initialize an Oracle 8i database. However, the torque 'insert-sql' target is

PL/SQL in generated Oracle scripts

2005-02-15 Thread Paul Osborne
I am trying to use the Maven Torque plugin to generate and initialize an Oracle 8i database. However, the torque 'insert-sql' target is failing because the generated SQL contains PL/SQL code, giving the error: [torque-sql-exec] [ERROR] Failed to execute: DECLARE TABLE_DOES_NOT_EXIST EXCEPTION. Am