Re: Is this a DBD::Pg problem or Postgres problem?

erl/DBD: /home/allwebfiles/perl/edit_inst_inv2.pl, Apache: referer: https:// avi.pharmacy.arizona.edu/a/edit_inst_inv.pl Also, PostgreSQL error messsages contain context, so you know that the > LINE 1: ...te('10-15-2023','MM-DD-'), now()) returning inv_id

Re: Advice or best practice for updating multiple rows with a single query

are($sql); $sth->execute(@when_params, @where_params) or die $DBI::errstr; There are a few other nitpicks I have with your code (like, why do you use map in one line and x in the next for the same purpose? Why is @placeholders a list with one member, why do you assign to variables

Re: Strange issue with inserting varchar2()

8 isn't really UTF-8: It's a weird double-encoding which may take up to 6 six bytes for non-BMP characters. To get real UTF-8, use AL32UTF8. hp -- _ | Peter J. Holzer| Story must make more sense than reality. |_|_) || | | | h...@hjp.at

Re: Hunting down (possible) memory leak in DBD::Oracle

ch is VARCHAR2(4000). I wonder if an overflow is possible if field4 is actually close to 4000 characters and it is expanded further by character encoding. Which raises the next question: What are the database and client encodings set to? hp -- _ | Peter J. Holzer | I think we

Re: (Fwd) DBI Dilemma

re not intended to be used standalone, you always use them indirectly through DBI. See the perldoc page for DBI which explains the architecture quite well. hp -- _ | Peter J. Holzer | I think we need two definitions: |_|_) | WSR - Softwaredevelopment | 1) The problem the

Re: Help with using Triggers MySql/Innodb

he rows affected by a trigger. OLD and NEW are MySQL | extensions to triggers; they are not case sensitive. So that should be UPDATE House SET PeopleCount = PeopleCount + 1 WHERE HouseID = NEW.HouseID hp -- _ | Peter J. Holzer | I think we need two definitions: |_|_) |

Re: Bad error message

ing properly quoted strings into the statement and the database will only see the final, composed statement. So it's possible that the wrong number of parameters is noticed before a syntax error. I still think this is a bug: The backquotes are obviously considered while scanning for placeholders,

Re: I have a weird issue with a script running under cron

LIBRARY_PATH"}="/usr/lib/oracle/11.2/client64/lib"; > > > > use DBI; > > [...] > > my $dbh = DBI->connect( "dbi:Oracle:host=$dbhost", $login, $dbpass, > > { RaiseError => 1 } ); doesn't work even with a BEGIN {} block

Re: I have a weird issue with a script running under cron

n; Yes, so obviously you should run John's little script via cron, too. What is the result? hp -- _ | Peter J. Holzer | I think we need two definitions: |_|_) | WSR - Softwaredevelopment | 1) The problem the *users* want us to solve | | | und Projektunterstützun

Re: PostgreSQL driver DBD::Pg releases version 3.0.0

wer perls the difference shouldn't matter any more) and whatever encoding the database expects. > o Decoding incoming data > $$item{$_} = decode('utf-8', $$item{$_} || '') for keys %$item Same here. With pg_enable_utf8 I would expect to get character strings, not by

Re: Error appears in web log but script runs ok on the command line

ME, but if it is the problem I cited, that doesn't help either because the dynamic loader won't pick up the changed LD_LIBRARY_PATH. You have to change it before starting Apache. hp -- _ | Peter J. Holzer | I think we need two definitions: |_|_) | WSR - Softwaredevelo

Re: ODBC Driver failing?

rs ago), but I don't seem to have the source code any more and don't remember where I got it. Unless one of your co-admins installed it you'll probably have to google (or duckduckgo or whatever) for it. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwig

Re: Prepared statements- variable number of placeholders

the members: $fields = join(',', @fields); $placeholders = '(' . join(',', map('?', @fields)) . ')'; my $sth = $dbh->prepare("INSERT INTO $table ($fields) VALUES $placeholders"); (and then you can get rid of $fields and $pl

Re: DBD::mysql::st bind_param failed: Illegal parameter number

.8.8? The current release of RHEL (6) is shipping with perl 5.10.1, but RHEL 5 will be supported until 2017, so people aren't in a hurry to upgrade. Some are probably still running RHEL 4 or even RHEL 3. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte d

Re: DBD::Oracle build on aix 6.1 ( host is 64 bit db server )

the same client everywhere. It also allows you to upgrade the server independently of the client (and vice versa). * In a server installation the client parts (libraries, sqlplus, etc.) are by default only accessible by the "dba" group. Your DBA may be unwilling to change

Re: Creating new database handles with mod_perl

local address, local port, remote address, remote port) is unique for each connection. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, m

