Replacing PREPARE

Hello all,

I have been given some C code that contained some of Oracle's SQL
calls. One of the types of call is a fetch that uses the PREPARE
command. I am having trouble coming up with a work around and would
appreciate any suggestions.

Code snip:

sprintf( query, "SELECT first, second FROM table_name where %s = %s",
value1, value2 );

EXEC SQL PREPARE :select_str USING :query;

EXEC SQL DECLARE my_cursor CURSOR FROM :select_str;

EXEC SQL OPEN my_cursor;

EXEC SQL FETCH FORWARD 1 IN my_cursor INTO :value1, :value2;

Thanks in advance,
Paul E Stephens