Re: book on perl oracle dB integration

Hi Manisha, I am searching for a book on Perl oOacle Database Integration. I have found similar books on Java Oracle DB Integration but not for perl. If anyone knows of one please let me know of it. You could always try: = http://www.oreilly.com/catalog/perldbi/ =

Re: How to find what version of Oracle *client* from Perl?

Hi Bill, Wouldn't it be much simpler to create your own module to determine the ORACLE_HOME to use based on the version of Perl? ( or any other criteria ) If you do write a module, maybe you could make it a DBIx extension, like DBIx::OracleHome or something? If this is of interest, check

Re: Perl + Oracle PL/SQL?

Hi Sei Heng, I know this may sound like a stupid question. Anyone can give some hint regard Oracle PL/SQL + Perl programming? Please forgive me if I'm merely repeating other advice, but from the emails I saw nobody mentioned extproc_perl? For more on embedding Perl within Oracle, try the

RE: Having problem with dbd-oracle 1.12 ....kindly help...

Hi Sal, link -out:..\..\blib\arch\auto\Tk\X\X.dll -dll -nologo -nodefaultlib -re lease -libpath:C:\perl\lib\CORE -machine:x86 X.obj C:\perl\lib\CORE\perl56 .lib oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib a dvapi32.lib shell32.lib ole32.lib

Re: DBI module

Hi John, I have SuSE 7.3 installed on my system. I am using mysql to create database tables. I was using db2 for linux but they want alot of money for their product so I am going to use mysql instead. Is my understanding correct that you use the dbi interface to link perl modules to

RE: Having problem with dbd-oracle 1.12 ....kindly help...

Hi Sal, The error I am getting is while trying to connect to oracle is DBI connect() failed :DBD (login failed,check your config,e.g.ORACLE_HOME/bin on your PATH etc) at orac_dba.pl line 304 Any advise ? It sounds like ORACLE_HOME is not set in your Win32 environment. However I need

Re: Tool to monitor oracle database performance

Hi David, Does anyone know if there is a tool out there we can use to monitor performance of oracle database? It sounds like you're after a continuous monitor. If you are, and if we stick to Perl, Sean Hull's Karma program might do the trick. You can check out the demo page, and download

Re: Having problem with dbd-oracle 1.12 ....kindly help...

Hi Sal, I could not do a proper perl Makefile.PL and subsuquently bad nmake. I am attaching the log files with this e-mail.The OS is win 2k advanced server and the oracle database is 81711. Have you considered ActivePerl instead? This works fine for the Orac program, with the DBI,

Re: Query on DBI and DBD

Hi Nilanjan I have a basic question on building the DBI and DBD. Can I build DBI and DBD on a machine where there is no database installed. Basically the DBD module. My set up is like this. I have an Application server and a database server. The database server will have the oracle database

Re: Embedding perl in Oracle

Hi Tim, I've done it, it works. Be aware that setting it up is not trivial, as the documentation is somewhat incomplete. That is being remedied however... http://www.cpan.org/modules/by-authors/Jeff_Horwitz/ http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.readme

Re: DBD-Oracle and Cygwin

Hi Dan, dlltool --input-def oci.def --output-lib liboci.a before running perl Makefile.PL, which returned the following Checking if your kit is complete... Looks good Note (probably harmless): No library found for -loci -- is this important? I think you have to put liboci.a somewhere

Re: mod_perl and dbi

Hi Dan, Can someone give me some examples of high-volume, high-profile sites using mod_perl and dbi? A lot of people use Embperl (HTML::Embperl), often with mod_perl and DBI. You can see some of these sites here: = http://perl.apache.org/embperl/Sites.pod.1.html A lot of other people also

Re: Unix GUI tool for Oracle (and others like mysql in future)

Hi Tim, If you're using Oracle from unix (or even windows) then this looks very interesting: www.globecom.net/tora Give it a whirl. Those using the Qt libraries, which Tora relies upon, may also wish to check out the following pages to make sure they're not straying into any kind of

Re: Unix GUI tool for Oracle (and others like mysql in future)

Hi Paul, http://www.trolltech.com/products/download/freelicense/ http://www.trolltech.com/products/download/freelicense/license.html http://www.trolltech.com/developer/faq/simple.html It seems to have become more restrictive again. All of these links have disappeared in the last couple of

Re: Unix GUI tool for Oracle (and others like mysql in future)

Hi John, Where in the world did Orac run off too? Kevin Kitt's website is down. The best place to get hold of Orac, is: = http://www.cpan.org/authors/id/A/AN/ANDYDUNC/ Try the Orac-alpha-1.2.5.tar.gz download, which makes use of Richard Sutherland's DDL::Oracle module, and Dean Arnold's

Re: Perl/Gui DB software

Hi Dan, I'm currently writing a db application based on Oracle with Perl batch processing, and am intending to implement a GUI front end. Perl/Tk looks like a possible option. I'm reasonably new to Perl but feel confident enough in it to create a functional app, even if the code is not

Re: DBI , Oracle - how to accept multiple rows returned by a PL/SQL s tored procedure

Hi Andrey, I'm considering to write a PL/SQL procedure that returns multiple rows (most likely via REF cursor , although i might think of PL/SQL tables or VARRAYs) How can i accept such an output in PERL script ? You could try the private DBMS_OUTPUT methods available via DBD::Oracle, and

[ANNOUNCE] Orac-1.2.3.tar.gz Perl/Tk Perl DBI Tool

Hi Everyone, Richard Sutherland and I are revamping the Orac Perl/Tk Perl DBI program. This now makes liberal use of Richard's DDL-Oracle package (required for Oracle usage) and we're also beginning to make use of Dean Arnold's DBD-Chart package (not required, but if available on your local