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 f
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_par
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;
$sth->{'prox
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 ma
It's time to end this thread now - or take it to an Oracle
specific mailing list like oracle-l.
Thanks.
Tim.
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
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]
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
$sth->b
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:
> > http://homepage.eircom.
Great I will look into it.
Thanks!
Denesa Shaw
713-207-5928
[EMAIL PROTECTED]
"Reidy, Ron"
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.
Ok now I'm getting results from my search! Thanks!
Denesa Shaw
713-207-5928
[EMAIL PROTECTED]
"Scott T.
...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.
> >
> >
> > O
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
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 p
"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.emp
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 bette
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 call
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 energy
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
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 contact
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 = 'ATTU'
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
parameter(
[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
>> arou
24 matches
Mail list logo
