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 <[email protected]>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: [email protected] > For additional commands, e-mail: [email protected] > >
