Hi ora_forum, http://www.amazon.com/gp/product/0596009771/sr=8-1/qid=1142976086/ref=pd_bbs_1/002-9080897-3686451?%5Fencoding=UTF8 OR http://www.amazon.com/gp/product/1590592174/qid=1142976127/sr=2-1/ref=pd_bbs_b_2_1/002-9080897-3686451?s=books&v=glance&n=283155 Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === On Tue, 2006-03-21 at 12:57 -0800, ora_forum wrote: > 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.