|
From: John H. <jh...@im...> - 2011-07-30 14:38:43
|
On Fri, 29 Jul 2011, Aaron Harrison wrote: > SELECT T1.procid, T2.data, T2.seqno > FROM informix.sysprocedures AS T1, informix.sysprocbody AS T2 > WHERE procname = ? > AND T2.procid = T1.procid > AND datakey = 'T' > ORDER BY T1.procid, T2.seqno > > If I execute this, it fails, and I get: > > Error: Too many or too few host variables given. Replace the ? with the quoted name of the SP you want to list. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Bipartisanship (n): Shut up about your principles and vote the way the President tells you to! ----------------------------------------------------------------------- 6 days until the 276th anniversary of John Peter Zenger's acquittal |
