I wish I could give you a 100% tumbs up on this but...
It should work without problems as I have used Oracle Wallet many times before
and in theory the OCI client and not the perl code should take care of all that
for you.
So if you can connect with DBD::Oracle it should just work.
You mig
hoststring.10G =
(DESCRIPTION=
(LOAD_BALANCE=yes)
(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.123)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.124)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=)
)
)
Currently, using the DBI module I am able to connect to these servers (x.x.
Sri-
Oracle connects via the TNS entry as seen in
%ORACLE_HOME%/network/admin/tnsnames.ora
Here the TNS Name DB1 is associated to Service IDentifier of DB 1 SID=DB1
which in this case is listening on localhost Port 1521
DB1=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=tcp)
You should find that you wll have virtally no problems with that.You might need
to build perl afresh though.
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent: Tue 03/07/2007 17:33
To: dbi-users@perl.org
Subject: Re: Oracle DBI for HP
[EMAIL PROTECTED] wrote
[EMAIL PROTECTED] wrote:
Can you get hold of an HP ANSI C compiler?
p
Yes I can.
R
Can you get hold of an HP ANSI C compiler?
p
> -Original Message-
> From: Robert Hicks [mailto:[EMAIL PROTECTED]
> Sent: 03 July 2007 16:19
> To: dbi-users@perl.org
> Subject: Re: Oracle DBI for HP
>
>
> [EMAIL PROTECTED] wrote:
> >
> > The
[EMAIL PROTECTED] wrote:
The basic rule about building perl, DBD & Oracle DBI on HP-UX (let alone
Itanium) using gcc is don't. Life is far far too short for it since you
will hit problem after problem. It is possible using HP's native C
compiler (in fact it is straight forwards) but if you are u
hing the archives of this list.
Steve
-Original Message-
From: Gupta, Razat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 October 2005 8:55 PM
To: Steve Baldwin
Subject: RE: Oracle/DBI
Dear Steve,
Can you please give me a brief description of the steps you want me to
follow.
Like : if I m ru
DBD::Oracle binaries that has been built against the correct version of the
SQL*Net client.
HTH,
Steve
-Original Message-
From: Gupta, Razat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 October 2005 6:50 PM
To: sreenivas reddy
Cc: dbi-users@perl.org
Subject: RE: Oracle/DBI
Thanks for your
u have any idea!
Regards,
Razat
-Original Message-
From: sreenivas reddy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 18, 2005 2:23 AM
To: 'sreenivas reddy'; Gupta, Razat; dbi-users@perl.org
Subject: RE: Oracle/DBI
Put tnsnames.ora file and try
Regards
gsreddy
-Original
Put tnsnames.ora file and try
Regards
gsreddy
-Original Message-
From: sreenivas reddy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 18, 2005 12:50 PM
To: 'Gupta, Razat'; dbi-users@perl.org
Subject: RE: Oracle/DBI
Try to install DBD-Oracle module
Oracle database driver f
Try to install DBD-Oracle module
Oracle database driver for the DBI module
Ppm>install DBD-Oracle
Regards
gsreddy
-Original Message-
From: Gupta, Razat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 18, 2005 12:37 PM
To: dbi-users@perl.org
Subject: Oracle/DBI
Hi Everyone,
I am tr
ot exposed to OCI."
>
> That is from Oracle. Hope that helps.
>
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 11, 2003 1:49 AM
> To: Kevin Moore
> Cc: [EMAIL PROTECTED]
> Subject: Re: Oracle dbi ?
>
>
> The p
On Tue, 11 Nov 2003 07:44:16 -0800 Kevin Moore <[EMAIL PROTECTED]>
wrote:
> Since I've got no experience with OCI and not much play time right
> now I'm going to ask this question. Can you execute a command line
> shell script using OCI? If so there is no reason you cannot invoke
> sqlplus and sta
Jared,
Since I've got no experience with OCI and not much play time right now
I'm going to ask this question. Can you execute a command line shell
script using OCI? If so there is no reason you cannot invoke sqlplus and
startup or shutdown an Oracle database.
Kevin
Jared Still wrote:
The pro
;
That is from Oracle. Hope that helps.
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 1:49 AM
To: Kevin Moore
Cc: [EMAIL PROTECTED]
Subject: Re: Oracle dbi ?
The problem is, these aren't actually SQL commands.
Rather, these are SQ
The problem is, these aren't actually SQL commands.
Rather, these are SQL*Plus commands. The DBD::Oracle
doesn't know what to do with these.
If you could figure out how to do this with OCI, then
you could probably patch DBD::Oracle to provide this
functionality.
Tim would appreciate that patc
What user are you conneted as when you try to shut down the database?
I've used shutdown, shutdown imediate, and in worst cases shutdown abort
to stop an Oracle database. This has been the method (sql> ) from 8i
forward.
Kevin
[EMAIL PROTECTED] wrote:
Since shutdown is not a sql command, has
Maybe you can't rollback a SELECT statement, but it can be part
of a transaction.
Using Oracle as an example:
Session 1:
create table x ( x number );
insert into x values(1);
commit;
Session 2:
commit;
set transaction read only;
select * from x;
X
--
1
1 rows sele
On Thu, Feb 07, 2002 at 04:41:31PM -0500, Ronald J Kimball wrote:
> Selects, updates, and deletes are part of a transaction; they can be
> commited and rolled back. Creates and alters are not; they happen
> immediately and cannot be rolled back.
Selects? Oops. :D I didn't think that explanati
hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 13:53
Subject: RE: Re: Oracle DBI commit/rollback ques
Thanks. (I'm used to using Sybase... I din't know that)
What about inserts? Aren't they also part of a transaction?
-Dave-
-Original Message-
From: dpf
Sent: Thursday, February 07, 2002 4:48 PM
To: Wren, David
Cc: dpf; dbi-users
Subject: RE: Re: Oracle DBI commit/ro
PHONE (573) 341-4841
---
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 3:31 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Re: Oracle DBI commit/rollback question...
Mac,
Ok, I've go
On Thu, Feb 07, 2002 at 04:31:08PM -0500, [EMAIL PROTECTED] wrote:
> I probably shouldn't say "ROLLING BACK TRANSACTION" because the
> "Rollback Status = 1".
> But I expect because AutoCommit = "" (I set it OFF) that the table I
> created in the first SQL
> statement would not exist. But it d
d not exist. But it does!!
So I don't know why it won't rollback. Can you offer any more
suggestions? Is it perhaps
a setting in Oracle which overrides DBI rollback()?
-Dave-
-Original Message-
From: mchase
Sent: Wednesday, February 06, 2002 5:58 PM
To: Wren,
eats fish for an age.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 14:41
Subject: RE: Re: Oracle DBI commit/rollback question...
> Thanks Mac, but what I'm doing is looping different DML statements
> thro
Until your execute() or do() the statement hasn't occurred yet, so there's
nothing to commit or rollback.
Each time you commit or rollback, a new transaction starts.
Transactions are session specific, so the transactions in two open database
handles in the same program are independent of each ot
In httpd.conf
Reg's
Oleg
> -Original Message-
> From: eddie iannuccelli [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 06, 2001 4:28 PM
> To: Oleg Mechtcheriakov
> Cc: [EMAIL PROTECTED]
> Subject: Re: Oracle DBI connection working in command line but not
Yes but in which file (httpd.conf or .cshrc or else ?)
thanks
Oleg Mechtcheriakov wrote:
> Try to add to apache config something like that:
>
> SetEnv ORACLE_HOME /path/to/your/oracle/home
>
> That way You surely have the environment variable set for Your CGI script.
> It helped in my case.
>
THAT' S IT
thank you very much :
Do you think the dbish pb is linked to that ?
Best regards
> ---
>
>>I don't understand what happen since the script work fine under apache
>>user session, nobody user session and root user session (http
Try to add to apache config something like that:
SetEnv ORACLE_HOME /path/to/your/oracle/home
That way You surely have the environment variable set for Your CGI script.
It helped in my case.
Reg's
Oleg
> -Original Message-
> From: eddie iannuccelli [mailto:[EMAIL PROTECTED]]
> Sent: Th
Try DBD::Oracle 1.09.
Tim.
On Thu, Aug 30, 2001 at 11:29:55AM +1000, Penaluna, John wrote:
> I'm attempting to install the Oracle DBI module on a 64 bit HPUX 11.00
> machine however it all falls over when I do the 'make'. It fails due to not
> finding library "nbeq". I've installed Oracle 8.1.
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 c
It needs at least the Oracle SQL*Net software to connect to remote hosts.
To build, it also needs either Oracle's Pro*C or OCI.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll ea
Figured it out ... It has to do with the registry ...
It wants ORACLE_HOME defined in HKLM\SOFTWARE\ORACLE, which it currently was
not on one machine but was on another.
For those offering other suggestions, thank you for your time.
-Original Message-
On Wed, 23 May 2001, Jones Ro
Check the TNSNAMES.ORA file on each machine.
They shoud only differ on the IP address
>From: Jones Robert Contr 81 CS/SCK <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Oracle DBI on Windows NT
>Date: Wed, 23 May 2001 16:04:05 -0500
>
>
>
> We have Oracle version 8 loaded on Windows
No we don't ... Both have account on their systems with the same accounts
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 4:58 PM
To: Jones Robert Contr 81 CS/SCK
Cc: [EMAIL PROTECTED]
Subject: Re: Oracle DBI on Windows NT
Hi,
you need an account for the other system/user.
Darrell
On Wed, 23 May 2001, Jones Robert Contr 81 CS/SCK wrote:
>
>
> We have Oracle version 8 loaded on Windows NT boxes. We also have
> ActiveState Perl build 522 installed with DBI 1.14 and DBD-Oracle 1.03.
>
> The problem
On Mon, Apr 16, 2001 at 07:44:57PM -0400, Sterin, Ilya wrote:
> I am afraid that's wrong, the arrow -> is resolved in the string context
> since it's the same as dereferencing the object in the string context. The
> problem is that the user which is executing the script does not have the
> enviro
Working! Much thanks to ALL who came to
rescue. Here's fix ( important since
I've seen complaints of same problem all
over the net:
- Ilya for ( among other things recommending
the modification & new placement of trace
allowing me to see & debug ) and Paul
(placing elusive line in Apache c
---
From: M.W. Koskamp [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:56 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Oracle-DBI-Win2k-Apache- MUST AUthenticate
>
> ***
> full script...
> **
> #!d:/perl/bin/perl.exe -w
> print "Content
:18 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Oracle-DBI-Win2k-Apache- Progress!
Progress. Changing nature of trace call was a big help. Thanks
Enclosed is trace output from web, versus from command line ( repetition cut
out).
How do I fix
>
> ***
> full script...
> **
> #!d:/perl/bin/perl.exe -w
> print "Content-type: text/html\r\n\r\n";
> use CGI;
> use DBI;
> use DBD::Oracle;
>
> print " test1 ";
> print " test2 ";
>
> %attr = (
> PrintError => 0,
> RaiseError => 1
> );
>
> print " test3 ";
> $dbh = DBI->connect
(DBI::st=HASH(0x1ec2104)~0x1b670ec)
dbd_st_fetch 1 fields, rpc 217 (cache: 11/206/309)
dbd_st_fetch 1 fields, rpc 217 (cache: 62/155/309)
<- fetchrow= ( '100219' ) [1 items] at oracle-perl5.pl line 45.
-> fetchrow for DBD::Oracle::st (DBI::st=HASH(0x1ec2104)~0x1b670ec)
***
so use
DBI->trace(2, "error.log") before connect to trace the full execution.
Ilya Sterin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 11:55 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Oracle
TIA!
Has anybody authenticated via web/Apache/DBI with Oracle?
Thanks for tips to unclutter script & change error out call.
I've also remove "my" from connect sequence ( my idea to further simplify).
I've enclosed entire brief script to make clear my point.
Problem restated: script fails at "t
AIL PROTECTED]
Subject: Re: Oracle-DBI-Win2k-Apache-want raw sql select output to
browser
Still need to connect to Oracle via web to get raw sql select
output into browser. All ideas welcome !
Thanks Sapovits. I changed to c:\\ (for correctness sake) but
this fixes nothing & it doesn&#x
First change to
print "Content-type: text/html\n\n";
then make sure your permissions for the script are right, since win2000 does
have permissions under NTFS file system.
Then you can use trace() at level 2 to see what is going on in your script.
Send the trace output to the list.
Also use CGI:
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 7:52 AM
Subject: Oracle-DBI-Win2k-Apache
> Have a test which executes & fine on command line but
> same script stops @ connect line when run as cgi
> via browser.
Still need to connect to Oracle via web to get raw sql select
output into browser. All ideas welcome !
Thanks Sapovits. I changed to c:\\ (for correctness sake) but
this fixes nothing & it doesn't seem to address the problem
(but is appreciated). I continue to get correct output ( with c:\
For one thing, your ORACLE_HOME path isn't what you think.
'\' is the escape character. To use it in a string as a
literal, you need to use two:
$ENV{ORACLE_HOME}="c:\\orant";
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 16, 2001
> "Michael" == Michael Officer <[EMAIL PROTECTED]> writes:
Michael> Thanks for the reply. Discovered that the problem isn't with
Michael> placeholders, seems to be a problem related to datatypes. I
Michael> mistyped my original example and misled you! It actually
Michael> works! Here's the
On Mon, Feb 05, 2001 at 08:48:24AM -0500, Seger, Jeffrey wrote:
> I believe you may have to escape that '*' (\*) or use single quotes.
* has no special meaning inside double quotes, so escaping it with a
backslash is not necessary.
Ronald
I believe you may have to escape that '*' (\*) or use single quotes.
If that doesn't work, try selecting specific column names.
-Original Message-
From: Michael Officer [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 8:30 PM
To: [EMAIL PROTECTED]
Subject: Oracle & DBI
I've
Foiani
> Sent: Friday, February 02, 2001 6:23 PM
> To: Michael Officer
> Cc: [EMAIL PROTECTED]
> Subject: Re: Oracle & DBI
>
>
> >>>>> "Mike" == Michael Officer <[EMAIL PROTECTED]> writes:
>
> Mike> I've tried everything I can think o
55 matches
Mail list logo
