Actually, delimiter is set to ;/ I just changed the type to row. -----Original Message----- From: Reaves, Timothy E [mailto:timothy.e.rea...@snapon.com] Sent: Monday, August 29, 2011 2:00 PM To: user@mojo.codehaus.org Subject: RE: [mojo-user] [mvn-sql-plugin] Can't create function
I tried both 1.4 & 1.5. I've now gotten it to work by setting the delimiter to /, and setting delimiterType to row. My SQL is not as readable, but, it works. -----Original Message----- From: Mark Struberg [mailto:strub...@yahoo.de] Sent: Monday, August 29, 2011 12:07 PM To: user@mojo.codehaus.org Subject: Re: [mojo-user] [mvn-sql-plugin] Can't create function Hi! With which version of the sql-maven-plugin does this happen? We recently released 1.5 ... You also might try to use <escapeProcessing>false LieGrue, strub --- On Mon, 8/29/11, Reaves, Timothy E <timothy.e.rea...@snapon.com> wrote: > From: Reaves, Timothy E <timothy.e.rea...@snapon.com> > Subject: [mojo-user] [mvn-sql-plugin] Can't create function > To: user@mojo.codehaus.org > Date: Monday, August 29, 2011, 3:07 PM > > I have a set of files that contain the > SQL I need to create all > of the database objects I need. I currently open each > file in Squirrel, > and run them. I want to have these run from > maven. The problem I am > having is that the three procedures and one function I need > all fail. > When loaded into Squirrel or SQL Developer - both that use > the same JDBC > - the script runs just fine. > > In looking at just the function, the > failure is: > [INFO] Executing file: > /home/bv6679/Development/Schema/src/main/sql/C0003.sql > [ERROR] Failed to execute: i NUMBER > [INFO] > ------------------------------------------------------------------------ > [ERROR] BUILD ERROR > [INFO] > ------------------------------------------------------------------------ > [INFO] ORA-00900: invalid SQL statement > > > The contents are: > CREATE FUNCTION "AEQ_FN_COLLECT"( t IN > AEQ_TYPE_VARCHAR2_TABLE ) > > RETURN CLOB > IS > > collectFilters CLOB; > i > NUMBER; > BEGIN > > i := t.first; > > WHILE i IS NOT NULL > > LOOP > > IF collectFilters IS NOT NULL THEN > > collectFilters := > collectFilters || ','; > > END IF; > > collectFilters := collectFilters || t(i); > > i > := t.next(i); > END > LOOP; > > RETURN collectFilters; > END; / > > > So I just can not figure out what is going on, and why it > is not > working. Any ideas? > > > --------------------------------------------------------------------- > To unsubscribe from this list, please visit: > > http://xircles.codehaus.org/manage_email > > > --------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email --------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email --------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email
