HDTenEightyP/NetNews huggingface dataset:
From: euajhs@eua.ericsson.se (Jonas Hansson)
Subject: NumLock in OPEN-LOOK
Reply-To: euajhs@eua.ericsson.se
Organization: Ellemtel Telecom Systems Labs, Stockholm, Sweden
Date: Tue, 15 Dec 1992 17:52:06 GMT

We are running on a SUN/UNIX platform OS 4.1.3 whith ORACLE RDBMS 6.0.36 and 
FORMS 3.0.16. In one of our departments we try to develop SQL*Forms applications
in a bit-mapped environment. This have caused some problems for us. At the moment 
there is a problem with the keypad. When pressing NumLock key we get the message

"You pressed an undefined function key".

If you know something about this problem or how we solve it, please mail

Jonas Hansson
Ellemtel Telecommunication Systems Labaratories      Mail: euajhs@eua.ericsson.se
From: sjs@netcom.com (Stephen Schow)
Newsgroups: comp.databases.oracle
Subject: Question about OPS$LOGIN and Oracle Passwords
Date: 14 Dec 92 20:09:52 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

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?

Could a user go into sql*plus with any convienient name and type

	connect ops$user/bogus

to get into that user's oracle accoun

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?!@#$%^

help!
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: cdm@pmafire.inel.gov (Dale Cook)
Date: Thu, 17 Dec 92 22:20:51 GMT
Organization: WINCO
Subject: Re: OPS$LOGIN :security hole?
Summary: 
Followup-To: 
Organization: WINCO
Keywords: 

In article <1992Dec17.184923.24754@ncsa.uiuc.edu> jfedorko@ncsa.uiuc.edu (Joel Fedorko) writes:
>Dale, I beg to differ with your differing....
>      ORASRV_PROXY_LOGIN=NO
>... in config.ora in ora_sqlnet .

OK, but the fellow I was replying to made it sound like there was NO WAY
to use OPS$ logins over the net without supplying a password.  That is
considerably different that saying it's a configurable parameter.
--------------------------------------------------------------------------
...Dale Cook    "I don't much care how a man prays -- there's plenty of
                 room in hell for all of us."  --- "Mad Jack" Duncan
