HDTenEightyP/NetNews huggingface dataset:
From: twood@windward (Tim Woodward)
Subject: Anyone using stored procedures with Pro*C ?
Organization: U S WEST Information Technologies
Date: Thu, 3 Sep 1992 13:09:49 GMT

	I am having a lot of trouble with calling stored procedures from
	pre-compiler code. Does anyone have a small example they would be
	willing to share? Any help would be appreciated.

	Tim Woodward
From: sharmp@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: PL/SQL, V$ problem
Date: 1 Sep 92 15:52:56 +1000
Organization: Aust. Dept. Health, Housing and Community Services

As part of our database monitoring, we have a system that collects stats on
database performance each time a database is started or stopped.  The stats
that are collected are based on snapshots of the dynamic v$ tables.  The 
snapshots have exactly the same column definitions as the v$ tables.  When the 
database is stopped or started, a series of insert statements load the 
snapshot tables with the data in the v$ tables.

The problem that we have struck is that we are attempting to rewrite the insert
statements in PL/SQL, because the current system dramatically slows down
starting and stopping databases.  When we try to do this, trying to load our
V$LOCK, V$PARAMETER, V$RESOURCE, V$ROWCACHE and V$WAITSTAT snapshot tables
fails because columns in these tables are PL/SQL reserved words (TYPE, COUNT
and RANGE).  A statement like 
	INSERT INTO dbu.drs_snapshot_v$lock
	     SELECT d.db_started,
		    d.db_closed,
		    v.addr,
		    v.pid,
		    v.type,
		    v.id1,
		    v.id2,
		    v.lmode,
		    v.request
	       FROM v$lock v, dbu.drs_driver d
fails because TYPE is a PL/SQL reserved word.  Sure, we could create the insert
statement as select * from, or rename the column, but is there a way to get
PL/SQL to accept a reserved word as a column name (how come ORACLE uses
reserved words anyway?! :^)).

By the way, we are running ORACLE V6.0.34 on VAX/VMS 5.5-1, PL/SQL V1.0.33.1.


Regards

Peter
Newsgroups: comp.databases.oracle
From: devine@olympus.CS.Berkeley.EDU (bob devine)
Subject: Re: Oracle TPC Benchmarks and "discrete transactions"
Organization: University of California, at Berkeley
X-Newsreader: Tin 1.1 PL3
Date: Wed, 2 Sep 1992 20:32:12 GMT

tcox@netcom.com (Thomas Cox) writes:
: If dt's are useful in a TPC environment, then they will be useful in
: those real world applications that resemble the TPC environment.  If
: there are no such applications, then the TPC is useless.  Which position
: are you taking?

The discrete transactions that are in Oracle 7 are so constrained that
they only seem good for TPC style uses.  As to whether the TPC benchmark
that Jim Gray developed is close to reality depends on your reality.
For an OLTP system, maybe the constrained discrete transactions can
be used (hard to say for the general case) but for complex queries
it seems doubtful (full-blown transactions are needed there).

The question of whether it is possible to invent a faster mechanism
for special cases is a simple "of course it is possible!"  But the
question is still open about if the constrained mechanism is useful
for more than a handful of cases.  The IMS approach fastpath was 
useful, and in my first method I was agreeing that something similar
could be usefully added to relational systems (though the more
religious may brand that as heresy).

Bob Devine
From: jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
Subject: Re: Customization of SQL*Forms.
Date: 27 Aug 92 07:21:54 GMT
Organization: University of Helsinki

In article <!-cn0-c.tcox@netcom.com>, tcox@netcom.com (Thomas Cox) writes:
> sinha@watson.bms.com (Anil Sinha) writes:
>>Many sites have written awk scripts ( in unix o/s) or 
>>other utilities to modify the ".inp" file. These utilities help to automate 
>>the customization procedure. 
> 
> 	Ahah!  The reason you're doing that is because... you modify
> 	your form (as above), and then for some reason you change some
> 	aspect of your CASE logical model and thus need to re-gen the
> 	form.  And in CASE Generator v1 (for Forms) the re-gen stomps
> 	all over your customization work.  Ouch.
> 
> 	But using 'awk' should be unneccessary.  Because... CASE
> 	Generator v2 for Forms no longer stomps on your customization
> 	work.  It lets you re-generate nondestructively.  

What does this 'nondestructively' mean? How generator v2 checks which
parts have been hand-modified?

What if the CASE logical model and hand-modifications contradict? Which
change takes presedence? Can I specify that I want to keep this
piece of hand-modification and replace this hand-modification with the
changes implied by the new CASE model?

Is the technique foolproof?

No, I don't have a manual at hand. Neither do I wish to hear any
marketing vaporware - I would like to hear a precise technical answer,
if possible.

> Tom Cox      DoD #1776   '91 CB 750 Nighthawk   tcox@netcom.netcom.com
> Yeah, I have a day job.  They don't believe me any more than you do.
--
Juhani Jaakola
jaakola@cc.helsinki.fi
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Old RPT and ORACLE Version 7
Date: 25 Aug 92 17:57:18 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna


Hi,

In a few months we are going to upgrade our oracle-database to version 7. 
At the time we have a lot of good old RPT-Reports, still working under 
oracle v6.

But will ORACLE V7 also support old RPT-Reports ?


thanks

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
 Bankgasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================
From: pihlab@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Oracle7 userids
Date: 1 Sep 92 16:18:28 +1000
Organization: Aust. Dept. Health, Housing and Community Services


Under Oracle6 when you revoke all access for a user there is no easy
way of actually removing them completely from the database ie they still
appear in the DBA_USERS table as a valid but inactive user.

Has this changed under Oracle7 ?

-- 

Bruce...        pihlab @ hhcs.gov.au
                 ^^

PS. Someone please post a followup to this news group so I know that my
    posting has actually arrived in the NEWS as we've been having problems
    with our NEWS distribution.

*******************************************************************
* 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.        *
*******************************************************************
From: ian@tethys.SLAC.Stanford.EDU (Ian A. MacGregor)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*plus -- limiting maximum number of returned rows?
Date: 1 Sep 92 14:56:53 GMT

In article <BtuK40.8By@ef2007.efhd.ford.com>, wwm@ef2007.efhd.ford.com (William Meahan) writes:
|> In SQL*Plus (not embedded SQL!) is there any way of limiting the number
|> of rows returned by a query?
|> 
|> I am working on a report that is supposed to find the "top 5" items in 
|> a catagory.  The query returns 0 or more rows based on the selection
|> criteria, sorted in the appropriate order.  Some queries return a dozen
|> or more rows, but I'm only interested in the first 5.
|> 
|> If I were using embedded SQL in a C program (or a perl script using 
|> oraperl) the solution would be trivial.  For internal reasons, however,
|> I'm stuck with using SQL*Plus.
|> 
|> Any ideas?
|> 
|> 
|> --
|> Bill Meahan
|> -- 
|> Bill Meahan			|EFHD Information Systems Staff
|> Technical Consultant		|Ford Motor Company
|> wwm@ef2007.efhd.ford.com      	| +1 313 487 6122
|> ...!fmsrl7!ef2007!wwm           |I'm not paid to speak for Ford!

The top 5 articles in a category may return more than 5 rows.  The following
query selects the people with the 5 highest salaried people from the Oracle 
EMP table.

     select * from emp  a where 5 >
     (select count(sal) from emp b where
     b.sal > a.sal)
     order by sal desc
/

If there are ties for the fifth highest paid person all rows containing the
"tie" value will be retrieved.

                         Ian MacGregor
                         Stanford Linear Accelerator Center
                         IAN@SLAC.STANFORD.EDU
                         (415) 926-3528
From: simon.rear@almac.co.uk
Newsgroups: comp.databases.oracle
Subject: rollback segments
Date: 1 Sep 92 21:30:30 GMT
Distribution: comp
Organization: ALMAC BBS Ltd

Hi,

Just a quick note to thank those that helped with my rollback segments
problem..

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

The problem apparently was the default storage parameters of the table space
containing the rollback segments, they allowed the segments to increase beyond
the physical size of the data file.

Thanks to Dave Mausner,
          Gary Meyers &
          Tim London
          (Tim I'd solved the problem before I had chance to answer your
           questions, although they themselves were a good indication as to
           what was wrong... Cheers)
---
 ~ OLX 2.1 TD ~ Press any key to continue or any other key to quit
--
ALMAC BBS Ltd. 0324-665371
Dos based USENET access,  call for details!
From: kan9691@bcstec.ca.boeing.com (Ken Niedermeyer)
Newsgroups: comp.databases.oracle
Subject: SunOS5.0 (Solaris 2.0) and ORACLE
Summary: Plans for ORACLE to run on SunOS 5.0
Keywords: SunOS 5.0 Solaris 2.0
Date: 27 Aug 92 21:06:15 GMT
Organization: Drawing Data Management Systems
X-Newsreader: Tin 1.1 PL4


