Re: ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126

I had a similar problem.    

  Instead of insert select;    

  try using for c1 in ( ) loop
  insert ....
  end loop;    

  Regards    

  Joseph

Onkar N Tiwary wrote:

    Hi,    

  I have one query , when I am running this query against the remote database, its working \ fine but when I am putting this in pl/sql block its giving the following error:   \
****************************************************************************************** \
*
Received on Tue Jan 10 2006 - 14:58:40 CST