Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: stored procedure

    i called three stored procedures in a visualbasic program.
    inputing parameter long.
    output parameter is also long but i am always getting value zero in output parameter
    ("APPLICATIONN0", adBigInt, adParamInput, 8, Val(cboApplicantId))
    ("APPLICANTID", adBigInt, adParamOutput, 8)

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Do you also declare the applicationId as an OUTPUT parameter in the declaration of the stored procedure? It must be declared as OUTPUT both in the procedure declaration and in the procedure call in order for a parameter value to sucessfully pass back to the caller.

    -PatP

Posting Permissions

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