RE: The value of variable is disappearing in stored procedure

SSC Guru

Points: 323504

April 30, 2010 at 11:15 am

chaturvedi.garima (4/30/2010)
Hi!!!
The variable is initialized in a stored procedure with the value present in a table.
It is disappearing at later point of time.The data type of variable is Char.
Tried to print the value, it displays as NULL.:(
Please help me...

so....are you going to show us the stored procedure? can't really help without that; there must be something changing the data if you say it was initialized to some value, or it was not assigned a value from your table when ou thought it was.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!