Re: Dynamic SQL
From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/06/06
Message-ID: <8hiifs$1048$1_at_s2.feed.news.oleane.net>#1/1
Date: 2000/06/06
Message-ID: <8hiifs$1048$1_at_s2.feed.news.oleane.net>#1/1
You can use funct1 and funct2 in the select only if
they guaranted not to update database.
That is no insert, delete, update statements nor write package
variables nor call to a procedure or function that doesn't
guarantee not to update the database.
-- Have a nice day Michel <ianeruda_at_my-deja.com> a écrit dans le message : 8hih6j$lds$1_at_nnrp1.deja.com...Received on Tue Jun 06 2000 - 00:00:00 CEST
> Hi!
>
> I have a problem with function call from dynamic sql statement. When I
> try to parse a statement that looks like this:
>
> DBMS_SQL.PARSE('insert into tab1 (col1,col2) select funct1(par1,par2),
> funct2(par1) where ....');
>
> a following message is reported:
> Function does not guarantee not to update database.
>
> We use Oracle 8.0.5.
>
> Thanks,
> Filip
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.