Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2012
    Posts
    3

    Question Unanswered: NEED HELP ASAP PLS-00306: wrong number or types of arguments

    Hello,
    New to forum and I need some help as soon as possible.

    I have a procedure that I have written. When running the procedure in Oracle it works great gets the expected results, but when I try to call the procedure in Crystal 10.5 I get the error message PLS-00306: wrong number or types of arguments.

    The issue seems to be with a parameter that is defined as a number. When I comment out that parameter or when i run another procedure without a "Number" parameter then I have no issues. Here is my procedure:

    DROP TABLE XAGTLST_GT CASCADE CONSTRAINTS;

    CREATE GLOBAL TEMPORARY TABLE XAGTLST_GT
    (
    ANGPNO VARCHAR2(8 BYTE) NOT NULL,
    ANGPLC VARCHAR2(8 BYTE) NOT NULL,
    ANBNTP VARCHAR2(2 BYTE) NOT NULL,
    ANEFTO NUMBER NOT NULL
    )
    ON COMMIT DELETE ROWS
    NOCACHE;



    CREATE OR REPLACE PACKAGE XAGTLST_PKG
    AS TYPE XAGTLST_CSR IS REF CURSOR
    RETURN XAGTLST_GT%ROWTYPE;
    END XAGTLST_PKG;


    CREATE OR REPLACE PROCEDURE XAGTLST_PROC
    (XAGTLST_Cursor IN OUT XAGTLST_PKG.XAGTLST_CSR,
    p_AgentID in umr_qlstage.AGENCM_TB.ANAGNT% type ,
    p_EffectiveThruDt in umr_qlstage.AGENCM_TB.ANEFTO% type,
    p_SourceDB in umr_qlstage.AGENCM_TB.SOURCE_DB% type
    )
    AS
    BEGIN
    OPEN XAGTLST_Cursor FOR
    SELECT ANGPNO,
    ANGPLC,
    ANBNTP,
    ANEFTO
    FROM UMR_QLSTAGE.AGENCM_TB
    WHERE ANAGNT = p_AgentID
    AND ANEFTO = p_EffectiveThruDt
    AND substr(SOURCE_DB,1,2) = p_SourceDB;
    END XAGTLST_PROC ;

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    consider posting in Crystal Report forum; since code work for Oracle
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2012
    Posts
    3
    Will do, thanks. The error to me seems to convey that the Crystal app and Oracle aren't communicating. Just verifying that someone in the oracle world may know if there is a problem with the communication of Oracle to Crystal 10.5.

    Hopefully someone in Crystal forum will know.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Parameter defined as NUMBER is "ANEFTO". How is it declared in your Crystal Report? Is it a NUMBER as well? If not, what happens if you set it to?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •