That surely is a fine manual.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 5:38 PM
To: Jeff Hunter; [EMAIL PROTECTED]
Subject: Re: Connecting as sysdba
On Tue, 24 Sep 2002 11:21:37 -0400 Jeff Hunter
<[EMAIL PROTECTED]>
I use perl to automate various Database Administration tasks for several
Oracle databases. With Oracle 9.x, to perform certain administrative tasks,
you must connect as sysdba. From sqlplus, the syntax is:
sqlplus "/@dbname as sysdba"
Does anybody know of a way to simulate this type of connect
You probably need to recompile your DBD module with your new Oracle client.
Vinod Menon wrote:
>Hi,
>
>Our application was using DBI.pm version 10.25 against Oracle 7.3.
>Lately the oracle database has been upgraded to 8i (8.1.6.1) and after
>that our Perl code is not able to connect to Oracle d
How long does it take to connect via sqlplus?
[EMAIL PROTECTED] wrote:
>I tried solve it by myself, and I am out of my wits.
>Please point me where to look/what to read (RTMF is fine - just what page).
>
>Problem:
>I am running IIS on Win2000 (%.00.2192), + Servce pack 2
>ActiveState Perl 5.6.1
We are testing a new version of the Perl DBD linked with the new Oracle
9i client libraries. I have two Oracle.so files, one in
~/old_perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle.so
and one in
~/new_perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle.so.
I can swit
If you're on Oracle, you can do:
SELECT nvl(max(some_item),0)
FROM db
WHERE item = 'something'
That will give you 0 if there are no "something" and will give you the
value.
Paul Rensel wrote:
>Hi there,
>
>I want to use a "select max(some_item) from db where item = 'something"
>query.
>
>How c
For my particular beef, the -8 flag works when compiling the DBD module
as suggested below.
Original Message
Subject: RE: Whitespace being truncated with Oracle
Date: Fri, 1 Mar 2002 12:18:34 +0100
From: "Jan Matejka" <[EMAIL PROTECTED]>
To: "'Jeff
Definitely!
ops$jeffh@dev817> create table xyz (x varchar2(20));
Table created.
Elapsed: 00:00:00.07
ops$jeffh@dev817> insert into xyz (x ) values ('abc ');
1 row created.
Elapsed: 00:00:00.02
ops$jeffh@dev817> insert into xyz (x ) values ('def ');
1 row created.
Elapsed: 00:0
I agree, it should be fixed.
Peter J. Holzer wrote:
>I don't think the current behaviour[1] is correct. In perl, strings can
>have trailing spaces: "test" and "test " compare as not equal.
>In Oracle varchar2 can store strailing spaces: If I store 'test ' in a
>varchar2 column, I get back 'test
whitespace.
Jeff Hunter wrote:
> I failed to mention that this worked with Perl 5.5.2 and an earlier
> version of the DBI/DBD.
>
>
> Sterin, Ilya wrote:
>
>> No, this is not a bug. varchar automatically strips trailing spaces, so
>> it's an Oracle thing. I wou
| 6
3 |3 | 6 |3 | 6
4 |4 | 6 |4 | 6
5 |5 | 6 |5 | 6
6 |6 | 6 |6 | 6
7 |7 | 6 |7 | 6
8 |8 | 6 |8 | 6
9 |9
>
>
>---
>David P. Fannin
>Database Administrator [EMAIL PROTECTED]
>UM-Rolla Computing and Information Services FAX (573) 341-4216
>URL http://www.umr.edu/~dpf PHONE (573) 341-4841
>-
ypes. Char is probably what you want to use.
>
>Ilya
>
>-Original Message-
>From: Jeff Hunter
>To: [EMAIL PROTECTED]
>Sent: 2/28/02 9:40 AM
>Subject: Whitespace being truncated with Oracle
>
>
>I am using perl 5.6.1 on Solaris 2.8. My DBI version is DBI-1.2
I am using perl 5.6.1 on Solaris 2.8. My DBI version is DBI-1.21 and my
DBD version is DBD-Oracle-1.12. My Oracle version is 8.1.7.2 and my
Oracle OCI version is 8.1.7.0.0.
I have setup a query that retrieves VARCHAR2(10) values from a table
into a bound variable. The values in the table a
14 matches
Mail list logo