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.
Dority — — source: Informix-list mailing list archive (1991-1998)
> What i am having trouble doing is
>getting the SQL procedure to execute and return a value.
>let s = "execute procedure p() into v"
>prepare e_SPL from s
>execute e_SPL
You're going to need to use a cursor to return rows back to
the front end.....
prepare e_SPL from "execute procedure p()"
declare x cursor for e_SPL
open x
-- if multiple values are going to returned --- set up a loop
fetch x into variable_list
J. Dority
Your privacy choices
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.