HDTenEightyP/NetNews huggingface dataset:
From: nolan@tssi.com (Michael Nolan)
Subject: Re: FOXPRO: Is there any E-mail servers or support?
Keywords: Foxpro Database ibm pc relational
Reply-To: nolan@tssi.com
Organization: Tailored Software Services, Inc.
Date: Wed, 14 Oct 1992 15:44:53 GMT

durai@ORTTA (Appadurai V.) writes:

>In article <s7aksB11w165w@slic.cts.com> mikey@slic.cts.com (Mike Shirley) writes:

>>I've looked around and haven't found an E-mail list for support
>>of FoxPro or Foxbase.  Do any exist?  If not, is anyone using
>>Foxpro and would like to join or start an E-Mail group on this
>>subject?

>>--
>>     Mike, WB6WUI   //   INET:  mikey@slic.cts.com   //   GEnie: SLIC

>I have not come across any e-mail list for support  (of course, compuserve 
>is different..)

>I tried to start a foxpro user discussion list some time ago, but gave it up 
>coz' of lukewarm response.

>I agree.  That should not deter us.  If you intend setting up some kind of 
>list, I am in.

There is a list for foxpro2, but it has not been very active lately.
The latest message was posted in August.  I've included it below, it 
includes the administrative address for the FoxPro list.

>From helios!Princeton.EDU!foxpro%dworkin Sat Aug 29 14:12:46 1992
>Subject: FoxPro's e-mail tech. support (fwd)
>Date: Sat, 29 Aug 92 13:29:22 EDT
>
>Hi all,
>
>A while ago, another user of this mailing list (Andrew Dent)
>posted a set of Internet addresses for Fox's tech. support people
>(they're actually using CompuServe).  Anyways, I had been using
>one of the addresses for a while, and did, in fact, reach tech.
>support.  However, I tried this again recently, and had no success..
>
>Does anyone know what happened?  I've sent a couple of messages to a
>couple of different people in their tech. support dept. (addresses
>supplied by above), and had absolutely no reply.  Weird stuff..
>
>Idan
>---------------------------------------------------------------------------
>shoham@enel.ucalgary.ca
>
>===========================================================================
>       Distributed via the FoxPro Mailing List - Lawrenceville, NJ
>Submissions: foxpro@Amber.mccc.edu  Info/Admin : foxpro_info@Amber.mccc.edu

I would guess that Fox Software's CompuServe address isn't being
used anymore, now that Microsoft is handling tech support.  The last I
heard, they were still planning on maintaining the CIS forum, although
I suspect Microsoft would prefer support moved over to the Knowledge Base.

In the total absence of any word from Microsoft about the multi-user or LAN
versions, I have basically abandoned FoxPro 2 anyway, and will probably
be switching to Oracle or Progress on a unix platform.
---
Michael Nolan, nolan@tssi.com      "Freedom of the press is still alive in    
Tailored Software Services, Inc.    America, at the U. S. Mint"  (Gallagher)   
Lincoln, Nebraska (402) 423-1490  
Newsgroups: comp.databases.oracle,comp.databases.sybase,comp.databases.ingres
From: troy@cbme.unsw.EDU.AU (Troy Rollo)
Subject: Re: Adding an exact equality operator to SQL based product
Organization: University of New South Wales
Date: Sat, 17 Oct 1992 00:02:44 GMT

From article <1992Oct15.195210.26532@smartstar.com>, by frank@smartstar.com (Frank Dziuba):
> 
> We have a 4gl product which is closely tied to SQL. Because of this,
> the 4gl string comparison operator ("=") ignores trailing blanks  when comparing
> 2 strings. 

The exact operation of the "=" operator in the case of trailing blanks
varies between implimentations, so assuming that "=" will ignore trailing
spaces is risky. Sybase will ignore trailing space, Gupta and Oracle
will not.
--
__________________________________________________________________________
troy@cbme.unsw.EDU.AU	Overworked, overcommited and always multitasking.
Newsgroups: comp.databases.oracle
From: johnh@nnshh127.uucp (John Hawkins)
Subject: SQL*Forms 3.0 - Hitting <Return> in Host Calls.
Organization: Northern Telecom Inc., Nashville, TN
  
     In Forms under Unix (HP-UX) platform, if we have a host() call to execute 
  something in the OS, after executing that command, the control comes back to 
  the Screen. But, at this time, it displays a (OK) to continue.. message at 
  the bottom, and the user has to hit the <Return> key or the 'O' key to 
  continue. This happens even when the option 'no_screen' is provided in the 
  host() command. 
  
    In some of the programs, there are several host calls and the user has to
  hit the key whenever there is a host call. 
Distribution: usa
Date: Thu, 15 Oct 1992 22:42:44 GMT

    Any Solutions to avoid this (OK) message...?  

    Thanks in advance.

	    - Naga Rajan.  
-- 
John Hawkins       }) #define disclaimer(x) fprintf(stderr," x\n");
Northern Telecom   }) Communication: Voice 615 734 4468   /* Able was I ere */
200 Athens Way     {)                Fax   615 734 4771   /* I saw Elba     */
Nashville TN 37728 {) Internet:  nvjhh01@NT.COM           /* Columbus ~1492 */
Newsgroups: comp.databases.oracle
From: rz34@rz.uni-karlsruhe.de (Schillinger)
Subject: Re: Oracle Motif SQLFORMS 30 Font Help!!!
Organization: University of Karlsruhe, Germany
Date: Mon, 12 Oct 1992 07:54:05 GMT

