Subject | String to BLOB field in SP?? |
---|---|
Author | Kevin Stanton |
Post date | 2000-12-05T17:18:16Z |
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)
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)