Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Which column caused ORA-01438?
How can I tell which column has caused a ORA-01438: value larger than
specified precision allows for this column?
I need to know because I'd like to return a meaningful error message, and I'd like to rely on check constraints as much as possible to implement these types of business rules.
create or replace procedure proc_ins (
param1 in tab1.col1%type,
param2 in tab1.col2%type,
errormess varchar2) is
begin
insert into tab1 (col1,col2) values
(param1,param2);
commmit;
errormess := 'no error';
exception
when others errormess := SQLERRM;
end;
Received on Mon May 31 2004 - 11:16:25 CDT