From oracle-l-bounce@freelists.org Sat Feb 28 10:41:24 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1SGfOE26462 for ; Sat, 28 Feb 2004 10:41:24 -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 i1SGfNo26457 for ; Sat, 28 Feb 2004 10:41:23 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0496C394DF5; Sat, 28 Feb 2004 11:42:25 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 28 Feb 2004 11:41:17 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from MXR-4.estpak.ee (ld3.estpak.ee [194.126.101.102]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B4428394CDA for ; Sat, 28 Feb 2004 11:41:14 -0500 (EST) Received: from localhost (reha4 [127.0.0.1]) by MXR-4.estpak.ee (Postfix) with ESMTP id B58B54032B for ; Sat, 28 Feb 2004 18:44:27 +0200 (EET) Received: from MXR-4.estpak.ee ([127.0.0.1]) by localhost (reha4 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25660-03 for ; Sat, 28 Feb 2004 18:44:27 +0200 (EET) Received: from porgand (213-35-251-162-dsl.kvm.estpak.ee [213.35.251.162]) by MXR-4.estpak.ee (Postfix) with SMTP id 37CA3401BD for ; Sat, 28 Feb 2004 18:44:27 +0200 (EET) Message-ID: <2a6e01c3fe1a$1fbd2480$73f823d5@porgand> From: =?iso-8859-1?Q?Tanel_P=F5der?= To: References: <032701c3fe17$8f192ac0$51a36244@ryan2le36ofjce> Subject: Re: anyway to get binds out of the data dictionary? Date: Sat, 28 Feb 2004 18:44:21 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_2A6B_01C3FE2A.E0D801C0" 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-Virus-Scanned: by amavisd-new at neti.ee X-archive-position: 18 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tanel.poder.003@mail.ee Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_2A6B_01C3FE2A.E0D801C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Check v$sql_bind_data view. Tanel. ----- Original Message -----=20 From: Ryan=20 To: oracle-l@freelists.org=20 Sent: Saturday, February 28, 2004 6:26 PM Subject: anyway to get binds out of the data dictionary? 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_2A6B_01C3FE2A.E0D801C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Check v$sql_bind_data = view.
 
Tanel.
 
----- Original Message -----
From:=20 Ryan=20
Sent: Saturday, February 28, = 2004 6:26=20 PM
Subject: anyway to get binds = out of the=20 data dictionary?

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=20 connection 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_2A6B_01C3FE2A.E0D801C0-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------