Re: Basic PRO*C problem

I notice that you are not using indicator variables. If the version of the RDBMS is 7.3 or higher you need to have indicator variables.

Ken

Patrick Drouin wrote:

> PRO*C is driving me crasy. I am trying to compile a VERY SIMPLE program
> that uses a cursor. I've done it in the past and ran into problem but
> moving some code around fixed it (don't ask why!). Now, it just won't
> budge.
> PRO*C compiles the C file without any problems but gcc or the Sun
> compiler will not accept the generated code (I would do the same...).
> Here's the snippet of my code. Anything wrong with this?
> /* We query the USER_PROFILES_CHANGES table */
> /* and grab all the entries. The ACTION column */
> /* tells us what to do and the status tells us */
> /* which rows we need to process. */
> EXEC SQL DECLARE user_list CURSOR FOR
> SELECT user_id, password, action
> FROM USER_PROFILES_CHANGES
> WHERE status=0;
> /* Open the cursor we have prepared */
> EXEC SQL OPEN user_list;
> /* Loop on the cursor and break if empty */
> EXEC SQL WHENEVER NOT FOUND DO break;
> for(;;){
> /* Fetch values into our HOST variables */
> EXEC SQL FETCH user_list INTO :new_user, :new_user_password,
> :action;
> printf("%s\t%s\t%s\n",new_user,new_user_password,action);
> }
> /* Close the cursor */
> EXEC SQL CLOSE user_list;

> Received on Mon Aug 16 1999 - 07:21:54 CDT