ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML;;
orawissNov 20 2007 — edited Nov 20 2007Hi all,
I have a problem!
I have one PL SQL function doing an Update and insert into some oracle tables, this function return one number (0 or 1 or 2).
I'm excuting this query from one PHP program to call the function :
SELECT SALE.DB_FUNC_ASSOCIATE_TB2U('jdonadeu@toto.com',123)
FROM dual;
the problem that I have these errors :
ERROR DB_FUNC_ASSOCIATE_TB2U Level 1 : ORA-01403: no data found
ERROR DB_FUNC_ASSOCIATE_TB2U : ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
there's a mean that i can do to call this function from PHP without getting this Error such as I tested this function using the script below and it works fine:
declare
a number;
begin
a:= SALE.DB_FUNC_ASSOCIATE_TB2U('jdonadeu@toto.com',123) ;
end;
/
Please help me :)
regards,