Re: Oracle connection error

Where is the library installed to? In what directory? Is that directory referenced in the /etc/ld.so.conf file? If not, add it and then run "ldconfig" command, then re-try. On Thu, Jan 12, 2023 at 11:32 AM Syed Abdulla wrote: > Thank you Clive. I installed the library libnsl.x86_64. Below

Re: Oracle connection error

Tough luck! That isn't working either. I tried: make realclean perl Makefile.PL LINKTYPE=static make make perl (you'll need to use and install _this_ new perl binary) make test make -f Makefile.aperl inst_perl MAP_TARGET=perl (install new perl) make install and then I see

Re: Oracle connection error

Thank you Clive. I installed the library libnsl.x86_64. Below I pasted outputs from the commands. I logged in as root. *# dnf install libnsl.x86_64* *Last metadata expiration check: 0:04:34 ago on Thu 12 Jan 2023 04:22:12 PM UTC.* *Package libnsl-2.28-189.5.el8_6.x86_64 is already installed.*

Re: Oracle connection error

dnf install libnsl.x86_64 > On 12 Jan 2023, at 14:25, Syed Abdulla wrote: > > Hi, > > While installing Perl DBI module to connect to Oracle 19c on RedHat 8 VM, I > see the below error and the installation fails. > > /usr/bin/ld: cannot find -lnsl > collect2: error: ld returned 1 exit status

Re: Oracle encoding query

On Wed, Dec 06, 2017 at 04:53:36PM +0100, H.Merijn Brand wrote: > On Wed, 6 Dec 2017 15:34:17 +, Tim Bunce > wrote: > > > A view might be useful. Or perhaps define your own function to wrap the > > expression. > > That worked very well! > > CREATE OR REPLACE FUNCTION

Re: Oracle encoding query

On Wed, 6 Dec 2017 15:34:17 +, Tim Bunce wrote: > On Wed, Dec 06, 2017 at 04:12:53PM +0100, H.Merijn Brand wrote: > > On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" > > > > > > I have been playing with several variants of > > > > > > select convert (land_u,

Re: Oracle encoding query

On Wed, Dec 06, 2017 at 04:12:53PM +0100, H.Merijn Brand wrote: > On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" > > > > I have been playing with several variants of > > > > select convert (land_u, 'AL16UTF16', 'UTF8') from land where c_land = > > 7072; > > > > but I didn't get SQL

Re: Oracle encoding query

On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" wrote: > I have an Oracle databse with NLS_CHARACTERSET US7ASCII > > I have a table "land", like > > create table land ( > c_land number (4) not null, > zoekarg varchar2 (5), > land

Re: Oracle character column sizes from {PRECISION}

> On Sep 8, 2015, at 3:42 PM, Steve Baldwin wrote: > > I have a table defined as follows: > > SQL> desc sb1 > Name Null?Type > - > C1

Re: Oracle character column sizes from {PRECISION}

That's true however our DB character set is utf8 and the client charset is AL32UTF8. I was trying to come up with a better performing mechanism than retrieving the information from user_tab_columns. The max length (along with column name and data type) ends up being sent to a client in a json

Re: Oracle Freakishness

On May 5, 2013, at 5:02 PM, David E. Wheeler da...@kineticode.com wrote: No, I get the same error if I cast it to a varray. What’s bizarre is that Oracle says that the error is on the join to tags, not the collect. Here’s another example (with the cast): ORA-00942: table or view does

Re: Oracle Freakishness

