Subject Slightly OT: 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?

Sorry to ask this here, need a quick answer and not sure when the message
will hit the mers list server (very very slow!).


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)