HDTenEightyP/NetNews huggingface dataset:
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases.oracle
Subject: SQL*Net using multiple protocols
Summary: SQL*Net using multiple protocols
Keywords: Novell SQL*Net ORacle
Date: 9 Sep 92 16:49:18 GMT
Distribution: comp
Organization: Robert Wood Johnson Medical School, Piscataway NJ

Hello once again fello Oracle people. I have some juicy questions
about SQL*Net for the project I'm working on. Here's the scoop:

We are thinking of setting up a Novell Netware LAN and running 
Oracle Server for Netware.  For PCs on the LAN, we would use the IPX/SPX
version of SQL*Net. So far this is nothing earth shattering. We
also intend on connecting this LAN up to the university network which
is based on TCP/IP. The network people tell me there should be no
problems if we would like to access the Oracle database from a remote
site by going accross the Internet. For PCs this is not a problem.

We have several users with Sun workstations who would also like to
have access to the Oracle database on the Novell server. We also
have some people who would like to dial in from home and have
access to the database. 

What are our options in terms of using SQL*Net
to do these tasks? 

What would performace be like? 

Users would like
to be able to run SQL*Forms, SQL*Plus and SQL*Menus. Is anyone out
there using SQL*Net Asynchronus? 

Will the new version of SQL*Net (is it 2.0?) be better for this kind
of thing?

I have been told about a process called IP tunneling which places the
SPX (Novell) packets inside of IP packets for transmission across the
internet.  Unfortunately, this scheme is very hard to debug and it is
not supported by the networking staff at this time. This would
not be an option.

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

Originally we were going to go with a Microvax II running Oracle which 
would have made this very easy since anyone with Telnet or dial-up
access can use the Oracle tools with nothing more than a terminal
emulator package. This level of simplicity and performace is
what we are looking to duplicate in the LAN setting.

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

Many thanks,

Rich Holowczak
Rutgers University
From: dlm@hermes.dlogics.com
Newsgroups: comp.databases.oracle
Subject: On reversing the master-detail relationship.
Date: 10 Sep 92 12:22:59 CST
Organization: Datalogics, Inc., Chicago, IL

colten@cbnewsb.cb.att.com (marc.colten) writes:
> dlm@hermes.dlogics.com writes:
>> colten@cbnewsb.cb.att.com (marc.colten) writes:
>> > 3)  Can you do a query on a detail block and have the relevant
>> >     information come up in the master block? [...]
>> > 
>> [...] just write triggers that treat
>> KEY-ENTQRY and KEY-EXEQRY in the detail exactly as if they are in the master,
>> but with the block associations reversed. 
>
> If I do a "go_block(master)" and then a query, it wipes out the
> values of the master block and waits for input.  I can't find a
> function that takes the current values and runs with them.

	REVERSING THE MASTER-DETAIL RELATIONSHIP.

The detail's foreign key is enforced from the master block primary key. The
master is generally coded with no key enforcement. So, enforce its primary key
from the detail block's foreign key. As long as the detail is cleared prior to
querying the master, the master-detail will work; if the master is cleared
prior to querying the detail, the detail-master will work. You will have to
write the triggers yourself (cannibalize the master-detail procedures).

The scenario will run something like this:

	master	key-entqry	go_block(detail);
				clear_block;
				go_block(master);
				enter_query;
				go_block(detail);
				execute_query;  [not enter_query]
				go_block(master);

	detail	key-entqry	go_block(master);
				clear_block;
				go_block(detail);
				enter_query;
				go_block(master);
				execute_query;  [ditto]
				go_block(detail);

The same principle is employed for the case of key-exeqry. This is the 
simplest method i can think of. 

Remember most of all that the detail-master relation makes an end-run around
the relational concept of key inheritance.

If you do not query on a foreign key, the rows returned will belong to many
masters. the behavior of the form is predictable: only one master will be
returned since its primary key can be enforced from only one detail row. This
presents a very misleading view of the relationship. If you solve this problem
by querying only on the detail's foreign key, you will have accomplished
little, since this action is the same as querying on the master's primary key.

