Re: pl/sql error

  • From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
  • To: ora_forum@xxxxxxxxx
  • Date: Tue, 21 Mar 2006 22:25:31 +0100

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.

Other related posts: