Re: Help urgent! Cursor prblem

From: <tandym_at_hotmail.com>
Date: Wed, 23 Feb 2000 21:03:20 GMT
Message-ID: <891hul$dr6$1@nnrp1.deja.com>

my pl/sql is weak, so I thought I would look this one up for educational purposes... I found this on metalink, document 72502.1, README for 8.0.6

Bug:409391
  If you try to declare a set of mutually-dependent types, where one of the
  types has a REF reference to a second as-yet-undeclared type, followed by
  a second reference to the same second as-yet-undeclared type, and you   then try to declare this second type such that this has a non-REF   reference to the first type, you will encounter an ORA-600 [17069]. The
  correct behavior here is for the server to report error ORA-4055.   The ORA-600 [17069] in this case really indicates a user-error in the   declaration of the types. Use the suggestions in the description of   error ORA-4055 to fix the user error. Example:
  create type t1 (a1 ref t2, a2 t2);
  create type t2 (b1 ref t1, b2 t1);2);

  # the creation of type t2 above will cause the ORA-600, rather than
  # the ORA-4055 (which would be the correct behavior) to indicate that
  # there is a user programming error.
  # In the example above, perhaps you meant to declare b2 as "ref t1"
  # rather than as "t1"; if so, change the declaration.

Workaround: remove the user programming error.

I'm not sure if this is exactly what you are looking for, but, hope it helps.

sonya

In article <891g8o$cfq$1_at_nnrp1.deja.com>,   vlarchev_at_eyewire.com wrote:
> Hi,
>
> I just want to create a procedure with in out parameter ref cursor.
> The problem that the cursor identifier is not recognize. What is
wrong?:
>
> Thank you
>
> (1):PLS-00201: identifier 'CURSOR' must be declared
>
> here is the code
>
> create or replace procedure p_rpt103p1 (pc_rowset in out ref cursor,
> pd_startdate in date , pd_enddate in date, ps_system varchar,
ps_locale
> varchar)
> as
>
> begin
>
> open pc_rowset for SELECT
> SALES_FACT."QUANTITY_SOLD", SALES_FACT."US_UNIT_LIST_PRICE",
> SALES_FACT."US_DISCOUNTS",
> DATE_DIM."DATE_DESC",
> PRODUCT_DIM."NAME", PRODUCT_DIM."PRODUCT_ID",
> PRODUCT_DIM."VOLUME_NAME",
> SALES_SYSTEM_DIM."SYSTEM_TYPE", SALES_SYSTEM_DIM."LOCALE_NAME"
> FROM
> DW.SALES_SUMMARY SALES_FACT,
> DW.PRODUCT_DIM PRODUCT_DIM,
> DW.SALES_SYSTEM_DIM SALES_SYSTEM_DIM,
> DW.DATE_DIM DATE_DIM
> WHERE
> SALES_FACT."DATE_KEY" = DATE_DIM."DATE_KEY" AND
> SALES_FACT."PRODUCT_KEY" = PRODUCT_DIM."PRODUCT_KEY" AND
> SALES_FACT."SALES_SYSTEM_KEY" =

SALES_SYSTEM_DIM."SALES_SYSTEM_KEY"
> and
> date_dim <= pd_startdate and
> date_dim >= pd_enddate and
> sales_system.system_type = ps_system and
> sales_system.locale_name = ps_locale;
>
> end;
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 23 2000 - 15:03:20 CST