Can you configure the end of line delimiter? If so, the user could
choose some unused character for this kind of situation.
Jeff Butler
On Mon, Oct 19, 2009 at 9:13 PM, Clinton Begin <clinton.be...@gmail.com> wrote:
> PS: you could use full line demarcation and use 'GO' or something like SQL
> Server...
> But otherwise we'll need some creative thinking to figure out how to deal
> with the double ;
> Clinton
>
> On Mon, Oct 19, 2009 at 8:12 PM, Clinton Begin <clinton.be...@gmail.com>
> wrote:
>>
>> The double ; will cause problems. I'm not sure how I would demarcate
>> that... any ideas?
>>
>> On Mon, Oct 19, 2009 at 7:18 PM, camelContext
>> <praveen.krish...@citrix.com> wrote:
>>>
>>> Hi All,
>>>
>>> I am using iBatis migration tool to create my service schema. My service
>>> schema demands that i execute couple of PL/SQL procedures for some
>>> permission related things (post schema creation).
>>>
>>> I tried to execute the following from one of my scripts
>>>
>>> BEGIN
>>> oracle.grants.everything('SUBSCRIPTPKRISHNAN','SUBSCRIPTPKRISHNANAPP',
>>> TRUE);
>>> END;
>>>
>>> But when executing the migrate statement, i get the following error
>>>
>>>
>>> ========== Applying: 20091009120309_create_base_schema.sql
>>> =====================
>>> -- create base schema
>>> -- Migration SQL that makes the change goes here.
>>> --EXECUTE IMMEDIATE 'BEGIN
>>> oracle.grants.everything(\'SUBSCRIPTPKRISHNAN\',\'SUBSCRIPTPKRISHNAN\',
>>> TRUE) END'
>>> BEGIN
>>> oracle.grants.everything('SUBSCRIPTPKRISHNAN','SUBSCRIPTPKRISHNANAPP',
>>> TRUE)
>>> END
>>> Error executing: BEGIN
>>> oracle.grants.everything('SUBSCRIPTPKRISHNAN','SUBSCRIPTPKRISHNANAPP',
>>> TRUE)
>>> END . Cause: java.sql.SQLException: ORA-06550: line 1, column 86:
>>> PLS-00103: Encountered the symbol "END" when expecting one of the
>>> following:
>>>
>>> := . ( % ;
>>>
>>>
>>> ERROR: Error executing command. Cause:
>>> org.apache.ibatis.jdbc.RuntimeSqlException: Error executing: BEGIN
>>> oracle.grants.everything('SUBSCRIPTPKRISHNAN','SUBSCRIPTPKRISHNANAPP',
>>> TRUE)
>>> END . Cause: java.sql.SQLException: ORA-06550: line 1, column 86:
>>> PLS-00103: Encountered the symbol "END" when expecting one of the
>>> following:
>>>
>>> := . ( % ;
>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Executing-PL-SQL-procs-from-migration-tool.-tp25967912p25967912.html
>>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
>>> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>>>
>>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
