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
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 Oraperl
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
query
into an array without fetching the row values from
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 for
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 = q{select application from busndate where
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.
Actually
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
But I not getting what it is taking
-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 what I think
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?
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 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 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
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
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 usage by Oraperl (plus
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 great tool
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.
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 successfully
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 oraperl-emulation of DBD::Oracle 1.14
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
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 server to Solaris 9 and am wondering
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 should use DBI and
DBD::Oracle directly.
http://search.cpan.org/dist/DBI/
http://search.cpan.org/dist/DBD-Oracle/
Writing to Tim
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');
I knew
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 alternatives?
I would like to know
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 possible send me in the right direction
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 thereto may
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
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
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 5.005_03 installed, Oraperl
v 1.39, DBD::ORACLE v 1.03
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
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.
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 much bigger
.
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 script already has a 'use Oraperl;' line which is all
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
- 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 Jul 2001 16:08:58 +0200
Organization: Telrad
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
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 commands.
PPM search DBD
Packages available from
a 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 09, 2001 18:01
Subject: Re: (Fwd) Oraperl Binary
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 for Windows
[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 interface. Use DBI and DBD::Oracle. You can
download
and install from activestate. You
) 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..
-- Forwarded by Mahesh L Velapakam on 05/09/2001 01:08
PM
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
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 environments display
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 understand what
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:
1
46 matches
Mail list logo
