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

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 12 Feb 1999 23:16:36 GMT
Message-ID: <36c4b5fc.14491466_at_news.siol.net>

On Fri, 12 Feb 1999 22:05:46 GMT, m_popov_at_hotmail.com wrote:

>Hi
>Yesterday I had a perfectly compiling stored procedure that contained
>2 cursor definitions.
>...[SNIP]...
> 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;

         ^^^^^^^^^^^^^

This has to be turned the other vay around!!! eg

        ss_rec ss_cur%ROWTYPE;

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Feb 13 1999 - 00:16:36 CET