Numeric or value error: character string buffer too small

Question

I am having trouble with this simple query in oracle application express and am getting this error:

Query cannot be parsed, please check the syntax of your query. (ORA-06502: PL/SQL: numeric or value error: character string buffer too small)"

SELECT E.EQUIPMENTID, E.EQUIPMENTDESCRIPTION
From EQUIPMENT as E
left outer join EQUIPMENT_CHECKOUT as EC 
on E.EQUIPMENTID = EC.EQUIPMENTID
WHERE EC.EQUIPMENTID is null

Jeffrey Kemp · Accepted Answer · 2012-11-23 02:19:33Z

1

I think the error might be misleading in this case. You don't include AS when specifying table aliases, i.e.:

SELECT E.EQUIPMENTID, E.EQUIPMENTDESCRIPTION
From EQUIPMENT E
left outer join EQUIPMENT_CHECKOUT EC
on E.EQUIPMENTID = EC.EQUIPMENTID
WHERE EC.EQUIPMENTID is null

BTW: in Apex, you can try SQL statements in the SQL Commands window (in SQL Workshop) which usually gives better syntax error info.

answered Nov 23, 2012 at 2:19

Jeffrey Kemp

60.5k15 gold badges111 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Numeric or value error: character string buffer too small

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related