HDTenEightyP/NetNews huggingface dataset:
Subject: Are Oracle in England on email? 
Distribution: world
Organization: zork
Date: Fri, 14 Aug 1992 17:37:02 +0000


In article <carol.713679271@ee.uts.EDU.AU> carol@ee.uts.edu.au writes:

> 
> I'm trying to track down someone in England. I know he works
> for Oracle. Does anyone know how I could go about finding out
> his email address?
>
If you do not know his name try the response desk (respnse@uk.oracle.com),
they may be kind enough to help, or email me his name and I will call on
Monday for you.

--
frozzboz@zork.demon.co.uk  (Keith Davidson)

Watch out The Borg are about
From: simon.rear@almac.co.uk
Newsgroups: comp.databases.oracle
Subject: rollback segments
Date: 20 Aug 92 21:22:56 GMT
Distribution: comp
Organization: ALMAC PC Board

Hi,

I've recently set up oracle version 6 on a novell network without too many
problems. At present there are only three concurrent users ie developers
primarily using forms version 3. Sometimes when saving forms to the database I
receive the error 'failed to extend roll back segment...'. After analyzing the
setup and reading up on rollback segments I adjusted the setup as follows;

Created 4 rollback segments, (in addition to the system rollback segment),
each with an initial extent of 1Mb, Max extents 99 and all in the table
space 'Rollback_segs' which itself is five Mb's in size.

The sizing I thought would be suitable for the finished application allowing
for 10% of the largest table and one rollback segment for each expected
concurrent user.

But the error still occurs, seemingly random and infrequent, but still
annoying. I monitored the use of the rollback segments and too my surprise
found that extents on all four segments had been increased yet the actual
amount of data contained never seems to exceed a couple of hundred K no where
near the 1Mb mark.

The largest table in the database is only 1Mb and the application has no long
running transactions or large sorts. I suspect the problem is perhaps my
limited knowledge, (I have only been using oracle for a month! :-) ).

Any Ideas??

Thanks in advance..

Simon.Rear@Almac.Co.Uk
---
 ~ OLX 2.1 TD ~ I've seen the truth but it makes no sense
--
ALMAC BBS Ltd. 0324-665371
Dos based USENET access,  call for details!
Newsgroups: comp.databases.oracle,connect.audit
From: boxfield@ibmpcug.co.uk (Paul J Snelling)
Subject: PL/SQL problem
X-Disclaimer: The views expressed in this article are those of the author
	alone and may not represent the views of the IBM PC User Group.
Organization: The IBM PC User Group, UK.
Date: Wed, 12 Aug 1992 12:40:06 GMT

 
This is probably a stupid question but Ive been trying all kinds of ways
to get information OUT of a PL/SQL block without writing it to a table.
I'm hoping that someone out there has tried the same thing and can tell me
(A) how to do it, or (B) it cant be done....
 
My latest attempt under sqlplus goes something like...
 
SQL> define MYVAR=500
SQL> declare
2    i  number ;
3    begin
4    for i in 1..10 loop
5      MYVAR := &MYVAR + i ;
6    end loop ;
7    end ;
 
A pathetic attempt, but you can see what Im trying to acheive (I hope).
 
Any ideas?
 
-- 
Paul Snelling,	BoxField Systems Ltd
Newsgroups: comp.databases.oracle
From: carol@ee.uts.edu.au (Carol Gibson)
Subject: Are Oracle in England on email?
Organization: University of Technology, Sydney, Australia
Date: Thu, 13 Aug 1992 04:14:31 GMT

I'm trying to track down someone in England. I know he works
for Oracle. Does anyone know how I could go about finding out
his email address?

Thanks.
	Carol Gibson
From: rz34@hp850.rz.uni-karlsruhe.de (Schillinger)
Newsgroups: comp.databases.oracle
Subject: National Language Support troubles
Date: 14 Aug 92 14:18:37 GMT
Reply-To: rz34@rz.uni-karlsruhe.de
Organization: University of Karlsruhe, Germany

I'm *still* working on getting that National Language Support running
properly.

We're running ORACLE v.6.0.34.2.1 and on a HP/UX 9000 Series 800.

The problem is getting the Umlauts and other special characters to
appear correctly on all four of our terminal types: xterm, hpterm,
vt100, and vt220.  WE8HP works on hpterm and WE8DEC works on the other
three.  

I set LANGUAGE=German_Germany.WE8DEC in init.ora, but I'd like the 
characters to appear correctly on hpterm too!  
Then I put the following if/then into my .profile to check on the terminal type
and access the correct message files for ORACLE **utilities**:

if [ $TERM = hpterm ]
then export LANGUAGE=German_Germany.WE8HP
else export LANGUAGE=German_Germany.WE8DEC
fi

The if/then works fine.  Which means vt220 and vt100 work fine.  (I'm
not sure about xterm because of the second problem.  See below.)  But
on hpterm in sqlplus, the Umlauts don't appear, the result of init.ora
LANGUAGE being set to WE8DEC, which it doesn't like.  However, since I 
reset the LANGUAGE in my .profile for utilities the Umlauts appear 
correctly in hpterm Forms, etc.

So, the question is:  Is it possible to put a similar if/then in my
init.ora to check on the terminal type and set the ORACLE instance
LANGUAGE depending on what the terminal type is??

Now, to the second problem:  When I try to run the msqlforms30 on
xterm or hpterm, I get only the following messages:

(it only comes in German now so I'll try to translate it as best I can)

Can't access help resource file.
Can't initialize the IAD application.

I assume the second error is due to the first and the first looks
** to me ** as if it occurs because a file is missing.  But I checked
in the manual and seem to have all the right filesr (iad,iap,iac,iag,
typ,ifp in forms30/mesg/).  The same error message comes when I try to
run msqlmenu50, but I don't know what message files are supposed to be
there for Menu.

Has anyone had any experience with these two problems in NLS?

I'd appreciate any help.  Thanks in advance!

Karen
rz34@hp850.rz.uni-karlsruhe.de
From: huynh@falcon.navsses.navy.mil
Newsgroups: comp.databases.oracle
Subject: Forms3 Delete a char of the field data
Date: 12 Aug 92 21:21:32 GMT
Organization: NSWCCD, Naval Ship Systems Eng Sta, Phila PA

Greetings,

I am using sqlforms version 3.0.
I have a problem which I don't even know where to start.  I want to delete a
char of the enter data into a field.  
eg. Let 's say I have a field that requires data
HULL: _________; where the users will enter something like HULL: LST-1183,
I want to delete the "-" sign/char.
I want the data to be in the form of 'LST1183', but because of the way our data
bases are set up, the users will enter the HULL in the form of 'LST-1183'. I
want to delete the "-" sign/char, and also at the time somehow join the 
LST 1183 together so that it is like the user had just entered 'LST1183' and
not 'LST-1183'.
I need to convert 'LST-1183' into 'LST1183', so that it corresponds with the
database HULL to do the query.

I hope I have made myself clear.  Anyone who is interested, but didn't quite
undertand me, please feel free to ask.  I will be more than happy to make
myself clear.  

Any comments or suggestions will be appreciated.  Thanks in advance.
Newsgroups: comp.databases.oracle
From: dewey@centerline.com (Devan F. Dewey)
Subject: Re: Forms3 Delete a char of the field data
Followup-To: comp.databases.oracle
Organization: CenterLine Software, Inc.
Date: Thu, 13 Aug 1992 12:37:22 GMT

In article <1992Aug12.162132.278@falcon.navsses.navy.mil>,
huynh@falcon.navsses.navy.mil wrote:
> 
> Greetings,
> 
> I am using sqlforms version 3.0.
> I want the data to be in the form of 'LST1183', but because of the way our data
> bases are set up, the users will enter the HULL in the form of 'LST-1183'. I
> want to delete the "-" sign/char, and also at the time somehow join the 
> LST 1183 together so that it is like the user had just entered 'LST1183' and
> not 'LST-1183'.

In a post-field or on-validate-field trigger, which ever you prefer use:

select replace(:block.hull,'-','') into :block.hull from system.dual;

This will do exactly what you are looking for.
                             
               Devan F. Dewey | Senior Systems Analyst
          CenterLine Software | dewey@centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: RE:RE: ** ORACLE Forms security **
Date: 13 Aug 92 07:46:33 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

Ok, ok

But you can take the full path name to prevent this, or you can protect the
SQLPLUS.EXE so that nobody can copy it !!

      INSTR(program,'$1$DUA2:[ORACLE.][SQLFORMS]IAP') <> 0

-- 

--------------------------------------------------------------------------------
Klaus-Michael Hatzinger                            hatzinger_m@bmwf1f.bmwf.gv.at
Federal Ministry of Science and Research
Computer Center
Vienna, Austria
From: sinha@watson.bms.com (Anil Sinha)
Newsgroups: comp.databases.oracle,comp.database
Subject: client server
Date: 13 Aug 92 16:12:00 GMT
Organization: Bristol-Myers Squibb PRI

Few weeks ago some one mentioned implementation issues associated with 
applications implemented using client server model. Can someone throw light on 
these issues ?

Thanks in advance.

Anil Sinha
internet:sinha@watson.bms.com
Newsgroups: comp.databases.oracle
From: dirtbag!howard (Howard Brenner)
Subject: Oracle table inserts and creations
Reply-To: bag!howard (Howard Brenner)
Organization: Monitor Company / IE
Date: Wed, 19 Aug 1992 20:51:02 GMT

If I know ahead of time that I will be inserting a large amount of data  
into a table is it more efficient to pre-allocate the space for the table  
or to let oracle do it when it needs to?

thanks!
From: semdipilla@condor.navsses.navy.mil
Newsgroups: comp.databases.oracle
Subject: Ora_term, key mapping forms 3.0
Date: 18 Aug 92 20:56:21 GMT
Organization: NSWCCD, Naval Ship Systems Eng Sta, Phila PA

Help,

   we need help creating a vt100 map file throught ora-term.   We currently
have an application that runs on a vt320 digital terminal.  WE need to make
this file work on a vt100.  WE want our user to be able to hit f5 and to 
commit(f12 on vt320).  WE need to also give the user a few other options
such as delete and update.  we only have f1-f10 function keys on vt100
's

we know we need to 
   1) go into ora_term
   2) get file for vt100
   3) modify it for our function key mappings
   4) save our changes
   5) then run our form with the modified vt100 file

