Re: Yesterday I had a perfectly compiling stored procedure ....

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 13 Feb 1999 00:19:05 GMT
Message-ID: <36cdc4b5.19864934@192.86.155.100>

A copy of this was sent to m_popov_at_hotmail.com (if that email address didn't require changing) On Fri, 12 Feb 1999 22:09:04 GMT, you wrote:

>Hi
>Yesterday I had a perfectly compiling stored procedure that contained
>2 cursor definitions.
>Then I added a third cursor definition with totally different
>variables. Now I am getting the following errors. Actually its giving
>me like 100 errors. It compiles perfectly If I comment out the new
>cursor definition.
>
>46/2 PLS-00305: previous use of 'SS_CUR' conflicts with this use
>46/2 PL/SQL: Item ignored
>56/9 PLS-00201: identifier 'SS_REC' must be declared
>56/9 PL/SQL: Item ignored
>
>There is no other defintion for SS_CUR and no duplicate variables.
>If any of you guys know what's happening , please let me know. The
>error manual is not of much help. This is frustrating...
>Thanks
>
>Mike.
>
>The actual definition of the third cursor is as follows :
>
> cursor ss_cur is
> select sap_sequence_number , shipment_number ,
> center_code , item_number_code ,
> sap_destination_type_indicator ,
> total_volume from
> sap_shipments_at_dmscprod
> where (sap_sequence_number between
> pkg_begin_seq_num and pkg_end_seq_num)
> and sap_destination_type_indicator = 'A'
> order by center_code;
> ss_cur ss_rec%ROWTYPE;
>

its right there. You have SS_CUR defined both as a CURSOR and as a variable of SS_REC%ROWTYPE. You have 2 definitions of SS_CUR. Here is a small example that does the same thing:

SQL> declare

  2          cursor ss_cur is select * from dual;
  3          ss_cur dual%rowtype;
  4  begin
  5          null;

6 end;
7 /

        cursor ss_cur is select * from dual;
        *

ERROR at line 2:

ORA-06550: line 2, column 2:
PLS-00305: previous use of 'SS_CUR' conflicts with this use
ORA-06550: line 2, column 2:

PL/SQL: Item ignored

rename the cursor or rename the local variable of ss_rec%rowtype.

>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Feb 12 1999 - 18:19:05 CST