Default stored procedure parameters, nullable method parameters

Posts   
 
    
SteveB
User
Posts: 15
Joined: 25-Jan-2006
# Posted on: 08-Feb-2006 16:39:34   

Hello, Our collection of existing Oracle stored procedures utilize default parameter values. In some cases a user has not selected a value in the UI for something of an Int16 datatype. We would like to not pass a value to the procedure or pass a NULL value to the procedure. The generated stored procedure wrapper exposes this parameters as a Short and it will not accept a null value. Ideally I'd like the tool to generate the parameters as nullable types (i.e. - Short?) if there's a default parameter value specified in the procedure. Then we could pass a null to the actionprocedure.

Any ideas of a workaround?

Thanks, Steve

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39930
Joined: 17-Aug-2003
# Posted on: 08-Feb-2006 19:06:15   

Please check: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=2929

V2.0 will have nullable parameters for procs when it is released. (in a few months time)

Frans Bouma | Lead developer LLBLGen Pro