In article <41680@gremlin.nrtc.northrop.com>, kkeller@cam.nad.northrop.com writes:
|> 
|> I was wondering if there are any users of Oracle Forms30 using the
|> Motif version (msqlforms30) if so I need help ASAP.
|> 
|> I have an application that was developed on an HP9000 Series400
|> workstation under hpux 7.05. I updated the operating system to
|> hpux8.0 and loaded my Oracle database and apps backon from tape.
|> 
|> I have this form that was designed so that the whole form is visable
|> on the screen at once without any scrolling.  Now when I load my
|> form after the os upgrade my static fonts and Lines are larger and
|> will not scale down so my form is now larger that the display
|> screen.  These fonts are the text that is created in the screen
|> painter under the designer mode of forms. The fields that you type
|> data into are just fine. 
|> 
|> I put the Orakit.color file into /usr/lib/X11/apps-defaults
|> directory and changed the Orakit*fontName: some other font
|> and the fontList to a smaller font size but the static font
|> (boiler plate) will not change.
|> 
|> Does anyone have a suggestion?
|> 
|> kkeller@cam.nad.northrop.com

Do you have a copy of Orakit in the directory from which you call Forms?
We had the same problem and then realized Orakit must be there, like
.profile.  Each user who wants to use msqlforms30 must have a copy of
Orakit in his/her directory as well.

Hope this helps.

Karen

Newsgroups: comp.databases.oracle
From: u6p86@space.link.com (Susan A Lewis)
Subject: Technical Bulletin 101451.515 wrap.c long field code
Followup-To: u6p86@lfhs2.hso.link.com
Keywords: long fields, wrap.c 101451.515
Organization: CAE-Link, Houston, TX
Date: Mon, 12 Oct 1992 14:42:43 GMT


We are running Oracle Version 6.0.33 on Solbournes connected with NFS from
Servers to clients.  Our user requested a workaround to output longfields
using sqlreport.  Long fields are truncated.  Oracle sent us the code wrap.pc 
documented in Technical Bulletin 101451.515.  

Has anyone incorporated this code into their sqlrep?  We have found 
several errors in use of 'c' functions memset & strlen.  

Has anyone else written any code to manipulate longfields with report
writer?

-- 
                CAE-Link, Houston                       2224 Bay Area Blvd.
                                                        Houston, TX  77058
                 Susan Lewis                            Ph  713-280-4420
                 u6p86@lfhs2.hso.link.com               Fax 713-280-4083
Newsgroups: comp.databases.oracle
From: hhescock@nrchh131.RICH.nt.com (Halayn Hescock)
Subject: Re: Force TO_CHAR to eliminate the leading blank during display
Followup-To: loffredo@nprdc.navy.mil (Rick Loffredo)
Organization: Northern Telecom
Date: Wed, 14 Oct 1992 13:28:58 GMT


