Top "Ora-06502" questions

ORA-06502: PL/SQL: numeric or value error

How to query a CLOB column in Oracle

I'm trying to run a query that has a few columns that are a CLOB datatype. If i run the …

Read More
sql oracle plsql clob ora-06502
Using DBMS_LOB.SUBSTR on a BLOB results in ORA-06502

When I try to run the dbms_lob.substr function on a BLOB field, I get the following error: ORA-06502: …

Read More
oracle oracle11g ora-06502
Getting an Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"

I have a below Package which is giving error ORA-06502: PL/SQL: numeric or value error: character string buffer too …

Read More
oracle plsql ora-06502
Problem with oracle stored procedure - parameters

I have this stored procedure: CREATE OR REPLACE PROCEDURE "LIQUIDACION_OBTENER" ( p_Cuenta IN NUMBER, p_Fecha IN DATE, p_…

Read More
sql oracle datetime ora-06502