Martin is correct to enable tracing: Client Side Tracing: Your SQLNET.ORA file should contain the following lines to produce a client side trace file: trace_level_client = 10 trace_unique_client = on trace_file_client = sqlnet.trc trace_directory_client = <path_to_trace_dir>
Server Side Tracing: To enable server side tracing, use the following parameters: trace_level_server = 10 trace_file_server = server.trc trace_directory_server = <path_to_trace_dir>[/code] www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-130300.pdf martin ______________________________________________ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Fri, 10 Sep 2010 08:57:50 +0100 > From: martin.ev...@easysoft.com > To: ero...@barrack.com > CC: dbi-users@perl.org > Subject: Re: SQL errors not making it back to Perl > > On 09/09/10 21:20, Roode, Eric wrote: > > On Thursday, September 09, 2010 4:14 AM, Martin J. Evans wrote: > >> > >> On 08/09/10 21:24, Roode, Eric wrote: > >>> Hello all, > >>> > >>> I am trying to implement error handling in our stored > > procedures, > > [...] > >> > >> Works fine for me (although possibly under different conditions): > > [...] > >> > > > >> I had to take out odbc_cursortype and odbc_default_bind_type as > >> they produced other errors with the driver I was using. > >> > >> You could send me a level 15 trace and I might see something but it > >> looks like raiserror in your case is not raising an error. > >> > >> I was using Perl 5.10.1, DBD::ODBC 1.24_3, DBI 1.609 on Ubuntu > >> Linux with the Easysoft SQL Server ODBC Driver. > > > > > > Now that is perplexing, because I can't see any significant difference > > between what you did and what I did, other than I'm on Windows > > (presumably using Microsoft's ODBC driver?) and you're on Ubuntu. > > > > I don't know what a "level 15 trace" is, but I'd be interested in > > doing it if it might shed some light on what's going on. > > > > -- Eric > > > > See http://search.cpan.org/~mjevans/DBD-ODBC-1.24/ODBC.pm#Tracing > > I suggest you add: > > use DBD::ODBC; > DBI->trace(DBD::ODBC->parse_trace_flags('odbcconnection|odbcunicode')); > > to the start of your script then do something like: > > set DBI_TRACE=15=x.x > > from the command line before running your script. The trace output will go to > the file x.x. > > Don't send the trace to the list - it will probably be quite large and will > get filtered anyway. > > Martin > -- > Martin J. Evans > Easysoft Limited > http://www.easysoft.com
