Does anyone have any experience w/ doing two-phase commit across connections to
two different databases from the same Perl program? (To guarantee that either
both or neither transaction is committed, for consistency.)
Any thoughts, ideas or suggestions would be appreciated.
Thanks,
-Mark
You should definitely check out Oracle-L. It's a very active group with a wide
variety of skill levels.
See: http://www.freelists.org/list/oracle-l for subscription information.
-Mark
-Original Message-
From: Raveen du [mailto:raveendu.oracle...@gmail.com]
Sent: Tuesday, April 12,
On 17/02/2011 3:05 PM, Bobak, Mark wrote:
Perhaps you have to declare you in type as a NCLOB??
Cheers
John
Hi all,
I'm running into a 'PLS-00418: array bind type must match PL/SQL table row
type' error, but only when passing UTF8 data.
The details are as follows. I have a PL/SQL
Tired the NVARCHAR2, it had no effect.
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 18, 2011 7:03 AM
To: Bobak, Mark
Cc: dbi-users@perl.org
Subject: Re: Problem with UTF8 and array binding
On 17/02/2011 4:38 PM, Bobak, Mark wrote:
Sorry
Hi all,
I'm running into a 'PLS-00418: array bind type must match PL/SQL table row
type' error, but only when passing UTF8 data.
The details are as follows. I have a PL/SQL packaged function that looks like
this:
FUNCTION MSTInsUpdCIT(
PI_CGP_ID IN VARCHAR2
,PI_CBL_ID
mentioned above...
I don't see how/where NCLOB fits into the picture?
-Mark
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, February 17, 2011 4:10 PM
To: dbi-users@perl.org
Subject: Re: Problem with UTF8 and array binding
On 17/02/2011 3:05 PM, Bobak
What do you have set for your ORACLE_HOME and any NLS variables?
env|grep ORA
env|grep NLS
Execute the above commands.
-Mark
-Original Message-
From: Vinod Guleria [mailto:vinod.gule...@gmail.com]
Sent: Monday, July 26, 2010 12:42 AM
To: Alexander Foken
Cc: John Scoles; Martin J.
I'd argue you want to use a shell wrapper anyhow, because rather than setting
those variables explicitly, you ought to do something like:
export ORACLE_SID=your_sid
export ORAENV_ASK=NO
. oraenv
and Oracle will set it all for you, and if/when something changes or is
upgraded, your code will
to indicate that it's working. It
probably needs a lot more testing, though.
-Mark
-Original Message-
From: Martin Evans [mailto:martin.ev...@easysoft.com]
Sent: Wednesday, April 07, 2010 12:38 PM
To: Bobak, Mark
Cc: dbi-users@perl.org
Subject: Re: Help with handling CLOBs in Oracle and ORA
From: Martin J. Evans [mailto:martin.ev...@easysoft.com]
Sent: Wednesday, April 07, 2010 2:49 PM
To: Bobak, Mark
Cc: dbi-users@perl.org
Subject: Re: Help with handling CLOBs in Oracle and ORA-1460 error
Bobak, Mark wrote:
Hi Martin,
Well, actually, a lot has happened since I wrote my
One solution is here:
http://asktom.oracle.com/pls/apex/f?p=100:11:0P11_QUESTION_ID:210612357425
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Friday, March 26, 2010 2:13 PM
Cc: dbi Mailing List
Subject: Re: parameter issues in DBD:Oracle
On Mar
I'm brand new here, feel free to take what I say with a grain of salt, ignore
me altogether, etc.
Being brand-new, I'm not sure how big a problem this type of spamming is for
you guys, but, the way we avoid it on Oracle-L, is that new subscribers are
immediately subscribed to the list and
Hi all,
I'm new to the list, and I'm a DBA, not really a Perl programmer, but I'm
running into this issue that I hope someone can help with.
I think I'm getting dangerously close to getting this to work. But, I'm just
not quite getting there.
We have an application coded in Perl w/ DBI *
13 matches
Mail list logo
