Re: [GENERAL] dbi_link help

2009-02-11 Thread SHARMILA JOTHIRAJAH
Hi, Another try to get a reply for this dbi-link problem... I was trying to look into the dbi_link.sql code and try to figure out the problem This is from the dbi_link.sql code CREATE OR REPLACE FUNCTION dbi_link.add_dbi_connection_environment(     in_data_source_id BIGINT,     in_settings YAML )

Re: [GENERAL] dbi_link help

2009-02-10 Thread SHARMILA JOTHIRAJAH
Thanks Richard --- On Tue, 2/10/09, Richard Huxton wrote: From: Richard Huxton Subject: Re: [GENERAL] dbi_link help To: sharmi...@yahoo.com Cc: "General postgres mailing list" Date: Tuesday, February 10, 2009, 2:51 AM SHARMILA JOTHIRAJAH wrote: > When I try to insert into or se

Re: [GENERAL] dbi_link help

2009-02-09 Thread Richard Huxton
SHARMILA JOTHIRAJAH wrote: > When I try to insert into or select from the oracle database I get > this error... > > ERROR: error from Perl function "remote_select": error from Perl > function "cache_connection": DBI > connect('database=postgres;host=...;sid=...;port=1521','postgres',...) > failed