In short, although you can jury-rig the detail-master relationship, it is
mostly pointless to do so. Net flames to /dev/nul or NLA0: please.
--
Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450
dlm@dlogics.com                                 Motto: Just show me the code
From: epeas@abds2.aberdeen.chevron.com (John Peach)
Newsgroups: comp.databases.oracle
Subject: Request for info; Sun, RS6000 or HP9000.
Date: 11 Sep 92 15:17:54 GMT
Organization: Chevron (UK) Ltd.


Before anyone flames me on this, I realise that the only 'true' answer
can be gained by running our own benchmarks.......

We are currently considering which Unix platform to use for running an
Oracle system which will have c. 100 concurrent users and a database
size in the order of 10 gigabytes. Does anyone have experience of
similar sized Oracle systems on Sun, RS6000 or HP9000? I would be
grateful for any information; response times, hardware configuration,
etc.


Reply by mail - I'll summarize.

Thanx in advance.

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
 Internet: epeas@abds2.aberdeen.chevron.com      Phone: +44 224 242637
From: mmcgreg@uswnvg.com (Mark McGregor)
Newsgroups: comp.databases.oracle
Subject: Re: How to print something in PL/SQL
Date: 8 Sep 92 16:33:11 GMT
Organization: U S WEST NewVector Group, Inc.
X-Newsreader: Tin 1.1 PL5

: Oracle, in their infinite wisdom, has deemed it appropriate that PL/SQL
: have no native print utilities.  A rather hideous means of "printing"
: is to write results to a table and then print them out with a select
: statement following the PL/SQL script.  But this is horrible (and costly
: in terms of extra database access) alternative to a print statement.
: 

It was correctly pointed out by various people that PL/SQL has no print
statements because it is implemented in the DB kernel.

So, I apologize for getting on the soapbox, but, I still think that
something could be done.  Sybase has already implemented stored procedures
as part of there kernel and also includes a message and error facility
with the following specifications:

    Sybase PRINT command

    example:

    if exist (select * from table) where something = something
    print "something"

    This allows you to send up to a 255 character message.  The application
    message handler then can determine what to do with the message.

    The other form of generating a message is the Raiserror.

    This form has the syntax:

          Raiserror #### 'message'

    It works the same as print, but it also sets the @@ERROR variable to
    ####.  The message can be accessed by the application programs message
    handler.

    These commands can be placed directly in stored procedures which can
    be accessed by various applications which can either do something
    with the message or ignore the message.


Although this is not the worlds greatest feature, at least it allows the
user to do messaging from within the procedural language.  I think that the
key thing here is that the application message handler determines what to
do with the message.

Mark McGregor -- mmcgreg@uswnvg.com

Newsgroups: comp.databases.oracle
From: kumar@ra.csc.ti.com (Sundeep Kumar)
Subject: FAQ FOR ORACLE
Organization: Texas Instruments
Date: Fri, 4 Sep 1992 21:58:09 GMT

I am using Pro*C to write some oracle applications and I keep facing 
what may be trivial problems. I am looking for an FAQ on Oracle since I
do not wish to waste BW every time I have a simple problem that has potentially
been discussed. 

Can somebody either Post the FAQ on the Net or send an email to me at :
kumar@ra.csc.ti.com

Thanks

Sundeep Kumar.
From: dewey@centerline.com (Devan F. Dewey)
Newsgroups: comp.databases.oracle
Subject: Trouble with name_in function (re-post)
Followup-To: comp.databases.oracle
Date: 11 Sep 1992 16:55:47 GMT
Organization: CenterLine Software, Inc.
Distribution: world
NNTP-Posting-Host: 140.239.3.212

When I get this error message:

      FRM-41012: Undefined field or variable reference.

this is the only part of my procedure that has executed:

      procedure pref_rate_movement is
        trig char(25);
        blk char(25);
        fld char(35);
        explination char(255);
      begin
        trig := :global.explination_trigger;
        blk := :system.cursor_block;
        fld :=  blk || '.explination';

 >>>    explination := name_in(name_in('fld'));


I'm trying to put the value stored in the field :hotel.explination into the
local variable explination.

What am I doing wrong???

BTW: I've been trying to e-mail this to ORACLE support. Does anyone have an
e-mail address for them???


                             
               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: NBROOKS@BBN.COM (Nat Brooks)
Newsgroups: comp.databases.oracle
Subject: Controlling "ad hoc" queries
Date: 8 Sep 92 18:31:44 GMT
Organization: Bolt Beranek and Newman, Inc.
NNTP-Posting-Host: 128.89.17.153
X-UserAgent: Nuntius v1.1

