RE: PL/SQL Cursor

From: Ken Janusz <ken.janusz_at_sufsys.com>
Date: Tue, 18 Dec 2001 07:19:01 -0800
Message-ID: <F001.003DEDE9.20011218064518@fatcity.com>

Raj:

Here is the code when I run it. Any idea what the problem is?

Thanks, Ken

DECLARE
  cursor ok_sos_hist_reg_nbr_cur is
    select tsh.tm_hist_reg_number,

               tdh.tm_hist_reg_number,
                   trh.tm_hist_reg_number,
                   d.tm_hist_reg_number
        from   tm_status_history tsh,
               trademark_data_history tdh,
                   trademark_registrant_history trh,
                   document d
    where  tsh.tm_hist_reg_number = tdh.tm_hist_reg_number
          and  tdh.tm_hist_reg_number = trh.tm_hist_reg_number
          and  trh.tm_hist_reg_number = d.tm_hist_reg_number
ORA-06550: line 14, column 0:

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   . ( * @ % & - + ; / at for mod rem <an exponent (**)> and or    group having intersect minus order start union where connect    ||

BEGIN
  if not ok_sos_hist_reg_nbr_cur%ISOPEN
  then
    open ok_sos_hist_reg_nbr_cur

ORA-06550: line 5, column 0:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:

   . ( % ; for

end if
end if
ORA-00900: invalid SQL statement

fetch ok_sos_hist_reg_nbr_cur into :tsh.tm_hist_reg_number fetch ok_sos_hist_reg_nbr_cur into :tsh.tm_hist_reg_number ORA-00900: invalid SQL statement

fetch ok_sos_hist_reg_nbr_cur into :tdh.tm_hist_reg_number fetch ok_sos_hist_reg_nbr_cur into :tdh.tm_hist_reg_number ORA-00900: invalid SQL statement

fetch ok_sos_hist_reg_nbr_cur into :trh.tm_hist_reg_number fetch ok_sos_hist_reg_nbr_cur into :trh.tm_hist_reg_number ORA-00900: invalid SQL statement

fetch ok_sos_hist_reg_nbr_cur into :d.tm_hist_reg_number fetch ok_sos_hist_reg_nbr_cur into :d.tm_hist_reg_number ORA-00900: invalid SQL statement

close ok_sos_hist_reg_nbr_cur
close ok_sos_hist_reg_nbr_cur
ORA-00900: invalid SQL statement

END
END
ORA-00900: invalid SQL statement

.
.

ORA-00900: invalid SQL statement

 -----Original Message-----
Sent: Monday, December 17, 2001 3:41 PM

To:     Multiple recipients of list ORACLE-L
Subject:        RE: PL/SQL Cursor

 << File: ESPN_Disclaimer.txt >> This means that you are using some (bind) variables but haven't supplied
values for them. Please post the code along with the open statement for the cursor.

Raj

---

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: ken.janusz_at_sufsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Dec 18 2001 - 09:19:01 CST