Re: Embedding perl in Oracle

2001-12-07 Thread Jared Still
Geez Andy, where *do* you get the energy. :) Jared On Wednesday 05 December 2001 02:22, Andy Duncan wrote: > Hi Tim, > > > > I've done it, it works. Be aware that setting it up is not trivial, > > > as the documentation is somewhat incomplete. > > > That is being remedied however... > > > htt

RE: connection frustrations

2001-12-07 Thread Laurie Gennari
My server CD is stuck in a machine that's not talking at the moment, but I seem to recall a screen with install options for a full install, minimum install, custom install, and client only install. So, at least one version has the client on the server CDs. (I've been installing so many versions

RE: connection frustrations

2001-12-07 Thread Brian LaMere
is the client on the server install CD? There is a "client" CD in the box set, but it only lists windows platforms... -Original Message- From: Steve Sapovits [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 11:08 AM To: Scott T. Hildreth; Brian LaMere Cc: [EMAIL PROTECTED] Subj

RE: Unsubscribing?

2001-12-07 Thread Laurie Gennari
Options in regular, though properties would be a better name for the window. >The easiest way with outlook express (and >outlook???) is to right click the >message and select properties. --

Re: Unsubscribing?

2001-12-07 Thread Richard Taylor
Yes, The easiest way with outlook express (and outlook???) is to right click the message and select properties. Richard - Original Message - From: "Jeff Seger" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> To: "Laurie Gennari" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, Decembe

RE: DBD::Oracle -- bind variables treat string of spaces as NULL

2001-12-07 Thread Fannin, David P.
This was exactly what I needed. For those of you who might be inclined to use ORA_CHAR instead of SQL_CHAR, that won't work. DBD::Oracle complains and treats the data as SQL_VARCHAR -- at least that was the case for my application. Thanks to everyone for the excellent feedback and assistance.

RE: connection frustrations

2001-12-07 Thread Laurie Gennari
Sounds like you're installing the wrong thing. You don't need to install the Oracle server everywhere (1GB), just the client. I don't have the numbers at hand, but it's a fraction of the server size. --

Re: DBD::Oracle -- bind variables treat string of spaces as NULL

2001-12-07 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Dec 07, 2001 at 12:52:35PM -0600, Fannin, David P. wrote: > I've got an application where I need to use bind variables to populate many > tables of a reporting server nightly. I'm using DBD::Oracle to access the > target server. If I use $st

RE: connection frustrations

2001-12-07 Thread Steve Sapovits
Also, the Oracle install required is just the Oracle client That should be well under a gig and should install fast. I've used it on both Windows and UNIX servers, connecting to actual DBs that reside on our UNIX servers. I find the client useful to have in my Perl environment to run SQL*Plus

Re: Oracle: can I get Session ID?

2001-12-07 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Dec 07, 2001 at 01:33:23PM -0500, Kevin White wrote: > Is there any way to get the Oracle session ID out of a $dbh, so I can > log it and map it back? SELECT SYS_CONTEXT('USERENV','SESSIONID') FROM DUAL; This returns the current session's a

RE: :Oracle -- bind variables treat string of spaces as NULL

2001-12-07 Thread George Xu
Try to change your table definition of the column from varchar2 to char, then you will be allowed to put empty space into oracle. -Original Message- From: Fannin, David P. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 1:53 PM To: '[EMAIL PROTECTED]' Subject: DBD::Oracle -- bin

RE: connection frustrations

2001-12-07 Thread Scott T. Hildreth
Use Proxy, perldoc DBD::Proxy On 07-Dec-01 Brian LaMere wrote: > My situation is simple (to describe). I have Oracle 8.1.7 installed on a > solaris 2.8 environment. I have a multitude of linux systems that need to > connect to said server, via perl. Oracle, as is its purpose, will be > hous

Re: Oracle: can I get Session ID?

2001-12-07 Thread Csaba Tanczos
Kevin, It sounds strange, V$SESSION->PROCESS always returns the right process ID, even if it is of a forked child's. However, with subsequent calls, if you display your db handle that you acquire in a script, you may get the same ones all the time depending on which Apache children served your r

DBD::Oracle -- bind variables treat string of spaces as NULL

2001-12-07 Thread Fannin, David P.
I've got an application where I need to use bind variables to populate many tables of a reporting server nightly. I'm using DBD::Oracle to access the target server. If I use $sth->bind_param ($num, ' ') Oracle treats the string of spaces as a NULL in my insert statement. Since NULLS aren't all

connection frustrations

2001-12-07 Thread Brian LaMere
My situation is simple (to describe). I have Oracle 8.1.7 installed on a solaris 2.8 environment. I have a multitude of linux systems that need to connect to said server, via perl. Oracle, as is its purpose, will be housing a database...duh. The various linux systems need to be able to access

Oracle: can I get Session ID?

2001-12-07 Thread Kevin White
Hello there! I've used DBI on many platforms and many databases over the years: Informix, Sybase, Postgres, and now, for the first time, Oracle. My Oracle platform is a brand new 9i box running Red Hat Linux 7.1. But it isn't the problem. The client is also Red Hat Linux, on another machine,

Re: Unsubscribing?

2001-12-07 Thread Jeff Seger
I think, though I have only used LookOut Express, and that only infrequently,that you can right click on a message on the list and choose properties. Totally intuitive. No, really, totally. Laurie Gennari wrote: > >Surely Outlook has a way of letting you view message headers? > > Open the me

RE: Unsubscribing?

2001-12-07 Thread Brett W. McCoy
On Fri, 7 Dec 2001, Michael Wray wrote: > In Calypso, Pegasus, and Pronto (The latter a UN*X client) you only > see the info if View FULL Headers is on...which even though I view > full headers frequently, I have turned off most of the time due to the > fact that Headers are usually longer than t

RE: Unsubscribing?

2001-12-07 Thread Michael Wray
In Calypso, Pegasus, and Pronto (The latter a UN*X client) you only see the info if View FULL Headers is on...which even though I view full headers frequently, I have turned off most of the time due to the fact that Headers are usually longer than the message, and I don't want to have to page t

RE: Unsubscribing?

2001-12-07 Thread Brett W. McCoy
On Sat, 8 Dec 2001, Laurie Gennari wrote: > >Surely Outlook has a way of letting you view message headers? > > Open the message (not just preview pane). Choose View...Options. No, that's not, I'd >like to opt to see headers. That's here are a bunch of things you can change and we >stuck the "I

Re: sybase access

2001-12-07 Thread Michael Peppler
Werner Lamping writes: > hello , > I like to get access to a sybase database using perl . > Therefore I installed freeTDS which went OK (I believe) > But the installation of DBD-sybase is failing . > Does somone know or has an idia what went wrong . > Like I mention before , I just want to a

RE: Unsubscribing?

2001-12-07 Thread Laurie Gennari
>Surely Outlook has a way of letting you view message headers? Open the message (not just preview pane). Choose View...Options. No, that's not, I'd like to opt to see headers. That's here are a bunch of things you can change and we stuck the "Internet headers" on this page 'cuz we didn't know w

Re: Nexted Selects in DBI for Oracle

2001-12-07 Thread Tim Bunce
The DBI and DBD::Oracle have no knowledge about what's in the statement. It's just a string that's sent to the server and the server returns a bunch of rows. Tim. On Thu, Dec 06, 2001 at 03:30:46PM -0600, Jones Robert Contr TTMS Keesler wrote: > > > When I do the following in SQL+ I get the co

RE: Has anyone COMPILED in the 9i libraries with DBD ???

2001-12-07 Thread Scott T. Hildreth
Only on Linux, we don't have 9i for Solaris yet. Although the Linux doesn't mean diddly squat to your situation, I indeed have compiled DBD::Oracle with the 9i libraries. On 07-Dec-01 Keith Kwiatek wrote: > Hello, > > Let me ask this a differnt way has anyone compiled in the 9i libraries >

RE: Unsubscribing?

2001-12-07 Thread LBaxter
So you can... Hmm... I'm pretty "computer literate", and I had no clue. If we don't want to keep having to answer these questions, I suggest appending this information to the bottom of the message. 'nough said. Lincoln -Original Message- From: Moulder, Glen [mailto:[EMAIL PROTECTED]]

Has anyone COMPILED in the 9i libraries with DBD ???

2001-12-07 Thread Keith Kwiatek
Hello, Let me ask this a differnt way has anyone compiled in the 9i libraries with DBD ? I an NOT talking about using an existing DBI/DBD setup using 8.x.x oracle libraries to connect to an oracle 9i database. Keith

RE: Unsubscribing?

2001-12-07 Thread Moulder, Glen
Hi Lincoln, You can see the mail headers by opening the message, clicking View, then Options. The headers are at the bottom of the screen. Glen > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 07, 2001 8:27 AM > To: [EMAIL PROTECTED

RE: Unsubscribing?

2001-12-07 Thread LBaxter
Well, We use MS outlook98 and MS Exchange server here, and I can find no way of showing the mail headers. Nada. So I guess it is not a "decent mailer". What a surprize. Given the (regretable) almost universal business adoption of MS products for office automation, it is probably a mistake to

Re: Does dbi/dbd work with oracle 9i ???

2001-12-07 Thread Keith Kwiatek
You have just 9i on solaris?.. or 9i AND solaris AND DBD ? - Original Message - From: "Tony Mogg" <[EMAIL PROTECTED]> To: "'Keith Kwiatek'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 3:48 AM Subject: RE: Does dbi/dbd work with oracle 9i ??? > Yes, I

what parts of 9i do you need to install for it to work with DBD ???

2001-12-07 Thread Keith Kwiatek
Hello, What exact part of 9i do you need to install for DBD to work? I tried the "client install" from the 9i disks (procC and net8), but it didn't seem to work. Thanks Keith

Re: Does dbi/dbd work with oracle 9i ???

2001-12-07 Thread Keith Kwiatek
I tried to install the "client" portion of 9i to provide the needed DBD oracle libraries, but it came back saying it couldning find a bunch of oracle ".mk" files. So I am installing a larger subset of the oracle database, but that takes a lot of time Keith - Original Message - From

sybase access

2001-12-07 Thread Werner Lamping
hello , I like to get access to a sybase database using perl . Therefore I installed freeTDS which went OK (I believe) But the installation of DBD-sybase is failing . Does somone know or has an idia what went wrong . Like I mention before , I just want to access and read data . If there is a more

Re: Unsubscribing?

2001-12-07 Thread Rohan Hart
Brett W. McCoy writes: > On Thu, 6 Dec 2001, Rhino wrote: > > > Can anyone remind me how to unsubscribe from the [EMAIL PROTECTED] list? > > They are in the header of every message: However my emails to dbi-users-unsubscribe (now that I've found news://nntp.perl.org/perl.dbi.users) and dbi

RE: Does dbi/dbd work with oracle 9i ???

2001-12-07 Thread Tony Mogg
Yes, I have it working. Installed without any problems. However, I cannot get a connection as sysdba. If anyone can advise on this I'd be very grateful. Tony -Original Message- From: Keith Kwiatek [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 10:37 PM To: [EMAIL PROTECTED]