Re: plsql err

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Tue, 24 Jan 2006 11:48:21 -0800
Message-Id: <1138132101.16612.252662056@webmail.messagingengine.com>

You would generate sql commands on the fly ; Subsequently you can do either of the following:

1. Either spool them out and run them separately
2. Store them in a varchar2 variable and execute the string
3. Execute immediate .. update :tname set :cname = :value using parm1 ,

parm2 , parm3.

HTH GovindanK
Certified DBA

On Tue, 24 Jan 2006 02:33:27 -0800 (PST), "raja rao" <raja4list_at_yahoo.com> said:
> 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: line 13, column 10:
> PL/SQL: ORA-00942: table or view does not exist
> ORA-06550: line 13, column 1:
> PL/SQL: SQL Statement ignored
>
> can someone help me on this;
> Raj
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 24 2006 - 13:48:21 CST