Try to use '||' (concatenation) between the elements.

Halayn Hescock
From: kkeller@cam.nad.northrop.com
Newsgroups: comp.databases.oracle
Subject: Oracle Motif SQLFORMS 30 Font Help!!!
Date: 9 Oct 92 15:45:49 GMT
Organization: Northrop Aircraft Division - Operations Productivity, Hawthorne, CA


I was wondering if there are any users of Oracle Forms30 using the
Motif version (msqlforms30) if so I need help ASAP.

I have an application that was developed on an HP9000 Series400
workstation under hpux 7.05. I updated the operating system to
hpux8.0 and loaded my Oracle database and apps backon from tape.

I have this form that was designed so that the whole form is visable
on the screen at once without any scrolling.  Now when I load my
form after the os upgrade my static fonts and Lines are larger and
will not scale down so my form is now larger that the display
screen.  These fonts are the text that is created in the screen
painter under the designer mode of forms. The fields that you type
data into are just fine. 

I put the Orakit.color file into /usr/lib/X11/apps-defaults
directory and changed the Orakit*fontName: some other font
and the fontList to a smaller font size but the static font
(boiler plate) will not change.

Does anyone have a suggestion?

kkeller@cam.nad.northrop.com
From: rwm26@cas.org (Ron McCamish)
Newsgroups: comp.databases.oracle
Subject: blank truncation on INSERTs
Keywords: Pro*C, dynamic
Date: 8 Oct 92 20:09:41 GMT
Reply-To: rwm26@cas.org
Organization: Chemical Abstracts Service


  I'm having a problem INSERTing fields using Pro*C 1.3 and dynamic sql,
 method 4.  If I try to insert a field with 1 or more blanks at the
 end, ORACLE seems to truncate the blanks.

  For example, in sql*plus,

      INSERT INTO CRAP(CRAP1, CRAP2) VALUES('XXXX ', 'XXX  ');

  yields via SELECT LENGTH(CRAP1), CRAP1, LENGTH(CRAP2), CRAP2 FROM CRAP;

	  5 XXXX              5 XXX

  so the blanks are there!

 But, if I mimic the same INSERT in Pro*C, dynamic SQL method 4, I get the
 follow after the dynamic INSERT (using via the same SELECT above):

	  4 XXXX              3 XXX

 And if I code the same INSERT in regular Pro*C, I get the same results
 as using sql*plus.  So it seems like the problem lies in dynamic sql.

 I used the following driver to prove the dynamic SQL problem:

-------------------------------------------------------------

#include <stdio.h>
#define MAXMSG 200

EXEC SQL BEGIN DECLARE SECTION;
   static char auto_log = '/';           /* Oracle automatic logon */
   VARCHAR statement[240];
EXEC SQL END DECLARE SECTION;
EXEC SQL INCLUDE SQLCA;
EXEC SQL INCLUDE SQLDA;
SQLDA  *bind_dp;
SQLDA  *select_dp;
extern SQLDA *sqlald();

int main()
{
   char msg_buf[MAXMSG];                  /* contains error message   */
   int  msg_buf_size = MAXMSG;            /* size of error msg buffer */
   int  err_msg_len;                      /* actual size of error msg */

   EXEC SQL WHENEVER SQLERROR GOTO errexit;
   EXEC SQL WHENEVER SQLWARNING GOTO errexit;
   EXEC SQL WHENEVER NOT FOUND continue;
   EXEC SQL CONNECT :auto_log;

   bind_dp = sqlald(40,30,30);
   bind_dp->N=40;
   select_dp = sqlald(40,30,30);
   select_dp->N=40;

   strcpy(statement.arr,"INSERT INTO CRAP(CRAP1, CRAP2) VALUES(:B0,:B1)");
   statement.len = strlen(statement.arr);
   fprintf(stderr, "%s\n", statement.arr);
   fprintf(stderr, "%d\n", statement.len);

   EXEC SQL PREPARE S FROM :statement;
   EXEC SQL DECLARE C CURSOR FOR S;
   EXEC SQL DESCRIBE BIND VARIABLES FOR S INTO bind_dp;

   bind_dp->N=bind_dp->F;
   bind_dp->L[0]=4;
   bind_dp->L[1]=5;
   bind_dp->V[0]="XXXX ";
   bind_dp->V[1]="XXX  ";
   bind_dp->I[0]=0;
   bind_dp->I[1]=0;
   bind_dp->T[0]=1;
   bind_dp->T[1]=1;

   EXEC SQL OPEN C USING DESCRIPTOR bind_dp;
   EXEC SQL CLOSE C;
   EXEC SQL COMMIT WORK RELEASE;
   exit(0);

errexit:
   sqlglm(msg_buf, &msg_buf_size, &err_msg_len);
   fprintf(stderr,"\n %.*s \n", err_msg_len, msg_buf);
   exit(-1);
}

