can't see a SQL generated by Crystal Report

From: Gene Gurevich <gurelei_at_yahoo.com>
Date: Mon, 08 Dec 2003 14:39:27 -0800
Message-ID: <F001.005D9345.20031208143927@fatcity.com>

Hi all:

I'm trying to catch a DDL generated by Crystal report. I'm using the following query to do that: select sql_text
  from v$sqltext
where ( address, hash_value ) in

          (select sql_address, sql_hash_value
             from v$session
           where username = UPPER('&username'))
              order by piece

I am catching a SQL, but that SQL returns different amount of rows than the report when executed through a Crystal. Is there something wrong with my query (it is running under Oracle 817) that makes it miss some data?

thanks

Gene

---

Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gene Gurevich
  INET: gurelei_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 08 2003 - 16:39:27 CST