pl/sql problem

From: <akkha_at_my-deja.com>
Date: Mon, 03 Jan 2000 19:14:46 GMT
Message-ID: <84qser$ks5$1@nnrp1.deja.com>

Hi,

I have a couple of stored packages which have been running for years on Oracle 7.3.4 with no problem. When I port them to 8.1.5 and execute them, following error occurs:

*
ERROR at line 1:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "name of package etc", line 132
ORA-06512: at line 1

I examined the code and found the following:

...

v_countrows number;
...

  select count(*)
  into v_countrows
  from tems_pager;

The above select statement is giving the trouble. If I change the declaration to v_countrows number(3), then the package could be run smoothly.

Is this a new feature or bug? Why the change in behavouir? Is it documented ?

Thanks for any suggestion.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 03 2000 - 13:14:46 CST