-------------------------------------------------------------

   This problem occurs in some very nasty application code where we
 were splitting up long fields in a table where a LONG already existed.
 The split occurred at a blank and the blank was not written to the
 database.  On retrieval, everything was messed up.

 help!

 ron....

Ron McCamish
BITNET: rwm26@cas.bitnet
UUCP:   ...!osu-cis!chemabs!rwm26
INET:   rwm26@cas.org
Newsgroups: comp.databases.oracle
From: alexbr@Xenon.Stanford.EDU (Alexander M. Brousilovsky)
Subject: ORACLE cardinality
Originator: alexbr@Xenon.Stanford.EDU
Organization: Computer Science Department, Stanford University.
Distribution: na
Date: Thu, 15 Oct 1992 21:36:41 GMT

Hello, friends,

Does somebody know how to find the cardinality of the relation
without actually counting it in ORACLE database?

Thank you.

Alex.

alexbr@cs.stanford.edu
Newsgroups: comp.databases.oracle
From: rhari@us.oracle.com
Subject: Re: Pro*C vs. Oracle Call Interface...
Organization: Oracle Corporation, USA
Date: Fri, 16 Oct 1992 20:54:32 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <DAVE.92Oct16094957@gough.GoldCoast.co.jp>, dave@gough.GoldCoast.co.jp (Dave Madden) writes:

> Pro*C manual (although they are still in the library and my programs
> still work).

There is a separate manual for OCI now.

Radhakrishna Hari
rhari@us.oracle.com
Newsgroups: comp.databases.oracle
From: kpalm@athena.qualcomm.com (Kent Palm)
Subject: Re: the ultimate oracle machine ?
Keywords: machine architecture bus disk performance oracle dbms
Organization: Qualcomm, Inc., San Diego, CA
Date: Fri, 9 Oct 1992 21:15:52 GMT

We run on a Solbourne multiprocessor.  Fast.  Reliable.  The company is
now focused on an Application Optimized Architecture with Oracle
Financials as their first target application.  Basically, they are
making their box scream - multiple Series 6 CPUs with on-board cache
(instructions and data), 1gb memory boards, mass storage subsystem
optimized for symmetric multiprocessing.
Newsgroups: comp.databases.oracle
From: marten@ilt.fhg.de (Lutz Marten)
Subject: How to get VMS logicals or symbols into SQL*forms 3.0 
Keywords: VMS SQL*forms
Reply-To: marten@ilt.fhg.de
Organization: FhG-ILT
Date: Thu, 15 Oct 92 14:47:42 GMT


Hello,
is there any possibility to read VMS logicals or symbols from a SQL*forms 3.0 trigger ?
ThanX !
--
# Lutz Marten,  Postmaster and general dogsbody 
# Fraunhofer-Gesellschaft Institut fuer Lasertechnik 
# BITNET: KQ040MA@DACTH11 , InterNet: marten@ilt.fhg.de                        
# HEPNET: 13533::52714::MARTEN, Phone: +49/241/8906-112, -0

Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: Re: orasrv: server already running: Address already in use
Organization: Colonial Mutual Group 
Date: Tue, 13 Oct 1992 03:11:55 GMT

