>EXECUTE DROP_USER_TABLES;
Do you see how ended your record? I suppose if you use "/" as delimiter
string then the record in sql file for example should be like this:
EXECUTE DROP_USER_TABLES
/
Best regards,
Juri.
-----Original Message-----
From: Kees de Kooter [mailto:[EMAIL PROTECTED]
Sent: Monday, November 26, 2007 3:50 PM
To: [email protected]
Subject: Re: [mojo-user] [sql plugin] How can I execute a stored
procedure?
Thanks Juri,
I did some more testing. Setting the delimiter to "/" solved the first
problem: running create script.
However I keep getting exceptions when executing the procedure:
[ERROR] Failed to execute: EXECUTE DROP_USER_TABLES;
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] ORA-00900: invalid SQL statement
Any ideas?
Kees
On Nov 26, 2007 2:10 PM, Artamonov, Juri <[EMAIL PROTECTED]>
wrote:
> I don't use it as m2 plugin but use as standalone library in the
> applications.
>
> SqlExecMojo contains the following method:
>
> /**
> * Set the delimiter type: "normal" or "row" (default "normal").
> *
> * <p>The delimiter type takes two values - normal and row. Normal
> * means that any occurrence of the delimiter terminate the SQL
> * command whereas with row, only a line containing just the
> * delimiter is recognized as the end of the command.</p>
> */
> public void setDelimiterType( DelimiterType delimiterType )
> {
> this.delimiterType = delimiterType.getValue();
> }
>
> Please see javadoc to this method. Hope it helps.
>
> Best regards,
> Juri.
>
> -----Original Message-----
> From: Kees de Kooter [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 1:01 PM
> To: [email protected]
> Subject: Re: [mojo-user] [sql plugin] How can I execute a stored
> procedure?
>
>
> Thanks Juri,
>
> If I look at the manual for the plugin
> (http://mojo.codehaus.org/sql-maven-plugin/execute-mojo.html) there is
> only a "delimiter" configuration property, which I guess is what you
> mean by "delimiter string".
>
> How can I set the delimiter type?
>
> thanks,
> Kees
>
> On Nov 26, 2007 10:41 AM, Artamonov, Juri <[EMAIL PROTECTED]>
> wrote:
> > Small fix :)
> >
> > You can have for example specified "/" as delimiter string and
> > "row" as delimiter type.
> >
>
>
> ---------------------------------------------------------------------
> 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
>
>
--
Cheers,
Kees de Kooter
http://www.boplicity.net
---------------------------------------------------------------------
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