On 5-2-13 15:20:23 David E. Wheeler wrote: This query: $dbh-selectrow_hashref(q{ SELECT c.change_id , COLLECT(t.tag) AS tags FROM changes c LEFT JOIN tags t ON c.change_id = t.change_id WHERE c.project = ? GROUP BY

Re: Oracle Freakishness

On May 5, 2013, at 7:34 AM, Garry T. Williams gtwilli...@gmail.com wrote: http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions031.htm#SQLRF06304 COLLECT is an aggregate function that takes as its argument a column of any type and creates a nested table of the input

Fwd: Re: oracle instant client for Linux (oracle 9.2) ?

Oops, forgot dbi-users: Original Message Subject:Re: oracle instant client for Linux (oracle 9.2) ? Date: Mon, 01 Oct 2012 19:17:43 +0100 From: Martin J. Evans martin.ev...@easysoft.com Organisation: Easysoft Limited To: Jack Craig jack.craig.ap...@gmail.com

RE: Re: oracle instant client for Linux (oracle 9.2) ?

that the client installs properly. I've been down that road. Hope it helps.. -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Monday, October 01, 2012 11:19 AM To: dbi-users@perl.org Subject: Fwd: Re: oracle instant client for Linux (oracle 9.2) ? Oops, forgot

Re: Re: oracle instant client for Linux (oracle 9.2) ?

On Mon, Oct 1, 2012 at 1:26 PM, Kevin Moore kmo...@esntech.com wrote: I'd recommend the 11gR2 (current) client. I believe it is backwards compatible with the 9.2 database. If you have problems installing the client or at runtime, it will be easier to get help with the newer client. And BTW,

Re: oracle instant client for Linux (oracle 9.2) ?

There's another option: Use DBD::Gofer on your web server, which forwards the request to your db server that has DBD::Oracle. You could also use DBD::Proxy -- Henri Asseily henri.tel On Oct 1, 2012, at 9:14 PM, Jack Craig jack.craig.ap...@gmail.com wrote: Ok, A further install question; on

RE: Oracle DBI on trusted hpux

I wish I could give you a 100% tumbs up on this but... It should work without problems as I have used Oracle Wallet many times before and in theory the OCI client and not the perl code should take care of all that for you. So if you can connect with DBD::Oracle it should just work. You

Re: Oracle and Two Phase commit with Perl?

On Thu, Oct 06, 2011 at 03:20:08PM -0700, Eirik Toft wrote: On Sep 13, 11:16 am, mark.bo...@proquest.com (Bobak, Mark) wrote: Does anyone have any experience w/ doing two-phase commit across connections to two different databases from the same Perl program?  (To guarantee that either both

Re: Oracle and Two Phase commit with Perl?

On Sep 13, 11:16 am, mark.bo...@proquest.com (Bobak, Mark) wrote: Does anyone have any experience w/ doing two-phase commit across connections to two different databases from the same Perl program?  (To guarantee that either both or neither transaction is committed, for consistency.) Any

Re: Oracle 11R2, perl-DBD: eating signal CTRL-C

On 27/04/11 15:33, Ulrich Weiss wrote: Hello! Yes, the problem exists also with DBD::Oracle 1.27. With my test machine, I have checked following environments: Failed: 11R2, DBD 1.28, DBI-1.613-1.fc14 11R2, DBD 1.27, DBI-1.613-1.fc14 11R2, DBD 1.22, DBI-1.613-1.fc14 11R2, DBD 1.22, DBI-1.607

Re: Oracle 11R2, perl-DBD: eating signal CTRL-C

Hello! Yes, the problem exists also with DBD::Oracle 1.27. With my test machine, I have checked following environments: Failed: 11R2, DBD 1.28, DBI-1.613-1.fc14 11R2, DBD 1.27, DBI-1.613-1.fc14 11R2, DBD 1.22, DBI-1.613-1.fc14 11R2, DBD 1.22, DBI-1.607 (RHEL 5.3, 64bit) Ok: 11R1, DBD 1.28,

Re: Oracle DBA's group mail ids'

Peter, Thanks for the response, i am a beginner level of DBA. I am looking for an help with beginer level of knoweldge. Can you please some group ids where i can get this ? regards, Raveendu On Wed, Apr 13, 2011 at 5:01 PM, Peter McLarty peter.mcla...@pacificdbms.com.au wrote: It would

Re: Oracle DBA's group mail ids'

why not google? I did and found this: http://oss.oracle.com/mailman/listinfo/ On Wed, Apr 13, 2011 at 5:03 PM, Raveen du raveendu.oracle...@gmail.com wrote: Dear friends,  awaiting for your reply . can you please someone advis me on this please On Tue, Apr 12, 2011 at 4:12 PM, Raveen du

RE: Oracle DBA's group mail ids'

You should definitely check out Oracle-L. It's a very active group with a wide variety of skill levels. See: http://www.freelists.org/list/oracle-l for subscription information. -Mark -Original Message- From: Raveen du [mailto:raveendu.oracle...@gmail.com] Sent: Tuesday, April 12,

Re: Oracle DBA's group mail ids'

Dear friends, awaiting for your reply . can you please someone advis me on this please On Tue, Apr 12, 2011 at 4:12 PM, Raveen du raveendu.oracle...@gmail.comwrote: Dear Friends, As like we are having the perl user community, i am also looking for some email groups for

Re: Oracle DBA's group mail ids'

It would depend on your level of expertise and if you are just wanting someone to do your work for you and not read manuals or if you need help with complex problems. ITToolbox has various lists for starting out and if you google you will find various advanced ones Cheers Peter On

Re: oracle multiple cursor sub query in different DBI versions

A little slow on this one and I apologize for that. Just closing things out for 1.28 version of DBD::Oracle and noticed this one hanging about. So I though I would give it a few tests I checked 1.24 and it fails but it seems to be fixed in 1.62 and in trunk So I will check this one off my list

Re: Oracle: ORA-24327 need explicit attach before authenticating a user in perl script

On 10/21/2010 1:11 PM, suuuper wrote: Funny that should work. What version of DBD Oracle are you using?? Can you connect using sqlplus?? If no it means there is some sort of TNSNAMES.ORA or other problems on the oracel network side of things I would try using an oracle easy connect string

RE: Oracle: ORA-24327 need explicit attach before authenticating a user in perl script

à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Fri, 22 Oct 2010 08:37:35 -0400 From: sco...@pythian.com To: giovanni...@gmail.com CC: dbi-users@perl.org Subject: Re: Oracle: ORA-24327 need explicit attach before authenticating a user

Re: oracle multiple cursor sub query in different DBI versions

On 05/08/10 13:41, lokasu lokasu wrote: Thank you for your reply. Indeed I meant any table, sorry for the confusion . I also get the expected results with: SELECT (2+3), cursor(select 2+3 from dual), cursor(select 2+3 from dual) FROM dual where rownum 10 5 DBI::st=HASH(0x3bf9540)

Re: oracle multiple cursor sub query in different DBI versions

On 04/08/10 19:27, LK wrote: In the process of moving from centos 4 to a centos 5 machine one script stopped working. I distilled it down to this problem : [snip] my $q = qq/ SELECT (2+3), cursor(select 2+3 from dual), cursor(select 3+3 from dual)

Re: oracle multiple cursor sub query in different DBI versions

Thank you for your reply. Indeed I meant any table, sorry for the confusion . I also get the expected results with: SELECT (2+3), cursor(select 2+3 from dual), cursor(select 2+3 from dual) FROM dual where rownum 10 5 DBI::st=HASH(0x3bf9540) DBI::st=HASH(0x3d9ee70) 5 5 If I do :

Re: Oracle VARRAY support

Actually it does support varray types since 1.20 (at least for select) http://search.cpan.org/~pythian/DBD-Oracle-1.22/Oracle.pm#Object__Collection_Data_Types You can select them all you want. I have not yet added support for inserts and updates and that is handled by psql better than the hay

Re: Oracle::DBI module - Issues in connecting to Oracle 10G

hoststring.10G = (DESCRIPTION= (LOAD_BALANCE=yes) (ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.123)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.124)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=) ) ) Currently, using the DBI module I am able to connect to these servers

