Re: Stored Proc problems
Posted in 1994
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL
In reply to your message of Mon Dec 19 23:19:18 1994
-------
> We are experiencing some problems with the use of stored procedures and I am
> interested to see if anyone else has encountered these problems and what they have
> done or what suggestions you might have for me.
Debbie,
I have very similar problem.
Workaround: create arbitrary small procedure, f.e.:
CREATE PROCEDURE bugFixed()
END PROCEDURE;And include its call in each 4gl module:
MAIN
...
PREPARE st_id FROM "EXECUTE PROCEDURE bugFixed()"
EXECUTE st_id
COMMIT WORK
...
-- Your work begin here...
...
END MAIN
It's work for me fine! Sorry, if for you not...
I would glad to listen to you again, if it helps.
-------
Yours,
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. Igor G.Popov . Laboratory of Open Information Systems, ltd. .
. res@lois.perm.su . Russia, Perm, b. Gagarina 49, +7-3422-486374 .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .