Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange question on error message " PLS-00103: Encountered the symbol " " "" ( Urgent)

Re: Strange question on error message " PLS-00103: Encountered the symbol " " "" ( Urgent)

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Mon, 29 Oct 2001 15:23:26 +0300
Message-ID: <9rjhij$oho$1@babylon.agtel.net>


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...

> 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>
Received on Mon Oct 29 2001 - 06:23:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US