subject:"Oracle reports"

Oracle Reports

2001-04-21 Thread Witold Iwaniec



Is there a version of Reports that runs on Windows Me? You can 
download only reports for NT, Sun, and Linux.

Thanks

Witold
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Reports!

2003-02-20 Thread Sesi Odury

Hi List,

 I need to abort the report execution, if the query generating report returns no rows. 
I tried to do this using the report trigger 'before report'. I have written code like 
this 
 Function BEF_REP_TRG return boolean is
   
begin

return (true);

  Exception
 when no data found
return (false);
  end;
But ,it is displaying rep-1825 Before Report trigger returned false .
Can we remove this???

Thanks
Sesi
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sesi Odury
  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).

Oracle reports

2001-06-11 Thread Mark Liggayu


I am creating a report based on a couple tables.  The report should show the
total amount sold for the current month and another field for total amount
sold Year To Date.
How can I created the report so that the month to date value for a
particular item is adjacent to the total amount for Year to date.  Please
see below for desired reports output.


Item #  Item DescriptionAmount Sold (Current Month)
 Amount Sold (YTD)

54654   Door jams   20,245.00  
 465,475.00
46545   Windows Casing 1500.00  
124,445.57

Does anyone know what reference material I should purchase for oracle
reports?

Thanks,
Mark

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Liggayu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Reports....

2001-10-25 Thread Thomas, Kevin


Hi all,

Sorry about the non-DBA related post...but I reckon you guys will be able to
point me in the right direction!

Our client is running some Oracle Reports (v2.5) that are killing our
database, in that the queries contained in them have an average hit rate of
less than 2%!!! Guess what, it get's better, they don't have the source code
anymore!! Is there a way of either a) re-engineering the executable, or b) a
third party tool that will extract the queries or show the report in a text
version (?!?).

Any thoughts guru-type-people ;o)

Kev.

"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Reports Server?

2001-04-11 Thread Dasko, Dan


Oracle reports server keeps a log file that tells when a server engine is
started and closed or if it can't be started etc.  IIS keeps a log of what
html page is accessed, and what action was taken by a web form.  IE,
action="/scripts/run.pl".  What I need to know is if either IIS has a way to
capture the data sent to the standard out by the html form, or if reports
server has a way of gathering the name of the report run and when.  Reports
server 6.0 on NT accessed via rwcgi60.exe through IIS.

Dan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Reports Server?

2001-04-11 Thread Dasko, Dan


Oracle reports server keeps a log file that tells when a server engine is
started and closed or if it can't be started etc.  IIS keeps a log of what
html page is accessed, and what action was taken by a web form.  IE,
action="/scripts/run.pl".  What I need to know is if either IIS has a way to
capture the data sent to the standard out by the html form, or if reports
server has a way of gathering the name of the report run and when.  Reports
server 6.0 on NT accessed via rwcgi60.exe through IIS.

Dan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Reports - SQL

2001-04-19 Thread Witold . Iwaniec




Hi

I started to work with Oracle Reports (2.5.5). My first task to maintenance of
existing reports. On one of them I need to change the SQL - whenever I change
it, the data model changes - some columns get moved between groups. Is it the
reports' behavior or do I miss a setting?

Thanks

Witold


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Reports: email

2003-02-04 Thread Maria Aurora VT de la Vega

This is quite OT in a DBA forum. More of a developer question.

How do I configure email in Oracle Reports. I have created the procedure
but I need to know where do I place the SMTP host name?

Thanks.





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maria Aurora VT de la Vega
  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: Oracle Reports!

2003-02-21 Thread Sony kristanto

Hi Sesi,

BEFORE_REPORT_TRIGGER is fired before sql statement is executed, so you
can't abort your report execution here by using that trigger.

HTH,

Sony