RE: Oracle::DBI module - Issues in connecting to Oracle 10G

Sri- Oracle connects via the TNS entry as seen in %ORACLE_HOME%/network/admin/tnsnames.ora Here the TNS Name DB1 is associated to Service IDentifier of DB 1 SID=DB1 which in this case is listening on localhost Port 1521 DB1= (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)

Re: Oracle 10.2 Perl 5.10

Hi, The level 4 trace output is: ok 11 - Statement prepared. - bind_param for DBD::Oracle::st (DBI::st=HASH(0x9adcf8)~0xa2c948 ':sql' ' SELECT row_num, TO_CHAR(col0) AS Billing Run ID, TO_CHAR(col1, '-MM-DD') AS Run Date, col2 AS Company Name,

Re: Oracle 10.2 Perl 5.10

Duncan Garland wrote: Hi, The level 4 trace output is: snipped most of trace (DBI::st=HASH(0xa2c528)~0xa2c678) thr#602010 dbd_st_fetch 6 fields... dbd_st_fetched 6 fields with status of 1(SUCCESS_WITH_INFO) field #1 with rc=0(OK) field #2 with rc=0(OK) field #3 with rc=0(OK)

Re: Oracle 10.2 Perl 5.10

Duncan Garland wrote: Hi, The level 4 trace output is: ok 11 - Statement prepared. - bind_param for DBD::Oracle::st (DBI::st=HASH(0x9adcf8)~0xa2c948 ':sql' ' SELECT row_num, TO_CHAR(col0) AS Billing Run ID, TO_CHAR(col1, '-MM-DD') AS Run Date, col2 AS Company

Re: Oracle 10.2 Perl 5.10

Martin Evans wrote: Duncan Garland wrote: Hi, The level 4 trace output is: snipped most of trace (DBI::st=HASH(0xa2c528)~0xa2c678) thr#602010 dbd_st_fetch 6 fields... dbd_st_fetched 6 fields with status of 1(SUCCESS_WITH_INFO) field #1 with rc=0(OK) field #2 with rc=0(OK)

Re: Oracle 10.2 Perl 5.10

Duncan Garland wrote: [Snip] dbd_st_fetch 6 fields... dbd_st_fetched 6 fields with status of 1(SUCCESS_WITH_INFO) field #1 with rc=0(OK) field #2 with rc=0(OK) field #3 with rc=0(OK) field #4 with rc=0(OK) field #5 with rc=0(OK) field #6 with rc=0(OK) - err

Re: Oracle 10.2 Perl 5.10

Hi Martin, The info should be: 0 1873197 2008-09-22 Suspense Account Generated no invoices 0 1 1873196 2008-09-22 York Mailing Ltd Generated no invoices 0 2 1873195 2008-09-22 York Mailing Ltd Generated no invoices 0 3 1873194 2008-09-22 XX Autodrive Generated no invoices 0 4 1873193 2008-09-22

Re: Oracle 10.2 Perl 5.10

Hi John, Thanks. A patch would be good although I'd better talk to the DBA before I actually apply it. The article implied that I should get more information if I switch PrintError on. It doesn't seem to make any diffeence. Regards Duncan John Scoles wrote: Duncan Garland wrote: Hi,

Re: Oracle 10.2 Perl 5.10

Hi Chris, Could be, your thread contains: DBD::Oracle::st fetchrow_hashref failed: ORA-24347: Warning of a NULL column in an aggregate function (DBD ERROR: ORA-60499 error on field 1 of 3, ora_type 2) ORA-24347: Warning of a NULL column in an aggregate function (DBD ERROR: ORA-60499 error on

Re: Oracle 10.2 Perl 5.10

Hi, Thanks. I'll look into that. I was really fishing to see if there are any known issues. Since I posted the message I've established that it runs properly in an ordinary prepare, execute, fetch loop. The problems occur when it call a PL/SQL procedure which executes the SQL and returns a

RE: Oracle 10.2 Perl 5.10

: Thu, 25 Sep 2008 09:00:53 -0700 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Oracle 10.2 Perl 5.10 CC: dbi-users@perl.org I wouldn't call that statement very long...but I wouldn't think DBI or DBD::Oracle could be doing anything to it. I'd try looking at some DBI trace

Re: Oracle 10.2 Perl 5.10

] Subject: Re: Oracle 10.2 Perl 5.10 CC: dbi-users@perl.org I wouldn't call that statement very long...but I wouldn't think DBI or DBD::Oracle could be doing anything to it. I'd try looking at some DBI trace() output, and if that doesn't show anything, I'd write a simple example in C using

Re: Oracle 10.2 Perl 5.10

: Re: Oracle 10.2 Perl 5.10 CC: dbi-users@perl.org I wouldn't call that statement very long...but I wouldn't think DBI or DBD::Oracle could be doing anything to it. I'd try looking at some DBI trace() output, and if that doesn't show anything, I'd write a simple example in C using the OCI

Re: Oracle 10.2 Perl 5.10

distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Thu, 25 Sep 2008 09:00:53 -0700 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Oracle 10.2 Perl 5.10 CC: dbi-users@perl.org I wouldn't

Re: Oracle procedure raises exception but looks to be successful from DBI

Jeffrey Seger wrote: begin proctest(?); end; is the more desirable syntax for calling oracle procedures. It's an anonymous pl/sql block. I personally had never seen the call proctest() syntax used in Oracle. It's valid syntax, but it doesn't appear to be doing what you want it to do.

Re: Oracle procedure raises exception but looks to be successful from DBI

On 25/01/08 15:25, Martin Evans wrote: Hi, I've just spent a long time tracking down a bug in an Oracle procedure because DBI's execute method returned success even though the procedure raised an exception. Shouldn't exceptions raised in procedures cause execute to fail? [ snip ] my $s =

Re: Oracle procedure raises exception but looks to be successful from DBI

begin proctest(?); end; is the more desirable syntax for calling oracle procedures. It's an anonymous pl/sql block. I personally had never seen the call proctest() syntax used in Oracle. It's valid syntax, but it doesn't appear to be doing what you want it to do. According to the Oracle

Re: Oracle procedure raises exception but looks to be successful from DBI

Not that I am offering you a solution, but with Oracle I have found the error messages are sometimes misleading. For example I was helping a co-worker with code. He wanted to call a stored procedure, so I sent him some example code that I had which called a function. The function I was

Re: Oracle procedure raises exception but looks to be successful from DBI

John Scoles wrote: I sort if expected that for the exec it is usualy only used withing SP perhaps begin; exec(user.package.proctest(?)); end; ?? who knows same problem as without exec: PLS-00302: component 'PACKAGE' must be declared The next error is usually a permission problem on the

Re: Oracle procedure raises exception but looks to be successful from DBI

John Scoles wrote: That is an odd one, I will check with the DBAs here to see if this is normal Oracle behavior Well the error id correct but and on my box an error is thrown that I catch I did change my code over to begin track.proctest(?) end; what version of DBI and DBD are you using??

Re: Oracle procedure raises exception but looks to be successful from DBI

I sort if expected that for the exec it is usualy only used withing SP perhaps begin; exec(user.package.proctest(?)); end; ?? who knows The next error is usually a permission problem on the Oracle side. Either the use who is calling the SP dose not have execute permission for the package

Re: Oracle procedure raises exception but looks to be successful from DBI

Wow I go one right for once. Not 100% sure on why that is? Me thinks when you use 'Begin End' it forces OCI to take it as an pseudo 'stored procedure' and runs in the current OCI client. I think using call just executes as a thread off the present client and in the background someplace??

Re: Oracle procedure raises exception but looks to be successful from DBI

That is an odd one, I will check with the DBAs here to see if this is normal Oracle behavior Well the error id correct but and on my box an error is thrown that I catch I did change my code over to begin track.proctest(?) end; what version of DBI and DBD are you using?? cheers Martin

Re: Oracle procedure raises exception but looks to be successful from DBI

John Scoles wrote: Wow I go one right for once. Not 100% sure on why that is? Me thinks when you use 'Begin End' it forces OCI to take it as an pseudo 'stored procedure' and runs in the current OCI client. I think using call just executes as a thread off the present client and in the

RE: ORACLE DRIVER

: Thursday, December 27, 2007 7:30 PM To: Cyril George-SJR; [EMAIL PROTECTED] Cc: dbi-users@perl.org Subject: RE: ORACLE DRIVER DBI - is the perl module to handle all the request of the database, connecting, disconnecting, routing the database request to proper driver. DBD::Oracle - is the Oracle

RE: ORACLE DRIVER

[bash]$ perl Makefile.PL Using DBI 1.40 (for perl 5.008005 on i386-linux-thread-multi) installed in /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI Configuring DBD::Oracle for perl 5.008005 on linux (i386-linux-thread-multi) Remember to actually *READ* the README file!

Re: ORACLE DRIVER

CyRiL. i-flex Solutions -- -Original Message- From: Paul Gallagher [mailto:[EMAIL PROTECTED] Sent: Thursday, December 27, 2007 1:05 PM To: Cyril George-SJR Cc: dbi-users@perl.org Subject: Re: ORACLE DRIVER Not sure I understand why you need ODBC Cyril. What program/client

RE: ORACLE DRIVER

on this please. Thanks -- Regards CyRiL. i-flex Solutions -- -Original Message- From: Paul Gallagher [mailto:[EMAIL PROTECTED] Sent: Thursday, December 27, 2007 1:05 PM To: Cyril George-SJR Cc: dbi-users@perl.org Subject: Re: ORACLE DRIVER Not sure I understand why you need ODBC Cyril

RE: ORACLE DRIVER

if kindly suggest if there is any other alternative. Thanks -- Regards CyRiL. i-flex Solutions -- -Original Message- From: Paul Gallagher [mailto:[EMAIL PROTECTED] Sent: Thursday, December 27, 2007 10:23 AM To: Cyril George-SJR Cc: dbi-users@perl.org Subject: Re: ORACLE DRIVER Hi Cyril

RE: ORACLE DRIVER

To: Cyril George-SJR Cc: dbi-users@perl.org Subject: Re: ORACLE DRIVER Not sure I understand why you need ODBC Cyril. What program/client are you connecting with? I assumed it was some perl DBI script given the mailing list this is on. If that is the case, I'd point you again to the native Oracle DBD

Re: ORACLE DRIVER

Hi Cyril, Oracle's own Instant Client kit should meet your needs. It is free, even for production use. I presume you are running under Windows, so see http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html The main Instant Client site is at

Re: ORACLE DRIVER

Cc: dbi-users@perl.org Subject: Re: ORACLE DRIVER Hi Cyril, Oracle's own Instant Client kit should meet your needs. It is free, even for production use. I presume you are running under Windows, so see http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/ winsoft.html

Re: Oracle connection issue with perl DBI

In message [EMAIL PROTECTED], Kumar Ranjan writes: I am facing a funny but troubling issue with Perl DBI Oracle. When my shell environment does not have ORACLE_HOME path set, my script works fine. I am connecting to Oracle DB like this: #!/usr/bin/perl -w use strict; use DBI; my $dbh =

Re: Oracle Performance still bad.

This is an Oracle database (10.2g). I apologize if this question isn't DBI or DBD::Oracle related. Basically, I have an instance of Oracle running a pair of tablespaces (one for data, the other for indexes) with 101 million records (data dbf is 53GB). On the same box (a quad core Xeon with

RE: Oracle::DBD build issue

Hi, Bob, I've met some (similar but not same) failed tests in my previous of DBD::Oracle installations. I eventually found out: 1. if it complains about libraries, the PATH environment variable of the user who is doing the installation might lack of something; 2. the Oracle account

Re: [Oracle][ODBC]Numeric value out of range.

--- Jared Still [EMAIL PROTECTED] wrote: On Fri, 2007-07-20 at 12:34 -0700, Paul Simon wrote: Again, setting the sql type to SQL_VARCHAR via bind_param solves the error... Looking back, the problem started when I upgraded the oracle client (including oracle odbc driver) from 9i

[Fwd: RE: :Oracle on Solaris 9/10 and Oracle 10g]

I received the following suggestion from a kind contributor: I believe the flag is -r=build32, the command being perl Makefile.PL -r=build32 and that option did indeed create the Makefile with the lib32 settings correctly enabled. However, I'm still running into a problem. I can only get

Re: [Oracle][ODBC]Numeric value out of range.

On Fri, 2007-07-20 at 12:34 -0700, Paul Simon wrote: Again, setting the sql type to SQL_VARCHAR via bind_param solves the error... Looking back, the problem started when I upgraded the oracle client (including oracle odbc driver) from 9i to 10g. There's something not right here - even

Re: [Oracle][ODBC]Numeric value out of range.

I'm guessing that DBI is making incorrect assumptions about SQL Types somewhere... Is this what's happening? It could be differences between versions, as you apparently upgraded the client only. You didn't mention the database version. Try running your script without

RE: :ORACLE

My wife, Diana Dhaskali, has provided the following translation from French to English: I have installed Oracle database 10g express Edition (10.2.0) then I have installed DBI 1.58 et DBD-Oracle 1.17. I use the following script use DBI; require tools.pl; ...

RE: :ORACLE

You may want to set LD_RUN_PATH, and SHLIB_PATH also. -Original Message- From: Rutherdale, Will [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 12:36 PM To: dbi-users@perl.org Subject: RE: :ORACLE My wife, Diana Dhaskali, has provided the following translation from French

Re: [Oracle][ODBC]Numeric value out of range.

On 7/16/07, Paul Simon [EMAIL PROTECTED] wrote: I'm guessing that DBI is making incorrect assumptions about SQL Types somewhere... Is this what's happening? It could be differences between versions, as you apparently upgraded the client only. You didn't mention the database version. Try

Re: [Oracle][ODBC]Numeric value out of range.

I'm guessing that DBI is making incorrect assumptions about SQL Types somewhere... Is this what's happening? It could be differences between versions, as you apparently upgraded the client only. You didn't mention the database version. Try running your script without bind_param

Re: [Oracle][ODBC]Numeric value out of range.

--- Paul Simon [EMAIL PROTECTED] wrote: Hi. I'm new to the list. I have a perl script that was working fine until I upgraded my Oracle client 9i to 10g (instant client). I'm inserting data into an Oracle database via DBD-ODBC. The insert will succeed if I do not bind the variables

Re: Oracle make test failing on HP/UX

Once again: I compiled Perl 5.6.2 using HP aC++/ANSI C: cd perl-5.6.2 sh ./Configure -A prepend:libswanted='cl pthread ' -des : No problems there Then I export some Oracle stuff: export SHLIB_PATH=$ORACLE_HOME/lib32 export LD_LIBRARY_PATH=$ORACLE_HOME/lib I run (as sudo): perl

Re: Oracle make test failing on HP/UX

/usr/lib/hpux32/dld.so: Cannot dlopen load module '/usr/lib/hpux32/libpthread.so.1' because it contains thread specific data. Failed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load '/users/user/DBD-Oracle-1.17/blib/arch/auto/DBD/Oracle/Oracle.so' for

RE: Oracle make test failing on HP/UX

Note the libraries. perl is 64 bit whereas you are trying to load 32 bit libraries. I have built Oracle DBI on Itanium if you want further info P -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: 03 July 2007 14:08 To: dbi-users@perl.org Subject: Oracle make

Re: Oracle make test failing on HP/UX

Looks like you are pointing to the 64 bit binarys. You will have to use a 32 bit oracle client. You best bet is to use the 32 bit instantclient for HP. Set your ORACLE_HOME to the dir you install the 32 bit instant cleint and the LD_LIBRARY_PATH to LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

Re: Oracle make test failing on HP/UX

[EMAIL PROTECTED] wrote: Note the libraries. perl is 64 bit whereas you are trying to load 32 bit libraries. I have built Oracle DBI on Itanium if you want further info P I would be much ablidged if you could share. : ) Robert

Re: Oracle make test failing on HP/UX

John Scoles wrote: Looks like you are pointing to the 64 bit binarys. You will have to use a 32 bit oracle client. You best bet is to use the 32 bit instantclient for HP. Set your ORACLE_HOME to the dir you install the 32 bit instant cleint and the LD_LIBRARY_PATH to

Re: Oracle DBI for HP

[EMAIL PROTECTED] wrote: The basic rule about building perl, DBD Oracle DBI on HP-UX (let alone Itanium) using gcc is don't. Life is far far too short for it since you will hit problem after problem. It is possible using HP's native C compiler (in fact it is straight forwards) but if you are

RE: Oracle DBI for HP

Can you get hold of an HP ANSI C compiler? p -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: 03 July 2007 16:19 To: dbi-users@perl.org Subject: Re: Oracle DBI for HP [EMAIL PROTECTED] wrote: The basic rule about building perl, DBD Oracle DBI on HP

Re: Oracle DBI for HP

[EMAIL PROTECTED] wrote: Can you get hold of an HP ANSI C compiler? p Yes I can. R

RE: Oracle DBI for HP

You should find that you wll have virtally no problems with that.You might need to build perl afresh though. From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: Tue 03/07/2007 17:33 To: dbi-users@perl.org Subject: Re: Oracle DBI for HP [EMAIL PROTECTED] wrote

Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?

] Sorry, after starting this thread, I dropped out for a while folks. John, did you get to a satisfactory solution in the end? Paul -- Forwarded message -- From: John Scoles [EMAIL PROTECTED] To: dbi-users@perl.org Date: Mon, 9 Apr 2007 14:33:41 -0400 Subject: Re: :Oracle - Any

RE: :Oracle function

[EMAIL PROTECTED] wrote: Anyone knows if DBD::Oracle has a function similar to the function $sth-rows that exist in DBD::Mysql? This is a DBI feature. It exists for all drivers. This function give us the number o rows in a select command. So, we don´t have to run a fetchrow with a while

Re: :Oracle function

-Corporate) [EMAIL PROTECTED] To: [EMAIL PROTECTED]; dbi-users@perl.org Cc: dbi-dev@perl.org Sent: Wednesday, April 11, 2007 10:28 AM Subject: RE: :Oracle function [EMAIL PROTECTED] wrote: Anyone knows if DBD::Oracle has a function similar to the function $sth-rows that exist in DBD::Mysql

RE: :Oracle function

John Scoles wrote: Oracle doesn't have this feature so DBD::Oracle doesn't either. This has cropped up many times before So you can blame Oracle on that. Thier logic (as it was explained to me) is How could you get the number of rows you are going to fetch without counting them all first?

Re: :Oracle function

John Scoles wrote: [EMAIL PROTECTED] wrote: Anyone knows if DBD::Oracle has a function similar to the function $sth-rows that exist in DBD::Mysql? This is a DBI feature. It exists for all drivers. This function give us the number o rows in a select command. So, we don´t have to run a

Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?

and had the same limit. -Original Message- From: Paul Gallagher [mailto:[EMAIL PROTECTED] Sent: Friday, February 16, 2007 8:25 PM To: Garrett, Philip (MAN-Corporate) Cc: Reidy, Ron; dbi-users@perl.org Subject: Re: :Oracle - Any advance on inserting CLOB to XMLTYPE? Thanks Philip

Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?

the same limit. -Original Message- From: Paul Gallagher [mailto:[EMAIL PROTECTED] Sent: Friday, February 16, 2007 8:25 PM To: Garrett, Philip (MAN-Corporate) Cc: Reidy, Ron; dbi-users@perl.org Subject: Re: :Oracle - Any advance on inserting CLOB to XMLTYPE? Thanks Philip

Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?

. -Original Message- From: Paul Gallagher [mailto:[EMAIL PROTECTED] Sent: Friday, February 16, 2007 8:25 PM To: Garrett, Philip (MAN-Corporate) Cc: Reidy, Ron; dbi-users@perl.org Subject: Re: :Oracle - Any advance on inserting CLOB to XMLTYPE? Thanks Philip for the extra info. I've attached a test

RE: :Oracle question?

Yes - tune your design and application code. MySQL != Oracle in any way. -- Ron Reidy Lead DBA Array BioPharma, Inc -Original Message- From: rami doqa [mailto:[EMAIL PROTECTED] Sent: Monday, February 26, 2007 3:20 AM To: dbi-users@perl.org Subject: DBD::Oracle question? Hi ALL. Is

RE: :Oracle - Any advance on inserting CLOB to XMLTYPE?

I ran this against v1.19 and had the same limit. -Original Message- From: Paul Gallagher [mailto:[EMAIL PROTECTED] Sent: Friday, February 16, 2007 8:25 PM To: Garrett, Philip (MAN-Corporate) Cc: Reidy, Ron; dbi-users@perl.org Subject: Re: :Oracle - Any advance on inserting CLOB

Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?

Thanks Philip for the extra info. I've attached a test case I'm working with .. wondering if anyone using DBD 1.19 can try this out too and report the results? Ron, can you check this also ... maybe your code is different in some way? For me the limit is at 63/64 elements (results are in the

  1   2   3   4   5   6   7   8   >