Re: plsql err
- From: Jared Still <jkstill@xxxxxxxxx>
- To: raja4list@xxxxxxxxx
- Date: Tue, 24 Jan 2006 11:07:47 -0800
Raj,
You need to buy this book:
http://www.oreilly.com/catalog/oraclep4/
It will help you immensely.
I've been relying on it (and subsequent versions) since about 1995.
Jared
On 1/24/06, raja rao <raja4list@xxxxxxxxx> 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: 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
>
> ------------------------------
> Yahoo! Photos
> Got holiday prints? See all the
> ways<http://us.rd.yahoo.com/mail_us/taglines/holidayprints/*http://pa.yahoo.com/*http://us.rd.yahoo.com/mail_us/taglines/photos/evt=38089/*http://pg.photos.yahoo.com/ph//print_splash>to
> get quality prints in your hands ASAP.
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