Re: [DBD::Oracle] ORA-02005 on array insert

On 2012-03-20 15:25:43 +0100, Peter J. Holzer wrote: > On 2012-03-20 13:19:14 +, Martin J. Evans wrote: > > On 20/03/12 12:12, Peter J. Holzer wrote: > > >Anyway, since the upgrade sometimes (not always) array inserts returned > > >the error > > > > >

Re: [DBD::Oracle] ORA-02005 on array insert

On 2012-03-20 13:19:14 +, Martin J. Evans wrote: > On 20/03/12 12:12, Peter J. Holzer wrote: > >A few months ago we upgraded two of our servers from RHEL 4 to RHEL6. > >Unfortunately the upgrade involved the OS, the Perl version (5.8.8 -> > >5.10.1), the Oracle client

Re: [DBD::Oracle] ORA-02005 on array insert

start, period_end, data_id, set_id, coordtype) values(?, ?, ?, ?, ? )"); $sth->execute_array({}, undef, undef, $data_ids, \@set_ids, $ct_none); (One interesting thing is that $ct_none is also undef, but that doesn't seem to be a problem). hp -- _ | Peter J. Holzer

[DBD::Oracle] ORA-02005 on array insert

fails, it always fails on the second iteration of the loop. If it gets through the second iteration it completes all 1000 iterations successfully. When the call to prepare_cached is replaced by a simple prepare, the script fails less often. I have run the script with DBI_TRACE=4, but I don't se

Re: Maintaining simultaneous support for two Oracle versions in DBI

LOBs, so YMMV). Accessing an 8.1 database with an 11g client definitely doesn't work. I'm not sure whether an 11g client can access a 9i database. For a transition from a 9i to an 11g database I would first try to use an 11g client and fall back to a 10g client if that doesn't

Re: DB2-DBD error messages