There are a large number of query tools available today.  These tools
allow end users to formulate their own queries and extract results of the
query to a file, to a spreadsheet, etc.
I'm looking for some practical advice on how to keep this "ad hoc" access
from crippling the
database.  I'm especially concerned about end users creating queries that
consume vast resources.

Has anyone out there successfully installed and supported an end user
query tool that was actually used by end users?  How did you prevent
"monster" queries?  How did you handle users formulating queries that
returned misleading results?  How did you /will you handle changes in the
database schema?

Thanks for your help.

- Nat Brooks
   (nbrooks@bbn.com)
Newsgroups: comp.databases.oracle,comp.os.vms
From: v038958@stortek.com (Nga Hoang)
Subject: Oracle Conversion from VMS to Unix
Originator: v038958@stcvax
Organization: Storage Technology Corp.  Louisville, CO
Date: Sat, 12 Sep 1992 16:10:58 GMT

We are in the process of converting our Oracle applications from a VMS
machine to an Unix machine (Sun).  Our applications consist of SQL*Forms
(3.0), Pro*C user exits & utilities and DCL scripts.  If you have gone
through similar conversion process, we would like to hear about your
experience.  Any hint or tip will be greatly appreciated.


Nga Hoang
Nga_Hoang@stortek.com
-- 
Nga Hoang  -  STC StorageTek (Disk Division)
uucp:	{ hao, ihnp4, decvax}!stcvax!nhh
	{ allegra, amd70, ucbvax }!nbires!stcvax!nhh
USnail:	Storage Technology Corp  -  MS 1169 / Louisville, CO / 80028
From: dlm@hermes.dlogics.com
Newsgroups: comp.databases.oracle
Subject: Re: Object-Referencing Strategies
Date: 7 Sep 92 11:38:16 CST
Organization: Datalogics, Inc., Chicago, IL

In article <1992Sep3.172635.105@datani.dk>, la@datani.dk writes:
> ...Object-Referencing is a way (as far as I can see) to ensure that changes 
> will be reflected in the whole system, and as so just what I want.  
> 
> ...So I want to know:
> 
> 	1. When is it a good idea ?. Advantages.
> 		- library forms???
> 		- for blocks 
> 		- for fields 
> 		- for triggers, procedures. 
>
It is always a good idea to collect procedures into library forms since in v6
this is your only way to hide information about your objects. You can write
procedures for validating every column used on any form, or for performing
trigger actions. Then you will write procedure calls in your triggers instead
of lots of pl/sql lines. To remain compatible with v7, i recommend that you 
collect procedures in your library rather than triggers, fields, or blocks.

If the same block is used on many forms, consider writing it as a separate form
and then call it when needed. Use global fields to pass parameters between such
calls.
> 
> 	2.  Drawbacks.
>
You will be obliged to observe very strict coding and naming standards so that
procedures can reference block/field objects across all forms in which they are
referenced. This is beneficial in any programming system.

Programmers will have to specify the userid of the library owner when
generating, that is, they will not be able to enter "SQLFORMS30 /". Perhaps
this is no problem for you.

> 
> 	3.  Experiences.
> 
I felt that sqlforms generation performance was seriously reduced when many
small procedures were referenced (that is, generation was much slower). This
may be a local response to our database conditions, or it may be universal.
One solution may be to keep forms as short as possible (fewer screens per form,
more forms) to reduce your development time.
--
Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450
dlm@dlogics.com                                 Motto: Just show me the code
Newsgroups: comp.databases.oracle
From: p228@uni05.larc.nasa.gov (Bailey Bob)
Subject: Re: more info about: Re: Which DEC/Ultrix box to pick?
Organization: Unisys-Hampton VA
Date: Mon, 14 Sep 1992 14:46:53 GMT

