Re: HELP! ORA-0911 on ProC PREPARE statement

Stephen M. Deal (deal_at_tempus.Kodak.Com) wrote:
: I strcpy a query (e.g. select name from emp) into a character array
: (char select[100]). When it is parsed by the PREPARE statement I get
: ORA-0911, invalid character from sqlca.sqlerrm.sqlerrmc with the
: sqlca.sqlerrd array coming up all 0's (0,0,0,0,0,0). This implies that
: the parse error occurs on the first character.

Not sure whether this has anything to do with this or not, but could it be the NULL terminator (hex 00) that strcpy is attaching to the end of the string?

--
------------------------------------------------------------------------------
Ian Steel.											  ian_at_bstone.demon.co.uk
Kettering, England.
------------------------------------------------------------------------------