> -Original Message-
> From: Sesi Odury [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 21, 2003 4:19 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle Reports!
> 
> Hi List,
> 
>  I need to abort the report execution, if the query generating report
> returns no rows. I tried to do this using the report trigger 'before
> report'. I have written code like this 
>  Function BEF_REP_TRG return boolean is
>
> begin
> 
> return (true);
> 
> Exception
>when no data found
>   return (false);
>   end;
> But ,it is displaying rep-1825 Before Report trigger returned false .
> Can we remove this???
> 
> Thanks
> Sesi
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Sesi Odury
>   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: Sony kristanto
  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: Oracle Reports!

2003-02-21 Thread Sesi Odury



The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.

<>

Oracle Reports coredump

2001-05-22 Thread Carle, William T (Bill), NLCIO


Hi,

I recently installed Oracle Reports and I'll work fine for a while. Then
I'll get a coredump. Has anyone else had a problem with that and know what
might be wrong?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle reports

2001-06-11 Thread Nicoll, Iain (Calanais)


You could try something like

select item, 
   sum(decode(sign(transaction_date - trunc(sysdate,'Month'),-1,0,
 
0,nvl(value,0),
 
1,nvl(value,0)) mtd,
   sum(decode(sign(transaction_date - trunc(sysdate,'Year'),-1,0,
  0,nvl(value,0),
  1,nvl(value,0)) ytd
from transactions_table
group by item

The sign should work out whether the transaction date is greater than start
of month or start of years and if not add 0 to the total.  The nvls are just
in case you might have any null values lurking about.  You may be able to do
it better in reports but I don't have it to hand right now.

HTH

Iain Nicoll



-Original Message-
Sent: 11 June 2001 21:20
To: Multiple recipients of list ORACLE-L


I am creating a report based on a couple tables.  The report should show the
total amount sold for the current month and another field for total amount
sold Year To Date.
How can I created the report so that the month to date value for a
particular item is adjacent to the total amount for Year to date.  Please
see below for desired reports output.


Item #  Item DescriptionAmount Sold (Current Month)
Amount Sold (YTD)

54654   Door jams   20,245.00
465,475.00
46545   Windows Casing 1500.00
124,445.57

Does anyone know what reference material I should purchase for oracle
reports?

Thanks,
Mark

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Liggayu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Nicoll, Iain (Calanais)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports....

2001-10-25 Thread Rachel Carmichael


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Sorry about the non-DBA related post...but I reckon you guys will be
> able to
> point me in the right direction!
> 
> Our client is running some Oracle Reports (v2.5) that are killing our
> database, in that the queries contained in them have an average hit
> rate of
> less than 2%!!! Guess what, it get's better, they don't have the
> source code
> anymore!! Is there a way of either a) re-engineering the executable,
> or b) a
> third party tool that will extract the queries or show the report in
> a text
> version (?!?).
> 
> Any thoughts guru-type-people ;o)
> 
> Kev.
> 
> "hit any user to continue"
> __
> 
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

FW: Oracle Reports....

2001-10-25 Thread Amar Kumar Padhi

Title: FW: Oracle Reports





Not having the source code is a handycap situation.
If you don't have .RDF, the executable .REP will not be of much help.
Afaik, converting .REP to .RDF is not possible. 


So the only solution as I see it is rebuilding the concerned reports!


rgds
amar


-Original Message-
From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Reports

RE: Oracle Reports....

2001-10-25 Thread Thomas, Kevin


Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say "are you running that report", because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Sorry about the non-DBA related post...but I reckon you guys will be
> able to
> point me in the right direction!
> 
> Our client is running some Oracle Reports (v2.5) that are killing our
> database, in that the queries contained in them have an average hit
> rate of
> less than 2%!!! Guess what, it get's better, they don't have the
> source code
> anymore!! Is there a way of either a) re-engineering the executable,
> or b) a
> third party tool that will extract the queries or show the report in
> a text
> version (?!?).
> 
> Any thoughts guru-type-people ;o)
> 
> Kev.
> 
> "hit any user to continue"
> __
> 
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports....

2001-10-25 Thread Thomas, Kevin


Thanks Amar,
 
I was afraid of that. I'm not too concerned with getting the report from
.REP to .RDF, but being able to get any of the query information out of the
.REP would be a good start.
 
Cheers,
Kev.
"hit any user to continue" 
__ 

Kevin Thomas 
Technical Analyst 
Deregulation Services 
Calanais Ltd. 
(2nd Floor East - Weirs Building) 
Tel: 0141 568 2377 
Fax: 0141 568 2366 
http://www.calanais.com   

 
 -Original Message-
