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 -> ORA-14551: cannot perform a DML operation inside a query

ORA-14551: cannot perform a DML operation inside a query

From: Daud <daud11_at_hotmail.com>
Date: 17 Aug 2001 23:32:14 -0700
Message-ID: <f0bf3cc3.0108172232.102b2b05@posting.google.com>


Hi

I have written a pl/sql function that returns a value. The function will insert or update into a table everytime it is called.
However, everytime I call the function from a select statement like:

select getVal('data') from dual;

I got an error message like below.

ORA-14551: cannot perform a DML operation inside a query

I think I understand why. However, is there a workaround to this problem? I need to call the function from a select statement and the function needs to insert/update a table.

thanks
Daud11 Received on Sat Aug 18 2001 - 01:32:14 CDT

Original text of this message

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