On Tue, 15 Feb 2005 23:29:55 -0000, 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 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 I using the wrong torque target to execute the scripts
>
> The SQL scripts appear to be correct and work perfectly via sql*plus.
>
> I've successfully managed to create the schema for MySQL without any
> problems but am struggling with Oracle.
>
> Any help would be greatly appreciated!
[...]
PL/SQL is a different environment from that of SQL, hence the error.
sql+ handles PL/SQL.
HTH,
--
Nuno Miguel Rodrigues <[EMAIL PROTECTED]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
