Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Procedure -- Help !!!
Guys,
the procedure below works fine on 9iR2/win2k. but when i try to create it on 8.1.6/NT , i get the error below.
can someone help me ???
Warning: Procedure created with compilation errors.
14:57:27 SQL>SHOW ERROR
Errors for PROCEDURE DEL_MEMBER:
LINE/COL ERROR
-------- ----------------------------------------------------------------- 6/4 PLS-00103: Encountered the symbol "SELECT" when expecting one of the following: ( - + mod not null others <an identifier>Received on Fri Jul 18 2003 - 01:12:33 CDT
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
6/54 PLS-00103: Encountered the symbol "AS" when expecting one of the following: ; return returning and or ***********************************************************************************************************
![]() |
![]() |