d Cwd was first released with perl 5 Cwd::fastcwd has also existed for a long time and I see no indication in the docs that it may not be available on some platforms. But the error message is "Usage: Cwd::fastcwd()" so I guess that the function is available but called incorrectly (pr

Re: How to set LD_LIBRARY_PATH

On 2010-05-31 15:52:21 +0200, Peter J. Holzer wrote: > On Linux (at least i386[1]) the loader uses the current value of > LD_LIBRARY_PATH when it is asked to load an .so file. So you can change > LD_LIBRARY_PATH just before you want to load the library. > > On Solaris the loader

Re: DBD::Oracle dbd_st_execute slow speed

-+ [18 rows of 1 fields returned] You need special privileges for that, though. I don't think a normal user can do it even for their own queries. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs

Re: SQL errors not making it back to Perl

On 2010-09-10 07:01:26 -0400, Martin Gainty wrote: > Your SQLNET.ORA file should contain the following lines to produce a > client side trace file: trace_level_client = 10 I don't think SQLNET.ORA will have much effect on MS SQL Server ;-). hp -- _ | Peter J. Holzer

Re: Reg DBI Problem

roceed to > overcome the above error. DBD::Oracle 1.16 is about 6 years old and I think older than Oracle 11g, so in addition to what John wrote it might help to upgrade to a current release. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sys

Re: "Out of memory! Out of memory! Callback called exit at ..."

any rows would it return if it didn't run out of memory?) If each row contains a 20 MB blob you don't need many rows to run out of memory. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig

Re: Problem with a conection...

e of the disconnect (so it's probably a good idea to structure your application in such a way that there are no long idle times in the middle of a transaction). hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprä

Re: Some DBI question -

, like printf, formats, various templating toolkits, etc. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern." __/ | ht

Re: How to set LD_LIBRARY_PATH

(probably libc) and after that the components aren't used any more. hp [1] I seem to remember that I ran into problems either on x86_64 or on power, but I don't remember the details. If it's x86_64, I should be able to test it (don't have access to power-based

Re: anyone accessing "h2" java database with DBI?

a). Of course for a server you don't need an ABI: You can (and maybe should) publish the network protocol instead and let people write their own client libraries. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingepr

Re: Trying to safely compare user input name against database

want to find a string regardless of capitalization. But maybe you also want to ignore accents or other spelling variants (for example, in German "ö" can also be written "oe"). Now it depends not only on the language but on context and on the expectations of the user. And once you do

Re: CLOB select with ora_pers_lob (truncation issue)

et *and* included all characters needed for the language. These days you can just use UTF-8 (AL32UTF8 in Oracle) and be done with it, although for some languages and some applications it may still be useful to distinguish between the two character sets. hp -- _ | Peter J. Holzer| A

Re: Help on using << on *nix and Windows

like sqlplus -S "/as sysdba" <$tmpfile. Or you could use IPC::Open2 (but I'm not sure whether that works on Windows). hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ew

Re: failed: ERROR OCIEnvNlsCreate. Check (everything)

ronment isn't what you think it is. How are you running the program from the server? CGI, mod_perl, something else? The environment must be configured differently depending on the method. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmi

Re: Perl coredump when using ora_dbh_share to connect to Oracle DB's

;> >> is a rather odd dsn > > I always the the method above, although I don't define the host and port part, > since it is known in tnsnames. But the dsn part looks normal to me :) If you want to use tnsnames, shouldn't that be: my $dsn = 'DBI:Oracle:XXX';

Re: parameter issues in DBD:Oracle

#x27;t do it as > 'in(?,?,?,?)' etc, because the number of list elements varies from > execution to execution. Sure you can: $qry = "select * from reservedroomtest where roomid in (" . join(",", map "?", @list) . ")"; $sth =

Re: Perl 5.6.1 supports DBI module

On 2010-03-18 16:30:11 -0500, Michael Nhan wrote: > DBI-1.605 was the last version not to require perl 5.8. Even though the > Readme doesn't state it, version 1.606 and newer requires 5.8.10 in the ITYM 5.8.1 hp -- _ | Peter J. Holzer| Auf jedem Computer soll

Re: Which SQLite DBD To Use

On 2010-03-17 10:27:45 -0500, Will Rutherdale (rutherw) wrote: > > -Original Message- > > From: Peter J. Holzer [mailto:h...@wsr.ac.at] > > On 2010-03-16 17:14:32 -0500, Will Rutherdale (rutherw) wrote: > > > Also, the DBD-SQLite package has a funny descrip

Re: Which SQLite DBD To Use

an that it is the Driver for > the "Self-contained RDBMS" of SQLite? No. The drivers includes an SQLite version and will ignore any other version which may already be installed on the system. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |

Re: How to extract db hostname from the $dbh handle?

ved by the library, not the DBD. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern." __/ | http://www.hjp.at/ |-- Wolfram

Re: Verify Compatibility

e number for you and determine if you have > pirated chinese software > or legitimate software from HP-US Huh? Since when are Perl, DBI, and DBD::mysql property of Hewlett Packard? And how do you "pirate" Perl? hp -- _ | Peter J. Holzer| Auf jedem Compute

Re: (Fwd) DBD::Oracle - Issues Compiling DBI

vs. const char[]). This warning supports the suspicion that you are trying to compile C code with a C++ compiler. Don't do that. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel wil

Re: Help needed.

about approximately 3 GB of RAM here, if each row has lots of fields it can be a lot more. Unless you need all that data in memory at the same time, use fetchrow_arrayref in a loop instead. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) |

Re: Looking for clever solution: Different versions of Oracle .so files within single Perl build

hem talks the Oracle 8 DB and the other one talks to the Oracle 10 DB. Let them communicate over a pipe or socket. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@w

Re: Info needed about version compatibility

hich is set up to build and test DBD::Oracle, so that all of the tests are in state "unknown". -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at

Re: MySQL client ran out of memory

he mysql client with the --quick > parameter it does work. > > Is there a way of using the quick parameter in DBI? I think you may be looking for the database handle attribute "mysql_use_result". hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Sa

Re: Does Pg's psql have an equivalent to Oracle's spool cmd?

y the results, not the commands. You should be able to get around the first limitation by invoking \o |tee file but I don't see any way around the second. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: &quo

Re: DBD::ODBC and character sets

can be little endian (LE) or big endian (BE). hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern." __/ | h

Re: Install issues. Os/x 10.5 and DBD-Oracle-1.23

is also the possibility that your Oracle installation already contains both types of libraries and Makefile.PL failed to detect the correct version. If there is a lib64 or lib32 subdirectory somewhere that's probably the case. hp -- _ | Peter J. Holzer| Auf jedem Computer s

