[Tutor] Whats wrong with this code..??
shobhan
schalla@vasoftware.com
Fri Nov 15 12:39:02 2002
--------------000607080806090309050801
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Forgot to tell that the python program is executed on the browser of
another machine, and its trying to connect to the Oracle DB on my machine.
And it doesnt show any errors when i use sqlplus.
BTW, ur right i can import modules on the same row, it also makes the
program compact.
I'll check if im missing anything in my path
Regards
Schalla :)
Magnus Lycka wrote:
> At 20:01 2002-11-15 +0530, shobhan wrote:
>
>> dbapi = __import__('cx_Oracle')
>
> I Huh? Why not
>
> import cx_Oracle as dbapi?
>
> BTW, you can import several modules on the same row by
> separating them with comma. (I prefer compact programs.)
>
>> Traceback (most recent call last):
>> File "/sourceforge/sfee/www/search/cc_scm_content.py", line 15, in ?
>> dbh = dbapi.connect(logger_conf.db_dsn)
>> cx_Oracle.DatabaseError: Error while trying to retrieve text for
>> error ORA-12154
>
>
> See
> http://www.is.mcgill.ca/minerva/Help/ora12154.htm
>
> for and explanation on the original error. Then you could
> obviously not get the error messages. I don't remember what
> used to cause this. I haven't worked with Oracle since the
> spring of 1998. A missing path? Some environment variable?
> Does it show error messages from the Oracle tools such as
> sqlplus?
>
>
>
--------------000607080806090309050801
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
<font face="Helvetica, Arial, sans-serif" size="-1">Forgot to tell that the
python program is executed on the browser of another machine, and its trying
to connect to the Oracle DB on my machine.<br>
And it doesnt show any errors when i use sqlplus.<br>
<br>
BTW, ur right i can import modules on the same row, it also makes the program
compact.<br>
I'll check if im missing anything in my path <br>
<br>
Regards<br>
Schalla :)<br>
</font><br>
<br>
<font face="Helvetica, Arial, sans-serif" size="-1">Magnus Lycka wrote:<br>
</font>
<blockquote type="cite"
cite="mid5.1.0.14.0.20021115181058.029d3d58@www.thinkware.se"><font
face="Helvetica, Arial, sans-serif" size="-1">At 20:01 2002-11-15 +0530,
shobhan wrote: <br>
<br>
</font>
<blockquote type="cite"><font face="Helvetica, Arial, sans-serif"
size="-1">dbapi = __import__('cx_Oracle') <br>
</font></blockquote>
<font face="Helvetica, Arial, sans-serif" size="-1">I </font><font
face="Helvetica, Arial, sans-serif" size="-1">Huh? Why not </font><br>
</blockquote>
<blockquote type="cite"
cite="mid5.1.0.14.0.20021115181058.029d3d58@www.thinkware.se"><font
face="Helvetica, Arial, sans-serif" size="-1"><br>
import cx_Oracle as dbapi? <br>
<br>
BTW, you can import several modules on the same row by <br>
separating them with comma. (I prefer compact programs.) <br>
<br>
</font>
<blockquote type="cite"><font face="Helvetica, Arial, sans-serif"
size="-1">Traceback (most recent call last): <br>
File "/sourceforge/sfee/www/search/cc_scm_content.py", line 15, in ? <br>
dbh = dbapi.connect(logger_conf.db_dsn) <br>
cx_Oracle.DatabaseError: Error while trying to retrieve text for error ORA-12154
<br>
</font></blockquote>
<font face="Helvetica, Arial, sans-serif" size="-1"><br>
See <br>
<a class="moz-txt-link-freetext" href="http://www.is.mcgill.ca/minerva/Help/ora12154.htm">http://www.is.mcgill.ca/minerva/Help/ora12154.htm</a> <br>
<br>
for and explanation on the original error. Then you could <br>
obviously not get the error messages. I don't remember what <br>
used to cause this. I haven't worked with Oracle since the <br>
spring of 1998. A missing path? Some environment variable? <br>
Does it show error messages from the Oracle tools such as <br>
sqlplus? </font> <br>
<br>
<br>
<br>
</blockquote>
<br>
<br>
</body>
</html>
--------------000607080806090309050801--