Sent: 25 October 2001 14:00
To: Multiple recipients of list ORACLE-L



Not having the source code is a handycap situation. 
If you don't have .RDF, the executable .REP will not be of much help. 
Afaik, converting .REP to .RDF is not possible. 

So the only solution as I see it is rebuilding the concerned reports! 

rgds 
amar 

-Original Message- 
 ] 
Sent: Thursday, October 25, 2001 3:20 PM 
To: Multiple recipients of list ORACLE-L 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports....

2001-10-25 Thread Rachel Carmichael


Ah but Kevin, that info stays around even if they are not running the
report at that second. so you can do a search in the tables and
look for sql that references the tables that have the reporting data in
them.

won't get you EVERYTHING you need, but it will take you at least one
step closer


--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Thanks Rachel,
> 
> I'll check these tables to see what dets they hold. The problem I
> have is
> that I can't phone the user and say "are you running that report",
> because
> they have a big nasty lady who will come and bite my head off if she
> thinks
> we're actually trying to help!!
> 
> ;o)
> 
> Kev.
> "hit any user to continue"
> __
> 
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> 
> 
> -Original Message-
> Sent: 25 October 2001 14:35
> To: Multiple recipients of list ORACLE-L
> 
> 
> you should be able to pull the queries out of v$sql, v$sqlarea and/or
> v$sqltext
> 
> --- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> > Hi all,
> > 
> > Sorry about the non-DBA related post...but I reckon you guys will
> be
> > able to
> > point me in the right direction!
> > 
> > Our client is running some Oracle Reports (v2.5) that are killing
> our
> > database, in that the queries contained in them have an average hit
> > rate of
> > less than 2%!!! Guess what, it get's better, they don't have the
> > source code
> > anymore!! Is there a way of either a) re-engineering the
> executable,
> > or b) a
> > third party tool that will extract the queries or show the report
> in
> > a text
> > version (?!?).
> > 
> > Any thoughts guru-type-people ;o)
> > 
> > Kev.
> > 
> > "hit any user to continue"
> > __
> > 
> > Kevin Thomas
> > Technical Analyst
> > Deregulation Services
> > Calanais Ltd.
> > (2nd Floor East - Weirs Building)
> > Tel: 0141 568 2377
> > Fax: 0141 568 2366
> > http://www.calanais.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Thomas, Kevin
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > 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!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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.com
> -- 
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great

RE: Oracle Reports....

2001-10-25 Thread Raj Gopalan


Give a try by tracing the session used by the report.

-Original Message-
Sent: 25 October 2001 16:05
To: Multiple recipients of list ORACLE-L


Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say "are you running that report", because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Sorry about the non-DBA related post...but I reckon you guys will be
> able to
> point me in the right direction!
> 
> Our client is running some Oracle Reports (v2.5) that are killing our
> database, in that the queries contained in them have an average hit
> rate of
> less than 2%!!! Guess what, it get's better, they don't have the
> source code
> anymore!! Is there a way of either a) re-engineering the executable,
> or b) a
> third party tool that will extract the queries or show the report in
> a text
> version (?!?).
> 
> Any thoughts guru-type-people ;o)
> 
> Kev.
> 
> "hit any user to continue"
> __
> 
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Raj Gopalan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports....

2001-10-26 Thread Thomas, Kevin


Ah, right!

Ok, thanks for that Rachel, I'll have a nosey at them today... ;o)

Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 25 October 2001 17:56
To: Multiple recipients of list ORACLE-L


Ah but Kevin, that info stays around even if they are not running the
report at that second. so you can do a search in the tables and
look for sql that references the tables that have the reporting data in
them.

won't get you EVERYTHING you need, but it will take you at least one
step closer