Re: Retrieving warnings after executing a MySQL INSERT statement

d state() methods may be used to retrieve extra information in these cases. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern.&qu

Re: Very slow mail-transport to the list

x27;t there in the first place. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern." __/ | http://www.hjp.at/ |--

Re: Very slow mail-transport to the list

o you snipped exactly the part where the problem can most likely be seen. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern

Re: Insert records in table with perl DBD::Mysql

argument is a hashref containing attributes, and the bind values come after that. So you want $dbh->do("insert into $objtbl values (?,?,?,?,?,?)", {}, $name,$type,$ip,$mask,$comment,$mark); or $dbh->do("insert into $objtbl values (?,?,?,?,?,?)", undef, $name,$type,$i

DBD::Oracle 1.23 and instant client 10.2.0.4

s about exactly _why_ you had to build it this way. Found header files in /usr/include/oracle/10.2.0.4/client. The rules defined by demo.mk are: all buildoci buildocci plus a bunch of others which don't look relevant. hp -- _ | Peter J. Holzer| Auf jedem Co

LD_LIBRARY_PATH on x86_64 linux

). A change to LD_LIBRARY_PATH after program startup seems to be ignored and consequently libclntsh.so.10.1 isn't found. If I set LD_LIBRARY_PATH before invoking the perl script it works, so the workaround is obvious, but it's ugly. Have others noticed the same thing? Does anyone know why

Re: unable to write from a select into outfile

r whatever network filesystem you mistrust least) or on a file server accessible by both. 2) copy the file from the database server to the web server, for example with scp or rsync. 3) forget about "select into outfile". Use a normal select and process the results in the

Re: Incorrect required version in readme for DBI 1.5 and 1.6

l v5.8.10 required--this is only v5.6.1, stopped at Makefile.PL line 10. 5.8.10 isn't even out yet (5.8.9 is the latest release in the 5.8.x series according to http://www.cpan.org/src/README.html), so I think this must be a typo. Maybe that should read 5.8.1? hp -- _ | P

Re: Problem with Oracle ODBC connection

8i databases any more. The last client to work with 8i databases was 10g. The 10g client also talks to Oracle 11 servers, so that's currently the "most compatible" client. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysad

Re: SQL Keyword is used as Field Name. SELECT Query Problem using DBI.

. > Please guide me how I can do this. The first step is to actually read the error message. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | blei

Re: DBI and DB:oracle modules

rmal way to install packages in RHEL (<= 4) is with up2date, but I don't know if that works without an internet connection. rpm always works, of course. hp -- _ | Peter J. Holzer| Am Anfang war der Bug und der |_|_) | Sysadmin WSR | Verantwortliche sprach: | | | h...@ws

Re: How to iterate through database tables

s) { $sth = $dbh->prepare("select * from ${month}_sales ..."); } Here $month is never tainted because it can get only values from your program, not from the user. So it is safe to use. hp -- _ | Peter J. Holzer| Am Anfang war der Bug und der |_|_)

Re: DBI and DB:oracle modules

.21? Just get the newest one from CPAN. > $perl -v > > This is perl, v5.8.5 built for i386-linux-thread-multi You may want to subscribe to the rhel-i386-as-4-webapp-1-beta channel, which includes perl-5.8.8. hp -- _ | Peter J. Holzer| Am Anfang war der Bug und der |_|

Re: Ways of ensuring integers in the database are seen as numbers in perl?

(64 bit) digits), but AFAIK it isn't. Your best bet is probably explicitely binding with an approriate type (SQL_INTEGER). hp -- _ | Peter J. Holzer| Am Anfang war der Bug und der |_|_) | Sysadmin WSR | Verantwortliche sprach: | | | h...@wsr.ac.at | Es

Re: DBI connect and ports issue

On 2009-01-14 22:01:39 -0500, Martin Gainty wrote: > Port 1526 sounds odd as the default port for oracle is 1521 Port 1526 used to be the default port for oracle (until version 7, IIRC). Some sites still use it for historical reasons. hp -- _ | Peter J. Holzer| Am Anfang

Re: Beginners Question: Can I have more the one statement-handle from same db-handle at a time?

tch_* just reads from the already cached data. So, as far as the DBI programmer is concerned, multiple open cursors are allowed (until the resultset is too large to fit into memory - then you need to turn mysql_use_result on and either fetch all rows or call finish before using another statement h

Re: Install DBD-Informix on 64bit RHEL

-- > > > I have no idea what this '-lifsql' is. "-lifsql" means "link with the "ifsql" library. The linker does find two libraries (/opt/ids/lib/esql/libifsql.so and /opt/ids/lib/esql/libifsql.a) but both are o

Re: what's <<"SQL" do?

x? See perldoc perlop, "Quote-Like Operators". hp -- _ | Peter J. Holzer| Am Anfang war der Bug und der |_|_) | Sysadmin WSR | Verantwortliche sprach: | | | [EMAIL PROTECTED] | Es werde ein Testcase. __/ | http://www.hjp.at/ |-- Clemens Zauner in dcii pgp5IjGjBJSLo.pgp Description: PGP signature

Re: Perl+DBI question [C1]

it - no messing around with @INC necessary. If you need to do that, you have already done something strange (not necessarily wrong, but strange - so you may run into strange problems). hp -- _ | Peter J. Holzer| Am Anfang war der Bug und der |_|_) | Sysadmin WSR | Verant

Re: [rt.cpan.org #36395]

umber of placeholders and the size of the array were not equal, I don't remember ever ending up with an empty array. I did forget the parameter list a few times (i.e., $sth->execute instead of $sth->execute($x, $y)) ... hp -- _ | Peter J. Holzer| If I wanted to be &quo

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

ran into a similar problem with instant client 10.2.0.4 on Linux (Debian Etch, instant client rpms converted to .deb with alien). Wierdly enough it happened only during "make test". Running the tests individually with "prove -b -v" worked, and at least my simple test scripts

Re: Generic DBI question about backups

his, set up your "migration PC" now, don't wait until the current hardware is gone. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don

Re: Perl 5.10.0

ferent package - look for something like "perl-devel", "perl-headers", or similar. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgp4TgF2ds08E.pgp Description: PGP signature

Re: install_driver(Oracle) failed: wrong ELF class: DynaLoader.pm

product/10.2.0/lib32 /oracle/dba/backup/ora19/DbOnline.pl ora19 directly into the crontab. But personally I prefer invoking small shell scripts to very long commands in crontabs. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR

Re: Perl in oracle 10.2.0.3 on 64 BIT OS

re-requisites and then > install DBD::Oracle. > > I can't answer for whether DBD::Oracle supports 64-bit systems, but it would > be astonishing (to me) if it did not do so. It works at least on 64-bit Linux. I believe 64-bit HP-UX has been mentioned on this list, too. hp --

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

nt to nudge people into separating client and server installations ... hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm

Re: DBD::Oracle and Support for Oracle 8 and 9 clients

client which access one of the old 8i databases. Sometimes things are a bit weird (especially with UTF-8), but it works. -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL

Re: Recursive SQL query?

So, you can for example do individual queries and cache the results (in the object, if you are creating objects, or in a hash). The upper levels in the catalog will almost always be in the cache, so you rarely need to send a query for the parent. hp -- _ | Peter J. Holzer| If I want

Re: question for DBD-Oracle driver

On 2008-04-10 10:26:50 -0500, James H. McCullars wrote: > At 09:08 AM 4/10/2008, Peter J. Holzer wrote: > >Why shouldn't it work with a CGI script? I can think of reasons why it > >wouldn't work with mod_perl, but none for a CGI script. > > Setting the environm

Re: question for DBD-Oracle driver

On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: > At 02:17 AM 4/10/2008, Peter J. Holzer wrote: > >>I've just been through an install of DBD::Oracle on a Solaris 10 > >>machine and this was my experience as well. My needs were > >>complicated by the

Re: question for DBD-Oracle driver

while () { chomp; my ($k, $v) = split(/=/); $ENV{$k} = $v; } close(E); } hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. |

Re: mysql inserting decimal value with perl loses precision

On 2008-03-14 12:44:29 +, [EMAIL PROTECTED] wrote: > Peter J. Holzer - [EMAIL PROTECTED] wrote: > > On 2008-03-14 09:50:15 +, [EMAIL PROTECTED] wrote: > >> This is more for the archives than anything as there is a workaround. > >> > >> When inserting 1

Re: mysql inserting decimal value with perl loses precision

ng? I would expect rounding errors when passing numeric scalars to "decimal" types in general, but not in this case - that should be handled correctly (because it can). hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR

Re: make error-> ld: Unrecognized argument: -Wl,+b...

't know about the ActiveState perl interpreter, I suspect that it isn't either. So I would recommend to always build your own perl on HP-UX (preferrably with the HP C/ANSI-C compiler). hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpwcA0WXacHO.pgp Description: PGP signature

Re: Find current database name from db handle

it[1]) is different between databases (in Oracle it's "alter session set current_schema = $scheme_name"). It may be possible in the driver which could check for these commands and remember the current database. But even that's not guaranteed to work: What happens if this comma

Re: DBI-DBD::ORACLE EROR

and the complete package is available for free from the Oracle web-site, so that's simply the easiest way for him to get it. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java.

Re: All tests fail for any other than user 'oracle'

emely unlikely that installing a software on one host will damage software on a different host, I conclude that your database and the Instant Client packages are installed on the same machine - so you need to be careful to set the environment to point to the right installation.

Re: Using q() to define a query

On 2008-01-14 13:07:17 +0100, Jenda Krynicky wrote: > From: "Peter J. Holzer" <[EMAIL PROTECTED]> > > As an aside, the SPL programming language[2] allows the terminator of a > > here document to be indented and to strip off everything up to and > > including s

Re: Using q() to define a query

for color coding, autocompletion, etc. That's a neat feature of course and an argument for using here-documents. hp [1] No, I don't think »my $sql = <<'SQL';« is a good idea. [2] http://www.clifford.at/spl -- _ | Peter J. Holzer| If

Re: Using q() to define a query

D- used, anyway? Isn't that usually written as MM/DD/ or MM.DD.?), it doesn't make a difference here: The string is converted to a date type, and then two date values are compared. That one of them was computed from a string is irrelevant. hp -- _ | Peter J. Hol

Re: Segmentation Fault(Core dumped)

u cannot just change the client path and expect it to work, you will have to rebuild DBD::Oracle against the new client. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | |

Re: heap corruption in DBD::Oracle

On 2007-12-16 23:07:36 +0100, Peter J. Holzer wrote: > I have a perl script which updates some (large) tables from text-files, > inserting, updating and deleting records. For performance reasons the > inserts, updates and deletes are queued together and then done with an > array op

heap corruption in DBD::Oracle

r? Version information: DBD::Oracle 1.19 DBI 1.58 perl v5.8.8 built for x86_64-linux-thread-multi Red Hat Enterprise Linux AS release 4 (Nahant Update 5) Oracle 10.2.0.1.0 hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_)

Re: Fun with UTF-8 and Oracle [PATCH]

On 2007-09-04 14:20:20 +0100, Tim Bunce wrote: > On Mon, Sep 03, 2007 at 07:20:42PM +0200, Peter J. Holzer wrote: > > On 2007-09-03 13:03:37 +0100, Tim Bunce wrote: > > > Oh the joys of Oracle character set support. > > > > > > See the dbd_rebind_ph() code i

Re: DBD::Sybase 1.08 fails to run tests on HP-UX 11.23 (64bit) with Sybase 12.5.3 (64bit)

ANSI-C-compiler, usable only for compiling /stand/build/conf.c (and similar specialized tasks). Either buy the HP ANSI-C compiler or get gcc. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Ja

Re: Segmentation fault with module DBD::Oracle 1.19 on SuSE Linux Enterprise Server 10 (IBM Power 64 bit)

with a 32-bit executable, so that's to be expected. I cannot explain the segfault, though. I did notice that you didn't include any output from "make test". Did you run it? If so, did it also crash with a segfault? hp -- _ | Peter J. Holzer| If I wanted to be &q

Re: Parsing Results from fetchall_hashref()

On 2007-10-28 16:29:21 +0100, Peter J. Holzer wrote: > On 2007-10-26 19:39:38 -, Rob Wilkerson wrote: > > I can access the value of each member just fine using $mediaref- > > >{$media_id}->{'ADID'} and I can access the size of the entire record > > set as

Re: Parsing Results from fetchall_hashref()

a prepared and executed statement handle. It returns a reference to a hash containing a key for each distinct value of the $key_field column that was fetched. For each key the corresponding value is a reference to a hash containing all the selected columns and their va

Re: using $dbh->quote with UTF

of quote in an HTML fragment doesn't seem very useful to me. I can only assume that you are doing it to demonstrate something but I don't understand what you are trying to demonstrate. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sys

Re: Very slow executes with utf8 integer parameters in DBD::Oracle

binding with the correct cs_form also works: $sth->bind_param(1, $name, { ora_csform => SQLCS_IMPLICIT }); hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED

  1   2   3   >