I am using Informix5.03 running on SunOS UNIX. I use stored procedures
in my 4gl modules. Everything was ok until I got the following error message:
--------------------------------------------------
Program stopped at "obs.4gl", line number 722.
SQL statement error number -674.
Procedure (oidb.getprogsofstudent) not found.
SYSTEM error number -111.
ISAM error: no record found.
--------------------------------------------------
The interesting thing is that the owner of the procedure
"getprogsofstudent" is "omer", not "oidb". The procedure exists,
and when I execute it from dbaccess, it works properly. Moreover,
there are some other procedures whose owner are "oidb" and programme
gives an error "procedure (omer.######) not found". By the way,
my 4gl module does not crash in the same procedure when I run
it at the different times. Today's "menu" is <getprogsofstudent>,
"chief's advise" in tomorrow may be <defineStudentId> :-)
What's happening ?
Is there anybody to help me ?
Thanks....
====================================================================
Omer OZTAN
Research Assistant e-mail
Middle East Technical University omer@rorqual.cc.metu.edu.tr
President's Office oztan@daimler.me.metu.edu.tr
Computer Center omer@knidos.cc.metu.edu.tr
oztan@ceng.metu.edu.tr
====================================================================