Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question newbie on PL/SQL: Create function with cursor
I have no problem with it in SQLplus.
zhang ruotao wrote in message ...
>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 Wed Feb 27 2002 - 08:42:12 CST