In article <1992Sep13.165429.9603@u.washington.edu> cintra4@milton.u.washington.edu (Dave Lange) writes:
>I have chosen Oracle for a database to hold 500M to 1.5G of data for querying,
>not transactions or dataentry. It will be used by a maximum of 5 users at a 
>time. I originally intended to use oracl.nlm on a dedicated netware server.
>The hardware was to be an EISA based 486DX2-66 with 17M, an Adaptec 1740 SCSI
>contro and a 32 bit ethernet board.
>
>>I would like to consider shifting this to unix, using the DEC platforms.
>>I understand unix has a flat loading curve as the number of users
>>increases, but this isn't my situation. What I need is the lower part
>>of this load curve to match or exceed the performance the NLM would have
>>provided on the selected platform.
>>
>>Without starting wars over whose system is better, I would like to know
>>what you have found out, in terms of benchmarks or use, about which
>>Ultrix box will give me equivalent performance in my situation.
>>
>>Also, how close to the top of the list is Ultrix in terms of when new
>>releases of Oracle are ported to different platforms? 
>>

While I don't have any exact performance specs handy, I can tell you what we
are doing here with the DECsystem 5000:

We are running Oracle 6.0 & SQL*Forms 3.0 on 8 DECsystem 5000's that are
configured as a distributed database.  The exact configuration of each 5000
is tailored to the number of users on each machine.  The smallest is a
DECsystem 5000 Model 200 with 80M memory.  This one supports around 75 users,
although the user license limits it to 32 concurrent users.  Performance on
this machine is satisfactory.  The largest is a 5000 model 200 with 224M 
memory.  This one needs to support about 140 users eventually.  The license
on this one also limits it to 32 concurrent users.  In this configuration,
it is being overburdened.  We are upgrading it to a model 240 (55% faster)
and will probably add more memory so that we can upgrade to a 64 user license.

These machines start somewhere in the low $20K range and go up from there.  We
are considering the new DEC Alpha machine for the future.  As I understand,
it is about 5 times faster and not much more expensive: i.e. more bang for
the buck!

For your application, DEC also makes some smaller DECstation 5000's that might
be suitable.  These are designed to be individual workstations, but could
possibly support 5 users; ask DEC, they can tell you what would be appropriate.

As far as Oracle is concerned, historically, one of the first platforms that
Oracle was ported to was DEC VMS.  From what I have been told, since the 
industry seems to be moving away from VMS and toward Ultrix/Unix, Oracle will
likely follow suit.

Bob Bailey p228@uni05.larc.nasa.gov
From: NBROOKS@BBN.COM (Nat Brooks)
Newsgroups: comp.databases.oracle
Subject: Summary: Controlling "ad hoc" queries
Date: 10 Sep 92 13:27:48 GMT
Organization: Bolt Beranek and Newman, Inc.
NNTP-Posting-Host: 128.89.17.153
X-UserAgent: Nuntius v1.1

In article <lapscgINN8jg@news.bbn.com> Nat Brooks, NBROOKS@BBN.COM writes:
>Has anyone out there successfully installed and supported an end user
>query tool that was actually used by end users?  How did you prevent
>"monster" queries?  How did you handle users formulating queries that
>returned misleading results?  How did you /will you handle changes in the
>database schema?

That's what I asked a few days ago.  The summary is that there is no
summary.  I did get asked to post a summary of responses, so here it is. 
Noone has replied with stories of success.

Now that I've taken care of that piece of business, I'll open the
question up a little:

Are "user query tools" a dead end, due to inadequate protection against
"incorrect" queries?
If so, what are the alternatives (rapid development of query
applications, improved report
writing tools...)?.  If not, how are they best used (only with heavy
training for users, small databases only, on extracted "reporting"
databases...)?

My intention here is to stimulate discussion.  Speculate away!

- Nat Brooks
From: pihlab@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Re: rollback segments - AVAILABLE vs. IN_USE  ??
Date: 10 Sep 92 08:52:42 +1000
Organization: Aust. Dept. Health, Housing and Community Services

In article <1992Sep8.163457.1@jaguar.uofs.edu>, littlec1@jaguar.uofs.edu (Chris Little) writes:
> I'm running Oracle 6.0.33 on a VMS platform.  I have a rollback segment,
> rb_A, which is AVAILABLE, but not IN_USE.  I have a single tablespace,
> ts_A, which is solely dedicated to rb_A.  If I do a SHOW DEVICE/FILE,
> I discover that file_A, which contains only ts_A, is open.  Why is it
> open, if rb_A is not IN_USE?
> 
> --
> Chris Little, Programmer/DBA                    University Computing Systems
>                                                 University of Scranton
>   LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510


You've got to reference the new rollback segment in your INIT.ORA file for
that database to make it active.

