137 must declare the scalar variable @XXXX

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

137 must declare the scalar variable @XXXX

Author

Topic

suresh.vadlamudi
Starting Member

3 Posts

Posted - 2010-07-23 : 03:06:49

Hi,
I am using MSSQL 2005.And i have created database containing some 5 to 6 tables in that.When i am running my application using this database ..every time i am getting 137 must declare the scalar variable @XXXX .
Could any one help me on this ...why i am getting this kind of error..

Thanks and Regards
Suresh.Vadlamudi

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-23 : 03:25:20

We don't know what your app is doing...

No, you're never too old to Yak'n'Roll if you're too young to die.

suresh.vadlamudi
Starting Member

3 Posts

Posted - 2010-07-23 : 03:36:07

Our application is a Java Based webapplication..using JDBC connection we are hitting this database.Thing is I am sure ...thr is no problem in application level...i am sure that there is some issue with the database (Sql Server2005) ... even i have googled for this kind of error ...but all most all the cases this kind of problem is coming with storedProcedures. But in my case i am not using any kind of stored procedures.
If anybody knows the reasons ..please suggest

Thanks & Regards
Suresh.Vadlamudi

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-07-23 : 03:36:21

Post your query here

KH
[spoiler]Time is always against us[/spoiler]

suresh.vadlamudi
Starting Member

3 Posts

Posted - 2010-07-23 : 03:39:09

KH???????????

quote:
Originally posted by khtan

Post your query here

KH
[spoiler]Time is always against us[/spoiler]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-07-23 : 03:44:44

quote:
Originally posted by suresh.vadlamudi

KH???????????
quote:
Originally posted by khtan

Post your query here

KH
[spoiler]Time is always against us[/spoiler]

What did you mean?
Can you post the code that cuased this error?

Madhivanan

Failing to plan is Planning to fail

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-07-23 : 03:53:18

We can't really help from what you describe. It is too generic. You need to post your query that cause the error here

KH
[spoiler]Time is always against us[/spoiler]

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2010-07-23 : 07:02:51

quote:
Originally posted by suresh.vadlamudi

Our application is a Java Based webapplication..using JDBC connection <snip> But in my case i am not using any kind of stored procedures.
If anybody knows the reasons ..please suggest

Thanks & Regards
Suresh.Vadlamudi

Found your reasons.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2010-07-23 : 12:08:22

herein lies the problem
Thing is I am sure ...thr is no problem in application level...i am sure that there is some issue with the database (Sql Server2005)
Can you please post the code that calls the database. If you are not calling a stored procedure I am sure :) you are doing some inline sql statement

If you don't have the passion to help people, you have no passion

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources