Subject | blobs and stored procedures |
---|---|
Author | Marcelo Miorelli |
Post date | 2001-01-06T23:06:08Z |
Untitled-1
Dear friends,
This message will be multiposted because I desired to reach everybody who
helped me.
Many persons have tried to help me but they simply gave me wrong clues, or
simply ignored the fact of properly working with blobs or with stored
procedures. Several persons told me that I could never do what I was
intending to. They we're wrong.
I am currently inserting, updating, retrieving the data or deleting a record
containing a text blob, everything through stored procedures.
It costed me several sleepless nights, much anxiety and doubts.
Now that I have the answer I would like to share it with everybody
interested. I will send the delphi 5 source code, and the source code of the
table and stored procedures related to everybody interested. Just send me a
private e-mail asking me.
Hope you are all well,
Marcelo Miorelli
My sincere acknowledgement to all these persons bellow, all have contributed
in sme way or other:
Thanks Francis Brock - without his help I would have given up the idea of
inserting and retrieving data from a blob using stored procedures.
Thanks Steave Peacocke for the knowledge shared.
Thanks Henri Fournier for telling me about the site www.deja.com.
Thanks Christophe Téla for his help on "invalid blob id" - Now I know what
causes this message - it's only an attempt to insert a record containing a
blob, resulting in SQLCODE -803 but not caught by the exception.
Thanks Art Metz for the attention.
Thanks Jesús A. García Zarco, Jorrit Jongma,Mark Kuhnke for the patience.
Thanks Helen Borrie for all advices.
Thanks Claudio Valderrama C. and Aage Johansen for the advices and sorry for
the multiposting, but I was really desperated! :-)
Dear friends,
This message will be multiposted because I desired to reach everybody who
helped me.
Many persons have tried to help me but they simply gave me wrong clues, or
simply ignored the fact of properly working with blobs or with stored
procedures. Several persons told me that I could never do what I was
intending to. They we're wrong.
I am currently inserting, updating, retrieving the data or deleting a record
containing a text blob, everything through stored procedures.
It costed me several sleepless nights, much anxiety and doubts.
Now that I have the answer I would like to share it with everybody
interested. I will send the delphi 5 source code, and the source code of the
table and stored procedures related to everybody interested. Just send me a
private e-mail asking me.
Hope you are all well,
Marcelo Miorelli
My sincere acknowledgement to all these persons bellow, all have contributed
in sme way or other:
Thanks Francis Brock - without his help I would have given up the idea of
inserting and retrieving data from a blob using stored procedures.
Thanks Steave Peacocke for the knowledge shared.
Thanks Henri Fournier for telling me about the site www.deja.com.
Thanks Christophe Téla for his help on "invalid blob id" - Now I know what
causes this message - it's only an attempt to insert a record containing a
blob, resulting in SQLCODE -803 but not caught by the exception.
Thanks Art Metz for the attention.
Thanks Jesús A. García Zarco, Jorrit Jongma,Mark Kuhnke for the patience.
Thanks Helen Borrie for all advices.
Thanks Claudio Valderrama C. and Aage Johansen for the advices and sorry for
the multiposting, but I was really desperated! :-)