Value error on procedure execution

[Monkeygumbo]

Hey everybody,

I'm new to Oracle.
I just wrote a rather lengthy procedure to insert records into Oracle open interface tables....the procedure compiles, but delivers the following error when executed:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.ACCENT_INVOICES_FUHS_PKG", line 460
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

line 460...
errbuf := 'Error processing invoices, refer to table accent_invoices_int_fuhs for specifics';

errbuf is on of to OUT parameters for the procedure, varchar2.
I have tried to shorten the message in half or so, but the same error is delivered.

Any suggestions.

MG

 

[sem]

You should change this parameter declaration in calling program and increase its size.

Regards, Dima

 

[sem]

I see, a bit ambiguous: change size of variable, that is passed as out parameter from calling procedure.

Regards, Dima