Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange question on error message " PLS-00103: Encountered the symbol " " "" ( Urgent)
Try to delete everything past end if; to the end of line - there may be an
unprintable character that is not parsed correctly. Just my 2 cents.
hth.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Paul" <jiacheng_work_at_yahoo.com> wrote in message news:f294310c.0110290405.7c115c6_at_posting.google.com...Received on Mon Oct 29 2001 - 06:23:26 CST
> SQL> create or replace procedure RebuildDictionary as
> 2 iDocID number;
> 3 sNotes varchar2(3999);
> 4 Ignore4 number;
> 5 thecursor4 number;
> 6 strSQL4 varchar2(255);
> 7 Begin
> 8 strSQL4:='SELECT DocketID,DocketNotes FROM tblDocket';
> 9 thecursor4:= DBMS_SQL.OPEN_CURSOR;
> 10 DBMS_SQL.PARSE(thecursor4,
> 11 strSQL4,
> 12 DBMS_SQL.NATIVE);
> 13 DBMS_SQL.DEFINE_COLUMN(thecursor4,1 ,iDocID);
> 14 DBMS_SQL.DEFINE_COLUMN(thecursor4,2 ,sNotes,3999);
> 15 ignore4 := DBMS_SQL.EXECUTE(thecursor4);
> 16 <<DocLoop>> loop
> 17 IF DBMS_SQL.FETCH_ROWS(thecursor4) > 0 THEN
> 18 -- Get column values
> 19 DBMS_SQL.COLUMN_VALUE(thecursor4,1 ,iDocID);
> 20 DBMS_SQL.COLUMN_VALUE(thecursor4,2 ,sNotes);
> 21 if sNotes is not null then
> 22 UpdateDictionaryXRef(iDocID,604,sNotes);
> 23 end if; |17 here
> 24 Else
> 25 exit DocLoop;
> 26 end if;
> 27 end loop DocLoop;
> 28 --close the cursor
> 29 DBMS_SQL.CLOSE_CURSOR(thecursor4);
> 30 end;
> 31 /
>
> Warning: Procedure created with compilation errors.
>
> SQL> sho err
> Errors for PROCEDURE REBUILDDICTIONARY:
>
> LINE/COL ERROR
> -------- -----------------------------------------------------------------
> 23/17 PLS-00103: Encountered the symbol " " when expecting one of the
> following:
> begin declare else elsif end exit for goto if loop mod null
> pragma raise return select update while <an identifier>
> <a double-quoted delimited-identifier> <a bind variable> <<
> close current delete fetch lock insert open rollback
> savepoint set sql execute commit forall
> <a single-quoted SQL string>
![]() |
![]() |