HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.oracle
From: smuench@oracle.com (Steven P. Muench)
Subject: Re: Oracle's 'Working...' Message - Can it be simulated?
Organization: Oracle Corp., Belmont CA
Date: Tue, 15 Dec 1992 08:41: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.

   >Has anyone ever tried to simulate the Oracle message 'Working...' which
   >is automatically displayed when committing a transaction (on a form)?
   >(Deleted...)
   >Thank you for suggestions.
   >-- 
   >Michael Kustermann        |  Der Vogel kaempft sich aus dem Ei.
   >Georgia Institute of Tech.|  Das Ei ist die Welt.
   >Atlanta, GA 30332         |  Wer geboren werden will muss eine
   >iadt3mk@prism.gatech.edu  |  Der Vogel fliegt zu Gott.  Gott ist Abraxas.


Forms 4.0 adds the optional parameter NO_ACKNOWLEDGE to the Message()
builtin procedure so that you can issue many messages that don't
require user acknowledgement, even from within the same trigger. We
also have a Clear_Message to programmatically clear the messaage line. 

        Message('Working...',NO_ACKNOWLEDGE);
        /*
        ** Do your thing here that's going to take
        ** a while...
        */
        Clear_Message;

In fact, you could devise a routine to display a working message
progress bar on the Message Line to show that a given percentage
(pct) of a task is completed...

	procedure show_status (pct number) is
	   str VARCHAR2(80); 
	   bl  NUMBER;
	   wh  NUMBER;
	begin
	   bl  := round(70*pct/100);
	   wh  := 70-bl;
	   str := 'Working ['||lpad('#',bl,'#')||lpad(' ',wh,' ')||']';
           message(str,no_acknowledge);
           synchronize;
        end;

A glimpse of the not-to-distant future. :-)

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  Steve Muench              Email: smuench@oracle.com
  SQL*Forms Development
  Product Manager
From: wwm@ef5003.efhd.ford.com (Bill Meahan)
Newsgroups: comp.databases.oracle
Subject: Explain THIS, please!
Date: Fri, 18 Dec 1992 20:42:01 GMT
Organization: Ford Motor Co., EFHD Ypsilanti Operations
Distribution: world
NNTP-Posting-Host: ef5003.efhd.ford.com

I'm tearing my hair out at the following:


SQL> l
  1  select '%' Shift,
  2   p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code PartNumber,
  3   s.scrap_code Reason,
  4   SUM(s.cost) TotalDollars
  5   FROM cimcmms.scrap_count_history s, acg.part p
  6   WHERE s.part_key=p.key
  7    AND s.work_center_code = '75021'
  8    AND s.production_date BETWEEN '1-Dec-92' AND '13-Dec-92'
  9    AND s.shift LIKE '%'
 10    AND s.part_key IN ( SELECT ss.part_key
 11       FROM cimcmms.scrap_count_history ss
 12       WHERE ss.work_center_code = '75021'
 13        AND ss.production_date BETWEEN '1-Dec-92' AND '13-Dec-92'
 14        AND ss.shift LIKE '%'
 15        AND ROWID <11
 16       GROUP BY ss.part_key
 17       ORDER BY SUM(ss.cost) desc )
 18   GROUP BY '%',
 19   p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code,
 20   s.scrap_code
 21   ORDER BY p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code,
 22*  SUM(s.cost) desc

SQL> /
     ORDER BY SUM(ss.cost) desc )
     *
ERROR at line 17: 
ORA-00907: missing right parenthesis 

SQL> spool off

There certainly AREN'T any mismatched parentheses!

Any ideas what is going on?

The sqlplus version is 3.0.12.1.1
The ORACLE version is 6.0.36.1.1
Computer is HP 9000/867  HP-UX 8.0

