Oracle Stored Procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a stored procedure in which one of the input Parameters secifies a
Default value, do I still have to create the parameter anyway? I tried not
providing and it says that I a missing a parameter...so it seems heavily
waited in the direction of I have to provide, but I wanted to check to see if
there was a way around having to provide it in the instance where the value
is defaulted?

If I have to provide, should I load System.DBNull.Value into the value of
the parameter?

Thanks in advance for your assistance!!
 
¤ If I have a stored procedure in which one of the input Parameters secifies a
¤ Default value, do I still have to create the parameter anyway? I tried not
¤ providing and it says that I a missing a parameter...so it seems heavily
¤ waited in the direction of I have to provide, but I wanted to check to see if
¤ there was a way around having to provide it in the instance where the value
¤ is defaulted?
¤
¤ If I have to provide, should I load System.DBNull.Value into the value of
¤ the parameter?
¤

Which database provider are you using? If it is the Microsoft .NET provider for Oracle are you using
named parameters?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top