Re: restrict references
Date: Fri, 6 Jul 2001 11:47:07 -0400
Message-ID: <9i4ms802tng_at_enews2.newsguy.com>
you have to use dynamic sql statement (dbms_sql) in order to create a table (or drop one) within a procedure
Ofer
vld <dirk.vanleuven_at_electrabel.com> wrote in message
news:ec77cde8.0107060506.6515d03f_at_posting.google.com...
> Can someone help me with the following problem.
>
> I have a package with a function, in that function do i calc something
> and these calculations can only be done by writing some data in a
> temporary (real) table.
> So when i call this function oracle give me the message " ORA-14551:
> cannot perform a DML operation inside a query".
> I use the term 'TRUST' in the pragma RESTRICT_REFERENCES but this
> don't help.
> I thougt that a dynamic solution would help but this didn't help
> anyway.
> Does anyone have any experience with this kind of troubles.
>
> Vld
Received on Fri Jul 06 2001 - 17:47:07 CEST