Nuno Miguel Rodrigues <[EMAIL PROTECTED]> schrieb am 16.02.2005
10:35:52:
> 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.
>
No, I do not think this is the point. The point is that a different line
separator (/) has to be used in ant(maven) to run the scripts.
> HTH,
>
>
> --
Thomas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
