How to find the SQLCODE

Results 1 to 2 of 2

Thread: How to find the SQLCODE

  1. #1
    Richard Wickens Guest

    Default How to find the SQLCODE

    I need to check the return code (sqlcode?) after I call a stored procedure. How do I do that?

  2. #2
    Join Date
    Dec 1969

    Default RE: How to find the SQLCODE

    Check out the ADO command object and parameters.<BR><BR>One type of parameter (the default, I believe) is input (meaning you are setting the parameter and passing it into the procedure).<BR><BR>One type is output (meaning that it will be set by the procedure and passed back out to you).<BR><BR>This is the gist of it, I believe. I have been so buried in Oracle stuff that I haven&#039;t used SQLServer in a long time.<BR><BR>Hope that helps...

Posting Permissions

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