Why do you have r declared as number(10)?
On 01/08/2004 03:24:25 PM, oranew2004 wrote:
> 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
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mladen_at_wangtrading.com
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).
Received on Thu Jan 08 2004 - 15:09:25 CST