My site is currently plannin to upgrade our Suns to SunOS 5.0 (Solaris 2.0).
Does ORACLE currently run under SunOS 5.0 or do they have plans on porting
it to SunOS 5.0?


---
Ken Niedermeyer			| The views expressed above do not represent
Computing Systems Analyst	| those of my employer.... (but when do they?)
Boeing Computer Services (BCS)  | 
                                | NOTICE:
Internet:                       | Lack of planning on your part
kan9691@eeidf002.ca.boeing.com  | does not constitute an emergency on my part.

-- 
Ken Niedermeyer			| NOTICE:
Computing Systems Analyst	| Lack of planning on your part
kan9691@eeidf002.ca.boeing.com	| does not constitute an emergency on my part.
Newsgroups: comp.databases.oracle
From: wkaufman@us.oracle.com (William Kaufman)
Subject: Re: keypad & sql*forms
Organization: Oracle Corporation, Redwood Shores CA
Date: Fri, 4 Sep 1992 18:59:44 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 <1992Sep3.133806.971@src.honeywell.com> kdady@src.honeywell.com (Ken Dady) writes:
] 
] Is there a way to re-define the numeric keypad on a
] VT100, Sun keyboard, Mac (running telnet) to be used
] as a 'normal' keypad with SQL*forms? i.e. Keys
] interpreted as numbers instead of functions. The
] numlock key seems to have no effect.

    I'll have to admit ignorance on Sun and Mac, but here's the deal on
the VT100:

    The VT100 is so function key-poor that the numeric keypad had to be
stolen for function keys.  You may be able to work around this problem
by:

    - Removing any keys you're not using, and will never want to use;

    - Using the SQL*Forms 3.0 menu, where applicable (like, for [Enter
      Query] or [Next Record])

    - Squishing all the remaining keys into [Control-something], [Esc
      something], [Esc Esc something],...

    If you can do that, use oraterm to define the new keymap, and remove
the "\e=" and "\e>" from the terminal setup and reset strings.  The
first string puts the keypad in "application" mode, the second in
"normal" mode.

    (In fact, you might want to swap the modes: instead of going into
application mode on entry and normal on exit, you can go into normal on
entry and application on exit.)

                                           -- Bill K.

Bill Kaufman,          | "Maybetheyhadaridiculousstatementtomakeaboutsomethingt
Corporate Lackey       |  heyhadntexperiencedPossiblySamhadadifferentopiniontha
wkaufman@us.oracle.com |  tnobodyeverconsideredimportant."  -- the Meat Puppets
Newsgroups: comp.databases.oracle
Subject: Comparison of Oracel/Ingres/Sybase on a VMS platform
From: sudhir@csc.wcc.govt.nz
Date: Mon, 31 Aug 1992 19:00:57 GMT
Reply-To: sudhir@csc.wcc.govt.nz
Organization: Wellington City Council, Wgtn, NZ

hi netland!

This is a request for information on the following 3 databases 
Oracle, Ingres and Sybase.

We (a local body) work on a 90 VUP VAX cluster of 6 machines and several DECStations
and about a 100Pcs using Pathworks to connect to the cluster and about
a 1000 terminals (500 users logged on at any one time). We use VMS
primarily and there is no plan to move to another platform in the
near future but would still like our chosen database to be portable.

We are starting on a comparative study of these 3 databases (or if someone
can suggest some other one eg Progress, Recital etc) and would like
some experiences of people in the netland. We would like information on

- Performance
- Development tools availability (vendor provided and 3rd party)
- Multi-database access from within applications
- a good API for use in GIS systems to get at the data from a C application
- data types and flexibility in defining and using new ones

Any help will be very useful and will make our task seem a bit easier. We have
until 15th October to submit our report so quick help will be very much
appreciated.

----------------------------------------------------------------------------
Sudhir Motwani, Consultant                              Voice: 64-4- 8013321
Information Technology                                  Fax  : 64-4- 8013020
Wellington City Council                       Domain: sudhir@csc.wcc.govt.nz
P O Box 2199,Wellington                   PSImail: PSI%0530147000090::SUDHIR
New Zealand                      UUCP: ...!munnari!vuwcomp!kosmos!csc!sudhir
----------------------------------------------------------------------------
From: tcox@netcom.com (Thomas Cox)
Newsgroups: comp.databases.oracle
Subject: Re: version 7
Date: 1 Sep 92 01:16:48 GMT
Distribution: usa
Organization: Netcom - Online Communication Services (408 241-9760 guest)

GO.MSB@isumvs.iastate.edu  writes:
>rthorstr@doc.bmd.trw.com writes:
>>ken@cs.UAlberta.CA (Huisman Kenneth M) writes:
>>> Does anyone know when exactly oracle version 7 comes out for the PC???

>>ORACLE has announced that version 7 WILL NOT be implemented on the PC.

>The article in InfoWorld stated NOT FOR DOS -- it is to be a Windows NT
>product only.  Do you have an update on this?  Thanks.

Ah, one of these DOS bigots who says "PC" and means "DOS"?  Well, I had
heard that of the PC operating systems in common use (DOS, OS/2,
Netware, Unix) version 7 was going to be out on all of them EXCEPT DOS.

But I'm no spokesperson.  I gather that the OS/2 version is ahead of the
curve, but that's just because (IMHO) OS/2 is the superior operating
system (yeah, go ahead and flame me ;-).  

There is supposed to be an Official List of which ports the Developer's
Version of Oracle7 is now out on; anybody have it?  Anybody want it?

Cheers.
	-- Tom
-- 
Tom Cox      DoD #1776   '91 CB 750 Nighthawk   tcox@netcom.netcom.com
My opinions!  Mine!  Not those of Netcom, or Oracle, or anybody else I know...
Newsgroups: comp.databases.oracle
From: u437737@sparc12.ncu.edu.tw (im)
Subject: Help ! Oracess Access problem.
Organization: NCU
Date: Mon, 24 Aug 1992 01:19:20 GMT

        currently I am developing an application of 4d with oracle,
I realize if I can allocate several context area, then I can
program more easily. But the oracle access manual really confuses me,
        this is what it said : (p.A-5)
        All open context areas are *closed* prior to COMMITing the work

        but the fact is I can use the same context area after commit,
this bother me because if I depend on it ( I might depend on it a lot )
then it may be incompatible with future version ( since it does not
conform to what document said .) It also maybe possible I mistake
the *close* action, does it mean deallocate ? what happens if
I use it after commit, does it has some side effect ?

        I will appreciate any reply.
  ________
  \      /                               Reply to: steve@im.mgt.ncu.edu.tw
___\ MGT.NCU.EDU.TW __________________________________________________________
    \  /
     \/   /   |)    ------       --             Steve Chiu
         /+-+ |)     +-+ |     ------
          | | |      +-+ |      \  /            EMail: steve@im.mgt.ncu.edu.tw
         -+-+-|         _|     ------           Phone: 886-03-426-7288
        Department of Information Management,
        National Central University, Chungli, Taiwan, R.O.C.
______________________________________________________________________________

Newsgroups: comp.databases.oracle
From: Mark.McIntosh@engr.UVic.CA (Mark  McIntosh)
Subject: Oracle install and SQL clients?
Organization: University of Victoria, Victoria, BC, Canada
Distribution: comp
Date: 26 Aug 92 02:05:40 GMT

1) When installing Oracle v6 on a Sun, does anyone have any particular
   gotchas to watch out for?  We will want to transfer a v5 DOS Oracle
   database to the Sun.  We didn't do the DOS install, so it will be
   our first Oracle installation.

