[Rearranged quotes for better readability]
On 2004-10-19 08:23:53 -0600, Reidy, Ron wrote:
BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED]:
Ok, then if you use Apache and mod_perl this should be easy... just open
connection if you don't have it (or you get and error on it), and keep it
around.
Hi,
I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File.
After the stored procedure executes, it returns an out parameter called
out_v_RECV_FILE_NM.
I have a perl script which uses the DBI:: Module.
My Question is:
Is the correct way retrieve the value of my out
Robert wrote:
My select looks like this:
SELECT surname, first_name, msf810.email_address, msf810.employee_id
FROM msf810, msf020, MSF829
WHERE msf810.employee_id = msf020.employee_id
AND msf810.employee_id = msf829.employee_id
AND msf020.dstrct_code =
On Thursday 21 Oct 2004 00:39 am, you said:
While trying to install DBD1.15 with the Oracle 9i client in a Linux
machine, we are facing some issues.
Unable to locate an oracle.mk, proc.mk or other suitable *.mk
file in your Oracle installation. (I looked in
...
We contacted
So what did the problem turn out to be?
Robert [EMAIL PROTECTED] 10/20/04 11:23PM
Robert wrote:
My select looks like this:
SELECT surname, first_name, msf810.email_address,
msf810.employee_id
FROM msf810, msf020, MSF829
WHERE msf810.employee_id = msf020.employee_id
Tim Bunce wrote:
On Wed, Oct 20, 2004 at 02:53:43PM +0200, Silvio Wanka wrote:
PS. When DBD::Oracle 1.16 will be released?
When I find the time to slay the demons of too many permutations
of client and server versions and character sets and Oracle, er,
features.
I've not had the time (or the
There are examples in the DBD::Oracle docs.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Denesa K Shaw [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 2:28 PM
To: [EMAIL PROTECTED]
Subject: Stored Procedures Parameters
Hi,
I'm
My comments are below ...
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Peter J. Holzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 9:10 AM
To: [EMAIL PROTECTED]
Subject: Re: Slow connection to Oracle 9i
[Rearranged quotes for
Hardy Merrill [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
So what did the problem turn out to be?
Robert [EMAIL PROTECTED] 10/20/04 11:23PM
Robert wrote:
My select looks like this:
SELECT surname, first_name, msf810.email_address,
msf810.employee_id
perldoc DBD::Oracle will show you how to do this.
On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote:
Hi,
I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File.
After the stored procedure executes, it returns an out parameter called
out_v_RECV_FILE_NM.
I have a perl
Sorry, I am assuming you are using Oracle, are you?
Look for bind_paraminout().
On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote:
perldoc DBD::Oracle will show you how to do this.
On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote:
Hi,
I'm calling a stored procedure called
...bind_param_inout(), typo.
On Thu, 2004-10-21 at 08:36, Scott T. Hildreth wrote:
Sorry, I am assuming you are using Oracle, are you?
Look for bind_paraminout().
On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote:
perldoc DBD::Oracle will show you how to do this.
On Wed,
Ok now I'm getting results from my search! Thanks!
Denesa Shaw
713-207-5928
[EMAIL PROTECTED]
Scott T.
Yes,
I'm using Oracle. This is a good start. I will do some research.
Thanks!
Denesa Shaw
713-207-5928
[EMAIL PROTECTED]
Scott T.
Great I will look into it.
Thanks!
Denesa Shaw
713-207-5928
[EMAIL PROTECTED]
Reidy, Ron
On Thu, Oct 21, 2004 at 02:44:35PM +0200, Silvio Wanka wrote:
Do you think that the successfully tested post 1.16-rc7 version is usable
in the meantime in a production environment or should I wait for the
released 1.16.
If this works for you then yes:
I wonder ... how about adding a method bind_params() like this:
sub bind_params {
my $sth = shift;
my $pos = (ref($_[0]) ? 1 : shift);
for my $param (@{$_[0]}) {
$sth-bind_param($pos++, $param);
}
}
So that this could be shortened to
On 2004-10-21 08:51:04 -0600, Reidy, Ron wrote:
My comments are below ...
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Peter J. Holzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 9:10 AM
To: [EMAIL PROTECTED]
Subject:
The statement was Call commit (even if you have done only selects)
This was what I was referring to.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Peter J. Holzer [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 10:20 AM
To: [EMAIL
It's time to end this thread now - or take it to an Oracle
specific mailing list like oracle-l.
Thanks.
Tim.
Thank you to all.
Your responsiveness was amazing and the responses very helpful.
If anyone has any other comments or ideas, please email them to me directly.
If I come across any new developments or solutions, I will forward
them to Tim, unless he prefers otherwise.
I may post to the Oracle-L
We make extensive use of named bind params in our apps (our DB is Oracle).
I just tried running a test program over DBD::Proxy and found it barfs on
these. Here is the code in DBD::Proxy that doesn't like them .
sub bind_param ($$$@) {
my $sth = shift; my $param = shift;
On Fri, Oct 22, 2004 at 07:34:38AM +1000, Steve Baldwin wrote:
We make extensive use of named bind params in our apps (our DB is Oracle).
I just tried running a test program over DBD::Proxy and found it barfs on
these. Here is the code in DBD::Proxy that doesn't like them .
sub bind_param
I'm hoping that there exists some sample code for interfacing with Oracle
XML DB. Ideally, I'd like to see a module like Oracle::XMLDB that provides
convenience methods to register, update, and query XML. But if someone is
using it via vanilla DBI I'd like to see that, too.
On the Oracle XMLDB
24 matches
Mail list logo
