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:

error sql command not properly ended.

 

Thanks.