pl/sql error

From: ora_forum <ora_forum_at_yahoo.com>
Date: Tue, 21 Mar 2006 12:57:04 -0800 (PST)
Message-ID: <20060321205704.65372.qmail@web36703.mail.mud.yahoo.com>

Hi All:
  My procedure must list only tables where max(length (formula))>150. I have about 100 schemas and each has FIELDCUSTOM table.    

  CREATE OR REPLACE PROCEDURE data_count is owner varchar2 (40);
i number (10);
BEGIN
FOR n IN (SELECT owner FROM dba_tables WHERE table_name ='FIELDCUSTOM') LOOP
    SELECT max(length (formula)) INTO i FROM n.owner.FIELDCUSTOM;      IF i>=150 THEN
   dbms_output.put_line (owner);

     ELSE
      null;

    END IF;
    END LOOP;
END;       Problem in line:
  SELECT max(length (formula)) INTO i FROM n.owner.FIELDCUSTOM   error sql command not properly ended.    

  Thanks.                 

---

Yahoo! Travel
 Find great deals to the top 10 hottest destinations!
--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 21 2006 - 14:57:04 CST