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
)
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
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