The opinions are mine only (i.e., they are NOT my employer's)
--------------------------------------------------------------------------
From: lev@ipxed5.nswses.navy.mil (Lloyd E Vancil)
Newsgroups: comp.databases.oracle
Subject: Re: mapping keyboard in xterm
Date: 16 Dec 92 22:54:34 GMT
Organization: NSWSES, Port Hueneme, CA

In article <1992Dec15.135039.8523@eua.ericsson.se> euajhs@eua.ericsson.se writes:
>
>We are running on a SUN/UNIX platform OS 4.1.3 whith ORACLE RDBMS 6.0.36 and 
>FORMS 3.0.16. We are using shelltool as user interface to forms, but looking for
>a better graphical interface. Now we try to use Xterm instead, but there is some
>problems whit the keypad. If you have experience on mapping keyboards in Xterm
>ore solve the problem with toggling numeric keypad on/off. please mail.
>
>
>Jonas Hansson
>Ellemtel Telecommunication Systems Labaratories      Mail: euajhs@eua.ericsson.se


1. start your xterm with -sf as:
 xterm -sf -fn courier18 -fb courier-bold18 -cr red -fg ivory -bg
 black -T "SQL*Plus" -e frm30

       -fn sets the font normal
       -fb sets the font bold
       -cr sets the cusor color
       -bg sets the bacground color
       -fg set the forgound(type) color
        -T sets the title
	-e executes the script frm30 

 Script frm30

 #! /bin/csh -f 
 #
 #
 cd /home4t/gfcsdata/sql
 sqlforms30 -c xtermsun:sun
 exit 0


 The -c xtermsun:sun clause is the other part of this
 fiasco.  I have taken to setting it into an env variable
 called $MY_TERM so that the thing can be changed.

 If you use a shell tool the pair looks like this:

 to open the window

 $OPENWINHOME/bin/shelltool -fn Courier-Bold18

 to start sqlforms

 sqlforms30 -c sun:sun


--
|suned1!lev@elroy.JPL.Nasa.Gov|lev@suned1.nswses.navy.mil|sun!suntzu!suned1!lev|
|S.T.A.R.S. The revolution has begun!|  My Opinions are Mine mine mine hahahah!|
Newsgroups: comp.databases.oracle
Subject: Re: msqlforms30... window size
From: ballpe@cbr2
Date: 18 Dec 92 12:07:47 GMT

In article <ByyGy7.6v8@watserv1.uwaterloo.ca>, teek@flight.uwaterloo.ca (Prateek Dwivedi) writes:

> In creating my first forms application, I was wondering how I could
> force my window size to become large (ie.  make the application know it
> has a big window).
> 
> The problem is that I have a table with a lot of fields, and I want to
> create a multiple record block for it.  But forms tells me that there is
> not enough room.  So I thought I could just open a really wide window
> and force it to be wider.


If I understand your problem correctly, the best thing to do is to determine
what fields you _really_ want to display on the screen first. Arrange these
in whatever order you wish, but pick meaningful ones to display. Then put the
rest of the fields for the record on Page 0. This way, all the fields for the
table are present in the block, but only the essential ones are shown and less
essential ones are hidden from view.

You also have access to the packaged procedures ANCHOR_VIEW and RESIZE_VIEW,
but I don't think these will help your current situation as you seem to want
to display more than can reasonably fit on the screen. They are very handy
though.


Peter Ball
Information Services Section
Dept of Health, Housing and Community Services
Brisbane, QLD, Australia
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: SQL*Loader foreign key problem
Date: 17 Dec 92 09:30:40 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1go4ktINNarb@fmsrl5.srl.ford.com>, hugh@slee01.srl.ford.com (Hugh Fader) writes:
> I am having a problem with SQL*Loader and foreign keys. I have two
> tables:
> 
> CREATE TABLE components(
>  id                              NUMBER(4,0)      NOT NULL,
>  confignum                       NUMBER(3,0)      NOT NULL
>  [other stuff deleted]
> )
> 
> CREATE TABLE conventional_data(
>  id                              NUMBER(4,0)      NOT NULL,
>  comp_id                         NUMBER(4,0)      NOT NULL,
>  [other stuff deleted]
> )
> 
> The conventional_data.comp_id column is a foreign key which references
> components.id.
> 
> Here is my problem: I am trying to load data into the
> conventional_data table using SQL*Loader. Each row in the external
> file contains a confignum value which is assumed to pre-exist in the
> components table. How can I assign a value to
> conventional_data.comp_id that points to the appropriate row in the
> components table? It seems as though I would have to use a SQL select
> in order to do this. Have I hit the limit as to what SQL*Loader can
> do?
> 
> --
> Hugh Fader
> Ford Research Laboratory
> hugh@slee01.srl.ford.com
Using SQL*Loader, insert the data directy into the conventional_data 
table with a NULL value assigned to comp_id.  After the load is complete,
run a SQL*Plus script to update the conventional_data table and synch
the values to the components table.  Something like:

	update conventional_data A
	set    comp_id = (select id 
                          from   components B
		          where  B.confignum = B.confignum)
	Where  comp_id is null;

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

>
From: pytlik@ra.cs.umb.edu (Marek Pytlik)
Newsgroups: comp.databases.oracle
Subject: Re: OPS$LOGIN : security hole?
Date: 18 Dec 92 02:23:52 GMT
Organization: University of Massachusetts at Boston, Dept of Math and CS

In article <1go861INN4hv@rave.larc.nasa.gov> p228@uni05.larc.nasa.gov (Bailey Bob) writes:
>In article <8aT=R#A@engin.umich.edu> lwk@engin.umich.edu (Lewis W Kellum) writes:
>>
>>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
>
>The only way the ops$ account works without a password is when you are
>directly logged into the host server at the OS level.  If you connect to
>the host via SQL*Net, the RDBMS will require entry of the password.
>
>Bob Bailey
that is not true in case of unix (clinent) to unix (server). smith on client
can access smith's database account on server.
From: scott.unrein@dwarp.sccsi.com (Scott Unrein) 
Newsgroups: comp.databases.oracle
Subject: SQL*Loader REALLY unique
Date: 14 Dec 92 16:33:00 GMT
Distribution: world
Organization: Data Warp Premium BBS - Spring/Houston, TX - 713-355-6107
Reply-To: scott.unrein@dwarp.sccsi.com (Scott Unrein) 

HF>Can anybody offer a way to get SQL*Loader to give me a sequence number
HF>which is unique for the entire table?

I don't have my SQL*Loader documentation with me... BUT I think you can
use an argument with the SQL*Loader sequence generator -- the argument
is either COUNT or LAST.  This will cause loader to count all the values
before adding new sequences.  -- Good Luck.  Scott Unrein
---
 . SLMR 2.1a . Go away, or I shall taunt you a second time.
From: wwm@ef5003.efhd.ford.com (Bill Meahan)
Newsgroups: comp.databases.oracle
Subject: Re: Explain THIS, please!
Date: 21 Dec 92 01:12:01 GMT
Organization: Ford Motor Co., EFHD Ypsilanti Operations
NNTP-Posting-Host: ef5003.efhd.ford.com


Craig, and the rest of you who replied by mail -- you know who you are
:-) --  Thanks for your noting the "no ORDER BY in a subquery" proviso
which I had been unable to find in TFM until now.

