Pro*C and dynamic SQL

Hello,

I try to use dynamic sql with a bind variable but it doesn't work :

strcpy(MyString, "SELECT MyTable.NEXTVAL from dual"); EXEC SQL PREPARE S FROM :MyString;
EXEC SQL EXECUTE S INTO :nSequence;

=> nSequence is always = 0

(of course, the sequence is not null when I execute the query with SQL*Plus)

What is the problem ?

Thanks in advance.

-- 
Ce message a ete poste via la plateforme Web club-Internet.fr
This message has been posted by the Web platform club-Internet.fr

http://forums.club-internet.fr/