How to avoid this ORA-14551 error?
814030Nov 18 2010 — edited Jul 1 2011I would want to log in a table called T_LOG ( a number, b varchar2(1000)) the values of the parameters of a function f(x number, y varchar2) each time this function is executed. So, I went in the source of the function and made an insert of one row :
<h3>Insert into T_LOG(a,b) VALUES(x,y);</h3>
but I also have a select statement where the function f is used, and now, when I run the select statement, I get the error ORA-14551 : cannot perform a dml operation inside a query. Please, how could I log the parameters of the function each time it is used and be able to do a select statement using this function?
Thanks.