-- 
Bill Meahan			|EFHD Information Systems Staff
Plant Floor Systems Specialist	|Ford Motor Company
wwm@ef5003.efhd.ford.com      	| +1 313 487 6122
..!fmsrl7!pmsmam!wwm           |I'm not paid to speak for Ford!
From: mjw@mailbox.eng.ufl.edu (Mike Wohlgemuth)
Newsgroups: comp.databases.oracle
Subject: Help!!!  I can't figure this out!!!
Keywords: user exit, proc, adding records
Date: 18 Dec 92 21:57:45 GMT
Organization: Engineering Computing Services - Univ. of Fla.

I need to add multiple records to a block from a
user exit written in Pro*C.  Changing the values in
the current record is now problem, but I've RTFM'd
for too long, and I see absolutely now way to add
a new record from the user exit.  Please tell me I'm
missing something horribly obvious.  PLEASE!!!

Thanks
Mike
From: vqh@dwrock.att.com (Viet Q. Hoang)
Newsgroups: comp.databases.oracle
Subject: SQL*Net performance
Date: 15 Dec 92 16:40:24 GMT
Reply-To: vqh@dwrock.ATT.COM (Viet Q. Hoang)
Organization: AT&T Denver Works


I found some puzzling performance difference between using the
SQL*Net tcp/ip driver and the pipe driver.  We ran a little
sqlplus script that does a select on a large table, it runs at least
twice (usually 3 or more times) slower if we specify the T:xxx
compared to the pipe driver.  The amount of data returned by
the select statement was insignificant.  Since most of the work
is done in the oracle server side anyway, why would the connection
method matter?  Is there some kind of tuning I could do to improve
the sql*net performance?

Our environment: Oracle RDBMS 6.0.33.1.1 on Sun 4/470 running SunOS 4.1.1B

Viet Hoang
AT&T Denver Works
v.q.hoang@att.com
-- 

Viet Hoang
AT&T, Denver Works
v.q.hoang@att.com
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: SQL*Loader REALLY unique sequences
Date: 14 Dec 92 09:32:46 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1gacpnINNbjl@fmsrl5.srl.ford.com>, hugh@slee01.srl.ford.com (Hugh Fader) writes:
> I am developing a system which needs to append ASCII data into a table
> and generate a unique identifier for each new row. SQL*Loader has a
> SEQUENCE function which will generate unique sequence number, but the
> numbers will only be unique for a given SQL*Loader session, not for
> the destination table.
> 
> Can anybody offer a way to get SQL*Loader to give me a sequence number
> which is unique for the entire table?
> 
> Thanks in advance.
> 
> --
> Hugh Fader
> Ford Research Laboratory
> hugh@slee01.srl.ford.com
> 
You are on the right track with SEQUENCE, but you need to add the MAX
option.  Assume a target table TEST with columns SEQVAR NUMBER, VAR1 TEXT,
and VAR2 TEXT with values of
	
	      SEQVAR   VAR1    VAR2
	      ------   ----    ----	
		1	AAA	ZZZ
		2	BBB	YYY
		3	CCC	XXX

and an input ASCII table TEST.DAT with contents of

		ddd,www
		eee,vvv

to load these variables with correct sequence numbers, use

	load data
	infile test.dat
	into table test
	append
	fields terminated by ',' optionally enclosed by '"'
	(SEQVAR SEQUENCE(MAX, 1),   -- ***** here is the sequence needed ***
	 var1,
         var2)

The SEQUENCE(MAX, 1) function attached to SEQVAR variable tells Oracle to scan
the existing table for the maximum value and then increment all successive
entries by 1. Check pg 7-19 of the Utilities manual.

The basic function works great.  I have never tested to see what happens if you
have a rejected record.  That is, does Oracle assign a number and then reject
the record leaving a gap, or does it reject the record first leaving some
records without sequence numbers. My guess is that it is position dependent. 

  ---------------------------------------------------------------------------
  |      Frank Greene                  |          //////  //////             |
  |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
  |      Telephone [615] 458-6032      |          ////    ////  //////       |
  |      324 Ootsima Way               |         ////    ////    ////        |
  |      Loudon, TN 37774              |        //////  //////  //////       |
  ----------------------------------------------------------------------------
  |         Of course, any opinions or suggestions are strictly my own       |
  ----------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: fogelinc@nmr1.Cyanamid.COM (Carl Fogelin)
