Re: OWS 7.12 (One with SuiteSpot) - Prob with cursors in Stored Proc

Hiren Bhatt wrote: > > We are using the Informix OWS 7.12 which comes bundled with Netscape > Suite Spot and we are trying to use cursors in Stored procedures. > > Is there any kind of limitations on this version of Informix OWS ? > > The problem we are having is as follows. > > I am getting a 201 error while doing a DECLARE CURSOR. I get the same > error if i move the SQL statement to a PREPARE statement preceeding the > DECLARE CURSOR statement. You simply have a syntax error in your SQL statement. :-) Cheers, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+