[
http://jira.codehaus.org/browse/MSQL-52?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=212071#action_212071
]
Robert Scholte commented on MSQL-52:
------------------------------------
Jon,
a few remarks before trying to fix this:
Are you aware that both statements should be a line within an sql-file?
If it's inside the pom, there's no reason to interpolate it different than
${var}: Maven is the only one executing these statements, so use it's power!
{quote}DROP SEQUENCE &&schema..ACCOUNT_CODE_DEFINITION_SEQ;{quote}
This means you need to have a property called _schema_.
It's a value in the <properties>-section of the pom, profile or other valid
place. Or it's something you add to your Maven-execution like {code}mvn
sql:execute -Dschema=SOME_SCHEMA{code}
{quote}SELECT &1 FROM DUAL;{quote}
This won't work, we're not executing sqlplus from command-line. In this case
you should use the {exec-maven-plugin |
http://mojo.codehaus.org/exec-maven-plugin/} instead.
> Add Oracle SQLPlus syntax for substitution variables
> ----------------------------------------------------
>
> Key: MSQL-52
> URL: http://jira.codehaus.org/browse/MSQL-52
> Project: Maven 2.x SQL Plugin
> Issue Type: New Feature
> Affects Versions: 1.4
> Reporter: Jon Strayer
>
> Replacement variables in Oracle SQLPlus files have the format of
> "%%whatever." This makes them rather hard to use with the Maven SQLPlugin.
> If this syntax were added as an option then the SQLPlugin could execute more
> scripts.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
