Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    London
    Posts
    2

    Question Unanswered: Checking Existence Of The Arguments To Stored Procedure

    I want to check to see if an argument has been defined in a procedure, it could take a default value, but I don't want to use this method since all values that if can take are valid values, there are no special values that it could be (e.g. null or -1).

    Is there a function called, for example, isDefined(x) which I can use to check it one of the argument has been defined.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Checking Existence Of The Arguments To Stored Procedure

    Originally posted by alex.collins
    I want to check to see if an argument has been defined in a procedure, it could take a default value, but I don't want to use this method since all values that if can take are valid values, there are no special values that it could be (e.g. null or -1).

    Is there a function called, for example, isDefined(x) which I can use to check it one of the argument has been defined.
    Hi,

    Not, does not exist.

    GUstavo.

  3. #3
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    If you are on version 9.x you can overload functions and stored procedures. For example, you could have:

    a(p1)
    a(p1,p2)
    a(p1,p2,p3)

    The versions that get's called depends on the number of parameters that you pass.

    This doesn't work if someone decides they want a(p1,p3).

    My suggestion, slap your programmers and have them pass a token you can check.
    Fred Prose

  4. #4
    Join Date
    Nov 2003
    Location
    London
    Posts
    2

    Ah, no..

    I'm on 7.31 unfortunatly.

Posting Permissions

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