ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From camelContext <praveen.krish...@citrix.com>
Subject Executing PL/SQL procs from migration tool.
Date Tue, 20 Oct 2009 01:18:45 GMT

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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message