Re: error 254
Posted in 1998
Topics: General Discussion
What version of Informix are you using? The possibility of table schema change always exist. There is another possibility. You may have two statement id and/or cursor with the same name in different module. The scope of cursor is global unless -local option used at the compile time. The limit is still 18 char, I think. Hope this helps -- Raja Mukherjee Sr. Software Engineer Virtual Solutions Inc. Sleeper, Derek wrote in message <6p51fk$mck$1@news.xmission.com>... > >Just for reference: > >254 Too many or too few host variables given. > >The number of host variables that you named in the INTO clause of this >statement does not match the number of "?" place holders that you wrote >into the statement. Locate the text of the statement (in a PREPARE or >DECLARE statement), and verify the number of place holders. Then review >the list in the INTO clause to see which item is incorrect. > >This error can be caused for various reasons. The most common two reasons I >have found are: > >1. A record variable is defined 'like' a whole table, (tablename.*) >and a prepared statement has the select explicitly defined (select col1, >col2, col3 ....) and the referenced table schema changes >2. A prepared select * is used and a record is explicitly defined and >the table changes. > >Check first for recent table changes then look to the code. > >Derek M. Sleeper >Management Information Consulting > <mailto:dsleeper@micinc.com> dsleeper@micinc.com / ><mailto:iidqs@brightpoint.com> iidqs@brightpoint.com > > > -----Original Message----- > From: pp [SMTP:jbarrera@isp.com] > Sent: Wednesday, July 22, 1998 5:20 AM > To: informix-list@iiug.org > Subject: error 254 > > Hi, > > Does anyone knows what could cause this error? because the program >that > cause the error is working fine since many years. > > Help will be appreciate > > Pedro > >