Problem, we don't know how to get into the vt100 file to make f5 do a
commit,etc.

Michael
From: littlec1@jaguar.uofs.edu (Chris Little)
Newsgroups: comp.databases.oracle
Subject: Naming database files - are there rules?
Date: 13 Aug 92 16:42:48 GMT
Organization: University of Scranton

I am about to create a database instance on a VMS system and don't want to use
the conventional filenames for files such as the system tablespace file
(ORA_SYSTEM.DMS), or the redo log files.  This is because we have multiple
database instances and want to precede the names of their files with unique
identifiers so that they can ne recognised easily.  For example I'd like to
name the file that contains the system tablespace of the production database
P_SYSTEM.DBS, and the redo log files P_RLOG_1.RDO and P_RLOG_2.RDO.  I know
this will work because I tried it, but will this deviation from the
conventional naming scheme cause us any problems down the line?

Thanks in advance for your help.

--
Chris Little, Programmer/DBA
                                                University Computing Systems
                                                University of Scranton
  LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510
Newsgroups: comp.databases.oracle
From: cdkeen@probitas.cs.utas.edu.au (Chris Keen)
Subject: orasrv protocol (Q)
Organization: University of Tasmania, Australia.
Date: Wed, 19 Aug 1992 03:15:20 GMT

I am looking for a specification of the TCP-based protocol used
to communicate with orasrv on a Unix system, over TCP/1525 port.

Does anyone know where I may be able to obtain a copy?

thanks,

chris

--
Chris Keen				AARNet: C.D.Keen@cs.utas.edu.au
Dept of Computer Science		Phone:  002-202906    (Australian)
University of Tasmania			        +61-02-202906 (international)
GPO Box 252C, Hobart, Tasmania  7001    Fax:    +61-02-202913
From: ian@tethys.SLAC.Stanford.EDU (Ian A. MacGregor)
Newsgroups: comp.databases.oracle
Subject: Re: Forms3 Delete a char of the field data
Date: 13 Aug 92 16:39:02 GMT

