2 problems: Report formatting; and Enterprise Manager on Windows 2000

After installing Oracle Enterprise Edition, Release2 on Windows 2000, I've been beating my head against the wall trying to get Enterprise Manager to work. I keep getting "Unable to connect to the management server" error when trying to load the Enterpirse Manager Console. Then I saw this in the documentation:

"Oracle Enterprise Manager release 2.1 is not supported on Windows 2000. After certification is complete, a patch, if necessary, will be released that includes Windows 2000 support. "

Can anyone verify that this error is caused by a problem with the software and not something I screwed up?

Another unrelated problem...
Is there a way to handle selecting and manipulating text from a column when the text may contain a single quote?

I have a table of technical publications and manuals, and another table containing applicable changes and amendments (if any) to the publications. To print a list of Publications and Amendments (with Titles and Stock Numbers), I can use this query:

  1 SELECT P.TP_NBR, P.TITLE, P.STOCK_NUMBER,   2 A.AMEND_NBR, A.STOCK_NUMBER
  3 FROM TECH_PUB P, AMENDMENT A
  4 WHERE P.TP_KEY = A.TECH_PUB_ID(+)
  5* ORDER BY P.TP_NBR, A.AMEND_NBR; which gives me a report in this format:

TP_NBR TITLE                               STOCK_NUMBER     AMEND_NBR

------ ----------------------------------- ---- ----------- ---------
---- -----------
0001   BARGE INFORMATION BOOK              7610-01-P03-3530         1
7610-01-A01-3533
0001   BARGE INFORMATION BOOK              7610-01-P03-3530         2
7610-01-A02-3533
0001   BARGE INFORMATION BOOK              7610-01-P03-3530         3
7610-01-A03-3533
0001   BARGE INFORMATION BOOK              7610-01-P03-3530         4
7610-01-A04-3533
0002A  MACHINERY ALLOWANCE LIST, VOLUME I  7610-01-P03-3540         1
7610-01-A01-3543
0002A  MACHINERY ALLOWANCE LIST, VOLUME I  7610-01-P03-3540         2
7610-01-A02-3543
0002A  MACHINERY ALLOWANCE LIST, VOLUME I  7610-01-P03-3540         3
7610-01-A03-3543
0102   KIDDE FIRE EXTINGUISHING SYSTEM     7610-01-P02-6540
0112   LUBRICATION OIL SERVICE PUMP, MOD Z 7610-01-P02-1170

I want to improve the format, making it more readable and making room for a date column by listing the Title of each publication only once with it's Amendments under it. I almost had it by running a query to generate the code for another query. The first query concatenates the Publication number, title, date and stock number and writes the code to select this string along with the number, date, and stock number columns from the Amdndments table.
(This is a simplified approximation of the actual code.)

SET FEEDBACK OFF
SET DEFINE _at_ /* Because of ampersands in document titles */ SET NEWPAGE NONE
SET HEADING OFF SPOOL TmpTPRpt.sql
PROMPT SPOOL TPREPORT.TXT
SELECT 'SELECT', ''''|| RPAD(SUBSTR(TP_NBR,1,6),6) || ' ' || RPAD(SUBSTR(TITLE,1,50),50) || ' ' || RPAD(DECODE(ISS_DATE,NULL,' ',ISS_DATE),8)
|| ' ' || STOCK_NUMBER ||'''', 'FROM DUAL;', 'SELECT '' AMENDMENT # ''|| AMEND_NBR, ISSUE_DATE, STOCK_NUMBER FROM AMENDMENT WHERE TECH_PUB_ID = ', TP_KEY, 'ORDER BY AMEND_NBR;'
FROM TECH_PUB
ORDER BY TECH_PUB.TP_NBR;
PROMPT SPOOL OFF
SPOOL OFF
START TmpTPRpt.sql

which produces this code:

SPOOL TPREPORT.TXT
SELECT

'0001      BARGE INFORMATION BOOK
7610-01-P03-3530'      

and gives me this report format:
(I can't duplicate the format for the report here because of the font & formatting of this newsreader program, but this gives a rough idea if you are viewing with a fixed-pitch font.)

0001      BARGE INFORMATION BOOK 13-SEP-82  7610-01-P03-3530
          AMENDMENT # 1          28-MAR-84  7610-01-A01-3533
          AMENDMENT # 2          28-MAR-84  7610-01-A02-3533        
          AMENDMENT # 3          19-MAR-85  7610-01-A03-3533        
          AMENDMENT # 4          21-AUG-86  7610-01-A04-3533        
0002A     MACHINERY ALLOWANCE LIST, VOLUME I     
                                 12-FEB-87  7610-01-P03-3540        
          AMENDMENT # 1          16-APR-87  7610-01-A01-3543        
          AMENDMENT # 2                     7610-01-A02-3543        
          AMENDMENT # 3                     7610-01-A03-3543        
0002B     MACHINERY ALLOWANCE LIST, VOL II  7610-01-P04-9200  
          AMENDMENT # 1                     7610-01-A04-9201        
          AMENDMENT # 2                     7610-01-A04-9202        
0102      KIDDE FIRE EXTINGUISHING SYSTEM   7610-01-P02-6540        
0112      LUBRICATION OIL SERVICE PUMP      7610-01-P02-1170        
0113      DIESEL FUEL OIL SERVICE PUMP      7610-01-P02-6550        

which is fine EXCEPT that many of the Publication titles like these: MANUFACTURER'S INSTRUCTION BOOK - INDEX, NAVAL ENG MK-V, 26' MOTOR SURF BOAT (MSB)
contain a single quote used as an apostrophe or an abbreviation for "feet" which causes:

ERROR:
ORA-01756: quoted string not properly terminated

Does anyone know a way to handle this problem or a different way to produce the desired format? Thanks for any suggestions.

Jeff Beverly Received on Tue Dec 12 2000 - 05:13:13 CET