CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI: Problem with DBI Link: Edit Log



rivo
New User

Feb 2, 2009, 3:20 AM


Views: 7016
Problem with DBI Link

Hi, I'm trying to execute a DBI Link script in a postgresql database, but the follow error is returned:

dbhab_teste=# \i dbi_teste_ora.sql
SELECT dbi_link.make_accessor_functions(
'dbi:Oracle:sid=veides2;host=172.25.136.85'::dbi_link.data_source,
'abc'::text,
'def'::text,
'---
AutoCommit: 1
RaiseError: 1
'::dbi_link.yaml,
NULL::dbi_link.yaml,
NULL::text,
NULL::text,
'veides2'::text
);
psql:dbi_teste_ora.sql:13: NOTA: Setting bail in %_SHARED hash. at line 25.

CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()"
psql:dbi_teste_ora.sql:13: NOTA: Setting quote_literal in %_SHARED hash. at line 25.

CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()"
psql:dbi_teste_ora.sql:13: NOTA: Setting get_connection_info in %_SHARED hash. at line 25.

CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()"
psql:dbi_teste_ora.sql:13: NOTA: Setting quote_ident in %_SHARED hash. at line 25.

CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()"
psql:dbi_teste_ora.sql:13: NOTA: Setting get_dbh in %_SHARED hash. at line 25.

CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()"
psql:dbi_teste_ora.sql:13: NOTA: Setting remote_exec_dbh in %_SHARED hash. at line 25.

CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()"
psql:dbi_teste_ora.sql:13: NOTA: SELECT dbi_link.set_up_connection(
'dbi:Oracle:sid=veides2;host=172.25.136.85',
'abc',
'def',
'---
AutoCommit: 1
RaiseError: 1
',
NULL,
NULL,
NULL,
'veides2'
)

psql:dbi_teste_ora.sql:13: NOTA: SELECT count(*) AS "driver_there"
FROM dbi_link.available_drivers()
WHERE available_drivers = 'dbi:Oracle:sid=veides2;host=172.25.136.85'

CONTEXTO: comando SQL "SELECT dbi_link.set_up_connection(
'dbi:Oracle:sid=veides2;host=172.25.136.85',
'abc',
'def',
'---
AutoCommit: 1
RaiseError: 1
',
NULL,
NULL,
NULL,
'veides2'
)
"
psql:dbi_teste_ora.sql:13: ERRO: error from Perl function "make_accessor_functions": error from Perl function "set_up_connection": install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: File cannot be found at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
at line 3
Compilation failed in require at line 3.
Perhaps a required shared library or dll isn't installed where expected
at line 37 at line 35.

Someone said that can be a problem in the search paths of perl...
Can anyone help to solve this?
thanks

Cool


(This post was edited by rivo on Feb 2, 2009, 3:21 AM)


Edit Log:
Post edited by rivo (New User) on Feb 2, 2009, 3:21 AM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives