of
list ORACLE-LAsunto: RE: Error in Package
Check the definition for COMPROBANTES_RECORD and the SELECT
statement.
You have one extra column AGENCIA in the
record which is not in the SELECT..
Yuval.
-Original Message-From: Ramon Estevez
[mailto
Check
the definition for COMPROBANTES_RECORD and
the SELECT statement.
You
have one extra column AGENCIA in the record which is not in the
SELECT..
Yuval.
-Original Message-From: Ramon Estevez
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 19,
2001 2:13 PMTo: Mul
of list ORACLE-LAsunto: RE: Error in Package
Ramon,
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
of list
ORACLE-LAsunto: Re: Error in Package
If you define the type of your parameters as
'table_name.column_name%TYPE' in package header, then in package body you
should do the same, and not use explicit data type (like
'NUMBER').
Igor Neyman, OCP
Ramon,
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.
Jack
Jack C.
Apple
If you define the type of your parameters as
'table_name.column_name%TYPE' in package header, then in package body you should
do the same, and not use explicit data type (like 'NUMBER').
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Ramon Estevez
To:
The definition of following procedure in package spec
PROCEDURE SELECCIONAR
(PCOMPROBANTESQRY IN OUT COMPROBANTES_REFCURSOR,
PGRUPOIN COMPROBANTES.GRUPO%TYPE,
PCOMPANIA IN COMPROBANTES.COMPANIA%TYPE,
PTIPO_COMPROBANTE IN COMPROBANTES.TIPO_COMPROBANTE%T