--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Thanks Rachel,
> 
> I'll check these tables to see what dets they hold. The problem I
> have is
> that I can't phone the user and say "are you running that report",
> because
> they have a big nasty lady who will come and bite my head off if she
> thinks
> we're actually trying to help!!
> 
> ;o)
> 
> Kev.
> "hit any user to continue"
> __
> 
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> 
> 
> -Original Message-
> Sent: 25 October 2001 14:35
> To: Multiple recipients of list ORACLE-L
> 
> 
> you should be able to pull the queries out of v$sql, v$sqlarea and/or
> v$sqltext
> 
> --- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> > Hi all,
> > 
> > Sorry about the non-DBA related post...but I reckon you guys will
> be
> > able to
> > point me in the right direction!
> > 
> > Our client is running some Oracle Reports (v2.5) that are killing
> our
> > database, in that the queries contained in them have an average hit
> > rate of
> > less than 2%!!! Guess what, it get's better, they don't have the
> > source code
> > anymore!! Is there a way of either a) re-engineering the
> executable,
> > or b) a
> > third party tool that will extract the queries or show the report
> in
> > a text
> > version (?!?).
> > 
> > Any thoughts guru-type-people ;o)
> > 
> > Kev.
> > 
> > "hit any user to continue"
> > __
> > 
> > Kevin Thomas
> > Technical Analyst
> > Deregulation Services
> > Calanais Ltd.
> > (2nd Floor East - Weirs Building)
> > Tel: 0141 568 2377
> > Fax: 0141 568 2366
> > http://www.calanais.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Thomas, Kevin
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > 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!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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.com
> -- 
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this ma

RE: Oracle Reports....

2001-10-26 Thread Thomas, Kevin


Thanks Raj,

Part of the problem is we don't know what queries actually belong to which
report (because the source is missing) and there are probably about 150+
users of this particular system at anytime running queries from SQL, FORMS
or REPORTS. 

Cheers,
Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 25 October 2001 19:11
To: Multiple recipients of list ORACLE-L


Give a try by tracing the session used by the report.

-Original Message-
Sent: 25 October 2001 16:05
To: Multiple recipients of list ORACLE-L


Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say "are you running that report", because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Sorry about the non-DBA related post...but I reckon you guys will be
> able to
> point me in the right direction!
> 
> Our client is running some Oracle Reports (v2.5) that are killing our
> database, in that the queries contained in them have an average hit
> rate of
> less than 2%!!! Guess what, it get's better, they don't have the
> source code
> anymore!! Is there a way of either a) re-engineering the executable,
> or b) a
> third party tool that will extract the queries or show the report in
> a text
> version (?!?).
> 
> Any thoughts guru-type-people ;o)
> 
> Kev.
> 
> "hit any user to continue"
> __
> 
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Raj Gopalan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REM

RE: Oracle Reports....

2001-10-26 Thread Mark Leith


Kevin,

Can you not log in as a user yourself and run the reports that you are
interested in, then trace your own session to see what SQL is being
executed?

What I would do:

1) As the report user, run the report you are interested in.
2a) Do a select from v$sqlarea/v$sqltext/v$session to get the SQL for your
particular session.
2b) set a SQL trace up for your own session, and record what order you ran
the reports in, and try to match this up with the SQL in your trace file.

Think this will work?

Mark


-Original Message-
Kevin
Sent: Friday, October 26, 2001 09:45
To: Multiple recipients of list ORACLE-L


Thanks Raj,

Part of the problem is we don't know what queries actually belong to which
report (because the source is missing) and there are probably about 150+
users of this particular system at anytime running queries from SQL, FORMS
or REPORTS.

Cheers,
Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 25 October 2001 19:11
To: Multiple recipients of list ORACLE-L


Give a try by tracing the session used by the report.

-Original Message-
Sent: 25 October 2001 16:05
To: Multiple recipients of list ORACLE-L


Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say "are you running that report", because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Sorry about the non-DBA related post...but I reckon you guys will be
> able to
> point me in the right direction!
>
> Our client is running some Oracle Reports (v2.5) that are killing our
> database, in that the queries contained in them have an average hit
> rate of
> less than 2%!!! Guess what, it get's better, they don't have the
> source code
> anymore!! Is there a way of either a) re-engineering the executable,
> or b) a
> third party tool that will extract the queries or show the report in
> a text
> version (?!?).
>
> Any thoughts guru-type-people ;o)
>
> Kev.
>
> "hit any user to continue"
> __
>
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send

RE: Oracle Reports....

2001-10-26 Thread Thomas, Kevin

Mark,

Yip, this sounds like a plan. As I mentioned earlier though, I don't want to
awaken the Kracken! So being sneaky and trying to get the reports is key. As
they are the client, I don't actually have access to any of there servers
that they hold the reports on, or acccess to PVCS (not that I think they
would actually have them in PVCS!!).

Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com

