Re: Std.'ized error codes

2004-04-02 Thread Jonathan Leffler
Tim Bunce wrote: Note that all I was after as a fairly *short* list of the specific SQLSTATE codes that correspond to errors that applications *often* want to explicitly check for. Duplicate key being an obvious example. SQL-99 (ISO/IED 9075-2:1999) defines standardized SQLSTATE values in Table

Re: Std.'ized error codes

2004-04-02 Thread Tim Bunce
On Fri, Apr 02, 2004 at 12:16:06AM -0800, Jonathan Leffler wrote: Tim Bunce wrote: Yes. There are two things I want to do: 1. Specify a fairly short list of the specific SQLSTATE values that I'd like drivers to support as a minimum. I'd prefer to have it called something else -- I'd

Re: Accessing bound params?

2004-04-02 Thread Tim Bunce
See $sth-{ParamValues} (and $h-{ShowErrorStatement} and $h-{HandleEvent}) Tim. On Thu, Apr 01, 2004 at 11:33:55AM -0500, [EMAIL PROTECTED] wrote: Hi all, in my application errors are trapped in a sub that prints: 1) a notice to the user indicating an exception has occurred; 2) the name of

Re: Installing dbish causing problems

2004-04-02 Thread Bart Lateur
On Fri, 2 Apr 2004 10:02:36 +1000 (EST), Dennis M. Gray wrote: I installed 11.91 and now get this when trying to bring up ppm: D:\ppm break_at is not exported by the Text::Reform module Can't continue after import errors at C:/Perl/site/lib/Text/Reform.pm line 43 BEGIN failed--compilation

RE: Installing dbish causing problems

2004-04-02 Thread Dennis M. Gray
I was about to re-install ActiveState Perl, opened the Control Panel and saw there was a repair button so I tried that first. I can run ppm and dbish now. Dennis -Original Message- From: Bart Lateur [mailto:[EMAIL PROTECTED] Sent: 02 April, 2004 8:07 PM To: Dennis M. Gray Cc: [EMAIL

Re: Accessing bound params?

2004-04-02 Thread tomg
On Fri, 2 Apr 2004, Rudy Lippan wrote: On Thu, 1 Apr 2004 [EMAIL PROTECTED] wrote: Hi all, in my application errors are trapped in a sub that prints: 1) a notice to the user indicating an exception has occurred; 2) the name of the script (w/ absolute path), user and $DBI::errstr 3)

Re: My DBI script wont UPDATE a Table!

2004-04-02 Thread Hardy Merrill
Mark, you need to read the perldocs for the DBI module - you can do that by doing perldoc DBI at a command prompt. Search (on *nix by using the forward / slash) in the perldocs for Transaction and eval. You can also look here: http://www.perldoc.com/perl5.6.1/lib/DBI.html#Transactions

Build-DBI make error on HP_UX

2004-04-02 Thread Suresh Velagaleti
Hi, I'm trying to build DBI on an HP-UX. The first command perl Makefile.PL works fine. But I am getting this error when I issue the second command make. I would appreciate any help in resolving this problem: $ uname -a HP-UX tako1 B.11.11 U 9000/785 2015658734 unlimited-user license $ make

Re: DBD::Oracle 1.12 Oracle 8.1.6: Unable to connect

2004-04-02 Thread Jared Still
Dug this up, maybe it will help. --- There are a number of issues filed with the same ORA-1019 error, each of which turned out to be related to NLS settings in the environment. In particular, make sure you have set the appropriate ORA_NLS variable in your environment. In 7.3.X,

RE: Why won't my script terminate?

2004-04-02 Thread Jared Still
It still won't block a reader. There's nothing you can do in Oracle that will block a reader. Short of catching the odd bug or two that is. ;) Jared On Thu, 2004-04-01 at 07:49, Ronald J Kimball wrote: Thanks, but the script in question included an UPDATE statement. That is what I believe

Re: My DBI script wont UPDATE a Table!

2004-04-02 Thread Hardy Merrill
Paste in your database connect statement. Are you setting RaiseError, PrintError, and AutoCommit? Which database are you using? Are you doing any error checking of DBI statements? And as was just pointed out by someone else, does the user you are connecting with have update permissions in your