Re: [BUGS] BUG #2517: Trouble with cx_Oracle and Plpython

On Thu, Jul 06, 2006 at 08:27:53AM +0000, Sergey Konoplev wrote:
>
> The following bug has been logged online:
>
> Description: Trouble with cx_Oracle and Plpython
>
> 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

This means you need to fix your connect identifier for Oracle so that
it works both locally and remotely. It's a bug in your script, not in
PostgreSQL, so I'm moving this to -general :)

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!