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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
