Defining default database from within Pro*C
From: Navis Corp <navis_at_netcom.com>
Date: Wed, 27 Jul 1994 00:47:45 GMT
Message-ID: <navisCtKq7L.Crs_at_netcom.com>
Date: Wed, 27 Jul 1994 00:47:45 GMT
Message-ID: <navisCtKq7L.Crs_at_netcom.com>
Does anyone know of a way to change the default database from within a Pro*C program? I know you can reference a non-default database using DECLARE DATABASE and CONNECT ... AT, but this means I have to use the "AT" notation for all my SQL embedded calls. I want to avoid having to does this, and I don't want to change the ORACLE_SID environment variable. I'm looking for something equivalent to a "DECLARE DEFAULT DATABASE" statement. Anyone else tried this?
Thanks
--- Sung U. Kim | Navis Corporation Senior Software Engineer | 1616 Franklin St., Suite 204 kims_at_navis.com | Oakland, CA 94612 Voice: (510)763-5715 | U.S.A.Received on Wed Jul 27 1994 - 02:47:45 CEST