Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David I. Berg — — source: Informix-list mailing list archive (1991-1998)
toddb@worf.infonet.net (Todd Breiholz) writes:
>I could sure use some help...
>I want to use a stored procedure to work with text data types.
>I am not using ESQL or 4GL as the calling application,
>so using a locator structure or the LOCATE statement is
>not a possibility. Can I get text data into and out of a
>stored procedure without using a locator structure or the
>LOCATE statement?
You can pass blobs through a procedure by defining the variable(s)
with the datatype "REFERENCES TEXT" or "REFERENCES BYTE", but you
cannot actually manipulate the blob value in SPL. (See Guide to
SQL Reference, Dec 91, pp 8-41 - 8-45.)
- David
>Thanks in advance.
>-------------------------------------------------------------
>Todd Breiholz | OoO OoO Oo oOoOo oOoOo oOoO oOoOoO
>Kirke-Van Orsdel, Inc. | oOo oOo oO OoOoO OoOoO OoOo OoOoOo
>toddb@worf.infonet.net | OoO OoO Oo oOoOo oOoOo oOoO oOoOoO
>-------------------------------------------------------------
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.