Taking away the ORDER BY and ROWNUM= certainly DO get rid of the error
but don't accomplish my aim which was to get the reason codes for the 10
most-wasted parts in a given work center.

I'll try out the approach you outlined above when I get to work in the
morning -- it looks like an interesting approach.


Again, thanks a bunch to all who took the time to reply.  Ain't USENET
nice? :-) :-)


-- 
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!
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Oracle Comment
Keywords: hate oracle weenie
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Distribution: usa
Date: Tue, 15 Dec 1992 16:13:12 GMT

dmcohen@anywhere.umd.edu (Dan Cohen) writes:
>Oracle bites my weenie.  It is a lousy database.  No one should be 
>tortured to use it.
>-Dan
>BTW- Hello Jeff!

Interesting. 

I like Oracle, Corp.  I like Oracle RDBMS 6 & Oracle7.  I enjoy
using it far more than ANY other database language out there.
-Andy
BTW - Hi Oracle peoples!

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.
  Join GEnie, call 800-638-9636/301-251-6415.  Join Unix, CASE, and Desktop 
  Oracle RDBMS Database discussions, send mail to ora-request@vistachrome.com
Newsgroups: comp.databases.oracle
From: teek@flight.uwaterloo.ca (Prateek Dwivedi)
Subject: calling multiple forms in motif
Organization: University of Waterloo
Date: Tue, 15 Dec 1992 16:42:31 GMT

I am using forms 3, and designing for motif.

i have a form that calls another form.  the calling form shows has
multiple rows on it (ie more than one record displayed on one page).

the called form is triggered by a Key trigger.  what I want to be able
to do is call another form from the calling form after I have already
called one.

to clarify... I have a table of models... and each of these models are
made up of components, which are on a separate form.  What I want to do
is bring up the component table for more than one model at the same
time.

(BTW.... I don not want to have a master/slave relationship between the
models and components, I just want a multitasking call function).

any ideas?

thanks,

-- 
Teek (Prateek Dwivedi)                  teek@kingcong.uwaterloo.ca
Research Assistant                      pdwivedi@systems.watstar.uwaterloo.ca
Flight Control Systems Group            (519)885-1211 x5314     Voice
University of Waterloo, Canada          (519)746-3077           Fax
Newsgroups: comp.databases.oracle
From: peter@dragon.acadiau.ca (Peter Steele)
Subject: Oracle for Solaris?
Organization: Acadia University
Date: Wed, 16 Dec 1992 17:35:32 GMT

Any one know when a Solaris 2.1 version of Oracle will be available?
-- 
Peter Steele        Unix Services Manager            peter.steele@acadiau.ca 
Acadia Univ., Wolfville, NS, Canada B0P 1X0  902-542-2201  Fax: 902-542-4364
From: mjw@mailbox.eng.ufl.edu (Mike Wohlgemuth)
Newsgroups: comp.databases.oracle
Subject: Passing query results from a user exit to SQL*Forms 3.0
Date: 15 Dec 92 17:04:02 GMT
Organization: Engineering Computing Services - Univ. of Fla.

I need to run a select query in a user exit, and have the query
results show up in a multi-record block.  I would like to be able
to open the cursor, fetch the records, and then assign them to
sucessive rows in the block.  As I understand it, IAF PUT will
put values into the fields of the current record in the block.
So, how do I create new rows and navigate to them within a user
exit?

Thanks,
Mike
Newsgroups: comp.databases.oracle,comp.sys.sun.misc,comp.sys.novell,comp.protocols.tcp-ip,comp.protocols.tcp-ip.ibmpc
From: aiko@opium.cs.odu.edu (John K Hayes)
Subject: Need advice on accessing Oracle on a Sun LAN from a Novell LAN
Organization: Old Dominion University, Norfolk, Va
Date: Wed, 16 Dec 1992 18:02:28 GMT



