Re: OK... maybe I'm being stupid... HELP

Unfortunately this won't work.
dbms_sql.parse is not defined at WNDS purity, so you will get an error something like:

PLS-00452: Subprogram 'HOWMANYCUSTOMERS' violates its associated pragma

Bottom line - you can't use dbms_sql in functions called by SQL.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

psinden_at_my-deja.com wrote in message <7mgsn7$5dj$1_at_nnrp1.deja.com>...
>You will need to add a
>pragma restrict_references( HOWMANYCUSTOMERS , WNDS,WNPS );
>in your package spec the WNDS tells oracle that the function will not
>write to the database. The WNPS tells oracle that the function will not
>change values in your procedure. There are other options you may add.
>WNDS is the only required option. There are several other postings
>about this around Deja if you want more details.
>
>In article <378A1818.87ADE733_at_bayer.co.uk>,
> Chris Edge <chris.edge.ce1_at_bayer.co.uk> wrote:
>>
>> --------------780685DAA8CB9B58C37D5A16
>> Content-Type: text/plain; charset=us-ascii
>> Content-Transfer-Encoding: 7bit
>>
>> Hi guys,
>>
>> I've been struggling with using cursors inside functions with the
>> DBMS_SQL command. So have looked thru the newsgroups and found the
>topic
>> under discussion here.
>>
Received on Wed Jul 14 1999 - 03:00:17 CDT