Re: Help! is this possible?

So you are pulling data from a 22-million row table and inserting it into another table, right? Your could pre-check the input table like: create a function like below to select primarykeycols from 22miltable where my_to_number (bad_column) =0;

create or replace function my_to_number( p_num in varchar2 ) return number
as
x number;
begin
x := to_number( p_num );
return 1;
exception
when others then return 0;

      end; Received on Thu Dec 16 2004 - 14:41:04 CST