A friend of mine is trying to figure out how to make an Oracle database
located on a Sun sparc (running SunOS with windows) accessible from nodes on a
Novell PC LAN.  I don't think he's bought anything yet; he just wants the 
configuration needed.  He wants to be able to run forms, etc from the PCs
while the database resides on the Suns using TCP/IP.  He's got some sort of
box called a xyplex that things plug into (not sure what that is) - he thinks
that DECNET is somehow involved with the xyplex (but again - I'm not sure).

The main problem is: how does he connect the Sun LAN to the Novell LAN
for Oracle communication.  I think Novell talks with IPX packets - would
he need some sort of IPX adapter?  I'm sure Oracle will run in both the
Sun and Novell environments - what packages does he need to connect them?
He said something about SQL*Net with SQL*Star for connecting - I don't 
know what SQL*Star is....

Any ideas on the hardware needed and software needed?  Thanks.

-- 
    ---{john hayes}  OLDOMINISITY; Norfolk, Virginia USA
                     internet: aiko@cs.odu.edu
Newsgroups: comp.databases.oracle
Subject: Re: Help with SQL Syntax
From: champs@cbr2
Date: 15 Dec 92 19:18:31 GMT

In article <1992Dec4.202332.21512@cbfsb.cb.att.com>, gerette@cbnewsb.cb.att.com (marianne.g.pittorino) writes:
> 
> Let's call the first table FIRST and the second table SECOND.  The data in
> 
> I need an SQL statement that will select the rows in FIRST that do not
> match any row in SECOND (and vice versa).  For example, let's pretend we have
> the following data:
> 	FIRST			SECOND
> 	-----			------
> 	1111			1111
> 	2222			2222
> 	3333			4444
> 	5555			5555
> 
> I need to know that 3333 exists in FIRST but not in SECOND, and that 4444
> exists in SECOND but not in FIRST.  I do not need to know this in the same
> SQL statement.
> 
> Does anyone know how to do this?
> 

After consulting the SQL reference manual, the simplest way (I don't know if
it's the most resource efficient way) is as follows:

	SELECT COL FROM FIRST
         MINUS
        SELECT COL FROM SECOND;

This returns all rows from FIRST that are not is second, so just reverse the
table names to get the appropriate rows from SECOND.

Bye for now.
-------------------------------------------------------------------------------
    /\       Steven Champness
   /  \      Dept Health Housing and Community Services
  /    \     Brisbane Queensland
 /      \     via
/   /    \   Canberra Australia
\  / /   /
 \/ / / /    MACINTOSH SOFTWARE AXIOM : If you need a manual to operate it
  \/ / /                                it wasn't designed properly in the
   \/ /                                 first place !
    \/
Newsgroups: comp.databases.oracle
From: torholg@flipper.pvv.unit.no (Tor Holgersen)
Subject: Question about LONG-fields
Keywords: SQL*FORMS, LONG-fields, SQL
Organization: ProgramVareVerkstedet - UNIT
Date: Fri, 18 Dec 92 10:46:47 GMT

I've got two questions about LONG fields:

 a)  Is it possible to copy a long field from one table into another?
     Example:
 
 	UPDATE TABLE1 SET TABLE1.LONGFIELD =
		( SELECT TABLE2.LONGFIELD FROM TABLE2
		  WHERE TABLE1.KEY = TABLE2.KEY )

	--> ORA-00997 Illegal use of LONG datatype.

 b)  Is it possible to display a long field with more than one line
     in an SQL*FORMS30 form?

     The pop-up editor is not what I want, because it is dynamic, has
     to be shown and removed. I want several static lines shown.
  
Please respond directly to me by e-mail.

Thanks in advance !

- Tor Holgersen <torholg@pvv.unit.no>
Newsgroups: comp.databases.oracle
Subject: Re: Barcoding and oracle.
From: tumidity@netlink.cts.com (Joel Garry)
Date: Thu, 17 Dec 92 11:18:05 PST
Organization: NetLink Online Communications, San Diego CA

jessea@u013.me.vp.com (Jesse W. Asher) writes:

> Does anyone have barcode printing integrated with Oracle?  We're a
> manufacturing company that needs to use barcoding and we have no idea
> about how to go about it.  We're running Oracle on unix and printing to
> HP LaserJets (II and III).  Can anyone give me some pointers on where to
> look for some code to do this sort of thing?
> 
> -- 
>       Jesse W. Asher                                          (901)762-6000
>                              Varco-Pruden Buildings
>                  6000 Poplar Ave., Suite 400, Memphis, TN  38119
>     Internet: jessea@vpbuild.vp.com                   UUCP: vpbuild!jessea

