Greetings. New user here.
I have interfaced with Oracle plenty of times in perl scripts
my $sql = qq{sdfsdfsdfsdfsdfsdf};
my $sth ...
($x, $y ..) = $sth->get..
But I have never collect binary files for the purpose of saving them in a local
directory.
I need some examples of how others
- Original Message -
From: "Nelson R Pardee" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 19, 2008 8:20 AM
Subject: Installing Oracle Module for latest Perl
> Dbd-oracle doesn't seem to be available for the latest version of perl,
> and I can't fig
Dbd-oracle doesn't seem to be available for the latest version of perl,
and I can't figure out how to make it available. No, I don't want to go
the odbc route. I can go back one perl version to get it to work, but
I'd prefer not to. Suggestions? Thanks in a
- Original Message -
From: "jagdish eashwar" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 21, 2007 12:16 AM
Subject: Re: problems in installing DBD-Oracle for ActiveState Perl
5.8.8build 822 through ppm
> Hi,
>
> Thanks Rob. I could install DBD-Oracle 1.1
Hi,
Thanks Rob. I could install DBD-Oracle 1.19 from trouchelle.com/ppm/, but it
is giving the following error message when I run a simple script which
connects to an oracle database and selects the sysdate from dual. The script
itself seems okay because I am able to run it successfully on
- Original Message -
From: "Sisyphus" <[EMAIL PROTECTED]>
.
.
>
> I can't reproduce the problem
.
.
Actually ... on closer investigation it seems that the DBD-Oracle I
installed might have come from the trouchelle rep (not the ActiveState rep).
Therefore, f
- Original Message -
From: "jagdish eashwar" <[EMAIL PROTECTED]>
To:
Sent: Sunday, August 19, 2007 10:38 PM
Subject: problems in installing dbd-oracle through ppm
> hi,
>
> I downloaded ActiveState Perl today. Thereafter, I could install dbd-mysql
> us
hi,
I downloaded ActiveState Perl today. Thereafter, I could install dbd-mysql
using ppm. But when I tried to install dbd-oracle, I kept getting the error
"| invalid switch", and then ppm would end abruptly. Is this something that
has to be corrected at the ActiveState end?
jagdi
s more specific
> than "Re: Contents of Perl-Win32-Users digest..."
>
>
> Today's Topics:
>
>1. trouble connecting to Oracle (Dan Jablonsky)
>
>
> ------
>
> Message: 1
>
"\n";
print "\n";
print "My List here\n";
&print_prompt($query);
print "I GOT HERE! -- form printed";
&do_work($query);
print "I GOT HERE! -- values processed";
#connect to ORACLE
print "<\BR>";
print "I GOT HERE! --
hi all,
i have had Perl 5.8.6.811 running for quite some time
on my machine. Everything was fine until I had to
install Oracle 10g.
Now, whenever I try to execute one of my old perl
scripts I get the following error:
Perl lib version (v5.8.3) doesn't match executable
version (v5.8.6) at
C:\o
Hi,
I need to update a mysql table with values contained in an oracle table. For
this, I am using the perl dbi, but am not getting the syntax right. I am
able to get the syntax for updating a mysql table from another mysql table
contained in the same database. But I am not able to update the
PROTECTED]
01/28/2007 01:39 AM
To
perl-win32-users@listserv.ActiveState.com cc
Subject
OLE : transferring data from Oracle to Excel
Hi,
I wish to transfer data from an Oracle table to an Excel workbook. The
Excel cells in which the data is to be input are all named. I
connected to
perl-win32-users@listserv.ActiveState.com
cc
Subject
OLE : transferring data from Oracle to Excel
Hi,
I wish to transfer data from an Oracle table to an Excel workbook. The
Excel cells in which the data is to be input are all named. I
connected to Oracle through DBI and picked up the required
Hi,
I wish to transfer data from an Oracle table to an Excel workbook. The
Excel cells in which the data is to be input are all named. I
connected to Oracle through DBI and picked up the required data into a
hash called "data", which has the Excel cell names as its keys. I then
connecte
Hello,
I finally installed DBD-Oracle.
The reason of error is due to network or so.
I tried to download the DLLs directly from the PPM site, guessed from
the download script.
I downloaded them after timeouts of 5 or 6.
And now I met another error, ORA-03134, meaning unsupported
version of
> Make sure that you have installed all the oracle
> binaries/libraries from
> the oracle distribution CDs first ....
Oh, oracle installation is required even now?
I have oracle client 9.2 installed.
And was able to use DBD::Oracle about 1 year ago.
I cann't just recent days on
Make sure that you have installed all the oracle binaries/libraries from
the oracle distribution CDs first
[EMAIL PROTECTED] wrote:
> Hello,
>
> Someone successfully installed DBD-Oracle?
> I failed for 3 times.
> "Fetching oci.dll.gz" takes less than 1 second.
>
Hello,
Someone successfully installed DBD-Oracle?
I failed for 3 times.
"Fetching oci.dll.gz" takes less than 1 second.
"Fetching oraociei10.dll.gz" ends error almost just after 180 seconds,
(3 min) maybe time outed.
I'm connecting to the Internet direct a without mo
Title: RE: :Oracle copy from one PC to another
Yes, the machines are set up similarly, with the exception that I installed a module on one, and can now no longer retrieve it from the repository I originally got it from.
Sam Gardner
GTO Application Development
Keefe, Bruyette & Woods,
I hope and believe this is not a hard question, merely procedural. . .
It seems Tim Bunce's Oracle DBD repository is no longer functional; does
anyone know the procedure for copying a module install from one machine to
another? So far I've tried copying the .pm's that seemed to b
To: activeperl@listserv.ActiveState.com
Subject: DBD::Oracle copy from one PC to another
I hope and believe this is not a hard question, merely procedural. . .
It seems Tim Bunce's Oracle DBD repository is no longer functional; does
anyone know the procedure for copying a module install fro
//lists.cpan.org/showlist.cgi?name=dbi-users
>Well, i'm trying to port a perl script from solaris to ActiveSate
>platform. My script has to connect to three Oracle Servers (2x8, 1x9i).
>I'm not used to win32 environment,
Based on the statement not used to a win32 environment
ipt from solaris to ActiveSate
>platform. My script has to connect to three Oracle Servers (2x8, 1x9i).
>I'm not used to win32 environment,
Based on the statement not used to a win32 environment
and the fact that you posted to an ActiveState list,
I'm assuming you are running Activ
OK. Thanks, your answer made things clearer.
You assumed well, i run ActiveState's Active Perl (5.8) and
i needed to build DBD-Oracle. I though i had to go for a play with
gcc... That's perl portabillity ;-)
Thanks for your link.
If i understood eveything, i need to uninstall my pr
;m trying to port a perl script from solaris to ActiveSate
platform.
>My script has to connect to three Oracle Servers (2x8, 1x9i).
>I'm not used to win32 environment,
Based on the statement not used to a win32 environment and the fact that
you posted to an ActiveState list
Hello World,
Hope this topic is not [EMAIL PROTECTED]
relevant. My Apologies if it's the case...
Well, i'm trying to port a perl script from solaris to ActiveSate platform.
My script has to connect to three Oracle Servers (2x8, 1x9i).
My problem is i'm unable to install prope
PROTECTED] On
> Behalf Of John Deighan
> Sent: Thursday, December 16, 2004 11:12 AM
> To: [EMAIL PROTECTED]
> Subject: RE: problems with DBD::Oracle
>
>
> At 04:50 PM 12/15/2004, Carter Thompson wrote:
>
> >John,
> >
> >Can you run simpler CGI script
, December 16, 2004 2:12 PM
To: [EMAIL PROTECTED]
Subject: RE: problems with DBD::Oracle
At 04:50 PM 12/15/2004, Carter Thompson wrote:
>John,
>
>Can you run simpler CGI scripts? I see you've given permissions to
>Everyone but I wonder if something else (that would be easier to debug)
;t try to connect to the Oracle
database. However, stand-alone scripts can connect and query just fine. One
temporary workaround I found is that I can set up IIS to run under my
domain account (the account I'm logged in to when I run stand-alone
scripts), so I know that it is indeed a permis
PROTECTED] On
> Behalf Of John Deighan
> Sent: Wednesday, December 15, 2004 12:59 PM
> To: [EMAIL PROTECTED]
> Subject: problems with DBD::Oracle
>
>
> I'm trying to get my web site working with an Oracle database
> (I've been
> using SQL Server through
I'm trying to get my web site working with an Oracle database (I've been
using SQL Server through DBD::ODBC). Although stand alone scripts can
successfully access the remote Oracle database, my web site, running under
IIS, can't. I get a 500 server error, and in the Perl
Eran Kaufman wrote:
I had this problem in the past and after doing some research I've
found there's a problem with Oracle DBD in ActivePerl version 5.8 and
up, due to license issues.
Although it's possible to find suitable Oracle DBD module for this
version, the simplest wa
[EMAIL PROTECTED]" in the
Perl
script as the user, but it fails as well. I can connect using ODBC but
would
prefer to use DBD::Oracle.
So, I realize that this is possibly a stupid question, but when you put
the logon string of '[EMAIL PROTECTED]' into the connect string, do you use
dou
- Original Message -
From: "Richard Morse" <[EMAIL PROTECTED]>
To: "Ken Cornetet" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Dirk Bremer (NISC)"
<[EMAIL PROTECTED]>
Sent: Monday, June 28, 2004 08:45
Subject: Re: :Oracle
>
&
- Original Message -
From: "Richard Morse" <[EMAIL PROTECTED]>
To: "Ken Cornetet" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Dirk Bremer (NISC)"
<[EMAIL PROTECTED]>
Sent: Monday, June 28, 2004 08:45
Subject: Re: :Oracle
>
&
On 25 Jun 2004, at 11:00 AM, Ken Cornetet wrote:
What version of Oracle client do you have installed on the client?
Can you TNSPING the database?
I believe DBD-Oracle only works with version 7 of the Oracle client.
DBD-Oracle-8 works with version 7 or 8 (I think...). I don't know if
either
Capacio, Paula J wrote:
> I actually got DBI and DBD::Oracle ppms from a user of that list,
> albeit for a different version of Perl which does you no good.
...keep in mind that if you have an Oracle license and are sharing
builds of DBD-Oracle you are violating the terms of your license.
Title: Message
This
topic is better suited for the DBI-Users mail list. [EMAIL PROTECTED]
Although ActiveState is not distributing, there are
people sharing PPM modules for DBD-Oracle.
In
fact there is a March 8th thread where someone else is asking about Oracle and
version 5.8.0!!
Try
Thanks Ken.
Why the CPAN Oracle driver (http://search.cpan.org/~timb/DBD-Oracle-1.15/) then for other Unix platforms? Is it just a issue for Windows platform? I always thought the Oracle client software was free and since this DBD driver is built from that it also should by free. It'
Title: Message
I
don't believe a binary distribution can be made available because of
Oracle's restrictive licensing on the Oracle client libraries. This has been a
major sore point. If memory serves, ActiveState was trying to work with Oracle
on a license change so that i
Can anyone tell me where I can get the DBD Oracle driver for DBI built for Perl V5.8.0? I found it on CPAN but not in any PPM repositories.
Many thanks!
David
___
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http
I forgot to report error msg.
(B
(BCan't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
(Bprocedure entry point Perl_Flockhook_ptr not found from perl58.dll
(B
(BRegards,
(B[EMAIL PROTECTED]
(B
(B-Original Message-
(BFrom: $BED8}(J [EMA
Hello,
(B
(BDBD-Oracle can run under Oracle9i Client 9.2.0.1.0?
(B
(BI installed
(BC:> ppm install DBI
(B
(BInstall 'DBI' version 1.39 in ActivePerl 5.8.1.807.
(B
(BC:\>ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/DB
Hi,
Does anyone know how to get the DBD::Oralce module to be installed in
5.8.0 build 804? I had the DBD:Oracle module installed in 5.6.1 before.
I've just upgraded to 5.8.0 yesterday. I could install DBD::ODBC and
DBD::CSV but couldn't install the DBD::Oracle module.
Than
DESCRIBE is not a SQL command, it's a SQL+ command IIRC. The Oracle ODBC
drivers don't know anything about "DESCRIBE", because it's not a SQL
command.
(Warning - based on recollections of two years ago when I actually *worked*
for a living)
- Original Message -
[EMAIL PROTECTED] wrote:
> I'm trying to get Information about a spezific table in an Oracle
> with the command
> 'describe table_name; '
> This command works within SQL-PLus and other Tools but I get the
> error message: "Ora-00900: invalid SQL statement&qu
Hi,
I'm trying to get Information about a spezific table in an Oracle
with the command
'describe table_name; '
This command works within SQL-PLus and other Tools
but I get the error message: "Ora-00900: invalid SQL statement"
when I use it within a perl-script using
Hi Gurus,
I am trying to connect to a remote Oracle server using a CGI program
given below.
CGI Code :
--
#!c:\perl\bin\perl
use CGI;
use DBI;
$q = new CGI;
print $q->header;
BEGIN {
$ENV{ORACLE_HOME} = "g:\\Ora81";
$ENV{ORACLE_SID} = "Ifund2";
}
##
Richard A. Nakroshis wrote:
>Todd Beverly wrote:
>
>
>>Check out the interval expression...
>>
>>This works in Oracle 8i:
>>
>>select column from table where check_date > (sysdate - interval '1' day);
>>
>>
>
>Todd,
&g
Todd Beverly wrote:
>
> Check out the interval expression...
>
> This works in Oracle 8i:
>
> select column from table where check_date > (sysdate - interval '1' day);
Todd,
Is 'interval' an actual Oracle statement or keyword? I couldn't find
T EndDate, CASE WHEN EndDate = - 86400 FROM PERS
>
> The above is quite wrong i'm sure, How can I do this?
Check out the interval expression...
This works in Oracle 8i:
select column from table where check_date > (sysdate - interval '1' day);
_
You can do this in Oracle or in Perl. If you do it in Perl with the
date_of_birth value being passed in then I would recommend using the
date:calc module. If you are doing it in Oracle then something akin to:
select name, date_of_birth from data
where sysdate - date_of_birth > 21 * 365;
T
Im using DBI to connect to a Oracle database and i'm having trouble with
this:
In a nut shell. I have a table called DATA, and a column called
DATE_OF_BIRTH.
I need to see if the person is under 21 years old. So I need to compare the
"DATE_OF_BIRTH" with whatever the current
Title: Re: Installing Microsoft ODBC driver for Oracle 8i
Hello,
I am not getting too far installing the ODBC driver from Microsoft for ORACLE.
I have been looking at Q175018 off the Microsoft support web site.
I have downloaded the MDAC 2.1.1.4202.3 (GA) and installed
You'll need the appropriate Oracle client (free from your DBA), the
DBI::Oracle and DBD modules (assuming you already have Perl installed and
you don't have those modules installed). You'll need to create an entry in
your workstation's TNSNAMES file. Best to have your Oracl
If you are using the perl-DBI module, you'll need the client portion of
Oracle on your machine. (Unless you want to use DBI-proxy to connect, you'll
need to install the dbi-proxy module on the oracle server (or any other
machine that has the oracle client sof
You don't need Oracle installed on your machine, just the ODBC driver,
install the MDAC version 2.6 and it will be installed. Or you can visit
Oracle on-line for the latest ODBC/ADO drivers.
Mark
-Original Message-
From: Mauricio Lairet P. <[EMAIL PROTECTED]>
To: [EMAI
Hi folks!
I wanted to ask something to you.
Someone asked me to read an Oracle database but I need the software
installed on my computer in order to test the database and Perl, am I right?
I dont have Oracle installed in my PC, just the odbc dirver.
can someones please tell me what do I need
> Behalf Of O'Malley, Bryan T.
>
>
> I really need some feedback on whether anyone has success with DBD-Oracle
> 1.06 and DBI 1.14 used in conjunction with PERL build 618 on Windows 2000
> server USING ORACLE 8i (version 8.1.6) client software (sqlnet).
>
> If th
60 matches
Mail list logo
