Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Error in Package
Thanks
Yuval
<SPAN
class=647035621-19122001>
that worked
!!!
<SPAN
class=647035621-19122001>
<SPAN
class=647035621-19122001>Regards,,
Ramon E.
Estevez
<A
href="mailto:com.banilejas_at_codetel.net.do">com.banilejas_at_codetel.net.do
Dominican Republic
809-565-3121
<FONT face=Tahoma
size=2>-----Mensaje original-----De: root_at_fatcity.com
[mailto:root_at_fatcity.com]En nombre de Yuval ArnonEnviado el:
Wednesday, 19 December, 2001 2:51 PMPara: Multiple recipients of
list ORACLE-LAsunto: RE: Error in Package
<SPAN
class=180504919-19122001>Check the definition for <FONT color=#000000
face=Verdana>COMPROBANTES_RECORD and the SELECT
statement.
<SPAN
class=180504919-19122001>
<SPAN
class=180504919-19122001>You have one extra column AGENCIA in the
record which is not in the SELECT..
<SPAN
class=180504919-19122001>
<SPAN
class=180504919-19122001>Yuval.
<FONT face=Tahoma
size=2>-----Original Message-----From: Ramon Estevez
[mailto:com.banilejas_at_codetel.net.do]Sent: Wednesday, December
19, 2001 2:13 PMTo: Multiple recipients of list
ORACLE-LSubject: Error in Package
Hi
List,
<SPAN
class=595075219-19122001>
I spent my morning
checking the package trying to figure out what
the error is and
couldn't find it. Need some help !!
<SPAN
class=595075219-19122001>
1
-- 2 -- Paquete para Mantenimiento Tabla de
Comprobantes 3 -- 4 CREATE OR REPLACE
PACKAGE MANTENIMIENTO_COMPROBANTES 5
AS 6 TYPE COMPROBANTES_RECORD
IS RECORD 7
(
8
GRUPO
FECHA
CUENTA
SELECCIONAR 40 ( 41
COMPROBANTES_REFCURSOR, 42PGRUPO IN
COMPROBANTES.GRUPO%TYPE, 43PCOMPANIA IN
COMPROBANTES.COMPANIA%TYPE, 44PAGENCIA IN
COMPROBANTES.AGENCIA%TYPE, 45PTIPO_COMPROBANTE IN
COMPROBANTES.TIPO_COMPROBANTE%TYPE, 46PCOMPROBANTE IN
COMPROBANTES.COMPROBANTE%TYPE 47); 48 -- 49 -- Procedimiento para Insertar registros de la tabla 50
7 -- 8 PROCEDURE SELECCIONAR 9 ( 10
COMPROBANTES_REFCURSOR, 11PGRUPO IN
COMPROBANTES.GRUPO%TYPE, 12PCOMPANIA IN
COMPROBANTES.COMPANIA%TYPE, 13PAGENCIA IN
COMPROBANTES.AGENCIA%TYPE, 14PTIPO_COMPROBANTE IN
COMPROBANTES.TIPO_COMPROBANTE%TYPE, 15PCOMPROBANTE IN
COMPROBANTES.COMPROBANTE%TYPE 16) IS 17
FOR 20 SELECT C.GRUPO, C.COMPANIA, C.TIPO_COMPROBANTE, 21 C.COMPROBANTE, C.FECHA, C.AG_CUENTA, 22 C.CUENTA, C.DETALLE, C.CONCEPTO, 23 C.ESTATUS,
A.DESCRIPCION 24 DESC_AGENCIA, D.CUENTA_CONTABLE, CT.DESCRIPCION 25 DESC_CUENTA, CTE.NOMBRE_COMERCIALDESC_CLIENTE 26
D, 28 CUENTAS CT, CLIENTES CTE 29 WHERE 30 C.GRUPO
PGRUPO AND 31 C.COMPANIA
PCOMPANIA AND 32 C.AGENCIA
AND 34 C.COMPROBANTE = PCOMPROBANTE AND 35 A.AGENCIA
C.AGENCIA AND 36 D.GRUPO(+)
C.GRUPO AND 37 D.COMPANIA(+) = C.COMPANIA AND 38 D.AGENCIA(+) = C.AG_CUENTA AND 39 D.CUENTA(+) = C.CUENTA AND 40 CT.GRUPO(+) = D.GRUPO AND 41 CT.COMPANIA(+) = D.COMPANIA
AND 43 CTE.CLIENTE = D.CLIENTE; 44 END
LOOP 52 INSERT INTO COMPROBANTES 53 ( 54 GRUPO, COMPANIA, AGENCIA, 55 TIPO_COMPROBANTE, COMPROBANTE, FECHA, 56 AG_CUENTA, CUENTA, DETALLE, 57 CONCEPTO,
) 59 VALUES 60 ( 61 PCOMPROBANTE_REC(C).GRUPO, 62 PCOMPROBANTE_REC(C).COMPANIA, 63 PCOMPROBANTE_REC(C).AGENCIA, 64 PCOMPROBANTE_REC(C).TIPO_COMPROBANTE, 65 PCOMPROBANTE_REC(C).COMPROBANTE, 66 PCOMPROBANTE_REC(C).FECHA, 67 PCOMPROBANTE_REC(C).AG_CUENTA, 68 PCOMPROBANTE_REC(C).CUENTA, 69 PCOMPROBANTE_REC(C).DETALLE, 70 PCOMPROBANTE_REC(C).CONCEPTO, 71PCOMPROBANTE_REC(C).ESTATUS, 72 PCOMPROBANTE_REC(C).ESTATUS_IMPRESION 73 ); 74 END
RAISE_APPLICATION_ERROR 78(-20001, 'Comprobante ya Existe
RAISE_APPLICATION_ERROR 81(-20002, 'Error en Procedimiento Insercion '); 82 END INSERTAR; 83* END
-----------------------------------------------------------------15/7PL/SQL: SQL Statement ignored17/7 PLS-00382: expression is of wrong typeSQL>
![]() |
![]() |