Re: Connection Status.

From: Nicolas Issakides <nissakid_at_planete.net>
Date: 1998/04/15
Message-ID: <353526d0.0_at_news.kampot.pci>#1/1

winthin a Pro C program( like any program) , you can check for the eror status aftter the connect has been executed .

you can use :

exec sql whenever

                <sqlwarning | sqlerror | not found > 
                <continue | stop | goto label_name>

;
or you can use a more sophisticaed way :

always use whenever continue and do checking of the error withing the SQLCA structure.

This is well documented in the pro*C manuals and within the samples distributed with Oracle.

Hope this will help you .

In article <3531fc1b.7712807_at_news.netvigator.com>, MEYOU_at_ComPorts.com wrote:
>Is there anyway to check connection status after "CONNECT" call in a
>Pro*C program?
>
>Need to know how very urgently. Please help!
>
>Regards
>
>Steven

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Wed Apr 15 1998 - 00:00:00 CEST