The following bug has been logged online:

Bug reference: 2517
Logged by: Sergey Konoplev
Email address: konoplev (AT) gw (DOT) tander.ru
PostgreSQL version: 8.1.4
Operating system: SUSE LINUX Enterprise Server 9
Description: Trouble with cx_Oracle and Plpython
Details:

Good day.

I’ve got a trouble with cx_Oracle and Plpython (PostgreSQL).

The function DDL:

CREATE OR REPLACE FUNCTION "public"."function1" () RETURNS varchar AS
$body$
import cx_Oracle
connection = cx_Oracle.connect('xxx', 'xxx', 'xxx')
$body$
LANGUAGE 'plpythonu' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

The function has executed successfully via psql interactive tool with local
transport.

pgdb:/ # /opt/PostgreSQL/bin/psql -U postgres -d transport
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

transport=# select * from function1();
function1
-----------

(1 row)

transport=#

But ORA-12154 error has been raised via same tool with remote transport.

pgdb:/ # /opt/PostgreSQL/bin/psql -U postgres -d transport -h
192.168.101.181
Password for user postgres:
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

transport=# select * from function1();
ERROR: plpython: function "function1" failed
DETAIL: cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the
connect identifier specified

transport=#

How can I solve this problem?

Regards,
Konoplev Sergey <konoplev (AT) gw (DOT) tander.ru>
Sen. software dveloper, IT department
Tander JSC
-------------------------------------------------
Levanevskogo st. 185, Krasnodar city, RUSSIA
Phone +7 861 210-98-10 (add.233)
Icq 29353802

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend