Subject String to BLOB field in SP??
Author Kevin Stanton
Greetings All,
Is there a way to have a declared string variable in a stored proc and then
perform an insert into a blob field?


TIA,
Kevin

What I want to do:

declare variable STally Varchar(255);


sp main body:
STally = STally || F_FIXEDPOINT(Pcs,0) || '/' || CLU || ' ';

insert into my_table(id, blobfieldname)
values(:id, :STally)