Re: Avoiding ORACLE_SID environment variable
From: Jerome Grandjanny <grandjanny_at_ldg.bruyeres.cea.fr>
Date: 1996/01/22
Message-ID: <4e09mk$7lh_at_news.cea.fr>#1/1
Date: 1996/01/22
Message-ID: <4e09mk$7lh_at_news.cea.fr>#1/1
Use :
exec sql connect :user identified by :password using :database_id ;
where :database_id is a varchar containing the database identification such as "T:server:sid"
Or you can call :
putenv ( "ORACLE_SID=xxxx" ) ;
just before the exec sql connect statement.
Hope this will help
Best regards.
J.G.
Received on Mon Jan 22 1996 - 00:00:00 CET