In article <1992Oct1.114352.1@us.oracle.com>, sstephen@us.oracle.com writes:
> In article <peter.717868592@merlin>, peter.steele@acadiau.ca (Peter Steele)
writes:
> > This error occurs when orasrv, the oracle kernel daemon, is
> > shutdown and the restart command is issued to soon after the
> > shutdown. Waiting a couple of minutes usually solves the problem.
> > However, we occasional get a situation where orasrv gets confused
> > and will issue this error indefinitely. The only way we've discovered
> > to clear this error is by rebooting, which isn't desirable on
> > a production machine.
> > 
> > Has anyone seen this error, where Oracle gets confused and won't
> > let you restart orasrv?
> > --
> > Peter Steele        Unix Services Manager		peter.steele@acadiau.ca 
> > Acadia Univ., Wolfville, NS, Canada B0P 1X0  902-542-2201  Fax: 902-542-4364
> 
> Killing the orasrv process seems to fix this problem, especially on ICL and NCR
> ports.  It happens less and less in each release.  I believe in orasrv 1.2.7,
> this problem is almost non-existent.
> 

I missed the initial posting on this topic but I think I know the issue.
Please pardon me if it is not,  so here goes.

The following situation I am about to describe is for UNIX boxes.   If you are
unable to restart/shudown your orasrv, there are a number of things you could
do.

1.  tcpctl stat
    Find out if there are any active connections?  If there are, log
    them out or kill the unix server connection process .  How do you
    find them?

2.  grep oracle /etc/services
    Get the socket number.  This is normally 1525.

3.   netstat -A |grep 1525
     Get all processes associated with the Oracle socket,1525

PCB      Proto Recv-Q Send-Q  Local Address      Foreign Address (state)
fface20c tcp        0      0  redbaron.1714      biggles.1525    ESTABLISHED
ffa9d60c tcp        0      0  redbaron.1525      biggles.4847    ESTABLISHED
ffa7ae8c tcp        0      0  redbaron.1052      biggles.1525    ESTABLISHED

4.  ofiles -n PCB_number
    This is the difficult part.  You now need to find out the UNIX
    process that is attached to the socket.  There is a public domain
    program called, ofiles that can do this.  Basically it looks at the
    protocol control block (PCB) and maps that to a UNIX process.  You
    will get a PID from ofiles.

5.  kill PID
    Once you have the PID, you may kill it.

6.  Try using tcpctl again

The problem is normally associated with PC-Client processes that switch off
their PC or reboot them while connected a server database.  I hope this
sheds some light.


-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
From: kmallory@oracle.com (Kevin Mallory)
Newsgroups: comp.databases.oracle
Subject: Re: Forms 4.0
Date: 8 Oct 92 23:13:51 GMT
Organization: Oracle Corp., Belmont CA
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.



>   Forms 4.0 for character mode is in Beta mode and should be out in the next6
>   months.  At the IOUW, San Francisco, they were pushing this product quite a
>   fair bit. 

	I think you mean SQL*Reportwriter V2. Forms 4.0 is NOT in beta
on ANY platform (character mode or otherwise) at this point.  We are
in alpha which includes both character mode and bitmap runform (aka
runform/runmenu) as well as a bitmap designer (you use the same
designer for both forms and menus).  The character mode designer will
be available at Beta.

>   I was fortunate enough to see the latest version of Forms 4.0 (bitmap) at 
>   Oracle, Redwood Shores.  It is very flexible and 'flash'.  The bitmap version
>   is in Alpha state and the word is, they are not intending to release it in the
>   next 6-9 months.  If it is as good as they make it out to be, then it will be
>   worth the wait.


	As I said before, we were demoing the Alpha version of forms
4.0 (bitmap and character mode) at IOUW on VMS, SUN, Windows 3.1 and
Macintosh.



--
---------------
Kevin Mallory	Oracle Corporation - Redwood Shores, California
SQL*Forms Development
I don't speak for Oracle, nor they for me.
Remember: If you can find someplace you laik better 'n' Tuna... **MOVE**!
Xref: sparky comp.databases.oracle:1824 comp.databases.sybase:128 comp.databases.informix:2163
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Newsgroups: comp.databases.oracle,comp.databases.sybase,comp.databases.ingress,comp.databases.informix
Subject: Did you use E-R modelling for your database design ?
Date: 13 Oct 92 19:56:16 GMT
Organization: Intel Corporation, Santa Clara, CA USA

