Re: Question newbie on PL/SQL: Create function with cursor

It looks fine by me.

Try running it again and posting your error message. Maybe you havent got rights to the underlying table in the cursor?

M

zhang_ruotao_at_iname.com (zhang ruotao) wrote in message news:<b372a0d0.0202270558.78f304c8_at_posting.google.com>...
> hi,
>
> i have difficulties to create my "simple" PL/SQL here, in SQL WorkSheet:
>
> create or replace function MyFunc
> return NUMBER
> IS
> cursor cl IS SELECT enti_id from ta_entite;
> BEGIN
> return (5);
> END;
>
> if i get rid of the declaration of CURSOR, that works.
> So i think there's a pb in my declaration of Coursor?
>
> Thanks
>
> ruotao zhang
Received on Thu Feb 28 2002 - 05:26:01 CST