This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
How can i pass null value to stored procedure parameter? I cannot find appropriate property of procedure parameter in designer. Can i solve my task by hand writing code like this: public System.Collections.Generic.IList<StoredProcedureResult> Save_Squad_Shift(int? param1, DateTime? param2, ref int? param3, string param4){ //... }
I use Oracle 10 database. |
|
|
|
|
This is a limitation of the current version of the designer. We'll see if we can get you a fix. In the meantime, you should be able to handle it by writing the stored procedure wrapper yourself, as per your example, and you can of course use the designer-generated code as a starting point. (Don't edit the generated code file -- it will get overwritten.) By the way, we had some issues with passing null values to Oracle in some of our earlier builds, so if you are using 2.2 RTM, you may find you need to upgrade to a nightly build. |
|
|
|
