Re: can't see a SQL generated by Crystal Report

2003-12-09 Thread Yechiel Adar 
Are you sure that Crystal does not do any local processing on the data?

Yechiel Adar
Mehish
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 12:39 AM


 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: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: can't see a SQL generated by Crystal Report

2003-12-09 Thread Gene Gurevich 
I'm not sure. I'm talking to the application team to
see what exactly is being done behind the scene. I do
know that I can't capture queries running via
ColdFusion server and thought that there may be
something like that with Crystal.

Gene
--- Yechiel Adar [EMAIL PROTECTED] wrote:
 Are you sure that Crystal does not do any local
 processing on the data?
 
 Yechiel Adar
 Mehish
 - Original Message - 
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Tuesday, December 09, 2003 12:39 AM
 
 
  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: [EMAIL PROTECTED]
  
  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: [EMAIL PROTECTED] (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).
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: Yechiel Adar
   INET: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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).


__
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: can't see a SQL generated by Crystal Report

2003-12-09 Thread John Flack 
I happen to know that you have to work hard to keep Crystal from doing a SELECT * and 
doing its own filtering and grouping.  It can be done, but you have to KNOW that that 
is what you want to do, i.e. novices will let Crystal do what it wants.

-Original Message-
Sent: Tuesday, December 09, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L


I'm not sure. I'm talking to the application team to
see what exactly is being done behind the scene. I do
know that I can't capture queries running via
ColdFusion server and thought that there may be
something like that with Crystal.

Gene
--- Yechiel Adar [EMAIL PROTECTED] wrote:
 Are you sure that Crystal does not do any local
 processing on the data?
 
 Yechiel Adar
 Mehish
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Flack
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

can't see a SQL generated by Crystal Report

2003-12-08 Thread Gene Gurevich 
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).