Sofware of this type is sold in the magazine ID Systems (603) 924-9631.
You could do as we did (in another database), and do it in post-script.
We used a report writer to generated postscript code.  The november
issue had an article about selecting bar code label software.  If you
have windows, you can get software to print barcodes for $200. 
Low cost barcode printers start at $800.

--                    
INTERNET:  tumidity@netlink.cts.com (Joel Garry)
UUCP:   ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
Newsgroups: comp.databases.oracle
From: gerette@cbnewsb.cb.att.com (marianne.g.pittorino)
Subject: Too many open files
Keywords: open files
Organization: AT&T
Date: Thu, 17 Dec 1992 14:34:30 GMT


Hi all!

I am running RDBMS V6.0.36.0.1 and Pro*C precompiler 1.4.8.2.2 on a Pyramid
(Release 2 UNIX).  I have an embedded SQL 'C' process that runs all day,
processing updates to our database.  The process frequently executes a system
call to SQL*Loader to load in bulk updates.

It seems as if sqlload is not closing its files.  After about 100 calls or so
(the number is not constant), I start getting the following error:
	SQL*Loader-500:  Unable to open file (filename)
	Pyramid UNIX Error: 24: Too many open files

Shouldn't sqlload be closing its files when its exec'ed shell completes?  I
meticulously checked the rest of the code; the process has one file open when
the system call to sqlload is made (a command file telling the process what
update it needs to perform).  Right before the system call is made, the
process opens the data file (the ".dat" file), writes the data to be loaded,
then closes the file.

Does anyone know of any weirdness with calling sqlload via a system call from
a 'C' program?


Thanks for your help,
Marianne
Newsgroups: comp.databases.oracle
From: jfedorko@ncsa.uiuc.edu (Joel Fedorko)
Subject: Re: OPS$LOGIN :security hole?
Originator: jfedorko@mars.ncsa.uiuc.edu
Organization: Day Data Systems @ Dow 
Date: Thu, 17 Dec 1992 18:49:23 GMT

Dale, I beg to differ with your differing....
      ORASRV_PROXY_LOGIN=NO
... in config.ora in ora_sqlnet .
-- 
Joel Fedorko                         Remember Bit Hopper, 
Consultant                     You must become one with the machine.
Day Data 
jfedorko@ncsa.uiuc.edu        Any opinions I express will be ignored.
From: rwessman@prodhp.us.oracle.com (Rick Wessman)
Newsgroups: comp.databases.oracle
Subject: Re: Question about OPS$LOGIN and Oracle Passwords
Date: 17 Dec 92 22:46:00 GMT
Organization: Oracle Corporation, Redwood Shores, 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.

In article <24727@suned1.Nswses.Navy.MIL> lev@ipxed5.nswses.navy.mil (Lloyd E Vancil) writes:

>   In article <1992Dec14.200952.22697@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>   This is a known security hole in the OPS$ user under oracle 6.. 
>   I am not aware of the fix if any in trusted oracle or in
>   oracle7.  

In ORACLE7, it is possible through the use of an init.ora parameter to
prevent op$ logins.

--
                                            Rick Wessman
                                            rwessman@us.oracle.com
From: p228@uni05.larc.nasa.gov (Bailey Bob)
Newsgroups: comp.databases.oracle
Subject: Re: How to emulate Yes/No Cancel Dialog?
Date: 16 Dec 1992 21:26:53 GMT
Organization: Unisys-Hampton VA
NNTP-Posting-Host: uni05.larc.nasa.gov

In article <6554.2b2ee64d@hayes.com> fgreene@hayes.com writes:
>So where do we get a copy of this paper?  I have done similar type things
>in the past, but could really use a standard source so the wheel doesn't get
>reinvented each time.

Try your Oracle Sales Rep - Our Sales Rep provided us with it during
discussions about GUI and where Oracle is headed.

Newsgroups: comp.databases.oracle
From: schneide@chx400.switch.ch (Marcel Schneider)
Subject: Exchanging know-how
Organization: SWITCH, Swiss Academic and Research Network
X-Newsreader: TIN [version 1.1 PL6]
Date: Sun, 20 Dec 1992 17:09:49 GMT


This is posted for a friend who is not (yet) on the net:

"In order to develop a solution for nationwide distribution of stock we
are interested in exchanging information with an already experienced
team. Topics for first mail exchanges:

	- usage of Oracle (versions, utilities, releases)
	- clientele, range of application
	- specific data of enterprise."


Please respond directly via e-mail to <schneider@switch.ch>.