Can't locate DBD/Oracle.pm in @INC (@INC contains:

Hi,
I am trying to call a SP in oracle from iwperl.
But now i face with the error as given below.
Could some one help me out..

The full code and discussion is also availabe here
http://www.experts-exchange.com/Programming/Programming_Languages/Perl/Q_21957758.html

Lal

Note : I am using TS 6.1

\tools\akg>perl -c testt.pl
Can't locate DBD/Oracle.pm in @INC (@INC contains: e:/In
/lib e:/Interwoven/iw-home/iw-perl/site/lib e:\Interwove
\lib .) at testt.pl line 4.
BEGIN failed--compilation aborted at testt.pl line 4.

Find more posts tagged with

Comments

lidkh

Hi Lal,

You have to use the same 'perl' command you used to compile the CPAN modules (DBD and DBI).
As you intend to connect to the DB from TeamSite, I would recommend to compile these modules with the perl version shipped with TeamSite, ie ' iwperl'.
While compiling the DBD module, you'll have to set some environment variables, such as ORACLE_HOME and LD_LIBRARY_PATH.

cheers,
Khalid

Lal

http://www.experts-exchange.com/Programming/Programming_Languages/Perl/Q_21957758.html

>> $sth->bind_param(3, $buffer, { ora_type => ORA_BLOB });

i did some googling and substituted the numeric of ORA_BLOB with 113 and it tried to compile. Now I am getting a different error

DBD: Smiley Surprised

DBC::st bind_param failed: [Oracle][ODBC]Optional feature not implemented. (SQL-HYC00)(DBD: _rebind_ph/SQLBindParameter err=-1) at testblob.pl line 51.
DBD: Smiley Surprised

DBC::st execute failed: (DBD: st_execute/SQLExecute err=-1) at testt.pl line 53.

Any help?

lidkh

Have you already tried to simply connect to ORACLE using DBD/DBI?

Lal

yes, i have.. and is working fine.. only problem is with BLOB

Lal