From oracle-l-bounce@freelists.org Sat Feb 28 10:20:49 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1SGKns25805 for ; Sat, 28 Feb 2004 10:20:49 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1SGKno25799 for ; Sat, 28 Feb 2004 10:20:49 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 99E07394C9E; Sat, 28 Feb 2004 11:21:50 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 28 Feb 2004 11:20:44 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 886A9394C22 for ; Sat, 28 Feb 2004 11:20:40 -0500 (EST) Received: from ryan2le36ofjce ([68.98.163.81]) by lakemtao01.cox.net (InterMail vM.5.01.06.08 201-253-122-130-108-20031117) with SMTP id <20040228162355.USKR28361.lakemtao01.cox.net@ryan2le36ofjce> for ; Sat, 28 Feb 2004 11:23:55 -0500 Message-ID: <032701c3fe17$8f192ac0$51a36244@ryan2le36ofjce> From: "Ryan" To: Subject: anyway to get binds out of the data dictionary? Date: Sat, 28 Feb 2004 11:26:03 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0324_01C3FDED.A61A8C20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 16 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan.gaffuri@cox.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_0324_01C3FDED.A61A8C20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm not happy with the error logging that our software engineers are = doing I want to do the following: 1. Use an on error database trigger 2. When an error occurs insert to a table the following: a. sid b. user (we are using connection pooling so this has limited use) c. last sql statement d. timestamp We are using bind variables. Anyway to grab what the actual values are? ------=_NextPart_000_0324_01C3FDED.A61A8C20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I'm not happy with the error logging = that our=20 software engineers are doing I want to do the following:

1. Use an on error database = trigger

2. When an error occurs insert to a = table the=20 following:

a. sid

b. user (we are = using connection=20 pooling so this has limited use)

c. last sql=20 statement

d. = timestamp

We are using bind variables. Anyway to = grab what=20 the actual values are?

------=_NextPart_000_0324_01C3FDED.A61A8C20-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------