RE: simple question

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: oranew2004 [mailto:oranew2004@yahoo.com]
Sent: Thursday, January 08, 2004 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: simple question

CREATE OR REPLACE PROCEDURE labware_admin.truncate_tables
(
    schema_owner        IN VARCHAR2
)
AS

   r number(10);

BEGIN

FOR r IN (SELECT table_name FROM dba_tables WHERE owner=schema_owner)
  LOOP
    EXECUTE IMMEDIATE 'truncate table schema_owner.'||r.table_name;
  END LOOP;

END; 

 

 

ERROR:  Line 14 Column 55 PLS-00364: loop index variable 'R' use is invalid.

 

 

Any ideas?

 

Thank you!

 

 

---

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: thomas.mercadante_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).