plsql err 2006-01-24 - By Johan Eriksson
Hi
You can't refer an object like that, you need to make the update as an
dynamic sql like:
execute immediate x.table_name||' set trnx_date=null';
/Johan
On Tue, 2006-01-24 at 02:33 -0800, raja rao wrote:
> Hi Team,
> when i am trying to execute the following pl/sql, i am getting the
> below error:
> DECLARE
> CURSOR c1hs IS SELECT table_name FROM dba_tables
> WHERE table_name like '%ADT_ACT_TRXMST'
> AND owner = 'SPLIT_USER';
> BEGIN
> FOR x in c1hs
> loop
> update x.table_name set trnx_date=null;
> commit;
>
> END loop;
> end;
>
> update x.table_name set trnx_date=null;
> *
> ERROR at line 13:
> ORA-06550 (See ORA-06550.ora-code.com): line 13, column 10:
> PL/SQL: ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist
> ORA-06550 (See ORA-06550.ora-code.com): line 13, column 1:
> PL/SQL: SQL Statement ignored
>
> can someone help me on this;
> Raj
>
> __ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
> Yahoo! Photos
> Got holiday prints? See all the ways to get quality prints in your
> hands ASAP.
--
http://www.freelists.org/webpage/oracle-l
|
|