2) I'm having a hard time getting a straight answer from our local
   Oracle rep on this.  When using SQL*ReportWriter from a DOS client,
   what kind of workload balance is there between the client and the
   Sun server?  (We aren't writing any embedded SQL commands for now).
   When doing a query, will the client form it in such a way that all
   the work is done on the server or will a lot of intermediate data
   get sent back to the client for processing there?  We are concerned
   about LAN bridge bandwidth limitations (19.2K bps) to remote sites
   and client processing power (mostly '286).

3) What alternative report generation programs would you recommend?
   Besides basic reports, there will be some need for trend analysis
   in future.

Thanks,
Mark J. McIntosh <Mark.McIntosh@engr.UVic.CA>
____________________________________________________________________________
University of Victoria, Faculty of Engineering - Dean's Office
Box 3055, Victoria, BC, CANADA    \ "...the mystery of life isn't a problem to
V8W 3P6            (604) 721-6049  \    solve but a reality to experience." 
UUCP: ...!{uw-beaver,ubc-vision}!uvicctr!sirius!mmcintos  \ from Dune
From: thierry@curlie.UUCP (Thierry Lach   )
Newsgroups: comp.databases.oracle
Subject: Re: backward scrolling
Date: Wed, 02 Sep 92 21:36:28 EDT
Organization: Not An Organization

louk@research.teleride.on.ca (Lou Kates) writes:

> We were evaluating Oracle recently (based only on the manual).  One thing
> we could not find was a way to get the previous record from the Oracle
> Call Interface to C.  However, a recent article in PC Magazine (September
> 15 issue) mentions that Oracle does have backward scrolling.
> 
> Could someone confirm whether we just missed it or is the article wrong?
> 
> Lou Kates, louk@research.teleride.on.ca

This is probably referring to SQL*FORMS scrolling capabilities
where the user (or the programmer) can refer to the previous
record, or reqest a scroll up.
From: csa09@seq1.keele.ac.uk (Paul Singleton)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*plus -- limiting maximum number of returned rows?
Date: 1 Sep 92 13:05:17 GMT
Organization: University of Keele, England

From article <1992Aug31.223520.28312@massey.ac.nz>, by M.W.Stern@massey.ac.nz (M.W. Stern):
 
> > I am working on a report that is supposed to find the "top 5" items in 
> > a catagory.  The query returns 0 or more rows based on the selection
> > criteria, sorted in the appropriate order.  Some queries return a dozen
> > or more rows, but I'm only interested in the first 5.
 
> I believe the answer to this goes something like this,
> 
> SELECT value FROM table WHERE ROWNUM <= 5

But I think the poster wanted the first N rows of a result relation, not
a base table?  This is one instance where the generalised SQL construct

	SELECT value FROM ( SELECT etc FROM etc WHERE etc )
	WHERE ROWNUM <= 5

would be valuable, assuming that intermediate relations had ROWNUMs.
----
  __   __    Paul Singleton (Mr)           JANET: paul@uk.ac.keele.cs
 |__) (__    Computer Science Dept.        other: paul@cs.keele.ac.uk
 |  .  __).  Keele University, Newcastle,    tel: +44 (0)782 621111 x7355
             Staffs ST5 5BG, ENGLAND         fax: +44 (0)782 713082
Newsgroups: comp.databases.oracle
From: wkaufman@us.oracle.com (William Kaufman)
Subject: Re: Customization of SQL*Forms.
Keywords: SQL*Forms, Oracle CASE
Organization: Oracle Corporation, Redwood Shores CA
Date: Fri, 28 Aug 1992 18:48:24 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 an email message, Steve Schow (sjs@netcom.com) asks me:
] 
] Thanks for responding to our plea.  What exactly is this resprint and
] resparse?  Are these resource files you are talking about part of
] v4 or are you refering to the FRM files?  Do these resprint and
] resparse utilities exist for v3?

    Sorry, should have been more explicit.

    Part of Toolkit 2 (the UI interface for the next generation of
Oracle tools) is the Resource Manager ([tm]?), which is a mini-database.
This is the new version of the Toolkit 1 (SQL*Forms 3.0) resource
files--it's where the terminal definitions, for example, will be stored.

    resprint and resparse are utilities to convert between the text
version and compressed version of the resource file (which, BTW, is
something you can't do with the Toolkit 1 / SQL*Forms 3.0 resource
files).

    If SQL*Forms 4.0 uses resource files for their forms (which, again,
I don't know) you'll still be able to get text versions of the forms.
And, even if it doesn't, there will probably still be some text version
supported, just for maximum portability.

                                           -- Bill K.

Bill Kaufman,          | "...all conscious species are plastic and
Corporate Lackey       |  all plastic species are conscious."
wkaufman@us.oracle.com |                     -- Yew-Kwang Ng
From: shamel@mais.hydro.qc.ca (Stephane Hamel)
Newsgroups: comp.databases.oracle
Subject: How to print something in PL/SQL
Date: 4 Sep 92 13:12:28 GMT
Organization: Hydro-Quebec, Montreal, Canada

When you use PL/SQL in SQL*Forms, you can show messages using the SQL*Forms
MESSAGE() function.

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! 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!
--
 Stephane Hamel (SHamel@Mais.Hydro.Qc.Ca)
Newsgroups: comp.databases.oracle