Re: A question in pro*C??

From: <justvrk_at_hotmail.com>
Date: Thu, 04 Mar 1999 08:38:58 GMT
Message-ID: <7blgr1$sl9$1@nnrp1.dejanews.com>

Hi Simrion:
U need to indicate that the host variable "tablename" is to be used in SQL statement. So just declare a new char ptr as follows:

int ORA_GetColumnInfo(char *tablename)
{
EXEC SQL BEGIN DECLARE SECTION;
char *tmpTableName;
EXEC SQL END DECLARE SECTION;
. . . .
.. . . .

Then make tmpTableName to point to the parameter tablename. Use tmpTableName in the EXEC SQL statement. The moral is U have to fore tell Pro*C precompiler that the variable will be used in SQL statements. Hope this works.

Vinayak Kulkarni

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 04 1999 - 02:38:58 CST