DBMS_SQL.exectue problem

I try to run a sql using DBMS_SQL.execute and get the error ORA-00942(table or view not exist ..).
the sql statement is "delete from scott.emp where empno= 7369'. I connected as system/manager. the record exists. if i run it from sqlplus, it works.
Why i can't execute using DBMS_SQL package to run the same sql? how to fix it?

thank you for your help

dennis Received on Fri Oct 22 1999 - 09:55:47 CDT