Oracle + iSQL*Plus – PLS-00103: Encountered the symbol “GRANT”
Hi, i am trying to create some new csdba users and assign some roles to them however i keep getting the following error message - 7/22 PLS-00103: Encountered the symbol “GRANT” when expecting one of the following: * & | – + / at mod remainder rem => .. <an expo nent (**)> || multiset [...]

Answer Question   |  March 12, 2009  5:54 PM
iSQL*Plus, Oracle, Oracle error messages, PLS-00103

PLS-00103: Encountered the symbol “E_PROD_REQ_ID_NOT_FOUND” when expecting one of the following:
how can i resolve that error? when i compile the store proc….it compiled without any errors….but in a package its throwing error

Answer Question   |  December 13, 2008  8:50 PM
Oracle error messages, PLS-00103, Stored Procedures

Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following
I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following: := . ) , @ % default character The symbol “,” was substituted for “OUT” [...]

Answer Question   |  February 1, 2011  5:16 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL error messages, PLS-00103

Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following
I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following: . ( , % from The symbol “from was inserted before “INTO” to continue. Anbody able to help me [...]

Answer Question   |  February 6, 2012  5:12 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL error messages, PLS-00103

Error(55,8): PLS-00103: Encountered the symbol “C1″ when expecting one of the following: := . ( @ % ;
Hi All, I get the following error on compiling my stored procedure code - ****************************************************************************** Error(55,8): PLS-00103: Encountered the symbol “C1″ when expecting one of the following: := . ( @ % ; ====================================================== Below is my code, any help appreciated :- ====================================================== create procedure FRAUDS_SIU_ADMIN.Frauds_Subm_Proc as begin EXECUTE IMMEDIATE ‘TRUNCATE TABLE FRAUDS_SIU_ADMIN.FRAUDS_SUBMISSION’; COMMIT; insert [...]

Answer Question   |  September 9, 2008  8:53 PM
Oracle error messages, PLS-00103