| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> simple embedded C/SQL question
Hello, I have a simple C code program with some embedded SQL in it. I have something like this:
...
char *query_string;
....
query_string = getenv("QUERY_STRING");
....
EXEC SQL DECLARE est_cursor CURSOR FOR
SELECT library, ESTs
FROM cluster_annotation
WHERE query_string;
Note:query_string would look something like db_id=1234
A little later on, I will be printing out something like:
library ESTs ------- ------- yodnorm 21345 87649 3008 tumor1 49484 84484
Now I can't get the syntax correct for the where clause to accept my variable. Could someone explain the correct syntax/method(s) to do this? Thanks for your time and help.
David
djd_at_u.washington.edu
p.s. system info: SunOS 5.5.1, oracle server: 7.2.3.0.0 Received on Tue Jun 23 1998 - 18:50:20 CDT
![]() |
![]() |