HELP! ORA-0911 on ProC PREPARE statement

From: Stephen M. Deal <deal_at_tempus.Kodak.Com>
Date: Sat, 18 Sep 93 03:35:38 GMT
Message-ID: <1993Sep18.033538.10288_at_kodak.rdcs.kodak.com>


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.

My select statement processes correctly in SQLplus but ProC cannot seem to digest the string. Has anyone experienced this problem and found the cause?

Any help would be greatly appreciated!

  +====================================================================+

| Steve Deal | Internet: deal_at_Kodak.COM |
| Eastman Kodak Co. | UUCP: ...rutgers!rit!kodak!tempus!deal |
| Engr. Systems Div. | Voice: (716) 722 - 2850 |
| mailcode: 03059 | FAX: (716) 588 - 2721 |
| 2400 Mt. Read Blvd. | |
| Rochester, NY | |
| 14650-3059 | |
+====================================================================+
Received on Sat Sep 18 1993 - 05:35:38 CEST

Original text of this message