Subject: Re: Pro*C
Reply-To: fogelinc@nmr1.Cyanamid.COM
Organization: American Cyanamid Company
Date: Thu, 17 Dec 1992 22:08:04 GMT

In article 13161@den.mmc.com, richard@crowded-house.den.mmc.com (Richard Armstrong) writes:
>
>I have plenty of good things to say about Oracle Pro*C. However, let me
>focus on one area where I find Pro*C completely brain-dead.
>
[stuff deleted]
>
>Why doesn't the Pro*C precompiler do #define substitutions?

Because the scope of the Pro*C preprocessor would probably get out of hand.
Sure, it would be nice if the Pro*C preprocessor would at least recognize 
#defines which are at the top of the current module, but the c preprocessor
can be much more complicated.  What about #defines found in an #include file?
What about #defines which use conditional assignments (i.e., #ifdef)?  These
are just a couple of complications, but if you think about it, I'm sure you
can come up with more.

Yes, I agree that I wish Pro*C did the #define substitutions, but I understand
why they didn't do it.  What I don't understand is why "struct"ures are not
valid for host variables, but VARCHARs (which are structures) are...  8-(

-------------------------------------
Carl Fogelin (fogelinc@cyanamid.com) 


Newsgroups: comp.databases.oracle
From: lwk@engin.umich.edu (Lewis W Kellum)
Subject: OPS$LOGIN :security hole? 
Date: Wed, 16 Dec 92 12:45:15 EST
Organization: University of Michigan Engineering, Ann Arbor

In article <1992Dec15.144220.25349@relay.nswc.navy.mil> rlarson@nswc-wo.nswc.navy.mil (Ruth Larson) writes:
>
>Steve Schow writes:
>>We routinely use the OPS$LOGIN feature of Oracle for all of our users.  This
>>way they don't have to worry about anything once they are logged onto the
>>UNIX machine.  They just type program / to run it with their UNIX login info.
>
>>Question:  
>
>>When we create a new user as follows:
>
>>	grant connect to ops$user identified by bogus;
>
>>and we actually use the word 'bogus' as the oracle password.
>
>>Does this mean that user ops$user could login to Oracle with either
>>the /, which would use his UNIX login info, or with 'bogus' as the
>>password?
>
>Yes, this is EXACTLY the case.
>
>>Could a user go into sql*plus with any convienient name and type
>
>>	connect ops$user/bogus
>
>>to get into that user's oracle account
>
>Again, Yes.
>
>>We routinely use bogus to define new oracle users, but I am concerned about
>>security loop holes.  We also use a number of macintosh client products that
>>use the ops$user with the UNIX password to login.  I am beginning to think
>>that we should make sure that the Oracle password is the same as the UNIX
>>password and NOT use bogus for everyone?!@#%               
>
>I would NOT suggest making the Oracle password the same as the system password.
>In many systems the logon password should only be known by the individual
>user.  However, there's now need for *anyone* to have to know the ops$ password
>for an individual user - he/she doesn't need to know it, and the DBA can 
>always reset it without the user even being aware that it has been reset.
>So use something random, and different for each ops$ account.  I like to pick 
>a 3 or 4 digit (or larger) number and then spell it out in words.  Example: 
>two_thousand_three_hundred_eleven.  *Nobody* including you will remember 
>*that*, and it's pretty hard to guess!

Here's another question: If I know Mr.Schow's unix login id, and the internet 
hostname of his Oracle server, what keeps me from creating his login id
on my host and connecting to his ops$ oracle account?  - Woody Kellum
Newsgroups: comp.databases.oracle
From: aiko@opium.cs.odu.edu (John K Hayes)
Subject: Re: Question about OPS$LOGIN and Oracle Passwords
Organization: Old Dominion University, Norfolk, Va
Date: Wed, 16 Dec 1992 17:04:32 GMT

In article <1992Dec14.200952.22697@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>We routinely use the OPS$LOGIN feature of Oracle for all of our users.  This
>way they don't have to worry about anything once they are logged onto the
>UNIX machine.  They just type program / to run it with their UNIX login info.
>
>Question:  
>
>When we create a new user as follows:
>
>	grant connect to ops$user identified by bogus;
>
>and we actually use the word 'bogus' as the oracle password.
>
>Does this mean that user ops$user could login to Oracle with either
>the /, which would use his UNIX login info, or with 'bogus' as the
>password?

I believe what oracle does with the autologin feature is just use the current
user's operating system userid to come up with the ops$user account, then
automatically log into that account using whatever password you gave it,
i.e. - bogus.  It does not have anything to do with the operating system
account password.  You can't keep the two passwords the same, since your
oracle passwords probably never change but your operating system passwords
do change.  You would have to keep the two in synch every time one changes.
It's not really necessary anyway.  

Oracle *does* use the password you assigned in the grant, it just provides
it automatically.  You can log into someone else's oracle account by just
giving that password if you know it.  So, yes, someone could do this:

connect ops$dbauser/bogus

if the dba account is set up for autologin with a 'bogus' password.
Probably not such a good idea.  

What I do is make all accounts autologin, but assign a different password
for each one and the passwords never change.  No one ever needs to know
what their password is, and no one can log into anyone else's account
since they don't know what the oracle password is (unless, of course, they
know the person's operating system password and log into that).

john
-- 
    ---{john hayes}  OLDOMINISITY; Norfolk, Virginia USA
                     internet: aiko@cs.odu.edu
Newsgroups: comp.databases.oracle
From: prs9k@brain.med.virginia.edu (Phil Scarr)
Subject: SAS and Oracle
Followup-To: poster
Organization: Neuroclinical Trials Center, University of Virginia
Date: Thu, 17 Dec 1992 17:04:43 GMT

Does oracle include a feature to export SAS datasets?

	-Phil
-- 
PHIL SCARR        \      We are Microsoft...     /          (o) 804.243.0229
 University of    /     OS/2 is irrelevant.      \          (f) 804.243.0290
 Virginia,        \     UNIX is irrelevant.      /        prs9k@Virginia.EDU
 Neurosurgery     /     Openness is futile.      \     prs9k@Virginia.BITNET
 HP-UX is my life!\ Prepare to be assimilated... /   ...uunet!virginia!prs9k

Newsgroups: comp.databases.oracle
From: tssmith@netcom.com (Tim Smith)
Subject: Re: Julian to normal date.
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Sun, 13 Dec 1992 07:42:53 GMT

In article <1gav7fINNfpk@flop.ENGR.ORST.EDU> dewaler@prism.CS.ORST.EDU (Eric DeWald) writes:
>I am doing date conversions.
>I would like to know what is the best way to convert
>a Julian Date into a normal date.

Within ORACLE, it's easy.  For example, to *get* a Julian date, you
could do as the SQL Lang. Ref. Manual suggests, and say

SELECT TO_CHAR(TO_DATE('01-JAN-92', 'DD-MON-YY'), 'J') FROM dual

to get a Julian date of 2448623.

To convert that figure back into a "normal" date, simply do

SELECT TO_DATE(2448623, 'J') FROM dual

and you get a character string: 01-JAN-92.

There is one caveat though.  ORACLE's Julian dates might not be like
other Julian dates.  They'll work within ORACLE consistently, but they
might give errors if you use other commercial subroutines that convert
between Julian dates and our conventional BCE/CE (BC/AD) dates.

The reasons for this are esoteric.  The Julian epoch (starting point)
is usually set at January 1, 4713 BCE.  ORACLE sets it as Jan 1, 4712
BCE, as if there were a year 0 BCE (there isn't).

--Tim (tssmith@netcom.com)
From: dewaler@prism.CS.ORST.EDU (Eric DeWald)
Newsgroups: comp.databases.oracle
Subject: Julian to normal date.
Date: 11 Dec 92 20:55:11 GMT
Article-I.D.: flop.1gav7fINNfpk
Distribution: usa
Organization: CS Dept, Oregon State University
NNTP-Posting-Host: prism.cs.orst.edu


I am doing date conversions.
I would like to know what is the best way to convert
a Julian Date into a normal date.

Thank you in advance
dewaler@prism.cs.orst.edu
From: news@hrd769.brooks.af.mil (InterNet News)
Newsgroups: comp.databases.oracle
Subject: SQL*Net IP interface
Date: 14 Dec 1992 12:12:48 -0600
Organization: Armstrong Lab MIS, Brooks AFB TX
Distribution: world
NNTP-Posting-Host: hrd769.brooks.af.mil

  We are interested in several projects which require programs to have
direct access to data on our Vax to produce datafiles and graphs for use
in several different formats, and to be able to have the programs 'converse'
with the Vax's Oracle instances.  We have already determined that there are 
several products that will a) give us real pretty graphs that we can never
us again, and b) give us real neat flat ASCII/formatted files that we can suck
into PC applications.
  I want to make my graph program smarter than that.  I want to be able to
