Re: Help urgent! Cursor prblem

I tried the one thing I haeve the following error which is the same mistake. It seems that the server doesn't know the cursor type ...is it possible

(1):PLS-00201: identifier 'REFCURSOR' must be declared

In article <38b448a3.10560985_at_204.181.81.99>,   See Message body for real address wrote:
>
> 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! =-----
>

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