CODEWITHSUNDEEP
databaseplsqloracle-apex
Jason
Jason

Reputation: 35

Processing Interactive Grid manually through PL/SQL and keeps throwing out an error

Used this site https://community.oracle.com/thread/3937159?start=0&tstart=0 to learn how to manually process interactive grids. I got it to work on a small table with 3 columns, but when I tried to get it to work for a bigger table, it keeps throwing this error:

PL/SQL: numeric or value error: character string buffer too small for.

I tried only updating 1 column and converting the datatype to the correct one, and it is not going away.

Upvotes: 0

Views: 489

Answers (1)

Rafael Trevisan
Rafael Trevisan

Reputation: 134

this message usually means you're trying to store 'AAAA' into a column that only accepts 1, 2 or 3 chars, like varchar2(3).

Make sure your columns have a proper limit size for the data you're processing.

Upvotes: 1

Related Questions