In article <1992Aug12.162132.278@falcon.navsses.navy.mil>, huynh@falcon.navsses.navy.mil writes:
|> Greetings,
|> 
|> I am using sqlforms version 3.0.
|> I have a problem which I don't even know where to start.  I want to delete a
|> char of the enter data into a field.  
|> eg. Let 's say I have a field that requires data
|> HULL: _________; where the users will enter something like HULL: LST-1183,
|> I want to delete the "-" sign/char.
|> I want the data to be in the form of 'LST1183', but because of the way our data
|> bases are set up, the users will enter the HULL in the form of 'LST-1183'. I
|> want to delete the "-" sign/char, and also at the time somehow join the 
|> LST 1183 together so that it is like the user had just entered 'LST1183' and
|> not 'LST-1183'.
|> I need to convert 'LST-1183' into 'LST1183', so that it corresponds with the
|> database HULL to do the query.
|> 
|> I hope I have made myself clear.  Anyone who is interested, but didn't quite
|> undertand me, please feel free to ask.  I will be more than happy to make
|> myself clear.  
|> 
|> Any comments or suggestions will be appreciated.  Thanks in advance.

How far along are you on this project?  There appears to be a basic error in
design in that the HULL field is not atomic, but includes two different pieces
of information; the class of ship and its hull number.  These should be separate
fields.  This will make queries looking for all LST's, DDG's, FF's, etc. easier.
You can concatenate the two fields on output or to store the class/hull number
combination in another database field. 

If your database design is immutable and you need to strip out the '-' character,
the following trigger will do the trick.

 BEGIN                                                                       
    IF (INSTR(:NAVY.HULL,'-') > 0) THEN                                 
      :NAVY.HULL := SUBSTR(:NAVY.HULL,1,                          
      INSTR(:NAVY.HULL,'-') -1)||                                       
      SUBSTR(:NAVY.HULL,INSTR(:NAVY.HULL,'-')+1,                  
      LENGTH(:NAVY.HULL));                                              
    END IF;                                                                  
 End;  


This code should be placed in an on-validate-trigger on the class_hull field
and on a pre-query trigger on the block.

Note: the use of this code will result in the '-' disappearing from the screen
field as well.  

                            Ian MacGregor
                            Stanford Linear Accelerator Center
                            IAN@SLAC.STANFORD.EDU
                            (415) 926-3528     
Newsgroups: comp.databases.oracle
From: lindholm@ucs.ubc.ca (George Lindholm)
Subject: Re: Terminal types, recognition of...
Organization: University Computing Services, UBC, Canada
Date: Wed, 12 Aug 1992 20:24:55 GMT

In article <1992Aug10.174956.13401@unixg.ubc.ca>, julia@unixg.ubc.ca (Julia Chen) writes:
> Hello,
> 
> Can anyone explain how Oracle interprets and treats terminal settings in a
> Unix environment? I work on a Sun IPC with xterm running on a remote Sun 4.
> With my envrionment variable $term set at xterm, none of the Oracle tools will
> recgonize the terminal. I either have to change $term to xtermsun:sun or add
> '-c xtermsun:sun' at invocation in order to get Oracle to correctly recgonize
> that I'm on an xterm. Why is this so? Is there various flavours of xterm's?

(It would be really nice if all the oracle tools would use the same terminal
support, but that's another question).

What I do in my .bashrc file is to define an alias for (say) runform30 that
takes care of the -c option:

if [ "$TERM" = "xterm" ]; then
   alias runform30='runform30 -c xtermsun:sun'
fi

   George
-- 
George Lindholm                                  phone:    (604) 822-4375
University Computing Services, UBC               fax:      (604) 822-5116
6356 Agricultural Road, Vancouver, B.C., Canada  internet: lindholm@ucs.ubc.ca
V6T 1Z2                                          bitnet:   USERGNL@UBCMTSG
Newsgroups: comp.databases.oracle
From: george@unixg.ubc.ca (George chow)
Subject: Re: Terminal types, recognition of...
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Wed, 12 Aug 1992 21:22:37 GMT

In article <1992Aug12.022036.9693@oracle.us.oracle.com>, wkaufman@us.oracle.com (William Kaufman) writes:
|> In article <1992Aug10.174956.13401@unixg.ubc.ca> julia@unixg.ubc.ca (Julia Chen) writes:
|> ] 
|> ] Can anyone explain how Oracle interprets and treats terminal settings in a
|> ] Unix environment? I work on a Sun IPC with xterm running on a remote Sun 4.
|> 
|>     (Note that the below only applies to SQL*Forms 3.0, SQL*Menu 5.0,
|> and Oracle*Terminal 1.0, and is fairly UNIX-specific.)
|> 
|>    If you don't specify a "-c" on the command line, it takes your $TERM
|> environment variable as your terminal, and oraterm.r as your resource
|> file.  (This is on UNIX systems--check your platform docs for defaults
|> on other platforms.)
|> 
|> ] With my envrionment variable $term set at xterm, none of the Oracle tools will
|> ] recgonize the terminal.
|> 
|>     Well, it'll look for a terminal named "xterm" in your oraterm.r.  If
|> it doesn't find it (and, in the default oraterm.r, it might not), the
|> program will warn you and halt.

