Re: DBMS_SQL.exectue problem

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 22 Oct 1999 15:40:53 -0400
Message-ID: <vb0QOAUkXWz2S8lH3X80MgymuETx@4ax.com>

A copy of this was sent to dennis liu <dliu_at_neostrata.com> (if that email address didn't require changing) On Fri, 22 Oct 1999 10:55:47 -0400, you wrote:

>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

see http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Oct 22 1999 - 14:40:53 CDT