query a database, and based on the data there, query other tables in this (or
other) databases.  The key here is the kind of flexibility that the 'canned' 
approaches do not really give us.
  
  "So what is it you want?" you may well ask.

  I want to know about the hand-shaking that happens at the SQL*Net socket
level.  I can open socket 1525 from my PC and Unix programs, and read and write
to it.  The reason I want this is to avoid spending a lot of YOUR money 
buying 3000 copies of SQL*Net and associated software.

  Of course, if you would rather have us spend MILLIONS and MILLIONS of your
tax dollars, no doubt increasing the National Debt and ultimately cause ruin
for the American Economic System, we will buy those products.

 (just kidding...)

  Is there an FTPable document that describes the various posers and 
responses at the socket level, I would appreciate hearing about it.

TSgt Dave Burgess
NCOIC, AL/Management Information Systems office
Brooks AFB, TX
Newsgroups: comp.databases.oracle
From: bhc@dirac.i-kinetics.com (Bruce Cottman)
Subject: Re: SQL*Net IP interface
Reply-To: bhc@i-kinetics.com
Organization: I-Kinetics, Inc., Cambridge, MA USA
Date: Tue, 15 Dec 1992 14:30:42 GMT

IMHO, you are seeking the wrong solution, but...
Start at the source.  
(1) Build your own Oracle gateway for the server machine
using Oracle Call Interface API and Unix sockets library.
(2) For PC, buy one (1) Socket API for TCP/IP and deploy.

