Odbc stored proc won't accept NULL

Question

0.00/5 (No votes)

See more:

Hi Guys,

Im using a ODBC Connection to call a SP (Sybase Stored Proc), It takes 41 parameters, But only needs 10 of the params to execute.

Works fine in SQL but when i use it in my code im not sure how to supply die blank/NULL Values?

Should it be left out or should i use Quotes ("")?

Here is my code:

C#

OdbcConnection cn;
OdbcCommand cmd;

OdbcDataReader dr;
string connetionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;

    //Change the connection string to use your SQL Server.
    cn = new OdbcConnection(connetionString);

    //Use ODBC call syntax.
    cmd = new OdbcCommand("{call p_MemberAdd_p ("WHAT DO I DO WITH THE EMPTY ARGUMENTS HERE?")}", cn);

    cn.Open();

    dr = cmd.ExecuteReader();

    //List each product.
    while (dr.Read())
        Label1.Text = dr.GetString(1);
        //Label2.Text = dr.GetString(0);

    //Clean up.
    dr.Close();
    cn.Close();

Posted 19-Mar-12 3:05am

man_in_marak

Updated 19-Mar-12 3:07am

V.

v3

Add a Solution

Comments

V. 19-Mar-12 9:07am

Added Code tags.

2 solutions

Solution 2

This is my code:

cmd = new OdbcCommand("{call p_MemberAdd_p (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}", cn);

SQL

CIS = cmd.Parameters.Add("@CIS", OdbcType.VarChar);
                CIS.Value = DBNull.Value;
                OrgId = cmd.Parameters.Add("@OrgId", OdbcType.VarChar, 20);
                OrgId.Value = "CBS";
                ProductId = cmd.Parameters.Add("@ProductId", OdbcType.VarChar, 20);
                ProductId.Value = "AGR";
                MPAcc = cmd.Parameters.Add("@MPAcc", OdbcType.VarChar, 20);
                MPAcc.Value = DBNull.Value;

With all the other params ofcourse

THANKS!!

Posted 19-Mar-12 3:26am

man_in_marak

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

V. · Accepted Answer · 2012-03-19T03:08:00

Solution 1

Try submitting DBNull.Value

Posted 19-Mar-12 3:08am

V.

Comments

man_in_marak 19-Mar-12 9:15am

Tried this? Same error cmd = new OdbcCommand("{call p_MemberAdd_p (" + DBNull.Value + ")}", cn);

V. 19-Mar-12 9:19am

I think you need to pass it as a parameter, not inline.
Inline is always dangerous btw. (look up : SQL injection)
In this case DBNull.Value will be serialized as a string and this is not what you want to do.