Re: Multiple Embedded SQL statements in one function

No problem at all. I do it all the time.

Somthing like:

static void Myfunct(void)
{

   EXEC SQL
   SELECT 'X' INTO :Myhost var FROM dual;

   EXEC SQL
   SELECT 'Y' INTO :AnotherHostVar FROM dual;

   return;
}

is ok to do in Pro*C

--
Alan D. Mills

Teresa Mah wrote in message <364A06E8.90AFB6CB_at_home.com>...
>Hi,
>
>Does anyone know if it's okay to have more than one embedded SQL
>statement in a C function? (that is, besides commit or rollback, i.e.
>multiple inserts, or multiple selects)
>
>Thanks.
>
>Teresa
Received on Fri Nov 13 1998 - 05:36:08 CST