Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01019 Error

Re: ORA-01019 Error

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 14 Jun 1998 13:20:19 GMT
Message-ID: <3583cdca.9370193@192.86.155.100>


A copy of this was sent to "Elena Sotelo" <esotelo_at_ipmultimedia.es> (if that email address didn't require changing) On Thu, 11 Jun 1998 17:47:10 +0200, you wrote:

>I have a program that runs well in UNIX. It only adds users in a Oracle
>Database.
>
>If I runs the program from an html page (I want it works than a cgi), it
>shuts down when it trying to connect to Oracle and shows the next message:
>
>Error ORA-01019.
>
>Does anyone what this means? Why if I execute the program from line command
>it runs well, and from html page not?
>
>I'm working in UNIX, and Oracle 7.3.2.2.0
>
>Thanks in advance,
>
> Elena Sotelo
> esotelo_at_ipmultimedia.es
>

when you run it as a cgi-bin, the environment is not setup.

Make sure your webserver is putting

ORACLE_HOME=
ORACLE_SID= into the environment before running the program. One simply way to accomplish this is to wrap your C program with a small shell script that does the setting of the 2 environment variables before running the c program....  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Jun 14 1998 - 08:20:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US