Re: problem in creating store procedure

>i'm using informix online dynamic server 7.2. when i create a store >procedure using dbaccess, it reports error number 279 indicating no >space to create temporary table. but i have 2 gb hard disc and enough >space on it. i created one simple procedure with the following sql > > SELECT name FROM master > WHERE code = sp_code> >where sp_code is parameter for this procedure. > >if the same sql is written as > >select name from master >where code = 'abc'> >the store procedure is created without any problem!!! > >can anyone help me please!!!! >my mail id is venkat@pacific.net.sg > I bet you have a listing file specified in the stored procedure (or maybe there is an automatic one for 7.20 - We are still on 7.11). If the directory does not have public write permissions, even if the current user/group does, the stored procedure compiler barfs when it attempts to create the listing file. The reason that the second form works, is that it eliminates the "warning" that the first form generates. (Warning: sp_code is a variable, not a database column). There doesn't seem to be any way of circumventing the warning that I know of. Change the listing file name to go into /tmp and you should be able to compiler the SP. It has been my experience that the listing files are close to worthless anyway. Paul. ----------------------------------------- Paul Kapp - Database Engineer plkapp@aol.com OR plk@interactive.visa.com