-Original Message-
Sent: 26 October 2001 11:20
To: Multiple recipients of list ORACLE-L

Kevin,

Can you not log in as a user yourself and run the reports that you are
interested in, then trace your own session to see what SQL is being
executed?

What I would do:

1) As the report user, run the report you are interested in.
2a) Do a select from v$sqlarea/v$sqltext/v$session to get the SQL for your
particular session.
2b) set a SQL trace up for your own session, and record what order you ran
the reports in, and try to match this up with the SQL in your trace file.

Think this will work?

Mark

-Original Message-
Kevin
Sent: Friday, October 26, 2001 09:45
To: Multiple recipients of list ORACLE-L

Thanks Raj,

Part of the problem is we don't know what queries actually belong to which
report (because the source is missing) and there are probably about 150+
users of this particular system at anytime running queries from SQL, FORMS
or REPORTS.

Cheers,
Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com

-Original Message-
Sent: 25 October 2001 19:11
To: Multiple recipients of list ORACLE-L

Give a try by tracing the session used by the report.

-Original Message-
Sent: 25 October 2001 16:05
To: Multiple recipients of list ORACLE-L

Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say "are you running that report", because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com

-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L

you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Sorry about the non-DBA related post...but I reckon you guys will be
> able to
> point me in the right direction!
>
> Our client is running some Oracle Reports (v2.5) that are killing our
> database, in that the queries contained in them have an average hit
> rate of
> less than 2%!!! Guess what, it get's better, they don't have the
> source code
> anymore!! Is there a way of either a) re-engineering the executable,
> or b) a
> third party tool that will extract the queries or show the report in
> a text
> version (?!?).
>
> Any thoughts guru-type-people ;o)
>
> Kev.
>
> "hit any user to continue"
> __
>
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing l

Oracle Reports Question

2001-02-21 Thread Carle, William T (Bill), NLCIO


Hi,

Can anyone point me to some good documentation on Oracle Reports?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports - SQL

2001-04-19 Thread Dasko, Dan


BWAHAHAHAHAHAHAHAHAHAAA,

Oh, sorry.  I can so relate.  That sounds like the reports acting like
usual.  One thing, it's virtually impossible to make certain changes without
rerunning the report wizard.  However, if you make a change that eliminates
one of the group break columns, things will have to change.  Email me
offline, and I'll offer any advice I can.

Dan

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L




Hi

I started to work with Oracle Reports (2.5.5). My first task to maintenance
of
existing reports. On one of them I need to change the SQL - whenever I
change
it, the data model changes - some columns get moved between groups. Is it
the
reports' behavior or do I miss a setting?

Thanks

Witold


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports - SQL

2001-04-19 Thread Viktor


Try giving aliase names and to the columns that are
changing their names. Each should have a diff. aliase.

P.S. Sorry, if I misspelled "aliase".


--- [EMAIL PROTECTED] wrote:
> 
> 
> Hi
> 
> I started to work with Oracle Reports (2.5.5). My
> first task to maintenance of
> existing reports. On one of them I need to change
> the SQL - whenever I change
> it, the data model changes - some columns get moved
> between groups. Is it the
> reports' behavior or do I miss a setting?
> 
> Thanks
> 
> Witold
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports: email

2003-02-04 Thread Shuja

Title: RE: Oracle Reports: email





set all the parameters in the reports (desname=email, desformat=pdf, destype=email). In client server mode, client systems must be configured for the email, eg on windows Outlook or netscape as default email client, with all the smtp settings etc. Mails get sent using that account.

Shuja