I think the parameter is rollback_segment = rb_A

-- 
Bruce...        pihlab@hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************
Newsgroups: comp.databases.oracle
From: kumar@ra.csc.ti.com (Sundeep Kumar)
Subject: Porting Applications written in Ingres/C to Oracle Pro*C
Followup-To: kumar@ra.csc.ti.com 
Organization: Texas Instruments
Date: Tue, 8 Sep 1992 16:21:35 GMT

A Company where a friend works is presently changing over from an 
INGRES DBMS (they got it free with BSD 4.2) to ORACLE system 6.
They have many C applications written for the INGRES Database. Is
There a automatic C/INGRES(embedded SQL) ---> Oracle/Pro*C Translator
available ?

--SK
From: pihlab@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Re: Forms3 LOV
Date: 7 Sep 92 09:51:14 +1000
Distribution: world
Organization: Aust. Dept. Health, Housing and Community Services

> 
> SELECT 'Y', 'N'
> INTO   :my_field
> FROM   system.dual


Hmmm....  Try a UNION statement to get the two items as separate rows rather
than as seperate columns.

Something like:

SELECT 'Y' FROM dual
UNION
SELECT 'N' FROM dual;


-- 

Bruce...        pihlab@hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: How to print something in PL/SQL
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Sat, 5 Sep 1992 00:50:31 GMT

shamel@mais.hydro.qc.ca (Stephane Hamel) writes:
>When you use PL/SQL in SQL*Forms, you can show messages using the SQL*Forms
>MESSAGE() function.

This is because the PL/SQL engine runs INSIDE of SQL*forms 3.0, not on the
database except when it has to access a database-inherent function such as
a sequence, table, view, pseudocolumn (sysdate), and so on.

Because it runs WITHIN SQL*forms it has access to your keyboard and screen,
just like Forms does.  Additionally, forms adds a bunch of packages to the
PL/SQL language (for example, MESSAGE() :-) ) which actually end up calling
a SQL*Forms routine.

>I have built an SQL*Plus script, wich use in-line PL/SQL. My problem is that
>there is no way to print a message on the screen when you are inside the
>PL/SQL block! 

Right.  When you are in SQL*Plus, the PL/SQL is running on the DATABASE
engine, not within SQL*plus.  The "Database engine" has no access to your
screen at all, nor are these predefined packages available to it.

>              I wonder if someone have a solution for this. I can't understand
>why there is no ECHO, PRINT, TYPE, REMARK, COMMAND, MESSAGE or any such command
>that simply print-out a text string!

The solution, which only works if you can execute a standard.COMMIT statement,
is to insert trace and other information in a table which you can view
after the fact.  This doesn't work if you need to ROLLBACK any of your work,
since the trace info ends up rolled back, too. :(

>--
> Stephane Hamel (SHamel@Mais.Hydro.Qc.Ca)

Hope that helps a little.  One of the things that CAN work is to
use "SELECT 'I got to point3' INTO :variable FROM DUAL" within a Pro*C
embedded PL/SQL block, you can use as many variables as you want to know
how things are going.

-- 
Andrew Finkenstadt       | Vista-Chrome, Inc.   |           andy@GEnie
GEnie Unix Sysop/Manager | The Printing House   |    NIC Handle: AF136
+1 904 222 2639 home     | 1600 Capital Cir SW  |   ...!uunet!rde!andy
+1 904 575 0189 work     | Tallahassee FL 32310 | andy@vistachrome.com
--------->  "Our OS which art in CPU... UNIX be thy name"  <----------
From: littlec1@jaguar.uofs.edu (Chris Little)
Newsgroups: comp.databases.oracle
Subject: rollback segments - AVAILABLE vs. IN_USE  ??
Date: 8 Sep 92 21:34:57 GMT
Organization: University of Scranton

I'm running Oracle 6.0.33 on a VMS platform.  I have a rollback segment,
rb_A, which is AVAILABLE, but not IN_USE.  I have a single tablespace,
ts_A, which is solely dedicated to rb_A.  If I do a SHOW DEVICE/FILE,
I discover that file_A, which contains only ts_A, is open.  Why is it
open, if rb_A is not IN_USE?

--
Chris Little, Programmer/DBA                    University Computing Systems
                                                University of Scranton
  LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510