- Bruce Cottman
From: pytlik@ra.cs.umb.edu (Marek Pytlik)
Newsgroups: comp.databases.oracle
Subject: Re: SQR and SQR Gossip
Date: 14 Dec 92 16:38:21 GMT
Organization: University of Massachusetts at Boston, Dept of Math and CS

In article <kc1mVB1w164w@cellar.org> kml@cellar.org (Scott Tiger) writes:
>pytlik@ra.cs.umb.edu (Marek Pytlik) writes:
>> I think that Sybase (SQR parent comp) announced that they would not support
>> SQL Report on Oracle 7 and up.  So it seems that SQR Report was JARW ( Just
>> Aother Report Writer). Tired of that?  Build C++ classes around your data bas
>> and do your reporting that way.
>
>How many times does SQL*Solutions/Sybase have to say they're going to 
>support Oracle 7 before you listen?  They've built the best report writer
>I've ever used for Oracle,and it works with the V7 Development Releases
>I've seen.  Anybody have the official SQR press release on this lying
>around?
>
>  Hofstadter's contracrostipunctus acrostically backwards spells 'J.S. Bach'
>                  Something constructive should come here.
>  kml%cellar@tredysvr.tredydev.unisys.com - My other account is a Mercedes.

In Oracle User Resource, September 1992, number 5, on pages 6 and 7 there 
is an article by Dale Lowery on the subject.  The publisher of the newsletter's
address is : Adirondak Information Resources, 1173A Second Ave. Suite 338,
NYC 10021, (212) 518 6487.