-Original Message-
From: Maria Aurora VT de la Vega [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 3:24 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Reports: email



This is quite OT in a DBA forum. More of a developer question.


How do I configure email in Oracle Reports. I have created the procedure
but I need to know where do I place the SMTP host name?


Thanks.






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maria Aurora VT de la Vega
  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: Oracle Reports: email

2003-02-04 Thread Jared Still

This isn't by definition a DBA forum.

The fact that the most vocal folks here are mostly DBA's
just makes it seem that way.

So, ask anything about Oracle that you like.

Jared

On Tuesday 04 February 2003 03:23, Maria Aurora VT de la Vega wrote:
> This is quite OT in a DBA forum. More of a developer question.
>
> How do I configure email in Oracle Reports. I have created the procedure
> but I need to know where do I place the SMTP host name?
>
> Thanks.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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: Oracle Reports: email

2003-02-04 Thread Gogala, Mladen

To be a good DBA one needs a personality of a used car salesman.
No wonder we the loudest ones around here. You cannot expect a DBA 
to be a blushing flower.

> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 04, 2003 10:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle Reports: email
> 
> 
> 
> This isn't by definition a DBA forum.
> 
> The fact that the most vocal folks here are mostly DBA's
> just makes it seem that way.
> 
> So, ask anything about Oracle that you like.
> 
> Jared
> 
> On Tuesday 04 February 2003 03:23, Maria Aurora VT de la Vega wrote:
> > This is quite OT in a DBA forum. More of a developer question.
> >
> > How do I configure email in Oracle Reports. I have created 
> the procedure
> > but I need to know where do I place the SMTP host name?
> >
> > Thanks.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jared Still
>   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: Gogala, Mladen
  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: Oracle Reports: email

2003-02-04 Thread Jared . Still

.. but with some semblance of ethics.

"Gogala, Mladen" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/04/2003 08:10 AM
 Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
    Subject:RE: Oracle Reports: email

To be a good DBA one needs a personality of a used car salesman.
No wonder we the loudest ones around here. You cannot expect a DBA 
to be a blushing flower.

> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 04, 2003 10:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle Reports: email
> 
> 
> 
> This isn't by definition a DBA forum.
> 
> The fact that the most vocal folks here are mostly DBA's
> just makes it seem that way.
> 
> So, ask anything about Oracle that you like.
> 
> Jared
> 
> On Tuesday 04 February 2003 03:23, Maria Aurora VT de la Vega wrote:
> > This is quite OT in a DBA forum. More of a developer question.
> >
> > How do I configure email in Oracle Reports. I have created 
> the procedure
> > but I need to know where do I place the SMTP host name?
> >
> > Thanks.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jared Still
>   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: Gogala, Mladen
  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: 
  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: Oracle Reports: email

2003-02-04 Thread Maria Aurora VT de la Vega



thanks everyone.
we'll try this one more time.
Shuja wrote:
 
set all the parameters in the reports (desname=email,
desformat=pdf, destype=email). In client server mode, client systems must
be configured for the email, eg on windows Outlook or netscape as default
email client, with all the smtp settings etc. Mails get sent using that
account.
Shuja
-Original Message-
From: Maria Aurora VT de la Vega [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 3:24 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Reports: email
This is quite OT in a DBA forum. More of a developer question.
How do I configure email in Oracle Reports. I have created
the procedure
but I need to know where do I place the SMTP host name?
Thanks.
 
 
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Aurora VT de la Vega
  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).

--
Maria Aurora VT de la Vega
Oracle DBA
Philippine Stock Exchange, Inc.
"If you don't risk anything, you risk even more."

Oracle Reports upgrade query

2002-01-09 Thread John Dempsey


I have Oracle 7.3.4 database running on HP-UX 10.20. We have reports v1.1
running against this (different ORACLE_HOME), on the same system. We are
looking at replacing the system with another HP-UX 11.0 system, and
therefore upgrade the database to  8.1.x. This is not a problem, but
although I know I have to migrate the report thru' v2.5 to whichever version
(eg.6i), my question is, how will we perform the running of such reports on
the same box.

At present we just use 'runrep', but in the migration of the reports, they
will require a GUI designer to modify, and I don't know what needs to be
installed on the UNIX system ... OAS ?? WEB?? Obviously there has been
various versions and ways to perform the task over the years, so in order to
cut out the waste, I thought I'd ask here.



TIA

John D.
Oracle DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dempsey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Reports Demo Tables

2001-05-16 Thread Carle, William T (Bill), NLCIO


Hi,

I recently installed Oracle Reports; however, they didn't send me the
demo cd that contains the sample tables, I can use to play with the product.
Does nyone have a copy of the script to create the demo tables that they can
send me?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports coredump

2001-05-22 Thread Dasko, Dan


No, I've been using reports for a couple of years and never had that
behavior.  Which version which part?  Is it the client side or the server
side?

Dan

-Original Message-
Sent: Tuesday, May 22, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L


Hi,

I recently installed Oracle Reports and I'll work fine for a while. Then
I'll get a coredump. Has anyone else had a problem with that and know what
might be wrong?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports coredump

2001-05-23 Thread Magrogan Michael A



We've had similar problems with the 6i runtime, using patchset3a.  Metalink
says it's fixed in patchset 4.

-Original Message-
Sent: Tuesday, May 22, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L


Hi,

I recently installed Oracle Reports and I'll work fine for a while. Then
I'll get a coredump. Has anyone else had a problem with that and know what
might be wrong?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Magrogan Michael A
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports coredump

2001-05-23 Thread Carle, William T (Bill), NLCIO


Dan,

I have the 6i version on HP-UX 11.0. It's all on one machine. I'm just
trying to create some sample reports to familiarize myself with the product.
It seems to coredump from time to time for no apparent reason.


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Tuesday, May 22, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Oracle Reports coredump

No, I've been using reports for a couple of years and never had that
behavior.  Which version which part?  Is it the client side or the server
side?

Dan

-Original Message-
Sent: Tuesday, May 22, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L


Hi,

I recently installed Oracle Reports and I'll work fine for a while. Then
I'll get a coredump. Has anyone else had a problem with that and know what
might be wrong?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports coredump

2001-05-23 Thread Dasko, Dan


Well, I can't comment specifically on that hardware.  I've got 6.? but not
6i server running on a WinNT server and no problems, then I've had both 2.?
and 6.? tools running on a WinNT workstation with no problems.  If you have
a workstation that you can use, isn't the windows version available at
technet?

Dan

-Original Message-
Sent: Wednesday, May 23, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


Dan,

I have the 6i version on HP-UX 11.0. It's all on one machine. I'm just
trying to create some sample reports to familiarize myself with the product.
It seems to coredump from time to time for no apparent reason.


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Tuesday, May 22, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Reports coredump

No, I've been using reports for a couple of years and never had that
behavior.  Which version which part?  Is it the client side or the server
side?

Dan

-Original Message-
Sent: Tuesday, May 22, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L


Hi,

I recently installed Oracle Reports and I'll work fine for a while. Then
I'll get a coredump. Has anyone else had a problem with that and know what
might be wrong?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports Question

2001-02-21 Thread bmarialuz


What version?

[EMAIL PROTECTED] wrote:
>
> Hi,
> 
>     Can anyone point me to some good documentation on Oracle Reports?
> 
> 
> Bill Carle
> AT&T
> Database Administrator
> 816-995-3922
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Carle, William T (Bill), NLCIO
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> 
> 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).
> 
__
Get your own FREE, personal Netscape Webmail account today at 
http://webmail.netscape.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports Question

