Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question newbie on PL/SQL: Create function with cursor

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

From: R Chin <rchin_at_panix.com>
Date: Wed, 27 Feb 2002 09:42:12 -0500
Message-ID: <a5ir8m$45r$1@reader2.panix.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US