Re: pl/sql error

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.

--
http://www.freelists.org/webpage/oracle-l