Use of PREPARE in Pro*C

Hi Pro*C Gurus,

I am trying to use to cursors in my Pro*C code and keep getting an error ORA-00911 Invalid Character. Does anybody know what that error means? I am using Oracle 7.3 on Ultrix. The syntax I am using is as follows

VARCHAR SqlString[100];
.
.

SqlString.len = sprintf ( SqlString.arr, "SELECT ID FROM STUDENTS"); EXEC SQL PREPARE LIST FROM :SqlString;

When I tried putting printf statements to try and see how far the program goes, I figured out that the PREPARE statement is the one whihc is gawking. If anybody could provide any pointers as to what the correct syntax ought to be, I would really appreciate it. Thanks for taking the time to read this posting and reply. You could either send me mail at nmoni_at_hotmail.com or post to his news group.

Sincerely,
Anish Received on Fri Jun 05 1998 - 00:00:00 CDT