2001-02-21 Thread Carle, William T (Bill), NLCIO


I found a white paper out on metalink that is fairly decent. Right now, I'm
looking for an overview of what Oracle Reports does and what it is used for.


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Wednesday, February 21, 2001 8:41 AM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Oracle Reports Question

What do you want to know??  Oracle has some white paper stuff on technet.
If you want more technical stuff, there isn't much.

Dan

-Original Message-
Sent: Wednesday, February 21, 2001 9:16 AM
To: Multiple recipients of list ORACLE-L


Hi,

Can anyone point me to some good documentation on Oracle Reports?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

_
This message has been checked for all known viruses by UUNET delivered 
through the MessageLabs Virus Control Centre. For further information visit
http://www.uk.uu.net/products/security/virus/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports Question

2001-02-21 Thread Dasko, Dan


What do you want to know??  Oracle has some white paper stuff on technet.
If you want more technical stuff, there isn't much.

Dan

-Original Message-
Sent: Wednesday, February 21, 2001 9:16 AM
To: Multiple recipients of list ORACLE-L


Hi,

Can anyone point me to some good documentation on Oracle Reports?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

_
This message has been checked for all known viruses by UUNET delivered 
through the MessageLabs Virus Control Centre. For further information visit
http://www.uk.uu.net/products/security/virus/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Anyone use Oracle Reports?

