C error SQL pointer

Question

My function takes pointer *d as parameter.

I wrote that line - EXEC SQL VAR d->x is STRING; Actually I want a variable which can store the value of d->x. with that variable i can manipulate some other work.

I get the following error

 Semantic error
 EXEC SQL VAR d->x is STRING;

Waiting for your suggestions.

post the code please, and tell us which database you are using. — Erich Kitzmueller
– Erich Kitzmueller, Commented Feb 18, 2010 at 10:09
Who gives you such error? Did you compile your source using proc ? — qrdl
– qrdl, Commented Feb 18, 2010 at 11:02
make doesn't compile by itself - it invokes some other programs, based on dependency rules. So my question is - which program gets invoked by make to perform actual compilation? Or this question is no longer relevant, as you have accepted obviously incorrect answer? — qrdl
– qrdl, Commented Feb 18, 2010 at 12:43

Alok Singhal · Accepted Answer · 2010-02-18 10:33:03Z

1

If I were to guess, you want to have a char array, or a char pointer with enough memory, and then put your query string in it:

char query[BIG_ENOUGH];
sprintf(query, "EXEC SQL VAR %s is STRING;", d->x);

The above assumes that your have a string in d->x, and that you want the string value in your SQL query. I don't know if your SQL query is well-formed though.

If this is not what you want, you need to post more information.

answered Feb 18, 2010 at 10:33

Alok Singhal

96.8k21 gold badges130 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

qrdl Over a year ago

Miss! EXEC SQL VAR is Oracle's embedded SQL statement, can be included directly into source

Collectives™ on Stack Overflow

C error SQL pointer

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related