Mark
Newsgroups: comp.databases.oracle
From: jyanowit@mtholyoke.edu (Jason Yanowitz)
Subject: Good windows front-ends?
Organization: Mount Holyoke College
Date: Fri, 18 Dec 1992 21:31:50 GMT

I was wondering if people could tell me their impressions/reviews of various
windows programs that access Oracle databases (InfoPublisher, etc...).
I'm interested in all products that meet this description, and would ask
that mail be diretoed to my mailbox (jyanowitz@hamp.hampshire.edu) and then
I can summarize to the net if there seems to be such a demand.


Thanks you, and any little review helps (even just a few lines),
Jason
(this account forwards tojyanowitz@hamp.hampshire.edu)

-- 

jason
(thhis account forwards to jyanowitz@hamp.hampshire.edu)
Newsgroups: comp.databases.oracle
From: pauck@mcshh.Hanse.DE (Marco Pauck)
Subject: Re: Oracle Card
Organization: Point of Presence & MCS Hamburg
Date: Sun, 13 Dec 1992 22:59:51 GMT

phillip@kraken.itc.gu.edu.au (Phillip Jones) writes:
>Has anyone used Oracle Card for either the Macintosh or the IBM PC with
>windows. If so could you please post details about how easy to use this
>product is and what sort of speeds have been obtained when in us. 

I tried Oracle Card and got mixed impressions. I like the basic
philosophy but there are a lot of quirks which prevent one from building
"real world" applications. The user interface is awful and the speed
is unacceptable (at least for me).

Oracle Card is based on the HyperCard clone Spinnaker PLUS with the
addition of interface code to Oracle Access (contained in a DLL)
and some Oracle Talk scripts. In my opinion, most of the problems are
in the underlying PLUS.

I would like to see a new improved version of Oracle Card which would
be a really nice prototyping tool. There is a rumor that a new version
will be released beginning next year.

	Marco
-- 
Marco Pauck - WMD GmbH Hamburg, Germany
e-mail: pauck@wmdhh.wmd.de, phone: +49-40-58958-120, fax: +49-40-58958-199
I think I've got the hang of it now .... :w :q :wq :wq! ^d exit logout bye quit
CtrlAltDel ^[zz ^[ZZ ZZZZ ^X^C ^H ^@ ^L ^[c ^X ^Q^Q^Q ^T ^V ^D ^d ^C ^c ? help
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: PrePrinted Forms
Date: 17 Dec 92 13:21:07 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In our applicataion, we need to develop a series of output products
that will utilize pre-printed, multipart, pin fed forms.  Any suggestions
as to the best method to utilize to properly format the output?  Any 
preferred products?  My initial thought is to utilize RPT, but hope there
is something better available.

I will summarize any and all replies.
Newsgroups: comp.databases
From: alliso@david.wheaton.edu (Bryan Allison)
Subject: Resources for Paradox info
Organization: Wheaton College, IL
Distribution: usa
Date: Mon, 14 Dec 1992 20:31:17 GMT

	Just wondering if anyone can tell me some good resources
about paradox 3.5 and 4.0.  Books, BBS's, generic libraries with
documentation explaining the code, etc....

Thanks,
Bryan Allison
Newsgroups: comp.databases