Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Error in Package
Thanks
Jack, Igor and all that reply.
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 Jack C. ApplewhiteEnviado
el: Monday, 17 December, 2001 11:45 AMPara: Multiple recipients
of list ORACLE-LAsunto: RE: Error in Package
<SPAN
class=968394416-17122001>Ramon,
<SPAN
class=968394416-17122001>
<SPAN
class=968394416-17122001>You've declared the Procedure SELECCIONAR differently
in the package spec and body. Oracle must think you're creating an
overloaded procedure with different arguments for each version. The spec
and body declarations must match.
<SPAN
class=968394416-17122001>
<SPAN
class=968394416-17122001>Jack
--------------------------------Jack C.ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
<FONT face=Tahoma
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Ramon EstevezSent:
Monday, December 17, 2001 9:21 AMTo: Multiple recipients of list
ORACLE-LSubject: Error in Package
Hi
List,
<SPAN
class=995141516-17122001>
What is wrong with
this package, I compared it to one example in a book and
looks equal, but
still get an error.
<SPAN
class=995141516-17122001>
CREATE OR
REPLACE PACKAGE MANTENIMIENTO_COMPROBANTES
AS TYPE COMPROBANTES_RECORD IS
RECORD ( GRUPO
FECHA
CUENTA
COMPROBANTES_REFCURSOR,PGRUPO IN
COMPROBANTES.GRUPO%TYPE,PCOMPANIA IN
COMPROBANTES.COMPANIA%TYPE,PTIPO_COMPROBANTE IN
COMPROBANTES.TIPO_COMPROBANTE%TYPE,PCOMPROBANTE IN
COMPROBANTES.COMPROBANTE%TYPE);
9 PGRUPO IN NUMBER, 10PCOMPANIA IN
NUMBER, 11PTIPO_COMPROBANTE IN
NUMBER, 12PCOMPROBANTE IN NUMBER)
FOR 16 SELECT C.GRUPO, C.COMPANIA, C.TIPO_COMPROBANTE, 17 C.COMPROBANTE, C.FECHA, C.AG_CUENTA, 18 C.CUENTA, C.DETALLE, C.CONCEPTO, 19 C.ESTATUS,
A.DESCRIPCION 20 DESC_AGENCIA, D.CUENTA_CONTABLE, CT.DESCRIPCION 21 DESC_CUENTA, CTE.NOMBRE_COMERCIALDESC_CLIENTE 22
D, 24 CUENTAS CT, CLIENTES CTE 25 WHERE 26 C.GRUPO
PGRUPO AND 27 C.COMPANIA
AND 29 C.COMPROBANTE = PCOMPROBANTE AND 30 A.AGENCIA
C.AGENCIA AND 31 D.GRUPO(+)
C.GRUPO AND 32 D.COMPANIA(+) = C.COMPANIA AND 33 D.AGENCIA(+) = C.AG_CUENTA AND 34 D.CUENTA(+) = C.CUENTA AND 35 CT.GRUPO(+) = D.GRUPO AND 36 CT.COMPANIA(+) = D.COMPANIA AND 37 CT.CUENTA(+) = D.CUENTA_CONTABLE AND 38
-----------------------------------------------------------------35/16PLS-00323: subprogram or cursor 'SELECCIONAR' is declared in a package specification
![]() |
![]() |