Ah, so oraterm.r is an index of sorts...

|> ] I either have to change $term to xtermsun:sun
|> 
|>     Don't do this!  Otherwise, other programs (like vi, for example) may
|> get confused about what kind of terminal you're using, and fail, or get
|> forced into line-mode.

Yes, I know I shouldn't do that. But it *is* one way to get it to go. :)

|> ] or add
|> ] '-c xtermsun:sun' at invocation in order to get Oracle to correctly recgonize
|> ] that I'm on an xterm.
|> 
|>     That's one solution.  If *all* your machine's users are using
|> xterms, though, you can simply rename your sun.r to oraterm.r (save the
|> old one somewhere!), and rename the "xtermsun" terminal listed in there
|> to "xterm" (and save the unmodified sun.r, too!).  Then, "xtermsun:sun"
|> becomes "xterm:oraterm", which would be your default.

Maybe I should have said that I was really more interested in the file oraterm.r.
I was slightly confused because my ORATERMPATH points to a directory which 
contains xterm.r, vt100.r, and a few others. Since I know that if I come in from
a vt100 terminal that things are okay, I couldn't understand why coming in from
an xterm would be different. So, the answer is that oraterm.r needs to have an
entry for xterm inside it before it will even start looking for xterm.r.

|>                                                 -- Bill K.
|> 
|> ===============================================================================
|> William P.D. Kaufman         Voice: (415) 506-2447     500 Oracle Parkway
|> wkaufman@us.oracle.com         Fax: (415) 506-7221     Box 659411
|> Tools & Multimedia                                     Redwood Shores, CA 94065

George
Newsgroups: comp.databases.oracle
From: mclark@us.oracle.com
Subject: Re: Implementing selectable LOV, how to...
Followup-To: comp.databases.oracle
Organization: Oracle Corporation, USA
Date: Thu, 13 Aug 1992 11:06:11 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 <1992Aug4.164432.12930@unixg.ubc.ca>, george@unixg.ubc.ca (George chow) writes:
> Hello,
>   I'm trying to implement a LOV from which a user is allowed to pick multiple
> values. I'm thinking of something similar to the <Select Columns> in 
> SQL*Forms's Default Block form. Other than that is is a pop-up page, I have no
> real idea of how to approach this. So has anyone here tried to do anything 
> similar to this?
> 
> George
> 
> 
Hi George,
This situation normally occurs when you have the following:
 
Table A >---- Intersecting Table A/B ----< Table B (Pathetic attempt at E-R)

Where, say, Table B has a small number of rows, and we wish to populate Table
A/B (The intersecting table with keys from A and B)

One way to do this is to Create a Block based upon A to enable the user to
Query which "A" they would like to nominate the "B"'s for.

A short discussion of this technique follows:

Then Create a Block based upon "B".

Make Block "B" the Detail for Block "A" (This is why we rely on the small
number of rows in "B")

Write a PRE-QUERY Trigger on BLock "B" to Highlight the Row Returned if a row
exists in the intersection Table A/B.  (using DISPLAY_FIELD)

Write trigger code to stop  inserts/deletes in Block "B".

Nominate a function key to be the "Select a Row" key.
Make this key change some detail in Block "B".  This will force an Update in
the Block which we can use to write/remove a row from the intersecting Table
"A/B".
Also make the key highlioght/de-highlight the row using display_field.

   Re-Write the ON-UPDATE Processing to Insert/Delete the Row in the
intersecting Table "A/B" depending upon whether the user has seleceted a new
row or de-selected an existing row.

  Re-write the ON-LOCK Processing so that it does not lock table "B"


This was written in a Rush, so give me a Mailer if you have any problems
(Assumes forms 3.0)

Thanks

Mark Clark (mclark@au.oracle.com)