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

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