Question on connect to oracle #cr001201

Kenneth Cheong

unread,

Mar 18, 1999, 3:00:00 AM3/18/99

to

To whom it may concern,

I have attached the perl file that I write to connect to oracle database.
Can you see my code to tell me why I cannot connect to oracle server.
Thanks for your help.

Kenneth

orp.pl

Robert J. Turner

unread,

Mar 18, 1999, 3:00:00 AM3/18/99

to

Try this..
$ENV{"ORACLE_HOME"} = "/usr/caen/oracle-8.0.4/local/caen"

--Rob

Woody Kellum

unread,

Mar 19, 1999, 3:00:00 AM3/19/99

to

You need to set the variable TNS_ADMIN;
$ENV{"TNS_ADMIN"} = "/usr/caen/oracle-7.3/local";
and make sure you delineate your select columns - '*'
does not work, so instead of
"SELECT * FROM Student"
you need
"SELECT studentid,firstname FROM Student"
- Woody

In message <Pine.SOL.4.02.990318...@blue.engin.umich.edu>, Kenneth Cheong writes:
> This message is in MIME format. The first part should be readable text,
> while the remaining parts are likely unreadable without MIME-aware tools.
> Send mail to mi...@docserver.cac.washington.edu for more info.
>
>---559023410-851401618-921817973=:29753
>Content-Type: TEXT/PLAIN; charset=US-ASCII

>
>To whom it may concern,
>
>I have attached the perl file that I write to connect to oracle database.
>Can you see my code to tell me why I cannot connect to oracle server.
>Thanks for your help.
>
>Kenneth
>

>---559023410-851401618-921817973=:29753
>Content-Type: TEXT/PLAIN; charset=US-ASCII; name="orp.pl"
>Content-Transfer-Encoding: BASE64
>Content-ID: <Pine.SOL.4.02.99...@blue.engin.umich.edu>
>Content-Description:
>Content-Disposition: attachment; filename="orp.pl"
>
>IyEvdXNyL3VtL2Jpbi9vcmFwZXJsDQojIHVzZSBPcmFwZXJsOw0KIyBkbyAi
>Y2dpLWxpYi5wbCIgfHwgZGllICJDYW5ub3QgaW1wbGVtZW50IGNnaS1saWIg
>XG4iOw0KIyAmUmVhZFBhcnNlOw0KDQokRU5WeyJPUkFDTEVfSE9NRSJ9ID0g
>Ii91c3IvY2Flbi9vcmFjbGUtOC4wLjQiOw0KJHNPcmFjbGVfaWQgPSAibXVz
>Y2xlIjsNCiRzVXNlcm5hbWUgPSAiRTU4NF8zMSI7DQokc1Bhc3N3b3JkID0g
>ImJsdWVza3kiOw0KDQojIFdlIGNvbm5lY3QsIGxvZ2luIGFuZCBnZXQgYSBo
>YW5kbGUgdG8gdGhlIGNvbm5lY3Rpb24NCiMgaW4gc2NhbGFyICRoQ29ubmVj
>dGlvbi4NCg0KJGhDb25uZWN0aW9uID0gJm9yYV9sb2dpbigkc09yYWNsZV9p
>ZCwgJHNVc2VybmFtZSwgJHNQYXNzd29yZCkgfHwgZGllIA0KJG9yYV9lcnJz
>dHI7DQoNCiRoUXVlcnkgPSAmb3JhX29wZW4oJGhDb25uZWN0aW9uLCAiU0VM
>RUNUICogRlJPTSBTdHVkZW50Iik7DQpwcmludCAiQ29udGVudC10eXBlOiB0
>ZXh0L2h0bWwgXG5cbiI7DQoNCkBhc1F1ZXJ5UmV0dXJuID0gJm9yYV9mZXRj
>aCgkaFF1ZXJ5KTsNCg0Kd2hpbGUgKEBhc1F1ZXJ5UmV0dXJuICE9IDApDQp7
>DQogcHJpbnQgIllvdSBtYXkgcmVhY2ggJGFzUXVlcnlSZXR1cm5bMF0gYXQg
>JGFzUXVlcnlSZXR1cm5bMV0gXG4iOw0KIEBhc1F1ZXJ5UmV0dXJuID0gJm9y
>YV9mZXRjaCgkaFF1ZXJ5KTsNCn0gDQoNCiMgQ2xvc2UgdGhlIHF1ZXJ5Lg0K
>Jm9yYV9jbG9zZSgkaFF1ZXJ5KTsNCg0KIyBMb2dvZmYgYW5kIENsb3NlIENv
>bm5lY3Rpb24uDQomb3JhX2xvZ29mZigkaENvbm5lY3Rpb24pOw0K
>---559023410-851401618-921817973=:29753--

Woody Kellum

unread,

Mar 19, 1999, 3:00:00 AM3/19/99

to

Also, you should use oracle-7.3 for ORACLE_HOME, i.e.
$END{"ORACLE_HOME"} = '/usr/caen/oracle-7.3";
- Woody

------- Forwarded Message

To: Kenneth Cheong <kch...@engin.umich.edu>
cc: oracle-...@engin.umich.edu, l...@engin.umich.edu
Subject: Re: Question on connect to oracle #cr001201
Date: Fri, 19 Mar 1999 11:48:21 -0500
From: Woody Kellum <l...@engin.umich.edu>
Status: