Re: sth-cancel
On Tue, Jul 02, 2002 at 04:44:59PM +0200, Waldemar Zurowski wrote: On Mon, 1 Jul 2002 21:34:50 +0100 Tim Bunce [EMAIL PROTECTED] wrote: Yet is't a horribly long name. Why don't you change connect into connect_to_database, prepare into prepare_statement and do into prepare_and_execute_statement? Huffman coding. Well - I personally like name 'finish'. It is doing what I want (in current context of course.) It is finishing a query. Trouble is, thousands of people (literally) think it finishes/deallocates the statement handle and/or that they need to call it after fetch loops. Tim. I sometimes need finish to prevent Oracle from whining that I havn't read all the rows I've selected. How about discard, or no_more, or enough_already, or thank_you_thats_enough? :-) Thinking about it, enough seems a reasonable suggestion! -- David Adams Computing Services Southampton University
Re: commit doesn't work with dbi::proxyserver
You will need to stop and re-start the proxyserver daemon after upgrading, I just got caught out by that. Can you produce a simple script which shows the DBI::ProxyServer error message? -- David Adams Computing Services Southampton University - Original Message - From: Antoine Janssen [EMAIL PROTECTED] To: Tim Bunce [EMAIL PROTECTED]; David Adams [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, June 17, 2002 1:35 PM Subject: Re: commit doesn't work with dbi::proxyserver Upgrading does not solve the problem. Im now using DBI version : 1.28 DBI::ProxyServer version : 0.2005 on both the machine that holds the db (and the proxyserver) and the machine that runs the script the error message: DBD::Proxy::db commit failed: Server returned error: Failed to execute method CallMethod: DBI::ProxyServer::db=HASH(0x8388ad4)-func() invalid redirect method name 'commit' at /usr/lib/perl5/site_perl/5.6.1/RPC/PlServer.pm line 332. Or perhaps you need to upgrade. Tim. On Thu, Jun 13, 2002 at 01:22:39PM +0100, David Adams wrote: $dbh-commit works fine for me using proxyserver to access an Oracle database. Perhaps if you included a code listing and a few more details someone will spot the cause of your problem. -- David Adams Computing Services Southampton University - Original Message - From: Antoine Janssen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 3:43 PM Subject: commit doesn't work with dbi::proxyserver hi, i'm trying to commit some changes with $dbh-commit(); while using dbi::proxyserver but get the following error message DBI::ProxyServer::db=HASH(0x8389228)-func() invalid redirect method name 'commit' at /usr/lib/perl5/site_perl/5.6.1/RPC/PlServer.pm line 332. is it a bug in dbi::proxyserver? what goes wrong?? if i disable transactions ($dbh-{AutoCommit} = 1) and don't use $dbh-commit() everything works fine. Antoine Janssen
Re: Query: How to install DBD::Oracle on Irix 6.5?
Thanks for your help Thomas, but I still havn't got DBD::Oracle to work under Irix. I tried compiling Perl with -64. There were so many fails during 'make test' that I didn't try installing it. The installed Perl was compiled with -n32 and a colleague got the Irix N32 Development Toolkit for me. Then I was able to build DBD::Oracle without more than a few warning messages from the C compiler. However, 'make test' fails completely, the output is at the end of this message. I'm told that Oracle 9i has no support for Irix atall, so I think our long-term strategy is going to be moving our applications on to Sun hardware. Also, I have DBD::Proxy running OK, so I do have a short-term fall-back, but I would like to get this working if I can. -- David Adams Computing Services Southampton University - Original Message - From: Thomas A. La Porte [EMAIL PROTECTED] To: David Adams [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August 03, 2001 4:01 PM Subject: Re: Query: How to install DBD::Oracle on Irix 6.5? You have two options, based on whether you want to build (or have built) Perl -64 or -n32. If you need n32, you'll have to order or download the Irix N32 Development Toolkit, which provides the basic set of client libraries in n32 form, rather than the 64 bit libraries. Alternatively, you can build with the 64-bit libraries if your Perl is already built 64-bit. I found that I needed to set a compiler.defaults file with -n32 and -mips3 specified, in order to match our version of Perl, and use the N32 Toolkit. Also, IIRC, I needed to build the Makefile with 'perl Makefile.PL -p' -- Tom Thomas A. La Porte DreamWorks SKG [EMAIL PROTECTED] On Fri, 3 Aug 2001, David Adams wrote: We have the Oracle 8.1.6 client installed and working on Irix 6.5. I have installed Perl 5.6.1 and DBI 1.18, and have DBD::Proxy working. I have failed to build DBD::Oracle 1.06, with the 'make' failing with the last two lines: cc WARNING:-64 conflicts with -n32; using latter value (-64) ld64: FATAL12 : Expecting n64 objects: Oracle.o is n32. Also the generated Makefile contains this weird line: EXTRALIBS = -L$(LIBHOME) echo -64 ; fi` -Wl,-woff,16,-woff,84,-woff,85,-woff,134,-rdata_shared,-multigot,-mips3 -o build -rpath /opt/local/oracle/lib -L/opt/local/oracle/network/lib/ -L/opt/local/oracle/ l ib/-lclntsh The README.help file suggests that I should compile Perl with the -32 -mips2 compiler options and re-install, but this advice seems to be for Oracle 7.?. What is needed to install DBD::Oracle with Oracle 8.1.6 on Irix 6.5? I will re-install Perl if I need to, but I can't afford to re-install it repeatedly until I hit on the right options. Thanks. -- David Adams Computing Services Southampton University PERL_DL_NONLAZY=1 /opt/local/perl-5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/opt/local/perl-5.6. 1/lib/5.6.1/IP27-irix-64all-ld -I/opt/local/perl-5.6.1/lib/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/base..FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/general...install_driver(Oracle) failed: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: 1016126:/opt/local/perl-5.6.1/bin/perl: rld: Fatal Error: unresolvable symbol in /opt/local/oracle/lib/libclntsh.so.8.0: sqlxfr at /opt/local/perl-5.6.1/lib/5.6.1/IP27-irix-64all-ld/DynaLoader.pm line 206. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/general.t line 20 dubious Test returned status 255 (wstat 65280, 0xff00) t/long..Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: 1016127:/opt/local/perl-5.6.1/bin/perl: rld: Fatal Error: unresolvable symbol in /opt/local/oracle/lib/libclntsh.so.8.0: sqlxfr at /opt/local/perl-5.6.1/lib/5.6.1/IP27-irix-64all-ld/DynaLoader.pm line 206. at t/long.t line 4 Compilation failed in require at t/long.t line 4. BEGIN failed--compilation aborted at t/long.t line 4. dubious Test returned status 255 (wstat 65280, 0xff00) t/plsql.Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: 1018742:/opt/local/perl-5.6.1/bin/perl: rld: Fatal Error: unresolvable symbol in /opt/local/oracle/lib/libclntsh.so.8.0: sqlxfr at /opt/local/perl-5.6.1/lib/5.6.1/IP27-irix-64all-ld/DynaLoader.pm line 206. at t/plsql.t line 17 Compilation failed in require at t/plsql.t line 17. BEGIN failed--compilation aborted at t/plsql.t line 17. dubious Test returned status 255 (wstat 65280, 0xff00) t/reauthskipped test on this platform Failed Test Status Wstat Total Fail Failed List of Failed t/base.t 52 40.00% 4-5 t/general.t 255 65280?? ?? % ?? t/long.t 255 65280?? ?? % ?? t/plsql.t
Re: [Oracle] DBI: Oracle client libs necessary ??
Say you have an Oracle DB installed and running on Machine A. To use DBI with the database you need the DBD::Oracle module installed on a machine where you also have the Oracle client libraries, etc. installed, either Machine A itself, or another machine, Machine B. If you want to run the Perl code on Machine A or Machine B then there is no problem. Just install DBD::Oracle on them. If you do not have the Oracle client installed on the machine where you want to run your Perl code, Machine C, then you can use the DBD:Proxy module (with supporting modules Net::Daemon, RPC:PlServer and Storable) installed on Machine C, and those modules plus DBD::Oracle installed on Machine A or B. Then, Machine C can run Perl code against the database on Machine A. If you need to go the DBD::Proxy route then you should consult the Cheetah Book Programmming the Perl DBI, and it's a good idea to consult it anyway. -- David Adams Computing Services Southampton University - Original Message - From: Markus Fischer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 8:11 AM Subject: [Oracle] DBI: Oracle client libs necessary ?? Hi this is just a question for my understanding: Does the perl-dbi module depends/needs the oracle client library installation (at least) or does connecting to oracle databases on remote hosts work without it ? ty Markus
Re: DBD:Oracle - LD_LIBRARY_PATH doesn't work...
You could try BEGIN { $ENV{ORACLE_HOME}=/quiq/share/OracleClient; $ENV{LD_LIBRARY_PATH}=/quiq/share/OracleClient/lib; } in your script. -- David Adams Computing Services Southampton University - Original Message - From: Raj Srinivasan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 12:14 AM Subject: DBD:Oracle - LD_LIBRARY_PATH doesn't work... Hi, I am building perl for distribution on several machines and I am having difficulties in using DBD:Oracle with that build. I have installed the DBD:oracle after setting up ORACLE_HOME and LD_LIBRARY_PATH. make test didn't report any errors. Available_drivers returns Oracle driver as installed. Driver: Oracle Data Source is dbi:Oracle:DMART01.world Data Source is dbi:Oracle:QA01.world Data Source is dbi:Oracle:QA02.world Data Source is dbi:Oracle:QUIQ.world Data Source is dbi:Oracle:TST01.world Now the question is... If I declare the LD_LIBRARY_PATH as my shell env variable, I could able to make connection to the oracle database. If I declare the LD_LIBRARY_PATH as part of the script, the connection don't go thru. #!/netapp01/repository/perl/bin/perl -w $ENV{ORACLE_HOME}=/quiq/share/OracleClient; $ENV{LD_LIBRARY_PATH}=/quiq/share/OracleClient/lib; Do I have to install DBD for oracle differently. Am I doing anything wrong? Any ideas? Thanks.. Raj $ /netapp01/repository/perl/bin/perl -V Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=linux, osvers=2.2.14-va.2.1smp, archname=i686-linux uname='linux selma.west.quiq.com 2.2.14-va.2.1smp #1 smp mon jul 31 21:53:20 pdt 2000 i686 unknown ' config_args='-Dprefix=/netapp01/repository/perl -des' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='cc', ccflags ='-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O2', cppflags='-fno-strict-aliasing' ccversion='', gccversion='egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=4, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt -lutil perllibs=-lnsl -ldl -lm -lc -lposix -lcrypt -lutil libc=/lib/libc-2.1.3.so, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic' cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: USE_LARGE_FILES Built under linux Compiled at Apr 23 2001 10:34:09 @INC: /netapp01/repository/perl/lib/5.6.1/i686-linux /netapp01/repository/perl/lib/5.6.1 /netapp01/repository/perl/lib/site_perl/5.6.1/i686-linux /netapp01/repository/perl/lib/site_perl/5.6.1 /netapp01/repository/perl/lib/site_perl .
Re: Design a place to open/modify/close a ticket
See: http://www.perl.com/pub/1998/11/article.html It doesn't use Oracle, but it does seem to have a good interface, which is probably the hardest part of the design. -- David Adams Computing Services Southampton University - Original Message - From: "Nguyen, David M" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 6:48 PM Subject: Design a place to open/modify/close a ticket Hi all, I am tasked to design a database so people can open a ticket, modify/close as need. Does someone ever do this with DBI and Oracle database? Is there any good resource I can go for demo? Thanks, David