Re: SELECT and Pro*C/C++

In article <7tv3c3$gpe$1_at_nnrp1.deja.com>, Alex Vinokur <alexander.vinokur_at_telrad.co.il> wrote:
> Hi,
> ------------------------------------
> Using in SQL the following command
> SELECT * FROM FFF;
> I see on screen what I want to see
> (all rows of table FFF);
> ------------------------------------
> ------------------------------------
> Using in Pro*C/C++ he following code
> RWCString tmp_str = "SELECT * FROM FFF";
> EXEC SQL BEGIN DECLARE SECTION;
> const char* execute_line = ((const char*)tmp_str);
> EXEC SQL END DECLARE SECTION;
> EXEC SQL EXECUTE IMMEDIATE : execute_line;
> I give nothing on screen.
> ------------------------------------

The command line

        EXEC SQL EXECUTE IMMEDIATE "SELECT * FROM FFF"; also shows no output on screen

> =================================
> === Oracle 8.0.5
> === Pro*C/C++ : Release 8.0.5.0.0
> === SunOS 5.6
> =================================
> What is wrong?
> Thanks in advance,
> Alex
> Sent via Deja.com http://www.deja.com/
> Before you buy.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!