Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Disappearing in-parameters in Entity Framework stored procedures

2 posts in General Discussion Last posting was on 2012-04-30 15:27:40.0Z
Håkan Nilsson Posted on 2012-04-30 09:37:19.0Z
Sender: 7648.4f9e59cd.1804289383@sybase.com
From: Håkan Nilsson
Newsgroups: sybase.public.ase.general
Subject: Disappearing in-parameters in Entity Framework stored procedures
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f9e5d4f.76f1.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 30 Apr 2012 02:37:19 -0700
X-Trace: forums-1-dub 1335778639 172.20.134.41 (30 Apr 2012 02:37:19 -0700)
X-Original-Trace: 30 Apr 2012 02:37:19 -0700, 172.20.134.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31060
Article PK: 73950

Hello,

I have a problem when calling stored procedure defined in an
Entity Framework. I'm using Visual Studio 2010 together with
Sybase ASE 15.7.

The Entity Framework creates a ExecuteFunction call using
instances of ObjectParameter to pass the input parameters of
the stored procedure. When the ExecuteFunction call is made
the parameters contain valid non-null values, but the stored
procedure receives only null values.

All trivial error sources such as mismatched names have been
thoroughly checked.

It's a long shot, but maybe someone else have encountered
this problem?

Regards
Håkan Nilsson.


Bret Halford Posted on 2012-04-30 15:27:40.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Disappearing in-parameters in Entity Framework stored procedures
References: <4f9e5d4f.76f1.1681692777@sybase.com>
In-Reply-To: <4f9e5d4f.76f1.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f9eaf6c$1@forums-1-dub>
Date: 30 Apr 2012 08:27:40 -0700
X-Trace: forums-1-dub 1335799660 10.22.241.152 (30 Apr 2012 08:27:40 -0700)
X-Original-Trace: 30 Apr 2012 08:27:40 -0700, vip152.sybase.com
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31061
Article PK: 73952


On 4/30/2012 3:37 AM, HÃ¥kan Nilsson wrote:
> Hello,
>
> I have a problem when calling stored procedure defined in an
> Entity Framework. I'm using Visual Studio 2010 together with
> Sybase ASE 15.7.
>
> The Entity Framework creates a ExecuteFunction call using
> instances of ObjectParameter to pass the input parameters of
> the stored procedure. When the ExecuteFunction call is made
> the parameters contain valid non-null values, but the stored
> procedure receives only null values.
>
> All trivial error sources such as mismatched names have been
> thoroughly checked.
>
> It's a long shot, but maybe someone else have encountered
> this problem?
>
> Regards
> HÃ¥kan Nilsson.

Is the procedure defined with default null values for
the parameters? If so, I'd still have some suspicion
about the parameter names somehow not matching up. But
there is no default or a non-null value default, it
would mean that the parameter value is somehow being
received as a null.

Have you tried dropping and recreating the procedure
to force the query tree to be rebuilt?

You might try using the RIBO utility to get a tracing
of the TDS packets sent to the server; this should help us
narrow down whether it is a server (ASE) or client problem
as it will show if the client is sending the right values
or nulls. The tool is in $SYBASE/jutils-3_0/ribo, html
documentation for it in $SYBASE/jutils-3_0/ribo/doc


-bret