The following bug has been logged online:
Bug reference: 2517
Logged by: Sergey Konoplev
Email address: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
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