Hi

I would like to know if you used E-R modelling  (Entity relationship) modelling
for your organizations database design. 

Specifically I would be interested in
1. Did you use E-R modelling for database design project
2. How big was the result (Approx no of tables  20,50,150 etc)
3. Did you use any software for designing the database. (to generate schema)
4. Are you aware of any company that has a business of database design ?
   (NOT programming etc but exclusively information modelling and giving
    you generated schema and all the documentation.)

    I do not want to know the products, or product development company
    but the consulting company which uses some of these products and give
    you the design.
5. did you really benefit from such design efforts ?

regards,

Aniruddha Kortikar (kortikar@mipos2.intel.com)

-------------------------------------------------------------------------------
E-mail 	: kortikar@mipos2.intel.com | for every action there is an 
Phone(W): 408 765 5515              | equal and opposite government program.
-------------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: "daniel snoddy" <daniel.snoddy@canrem.com>
Subject: oci and microsoft c7
Reply-To: "daniel snoddy" <daniel.snoddy@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 7 Oct 92 23:24:22 EST

Is anyone using the OCI and Microsoft C7.  I've written a DLL to let
Visual Basic talk to Oracle using QuickC/Win.  I'm having trouble
getting some of the OCI calls to function when I recompile in C7.

Thanks.

--- via Silver Xpress V3.00
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
From: sharmp@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Re: ORACLE exports
Date: 8 Oct 92 00:54:46 +1000
Organization: Aust. Dept. Health, Housing and Community Services

In article <1992Oct7.000919.947@cerberus.bhpese.oz.au>, brad@cerberus.bhpese.oz.au (Brad Keifer) writes:
> Is there a limit on the number of tables that can be specified to export
> when performing an export from ORACLE areas?
> I have discovered a problem with some exports that I was automatically
> performing.
> The ORACLE version is 6.0.31.0.1, running on an RS/6000 AIX Version 3.2.
> I have an sql script that generates a "PARFILE" that contains a file name to
> store the export in, followed by a series of table names. I have found
> that only the first 98 tables actually get exported. The export routine
> does not indicate an error, in fact it says that the export terminated
> successfully.
> -- 
Don't know about the number of tables but I know that one of our DBA's in
Queensland ran into similar problems when his parfile had approximately 200
users. Split into 2 parfiles, it worked fine (using Oracle 6.0.34 on VMS 5.5). 
Perhaps there is a generic problem using big parfiles like this?  By the way,
wouldn't it be easier to export by owner, if all these tables are owned by one
user?


Regards

Peter
Newsgroups: comp.databases.oracle
From: sstephen@us.oracle.com
Subject: Re: Force TO_CHAR to eliminate the leading blank during display
Organization: Oracle Corporation, USA
Distribution: usa
Date: Wed, 14 Oct 1992 21:59:45 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <38330@arctic.nprdc.navy.mil>, loffredo@nprdc.navy.mil (Rick Loffredo) writes:
> I wrote a small SQLPLUS script to convert the Oracle data to an ASCII file.
> As you can see from the script, I had 1 numeric field in the table.  In 
> addition, I also put out 4 '|'s as field delimiters.  QUESTION: How come there
> is alwayw an extra blank preceeding the numeric field (Argument_Number), even 
> though I explicitly set "space 0", and provided the TO_CHAR function with a
> format of '09'.
> 
(SQL*Plus script deleted)

I had always assumed that the leading space was a "place holder" for the
"sign".  If you try the same TO_CHAR on negative numbers, you get no leading
spaces, only a leading "-".  I guess this makes it easier if you don't want a
sign, (just truncate the first character, ALWAYS).  If they had stripped off
the leading blanks, you would have to truncate if negative...  You can move the
space around, though : 09MI would give you |01 |, 09PR would give you | 01 |.


-- 
================================================================================
Scott Stephens				inet:	sstephen.us.oracle.com
Oracle WorldWide Support                Redwood City, California