| ORA-01460: unimplemented or unreasonable conversion requested [message #632391] |
Thu, 29 January 2015 15:16  |
 |
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 #632393 is a reply to message #632392] |
Thu, 29 January 2015 15:34  |
 |
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
|
|
|
|