Re: select and insert long column in a stored procedure

Try to bind it to a long variable example something like.

Please exuse incorrect SQL I think you get the idea.

DECLARE
L_longCol Long;
BEGIN select x from source into L_longCol;
insert (y) into dest values(:L_longCol);

END; HTH Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 11 2000 - 00:00:00 CDT