Execute string as SQL query in C

Question

it's possible to execute a string as a SQL query in C and get the result? I'm trying to compile this code:

EXEC SQL
    EXECUTE IMMEDIATE : sql_formula INTO :sql_prec_desconto_mp;

But I've this error:

Error at line 10548, column 35 in file

D:\syncs\AIX\fuentes\funcn\niv2\src\rutin as.pc
            EXECUTE IMMEDIATE : sql_formula INTO :sql_prec_desconto_mp;
PCC-S-02201, Encountered the symbol "INTO" when expecting one of the following:

; ( [ . ++ -- ->

How can I get the result of the SQL query? If I remove the INTO clause I can compile without errors.

Thanks in advance.

Alex Poole · Accepted Answer · 2016-11-15 20:00:07Z

1

That format is described in the documentation:

To prepare and execute a DELETE, INSERT, or UPDATE statement or a PL/SQL block containing no host variables.

You aren't doing one of those DML types, and those don't recognise INTO. When you run a dynamic SQL query without an INTO the query is never actually executed (see the note in the docs).

The quickest way that immediately comes to mind to do what I think you want, is to prepare a cursor and fetch the result:

EXEC SQL PREPARE stmt FROM :sql_formula;
EXEC SQL DECLARE cur CURSOR FOR stmt;
EXEC SQL OPEN cur;
EXEC SQL FETCH cur INTO :sql_prec_desconto_mp;

answered Nov 15, 2016 at 20:00

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

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

1 Comment

Miguel Martins Over a year ago

Thanks for the answer, that code solved my problem! :)

Collectives™ on Stack Overflow

Execute string as SQL query in C

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