Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Question Unanswered: Stored Procedure Issue!!

    I have a stored procedure in DB2 which is executing perfectly. But if i embed the stored procedure in the crystal reports i get an error

    Query Engine Error : '42884:[IBM][CLI Driver] SQL0440N No authorized routine named "DEVL3FED.FEDSDWE' of type "" having compatible arguments was found. SQLState=42884



    Please help on this

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The problem is probably how Crystal is calling the SP. One or more of the parameters is not being properly set to the correct data type when the call is presented to DB2.

    Andy

Posting Permissions

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