Re: Dynamic SQL

<ianeruda_at_my-deja.com> wrote in message news:8hih6j$lds$1_at_nnrp1.deja.com...
> 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), [Quoted]
> funct2(par1) where ....');
>
> a following message is reported:
> Function does not guarantee not to update database.
>
> We use Oracle 8.0.5.
>
> Thanks,
> Filip

You need to make it a procedure. Functions cannot do inserts, updates, and deletes.

-Matt Received on Wed Jun 07 2000 - 00:00:00 CEST