Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01460: unimplemented or unreasonable conversion requested (Oracle 11g)
ORA-01460: unimplemented or unreasonable conversion requested [message #632391] Thu, 29 January 2015 15:16 Go to next message
johnwcv
Messages: 1
Registered: January 2015
Location: MedellĂ­n
Junior Member
Hi.

In some point of the next sp code (iterating the cursor), Oracle throw me the ORA-01460 error:

CREATE OR REPLACE PACKAGE BODY PCK_NAME IS
...
PROCEDURE SP_NAME(...)
...
lvaCdAgente AGE_AGENTES.CDAGENTE%TYPE;
lvaDniTomador PERSONAS.DNI%TYPE;
lvaCdSubramo CUERPOLIZA.CDSUBRAMO%TYPE;
lvaCddelegacion_Radica CUERPOLIZA.CDDELEGACION_RADICA%TYPE;
...
CURSOR lcuInfoPoliza (ivaNpoliza IN VARCHAR2) IS
SELECT c.NPOLIZA,c.CDAGENTE,c.DNI_ADMINISTRATIVO,c.CDSUBRAMO, c.Cddelegacion_Radica
FROM cuerpoliza c
WHERE c.npoliza = ivaNpoliza;
...
BEGIN
...
FOR cuPol in lcuInfoPoliza (ivaNpoliza) LOOP
lvaCdAgente := cuPol.CDAGENTE;
lvaDniTomador := cuPol.DNI_ADMINISTRATIVO;
lvaCdSubramo := cuPol.CDSUBRAMO;
lvaCddelegacion_Radica := cuPol.Cddelegacion_Radica;
END LOOP;
...
END SP_NAME;
...
END PCK_NAME;



Do you have any idea to know how to solve this error?

Thanks in advance.
Re: ORA-01460: unimplemented or unreasonable conversion requested [message #632392 is a reply to message #632391] Thu, 29 January 2015 15:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

>Do you have any idea to know how to solve this error?
Do it correctly.

since we don't have your table or data, we can't run your code to produce the reported error.
It appears ..... that ..... some problem ..... exists according to you .... but I could be ....... mistaken.
Re: ORA-01460: unimplemented or unreasonable conversion requested [message #632393 is a reply to message #632392] Thu, 29 January 2015 15:34 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
does below still throw error
CREATE OR REPLACE PACKAGE BODY PCK_NAME IS
...
PROCEDURE SP_NAME(...)
...
  lvaCdAgente                 AGE_AGENTES.CDAGENTE%TYPE;
  lvaDniTomador               PERSONAS.DNI%TYPE;
  lvaCdSubramo                CUERPOLIZA.CDSUBRAMO%TYPE;
  lvaCddelegacion_Radica      CUERPOLIZA.CDDELEGACION_RADICA%TYPE;
...
  CURSOR lcuInfoPoliza (ivaNpoliza IN VARCHAR2) IS
    SELECT c.NPOLIZA,c.CDAGENTE,c.DNI_ADMINISTRATIVO,c.CDSUBRAMO, c.Cddelegacion_Radica
    FROM   cuerpoliza c
    WHERE  c.npoliza = ivaNpoliza;
...
BEGIN
...
  FOR cuPol in  lcuInfoPoliza (ivaNpoliza) LOOP
    lvaCdAgente               := NULL;
    lvaDniTomador             := NULL;
    lvaCdSubramo              := NULL;
    lvaCddelegacion_Radica    := NULL;
  END LOOP;
...
  END SP_NAME;
...
END PCK_NAME;
 

if no error, change 1 line at a time to learn where error occurs
Previous Topic: Transpose rows to columns without an aggregation
Next Topic: Creating boundaries in between xml elements
Goto Forum:
  


Current Time: Mon Aug 24 02:20:34 CDT 2026