>the stored procedure to for inserting data as:
>
>create procedure insertorg (
> in_title varchar(30),
> in_level smallint,
> in_parent bigint)
>as
>declare variable insertsql varchar(90) = 'insert into organisation (title,
> levels, parent) values (:ptitle, :plevel, :pparent)';
>begin
> if ((in_level =1 and in_parent is null)
> or (in_level >1 and in_parent is not null) ) then
> execute statement (insertsql) (ptitle := in_title, plevel := in_level,
> pparent := in_parent );
>end ^
>
>when i try to use the procedure to insert a new record in the table i get the
>following error message:
> "arithmetic exception, numeric overflow, or string truncation string right
>truncation at procedure 'insertorg' line: 3, col: 1".
>
>
>however if i issue the insert command directly eg: insert into organisation
>(title,
> levels, parent) values ('main dept',1,null); this works fine. (There
>is a before inset trigger on the table that takes care of issuing a value for
>the primary key).
>
>What in the procedure is causing this error? I've tried the procedure without
>the if then statement and still receive the same error.
Either simple or the email adding a few extra spaces: As far as I can see,
insert into organisation (title,
levels, parent) values (:ptitle, :plevel, :pparent)
contains 93 characters if spaces are counted and that cannot fit into
varchar(90).
HTH,
Set
