Re: Help urgent! Cursor prblem

I think refcursor is one word...

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.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Feb 23 2000 - 14:53:24 CST