2001-02-23 Thread Carle, William T (Bill), NLCIO


Hi,

Does anyone use the Oracle Reports product? Preferably on HP-UX? What do
you think of it? Do you need to purchase other products with it or does it
stand alone?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Subject: Oracle Reports Server?

2001-04-12 Thread Anubha Jalsingh


Ckeckout the showjobs option. It will display all reports ran by a report
server including other details like started and finished time etc.

HTH,
Manmohan.





___
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anubha Jalsingh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle reports 9i with 9i2

2003-07-28 Thread Nalla Ravi

HI ,

Please kindly share your experience or any known
issues with Oracle reports 9i  on oracle 9i2 Database
on SUN Solaries. We would like to move from 8.1.7 to
9i2 and from reports 6i to 9i.

OS: Sun solaris 8
DB : 8.1.7
Reports : 6i

To DB 9i2 and reports 9i.

with many thanks,
Ravi.

__
Yahoo! Plus - For a better Internet experience
http://uk.promotions.yahoo.com/yplus/yoffer.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  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).

Oracle Reports 6i Vs 9i

2002-08-19 Thread Loughmiller, Greg


Does anyone have an opinion as to which is easier to implement,
architecture, performance and development differences?

We are working on implementing on of these.. We have a standard on App
Servers and we need to consider the use of BEA/Iplanet and being used as a
proxy...

thanks!
Greg

Greg Loughmiller
Sr Manager - Enterprise Data Architecture
gloughmiller (IPS)
678.893.3217 (office)


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Loughmiller, Greg
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Anyone use Oracle Reports?

2001-02-23 Thread Dasko, Dan


Yes we do use Oracle Reports.  You can use it stand alone, but we enter
limit data for the reports via web forms and return the result via the web
so we also need a web server.  I'm looking into OAS but we currently use
IIS.

Dan

-Original Message-
Sent: Friday, February 23, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L


Hi,

Does anyone use the Oracle Reports product? Preferably on HP-UX? What do
you think of it? Do you need to purchase other products with it or does it
stand alone?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

_
This message has been checked for all known viruses by UUNET delivered 
through the MessageLabs Virus Control Centre. For further information visit
http://www.uk.uu.net/products/security/virus/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Anyone use Oracle Reports?

2001-02-23 Thread Miller, Jay


We use it on Solaris.  No real problems, though it's a little tricky to
learn.

Jay Miller
Sr. Oracle DBA

-Original Message-
Sent: Friday, February 23, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L


Hi,

Does anyone use the Oracle Reports product? Preferably on HP-UX? What do
you think of it? Do you need to purchase other products with it or does it
stand alone?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle Reports 6i Vs 9i

2002-08-19 Thread Charlie Mengler


IMO, 9iAS R2 is _OVERLY_ complex, complicated & confusing.
I was forced to using R2 because of a _BAD_ memory leak in
the f60webm executable in R1. Oracle Tech. Supp. for 9iAS 
R2 is poor to nonexistent.

My advice is to avoid 9iAS R2 if at all possible.

"Loughmiller, Greg" wrote:
> 
> Does anyone have an opinion as to which is easier to implement,
> architecture, performance and development differences?
> 
> We are working on implementing on of these.. We have a standard on App
> Servers and we need to consider the use of BEA/Iplanet and being used as a
> proxy...
> 
> thanks!
> Greg
> 
> Greg Loughmiller
> Sr Manager - Enterprise Data Architecture
> gloughmiller (IPS)
> 678.893.3217 (office)
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Loughmiller, Greg
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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).

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Lack of planning on your part doesn't constitute an emergency on my part!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Help in html Output from Oracle Reports...PLease

2002-11-20 Thread Kitty Luo



Hi,
I am having problem with html output from oracle reports.I have designed a
report which looks for *.jpg pictures location in the database and then from
physical location generate report as html.For this output itself converts
*.jpg to *.gif so the output comes with pictures but very shaded pictures
which is not acceptable.No problem with pdf output.If I can get some help
how to prevent report to convert .jpg to .gif or some other way to generate
a good html output.
Thanks in Advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kitty Luo
  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).

47 matches

Mail list logo