Calling Sorted Procedure

2002-12-10 Thread Rami Shibli
Hello I need some help regarding sorted procedures on ORACLE; I need to call the sorted procedure from my application that returns a string. And I don’t know how to do it Regards Rami Shibli

Re: /hpx/work/ee/8.1.7.4/hpx32/src_0424/lib

2002-12-10 Thread Markus Trenkle
Am Montag, 09.12.02 um 23:14 Uhr schrieb ulairi: This insanity it caused by the Makefile.PL somehow parsing in way (and I do mean WAY) too many -l switches for the compile line, which overloads Thats another oddity I noticed. But somehow some systems are affected and some not. I compiled a DB

Re: Oracle OCI 7/8 LOB error

2002-12-10 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Dec 10, 2002 at 04:30:26PM -0600, Paul Bryant wrote: > According to the documentation I have read, the DBD::Oracle module should > default to the Oracle 8 OCI API functions after version 0.55. Since I am > using version 1.06, I'm not sure why

Oracle OCI 7/8 LOB error

2002-12-10 Thread Paul Bryant
I'm using perl v5.6.1, DBI v1.27, DBD-Oracle v1.06, DBD-ODBC v0.28 to connect to Oracle 8i v8.1.7.2.0 from a Windows 2000 Pro v5.0SP3 PC. Everything has worked well for reporting purposes until I tried to select from a CLOB field when I received this error: DBD::Oracle::st execute failed: ORA-0093

Problem installing DBD::DB2 on AIX

2002-12-10 Thread Sean Rowe
I'm trying to install the DBD::DB2 module from CPAN (DBD-DB2-0.76) onto an AIX machine ( version 4.3.3.0) running perl version 5.005_03. I have installed the DBI (DBI-1.32) module successfully; however, when I try to install DBD::DB2 module, i'm running into problems. perl Makefile.PL ran fine, a

Error: no suitable installation target found for package DBD-Orac le

2002-12-10 Thread Brian Kuhn
Hello, I need some help. I've been trying to install DBD-Oracle all day. Other modules (DBD-ODBC, DBI) have installed fine, but for some reason, I get "Error: no suitible installation target found for package DBD-Oracle." Has anyone else gotten this error before/know how to fix it? I've incl

Re: DBD-PG on Windows 2000

2002-12-10 Thread David Wheeler
On Tuesday, December 10, 2002, at 04:23 AM, Stephan Harren wrote: When I try to build DBD-PG-1.20, I get the following error: dbdimp.obj : error LNK2001: unresolved external symbol _snprintf blib\arch\auto\DBD\Pg\Pg.dll : fatal error LNK1120: 1 unresolved external NMAKE : fatal error U1077: 'li

Re: DBI, DBD-PG, Windows 2000

2002-12-10 Thread David Wheeler
On Tuesday, December 10, 2002, at 02:36 AM, Stephan Harren wrote: OK, I installed postgres-DB under cygwin. Compilation still fails, no library found for -lpq. I set postgres_home to c:\cygwin\usr\local\pgsql. -lpq doesn't work. Try unsetting the POSTGRES_INCLUDE and POSTGRES_LIB environment

FW: CPAN Upload: J/JU/JURL/DBD-ODBC-1.01.tar.gz

2002-12-10 Thread Jeff Urlwin
Small fix for perl 5.8.0 builds. The uploaded file DBD-ODBC-1.01.tar.gz has entered CPAN as file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-1.01.tar.gz size: 86921 bytes md5: ed9e02aa97d26a42a13568594d26e93b No action is required on your part Request entered by: JURL (Jeff Urlwin) Reques

can't install DBD::mysql

2002-12-10 Thread David Driscoll
Hi, I've been trying to install DBD::mysql on SUSE 8.1. I run "perl Makefile.PL" then "make" make gets to "chmod: failed to get attributes of 'blib/arch/aaut/DBD/mysql/mysql.so'" and fails. There is no mysql.so anywhere on my system. I googled and found something on the MYSQL site that said th

DBD-PG on Windows 2000

2002-12-10 Thread Stephan Harren
Now for a new (not counting anymore) try, I installed Postgres-7.3-1, compiled the win32-client-libraries and put libpq.lib into the library-path and libpq-fe.h postgres_ext.h into the include-path. When I try to build DBD-PG-1.20, I get the following error: dbdimp.obj : error LNK2001: unresol

RE: DBD::Oracle 1.12 on Oracle 9iR2 9.2.0.2 test errors (again)

2002-12-10 Thread Ben Middleton
Okay, > It would be good if you could hack the Makefile.PL to get the build > rule discovery to work. I have hacked the Makefile.PL so that it can work out the build rule: New output from perl Makefile.PL -v: ... Attempting to discover Oracle OCI build rules... gcc -B/usr/ccs/bin/ -c DBD_O

Re: DBI, DBD-PG, Windows 2000

2002-12-10 Thread Stephan Harren
OK, I installed postgres-DB under cygwin. Compilation still fails, no library found for -lpq. I set postgres_home to c:\cygwin\usr\local\pgsql. What am I missing? Best regards, Stephan David Wheeler wrote: On Friday, December 6, 2002, at 02:31 AM, Stephan Harren wrote: Do you have the Postg

(Fwd) DBD::Oracle

2002-12-10 Thread Tim Bunce
- Forwarded message from Smith Chad - chasmi <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: Smith Chad - chasmi <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: DBD::Oracle Date: Mon, 9 Dec 2002 14:08:13 -0600 I am having problems compiling this on A

Wherefore art thou DBI::Shell? (was: multiple DBI::Format's in CPAN installing to different locations, and $VERSION bug)

2002-12-10 Thread Tim Bunce
On Mon, Dec 09, 2002 at 09:43:41AM -0800, David Dyck wrote: > > DBI::Format comes with > > DBI-1.32 in lib/DBI/Format.pm as VERSION 11.4 > and > DBI-Shell-11.9in lib/DBI/Format.pm as VERSION 11.8 > > According to the .packlist files DBI installs Format.pm in > /usr

Re: DBD::Oracle 1.12 on Oracle 9iR2 9.2.0.2 test errors (again)

2002-12-10 Thread Tim Bunce
On Mon, Dec 09, 2002 at 12:01:25PM -, Ben Middleton wrote: > Hello again, > > I am still not having any luck in getting the tests to pass. It appears to > be the CLOB re-reading that is failing. > > I have checked all the usual places for help. I have also tried creating a > test stub that do

Re: error ORA-28011 during connect

2002-12-10 Thread Tim Bunce
On Mon, Dec 09, 2002 at 03:43:57PM +0800, [EMAIL PROTECTED] wrote: > While trying to connect to an Oracle db (8.1.7.2) I get the following > message: > DBI->connect(aojprd) failed: ORA-28011: the account will expire soon; change > your password now (DBD SUCCESS_WITH_INFO: OCISessionBegin) > > How