Stored Procedure Param limitation - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

chadmc
Free support Topic Starter

2009-09-11T22:29:21Z

When running task of type SQL - Stored Procedure I am attempting to pass a large varchar param. The SP accepts varchar(max), but VC appears to be truncating the value to 50 chars. I've tried using datatypes varchar and text, and disabling validate, with similar results.

Anyone using Stored Procedure successfully with param values > 50 chars?

-Chad

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

2009-09-12T08:11:50Z

You get no error? It is just truncated?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

chadmc
Free support Topic Starter

2009-09-14T15:23:38Z

That is correct.

mattmw24
Free support

2009-12-21T15:24:41Z

Is there a resolution to this issue?! I'm stuck on the same thing. Although I'm not even getting 50 characters before I get truncated. Please help asap!

Thanks,
Matt

🤬

Support
Official support

2009-12-21T15:27:25Z

We'll look at this. Are you running against SQL server?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

Support
Official support

2009-12-21T15:30:46Z

Are you using ODBC or native SQL?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

mattmw24
Free support

2009-12-21T15:56:00Z

Yes, SQL 2005, ODBC connection. Thanks for the quick replies.

Matt

mattmw24
Free support

2009-12-21T16:41:27Z

Also, FYI, I am running version #5.3.1 if that makes a difference.

My User defined variable is getting truncated after 21 characters, regardless of whether I use it as a parameter to a stored procedure, or whether I try and call the stored proc via a direct SQL statement. However, the "Value Preview" window shows the entire string.

Matt

Edited by user 2009-12-21T16:51:05Z | Reason: Not specified

Support
Official support

2009-12-22T11:54:08Z

Can you please test this version. After install, edit the parameter and set Size to Max.

http://www.visualcron.co...m.aspx?g=posts&t=997

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

mattmw24
Free support

2009-12-22T20:44:02Z

#10

Do you mean I should just install the client and try it, or install it as a VC server? It'll be tough to upgrade the server as we have a few systems we'll have to test, but if we can upgrade only the client it won't be as big of a deal.

Thanks,
Matt