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
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