Home > Archive > ASE Database forum > April 2005 > Date as UDT parameter in Stored Proc









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Date as UDT parameter in Stored Proc
David Speight

2005-04-06, 7:02 am

Just upgraded to 12.5.3 from 12.5.03

A stored procedure executed with a date parameter fails with
can;t convert varchar to numeric under 12.5.03 but works in
12.5.3.

Not such a problem but can't see this as one of the
documented fixes. anyone have any idea when this was fixed.

The reason I want to know is, if this has changed, then what
else has?

Look forward to your answers!
Dave
Bret Halford

2005-04-06, 8:03 pm

In the specific - if you can isolate the issue down to a particular
command (and associated values) that gets the error, and post
that and the exact error, I may be able to tell you when it was fixed.

In general - you will find descriptions of changes both in the
coverletters
(describing various defect CRs that have been addressed) and in the
"What's New" and "Release Bulletin" documents (and other docs)
for the new versions. However, it is also just a fact of life that
not all the changes are documented.

Cheers,
-bret


David, Speight wrote:

> Just upgraded to 12.5.3 from 12.5.03
>
> A stored procedure executed with a date parameter fails with
> can;t convert varchar to numeric under 12.5.03 but works in
> 12.5.3.
>
> Not such a problem but can't see this as one of the
> documented fixes. anyone have any idea when this was fixed.
>
> The reason I want to know is, if this has changed, then what
> else has?
>
> Look forward to your answers!
> Dave


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com