Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    12

    Unanswered: The signature provided in the definition for ...+DB2 Stored procedure

    I get this error when running the SP...

    ###############
    The signature provided in the definition for routine "SP_SAVE_PRICHGFLOW" matches the signature of some other routine that already exists in the schema or for the type. SQLSTATE=42723
    ###############

    Please help.......


    What does it means ?
    Regards
    Mahesh
    Senior DBA
    Calypso Technology

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    A routine with the same schmea name and procedure name and same input output parameters already exisits in the database.

    If you are sure you want to recreate the stored procedure drop the exisiting one and then do a CREATE

    HTH

    Sathyaram

  3. #3
    Join Date
    May 2002
    Posts
    12
    Thx
    Originally posted by sathyaram_s
    A routine with the same schmea name and procedure name and same input output parameters already exisits in the database.

    If you are sure you want to recreate the stored procedure drop the exisiting one and then do a CREATE

    HTH

    Sathyaram
    Regards
    Mahesh
    Senior DBA
    Calypso Technology

Posting Permissions

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