Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Local image variable on stored procedure

Status
Not open for further replies.

netangel

Programmer
Feb 7, 2002
124
PT
I need to call a stored procedure that has an image type parameter, from within a cursor.

My cursor fetches thru a table and one of it's returns is an ID to another table that has an image.
Then I execute a stored procedure that copies that image field to a third table.

My problem is sending the image from a table to a stored procedure. I was trying to use a variable, but I got the error message:

'The text, ntext, and image data types are invalid for local variables.'


I have no ideas how to solve this problem.

Is this possible?
NetAngel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top