On Tue, Aug 5, 2008 at 3:19 PM, Martin Evans <[EMAIL PROTECTED]>wrote:
> Amit Saxena wrote:
>
>> Hi all,
>>
>> What's the DBI equivalent of Oraperl ora_titles function ?
>>
>> I need it because I want to get the titles (column names) of a select
>
Amit Saxena wrote:
Hi all,
What's the DBI equivalent of Oraperl ora_titles function ?
I need it because I want to get the titles (column names) of a select query
into an array without fetching the row values from the database.
Thanks & Regards,
Amit Saxena
I have not used Oraper
Hi all,
What's the DBI equivalent of Oraperl ora_titles function ?
I need it because I want to get the titles (column names) of a select query
into an array without fetching the row values from the database.
Thanks & Regards,
Amit Saxena
On Mon, Jan 08, 2007 at 09:46:09PM +, Nathan Morrow wrote:
> Below are the test runs of the following script:
>
> Test the new proposed version
>-> ora_fetch
><- () [0 items]
> $ora_errno is DEFINED
> $ora_errno = 0
>!! warn: 0 CLEARED by call to finish method
>-> finish
Below are the test runs of the following script:
BEGIN SCRIPT test_fetch.pl
#!/usr/local/perl5.8.4/bin/perl -w
use Oraperl;
ora_version;
my $lda = ora_login('','','')
or die "Connect failed: $ora_errno, $ora_errstr"
;
$lda->debug(4);
my $select_stmt
2007 at 11:37:22PM +, Nathan Morrow wrote:
> I am having some issues with my company's upgrade of our Solaris 8
> applications from Perl 5.00502/Oracle 8i to Perl 5.8.4/Oracle 10g
>
> We have the following versions of Oraperl:
>
> Under perl 5.00502:
> Oraperl Emulation
I am having some issues with my company's upgrade of our Solaris 8
applications from Perl 5.00502/Oracle 8i to Perl 5.8.4/Oracle 10g
We have the following versions of Oraperl:
Under perl 5.00502:
Oraperl Emulation Interface version 1.37
Oracle Driver 0.59
DBI-1.02 Switch by Tim Bunce, ve
You should read the Oracle SQL*Plus docs for the meaning of "/" as a
username.
-Original Message-
From: Gupta, Razat [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 06, 2005 11:35 PM
To: dbi-users@perl.org
Subject: Oraperl
Hi EveryOne,
I have a query related to Oraperl.
Hi EveryOne,
I have a query related to Oraperl.
Actually , I have a script which is creating a connection to an Oracle
database.
The connection code is :
&ora_login('','/','');
What I know is that for system_id , it is taking the value of
ORACLE_SID
B
>-Original Message-
>From: Sid Katz [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, August 02, 2005 12:14 PM
>I am converting oraperl statments to the new Perl-DBI format and do
>not entirely understand the Perl-DBI syntax. I have included code
>with the oraperl method and w
Hi,
I am converting oraperl statments to the new Perl-DBI format and do not
entirely understand the Perl-DBI syntax. I have included code with the
oraperl method and what I think is the correct Perl-DBI method. My 2
questions are:
# is $INSERT correct as written or should it be ...values
is there an web based guide detailing how to port oraperl to the perl-dbi
format?
On 06/16/2005 02:55 AM, Ashish Jain said:
I am using Oraperl pack for my development. I get the following error at
the line where I use Oraperl ( use Oraperl).
You should not be using Oraperl for new development. It is a wrapper
around DBI and DBD::Oracle intended to allow existing programs
Hi,
I am using Oraperl pack for my development. I get the following error
at the line where I use Oraperl ( use Oraperl).
Unknown error
Compilation failed in require at
/home/ebso/EM10103_agent/sysman/admin/scripts/semd_common.pl line 34.
BEGIN failed--compilation aborted at
/home/ebso
On Mon, Oct 18, 2004 at 02:20:14PM +0530, rajarathnam, devaraj wrote:
> Hi
> I am using Oraperl emulation for DBD:Oracle for a perl program in HP-UX11i.
>
> I would like to know the amount of CPU usage by Oraperl since we are having
> CPU usage constraints.
The CPU u
Hi
I am using Oraperl emulation for DBD:Oracle for a perl program in HP-UX11i.
I would like to know the amount of CPU usage by Oraperl since we are having
CPU usage constraints.
I would also like to know whether waiting for input will put the state of the
process to
Hi
I am using Oraperl emulation for DBD:Oracle for a perl program in HP-UX11i.
I would like to know the amount of CPU usage by Oraperl since we are having
CPU usage constraints.
I would also like to know whether waiting for input will put the state of the
process to
On Mon, May 10, 2004 at 10:11:29AM -0500, Gram M. Ludlow wrote:
> Good morning!
> I have been in charge of installing Oraperl on a bunch of our HPUX systems.
Oh joy :)
> I resolved the issue. I thought you might want to add it to your
> README.HPUX at some point.
Thanks.
Tim.
Good morning!
I have been in charge of installing Oraperl on a bunch of our HPUX systems.
I've gone from 10.20 all the way to 11i. I found your cpan.org site, which
has almost all of the information that I already gleaned from sources
abroad. Thanks for maintaining all this, it's a gre
Thanks.
Tim.
On Wed, Sep 03, 2003 at 04:52:08PM +0200, Martin Busik wrote:
> Hi folks,
>
> the $ora_errno and $ora_errstr variables should contain the error code
> and the error string of the last function call to a oracle-OCI function.
>
> Unfortunately, in the oraper
Hi folks,
the $ora_errno and $ora_errstr variables should contain the error code
and the error string of the last function call to a oracle-OCI function.
Unfortunately, in the oraperl-emulation of DBD::Oracle 1.14 the above
mentioned variables contain the "last" error, regardles of su
On Tue, 15 Jul 2003 10:26:48 -0400 Divyesh Thakker <[EMAIL PROTECTED]> wrote:
> I have a question for Oraperl that hopefully you can answer.
>
> We currently have Oraperl (perl4) running on Solaris 2.6 connecting to a
> Oracle 7.3.3 DB.
> We need to upgrade the serve
Hi
I have a question for Oraperl that hopefully you can answer.
We currently have Oraperl (perl4) running on Solaris 2.6 connecting to a
Oracle 7.3.3 DB.
We need to upgrade the server to Solaris 9 and am wondering if
1) We can get Oraperl to run on Solaris 9, connecting to the Oracle 7.3.3 ?
This
]>
> Cc: "Che, Thuy" <[EMAIL PROTECTED]>
> Date: Thu, 3 Jul 2003 09:28:43 -0400
> I could not find the place where I can download the Perl module named
> Oraperl. I need help in find the place to download it.
Oraperl is part of DBD::Oracle. Any new development shoul
CTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Cc: "Che, Thuy" <[EMAIL PROTECTED]>
Subject: Oraperl
Date: Thu, 3 Jul 2003 09:28:43 -0400
Hi,
I could not find the place where I can download the Perl module named
Oraperl. I need help in find the place t
I am trying to find out what version of Oraperl works for Oracle 8i?
Can you provide any assistance?
Thanks in advance,
Jonathan Blair
Cummins, Inc.
On Mon, 20 May 2002 09:14:33 +0200 "Boyle, Rod A." <[EMAIL PROTECTED]> wrote:
> How do I execute SQL*Plus commands while accessing the Oracle7 DB with the
> oraperl module? Specifically, I am trying to execute the SQL*Plus
> command,
> BREAK prior to executing the SQ
Hi All,
How do I execute SQL*Plus commands while accessing the Oracle7 DB with the
oraperl module? Specifically, I am trying to execute the SQL*Plus command,
BREAK prior to executing the SQL statement.
Any ideas, thoughts or help would prove very useful.
Thanks,
Rod A Boyle, CSC
HQ USEUCOM
Hi,
I am having problem and need your attention. How to write an SQL statement for the
below in Oraperl:
$csr = &ora_open($lda,"select datetime, comments, user_id
from table1
where message = 'NEW USER'&q
From: "Andhavarapu, Srinivas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 09:34
Subject: Need information about oraperl
> I am not sure if I am sending this email to the correct group. If not
> excuse me for my intrusion and if p
t we have. I have a
> few questions and here they are:
>
> Can anyone tell me if they had done something similar and what is their
> experience in doing this kind of conversion?
>
> Is this approach of moving from Sybperl to Oraperl is a good one or are
> there any other alte
I just managed to successfully do this myself not long ago. I'll send you
more info in a bit.
-Original Message-
From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: Stored Procedure with Oraperl
Hello,
Is
Hello,
Is there somebody who can tell me how I can execute
a Stored Procedure with Oraperl ?
I know that is possible to do that with DBI but
I have a constraint to keep Oraperl that I'm using now.
Thanks in advance,
José.
DISCLAIMER
"This e-mail and any attachment t
> -Original Message-
> From: Van Scoyoc, James [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 28, 2001 3:24 PM
> To: [EMAIL PROTECTED]
> Subject: Performance problems with DBI/DBD/Oraperl
>
>
> Has anyone encountered wildly different performance results
Has anyone encountered wildly different performance results between one
Dec-Unix machine and another? I've installed the modules named above on two
different machines, and found that for spooling data from a third remote
machine--in this case an RDB database--it takes longer on one of the two
Uni
y, October 18, 2001 16:50
Subject: Problem with Oraperl and DBD::ORACLE within CGI scripts
> My team upgraded Oracle from 8.0.6 to 8.1.7. It was discovered that the
> CGI scripts that use Oraperl to interact with our database would cause a
> core dump. At the time we had perl version
DBI users,
My team upgraded Oracle from 8.0.6 to 8.1.7. It was discovered that the
CGI scripts that use Oraperl to interact with our database would cause a
core dump. At the time we had perl version 5.005_03 installed, Oraperl
v 1.39, DBD::ORACLE v 1.03, and DBI 1.13. I attempted to link to
Hi,
We are migrated our Oracle7.0 to Oracle8.1.6, The perl programs were
written using oraperl.pm script to connect to database, and now
we are trying to install Oracle DBD:DBI modules, Is it going to be
smooth transition? any ideas?
Our old perl programs are going to work?
Pl . let me know.
Th
.
Give a hobbit a ring and he eats fish for an age.
- Original Message -
From: "Michael A. Chase" <[EMAIL PROTECTED]>
To: "Anshu Anshu" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 06:49
Subject: Re: Oraperl -> DBI
> The scrip
The script already has a 'use Oraperl;' line which is all that should be
needed to use the Oraperl emulation that comes as part of DBD::Oracle. The
Oraperl emulation is provided specifically to allow old scripts that use
oraperl calls to continue to work with minimal changes.
A much m
Hi All,
We are using a script which uses Oraperl. This script (attached) needs to
be install on another machine which is Solaris 8 on sparc. That machine got
Perl 5.005 and perl 5.6.1 version installed. And I learnt that Oraperl
supports only Perl 4 and I need to convert this script to DBI
One definite problem with Oraperl is that it is obsolete. DBD::Oracle
includes an Oraperl emulation layer so old programs can keep working, but
any new development should use DBI methods instead of Oraperl subroutines.
There should have been more to the message. IIRC, ORA-1 is a duplicate
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I'm looking for a resource (site,FAQ,etc.), where i could find some known
> problems/bugs with Oraperl.
Oraperl is effectively obsolete. Please use the DBI interface.
> I got some ORA-1 errors while executing a very
- Forwarded message from Avi Vainshtein <[EMAIL PROTECTED]> -
Reply-To: Avi Vainshtein <[EMAIL PROTECTED]>
From: Avi Vainshtein <[EMAIL PROTECTED]>
To: "Tim.Bunce" <[EMAIL PROTECTED]>
Subject: Looking for know problems/bugs in oraperl
Date: Mon, 16 Ju
D]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 6:01 PM
Subject: Re: (Fwd) Oraperl Binary for Windows
>
> Hello Rajanath,
>
> I am working with Mahesh on this project. We are interested in using the
> Oracle DBD for W
--Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Sterin, Ilya; [EMAIL PROTECTED]
Sent: 05/09/2001 7:01 PM
Subject: Re: (Fwd) Oraperl Binary for Windows
Hello Rajanath,
I am working with Mahesh on this project. We are interested in using the
Oracle DBD f
fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, May 0
PM
To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject: Re: (Fwd) Oraperl Binary for Windows
Try this/You can find all these drivers and dbd's in Activestate.com
C:\>ppm
PPM interactive shell (2.1.2) - type 'help' for available
rom: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 4:14 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: (Fwd) Oraperl Binary for Windows
Thanks a lot for that 3 * 10 ** 8 m/sec response :) , we dont see a binary
version for DBI and DBD
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 6:14 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: (Fwd) Oraperl Binary for Windows
>
>
> Thanks a lot for t
ECTED]>
Sent: Wednesday, May 09, 2001 1:13 PM
Subject: RE: (Fwd) Oraperl Binary for Windows
> Thanks a lot for that 3 * 10 ** 8 m/sec response :) , we dont see a
binary
> version for DBI and DBD ..are they available.? or should we have C
compiler
> and have to compile it..
> --
terin, Ilya" <[EMAIL PROTECTED]> on 05/09/2001 12:48:12 PM
To: "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
cc: "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
Subject: RE: (Fwd) Oraperl Binary for Windows
Oraperl is depricated int
Oraperl is depricated interface. Use DBI and DBD::Oracle. You can download
and install from activestate. You must have ActiveState Perl installed.
Then use the ppm utility to install. See docs for instructions.
Ilya Sterin
-Original Message-
From: Tim Bunce
To: [EMAIL PROTECTED]
Cc
- Forwarded message from [EMAIL PROTECTED] -
From: [EMAIL PROTECTED] ()
X-Server-Uuid: 1569d162-b3be-4edd-8d78-ab9187b54f11
Subject: Oraperl Binary for Windows
To: [EMAIL PROTECTED]
Date: Wed, 9 May 2001 11:50:43 -0700
X-MIMETrack: Serialize by Router on SV-GW1/Seagate Internet(Release
Hi ,
A simple query.
If Oracle is very much required for DBD installtion on a HPUX box, is it possible to
run old oraperl scripts to access
a remote oracle database (on a different machine) using DBD::Oracle and local Oracle
libraries ?
If yes , then what are the Oracle components are
hi,
I am struggling with a dirty little problem on a HPUX, using perl 5.003,
with oraperl.
I don't get the correct GERMAN characters reading the oracle-database. This
problem seems to stem from a systemupgrade on the HP (don't know which, HPUX
10.20, oracle 8 ?).
All other environmen
If you are writing new code, you'd be better off using the DBI method calls
instead of the Oraperl ones. Under Perl 5, Oraperl is just an emulation
layer over DBI and DBD::Oracle. The people here, including me, are more
likely to be able to help with DBI calls.
I'm not sure I understa
Dear Sir:
I have met some trouble for oraperl. I need your help.
I am using Cgi(oraperl) to access oracle database with
&ora_open($lda,$Sql). But when I input a wrong Sql command,
parameter ($ora_errno) doesn't come back and program is aborted.
For example
Just adapt the code below and see the performance improvement.
# The corresponding Oraperl is "eval 'use Oraperl; 1';"
use DBI;
# The corresponding Oraperl is ora_login( $dbh, $instance, $userid,
$password );
# By turning off AutoCommit (ora_autocommit(0);), you avoid the ov
To: <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 10:51 AM
Subject: Re: Oraperl, DBI,DBD , ARRAY PROCESSING and performance issue
> My program didn't use any bind variable, prepared statement.
> The BIND variable and prepared stmt definitely will speed up the program,
but withou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, Jan 25, 2001 at 09:27:40AM -0500, Ted X Wang wrote:
>
>
> Hi,Gurus:
>
> I'm looking for some help to spped up my perl application.
>
> It's a data loading program written in Oraperl, perl5.02.
>
>
Oraperl is a Perl 4 binary with the Oracle OCI calls compiled in. If you
are using 'Oraperl' with Perl 5, you are actually using the oraperl
emulation layer provided as part of DBD::Oracle. It is provided to allow
Perl 4 code to run without major changes, but it shouldn't
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Ted X Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 6:27 AM
Subject: Oraperl, DBI,DBD , ARRAY PROCESSING and performance issue
> I'm lo
implementing the DBD::Oracle changes.
>
> Anyhow, let me know if you would like a copy of the modified DBI and
> DBD::ODBC
> modules.
>
> Regards,
> Dean Arnold
>
> - Original Message -
> From: "Ted X Wang" <[EMAIL PROTECTED]>
> To: <[EMAIL
64 matches
Mail list logo
