HDTenEightyP/NetNews huggingface dataset:
From: joe.bartling@sqlware.uunet.UU.NET (Joe Bartling) 
Newsgroups: comp.databases.oracle
Subject: VISUAL BASIC AND QELIB
Date: 20 Dec 92 18:52:00 GMT
Distribution: world
Organization: SQLWare Inc., Leesburg, VA - (703) 771-3979
Reply-To: joe.bartling@sqlware.uunet.UU.NET (Joe Bartling) 


I have been using Visual Basic under MS-Windows and connecting to ORACLE
using QELib from Pioneer Software which connects to Oracle via SQL*Net.
The biggest problem is that I can't connect to a local DOS ORACLE
database (only client-server).  Other than waiting for Pioneer to come
out supporting local an Oracle DOS database, are there any other
solutions given my front-end of Visual Basic?  Has anyone heard of
Microsoft Access?  Will that help?

Regardz, Joe

-----------------------------------------------------------------------
Joe Bartling, SQLWare Inc., Leesburg, VA
SQLWare BBS: (703)771-4158 (Specializing in ORACLE files/solutions)
uunet!sqlware!jbartlin
-----------------------------------------------------------------------
                           
----
+--------------------------------------------------------------------------+
| SQLWare BBS  703-771-4158 (HST V.32BIS-Specializing in ORACLE and other  |
| RDBMS topics.  Sponsored by SQLWare Inc., Leesburg,VA-300 conferences.   |
+--------------------------------------------------------------------------+
From: kmallory@oracle.com (Kevin Mallory)
Newsgroups: comp.databases.oracle
Subject: Re: Does anyone know the status of SQL*FORMS 5.0
Date: 31 Dec 92 18:32:45 GMT
Organization: Oracle Corp., Belmont 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.

SQL*Forms 4.0 is currently ALPHA. 
--
---------------
Kevin Mallory	Oracle Corporation - Redwood Shores, California
Manager, Quality and Performance Programs
SQL*Forms Development
I don't speak for Oracle, nor they for me.
Remember: If you can find someplace you laik better 'n' Tuna... **MOVE**!
From: frampton@vicuna.ocunix.on.ca (Steve Frampton)
Newsgroups: comp.databases.oracle
Subject: Can the screen be cleared in RPT?
Date: 23 Dec 92 01:25:52 GMT
Reply-To: frampton@vicuna.ocunix.on.ca
Followup-To: comp.databases.oracle
Organization: Vicuna Systems, Kingston, Ontario, CANADA
Content-Type: text/plain; charset=us-ascii

Hi everyone:

Just 3 quick questions:  

(1) I am writing an RPT where I wish to display a bunch of stuff to the 
user, accept some input, etc.  I would like the screen to be "pretty" and 
was wondering if there was some way of clearing the screen under RPT 
(besides outputting 25 lines).  Oh, this should be a VAX/VMS solution 
(VT220/VT320 emulator).

I tried something to the effect of:

.define clrscrn a4

.define get_clrscrn_value
   select chr(27)||'[2J'
   into   clrscrn
   from   dual
..

.define my_proc
   .execute get_clrscrn_value
   .tell ""clrscrn
   .tell "Welcome to my report..."
..

This method certainly works under DCL, but does nothing under both
SQL*Plus and RPT.

Is there an easy way to clear the screen?


(2) Is there a way to pass a variable from a DCL script to an RPT
program?  If so, how?

(3) Is there a way for RPT to execute a DCL command from within the
report?  If so, how?

I would appreciate any information you can provide.  Please respond
via e-mail to preserve bandwidth, I shall be quite happy to follow-up 
here with a summary.

Thanks in advance!

+--------+< Unabashed Shabba Ranks Fan! >+------+--------------------+
| Steve Frampton - frampton@vicuna.ocunix.on.ca | Steve Frampton     |
| I collect postcards!  If you send me one from | 501-A Princess St. |
| your area, I'll send one in return.  Send to >| Kingston, Ontario  |
| (Don't forget both email and mailing address) | CANADA   K7L 1C3   |
+-----------------------------------------------+--------------------+
From: ballt@osshe.edu (Terry Ball)
Newsgroups: comp.databases.oracle
Subject: Direct to tape exports?
Date: 28 Dec 92 21:06:13 GMT
Organization: Oregon State System of Higher Education
NNTP-Posting-Host: osshe.edu

I am hoping for some net wisdom here.  We have a very large database
and full disks, so we would like to do a direct to tape export.  We 
are currently on Oracle v6.0.32 on a Honeywell DPX2.

The problem we have is that we can not do a direct to tape export from
a parfile.  There is a prompt for the volume and since this is not
a keyword, it can not be included in the parfile.  So we end up
tying up a terminal because the export must be done in the forground.

The question:  Is this different on other platforms?  If not, has the
problem been addressed in later versions and/or will it be different
in v7?

Thanks in advance.

Terry
From: boughter@redbud.asc.slb.com (Ellen Boughter)
Newsgroups: comp.databases.oracle
Subject: oracle
Date: 28 Dec 1992 20:38:55 GMT
Organization: Schlumberger Austin Systems Center
Distribution: world
NNTP-Posting-Host: redbud.asc.slb.com
Keywords: ANSI

Has anyone else out there noticed that specifying mode=ANSI
as a PROC command line argument
negates the effect of specifying sqlcheck=FULL? I have not
yet reported this to Oracle. I'm running Oracle V7.0.10, BTW.
I get around this by running the V6 preprocessor once to see if
there are any Oracle usage errors, then running the V7 preprocessor
to produce ANSI-standard C code. Just a little peculariaty that I
thought I'd mention...

Ellen Boughter
boughter@asc.slb.com
From: epeas@abds7.aberdeen.chevron.com (John Peach)
Newsgroups: comp.databases.oracle
Subject: Re: Explain THIS, please!
Date: 23 Dec 92 08:50:14 GMT
Reply-To: epeas@aberdeen.chevron.com
Organization: Chevron (UK) Ltd.
Disclaimer: The opinions expressed are mine; _not_ those of        
            the company I work for.

In article <1992Dec22.163411.557@hhcs.gov.au>, champs@hhcs.gov.au writes:
|> In article <1gtd91INN7ln@ef2007.efhd.ford.com>, wwm@ef5003.efhd.ford.com (Bill Meahan) writes:
|> > I'm tearing my hair out at the following:
|> > 

-------stuff deleted------

|>             **************************
|> WARNING !  WARNING !  ORDER BYs DON'T WORK IN SUB-QUERIES
|> At least they don't in our version (VAX 3.0.9.7.1).  As soon as we put an order
|> by in a sub-query we got your error (group by worked fine though).  The SQL 
|> reference says you can't have order by in a sub-query on insert,update, and 
|> delete but does not say they're illegal in a select.
|> 

The Oracle7 documentation is more specific:

"The ORDER BY clause cannot appear in subqueries within other statements".


-------more deleted------

|> 
|> Hope this helps.
|> ------------------------------------------------------------------------------
|>     /\       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 !
|>     \/

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas@aberdeen.chevron.com       Phone: +44 224 242637
Newsgroups: comp.databases.oracle
From: srangan@mothra.syr.EDU (R A N G A N )
Subject: Is Oracle (Unix version) available on public domain site ?? 
Organization: Syracuse University, Syracuse, NY
Date: Thu, 24 Dec 92 18:11:19 EST

hi Netters,
             Is oracle (on unix platform) available on Public domain ?? . If
             yes can you please let me know. Also how much memory does it
             comsume ??. And what is the latest wersion ??

Thanks a lot.

Rangan
From: zhou@igd.fhg.de (Zhou Jian)
Newsgroups: comp.databases.oracle
Subject: Help needed: how to install SQL*Forms under X11/mwm
Keywords: SQL*Forms
Date: 27 Dec 92 17:21:12 GMT

I  am installing SQLFORMS on a SUN-SPARC/SLC, using  SunOS Release
4.1.1 and X11R5.  I used the utility crt and created the file
XTERM.crt. However, when I call sqlforms to run examples in the
SQL*Forms Designer's Tutorial, sqlforms hangs up after I input userid
and password.

Can anyone give me some tips on how to install SQL*Forms under X11(mwm
window is used)? PLease send your suggestions to
    zhou@igd.fhg.de
I use Oracle RDBMS  V6.0.33.1.1 and SQL*Forms 2.3.31.1.4.

Thank you in advance.

+----------------------------------------------------------------+
| Jian Zhou -- Jaegertorstr. 41 -- 6100 Darmstadt 12 -- Germany  |
| email: zhou@igd.fhg.de                Home:   +49/6151/377537  |
| Fax: +49/6151/155199                  Office: +49/6151/155141  |
+----------------------------------------------------------------+

P.S. When I installed the whole oracle rdbmsseveral months ago, I used
oracle.install to install the SQL*Forms. oracle.install automatically
selected sun-cmd as default terminal and created the file SUN-CMD.crt.
My SQL*Forms  currently works well under openwindow, but not under
X11R5/mwm.
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases.oracle
Subject: Re: Question about OPS$LOGIN and Oracle Passwords
Date: 22 Dec 92 16:40:53 GMT
Followup-To: comp.databases.oracle
Organization: Dartmouth College

In article <24727@suned1.Nswses.Navy.MIL>, lev@ipxed5.nswses.navy.mil
(Lloyd E Vancil) wrote:
> 
> In article <1992Dec14.200952.22697@netcom.com> sjs@netcom.com (Stephen Schow) writes:
> >We routinely use the OPS$LOGIN feature of Oracle for all of our users.  This
> >way they don't have to worry about anything once they are logged onto the
> >UNIX machine.  They just type program / to run it with their UNIX login info.
> >
> >Question:  
> >
> >When we create a new user as follows:
> >
> >	grant connect to ops$user identified by bogus;
> >
> >and we actually use the word 'bogus' as the oracle password.
> >
[stuff omitted]
> 
> >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
> 
> 
> Emphatically YES
> 
> 
> This is a known security hole in the OPS$ user under oracle 6.. 
[stuff omitted]> 
> Since the OPS$ password need only be used once, in the
> grant command, the dba should be free to use any valid
> password, as long as it follows 2 conventions
> 1. the dba should be THE ONLY PERSON TO KNOW IT.
> 2. each one is unique (within reason here folks)

I disagree with #1.  There is no reason for the dba to know these
passwords, either.  If a DBA really needs to know somebody's password, they
can always
change it to something known, then change it back.

You can use a script to set the password to a random value.  Or, you can
use the VALUES clause to set the encoding of the password, so that the
actual password is not known by anyone.

Glad to hear this is fixed in ORACLE 7.
From: rjk@world.std.com (robert j kolker)
Newsgroups: comp.databases.oracle
Subject: Re: What is Oracle?
Date: 28 Dec 92 17:16:32 GMT
Organization: The World Public Access UNIX, Brookline, MA


If I may follow up Mike Stouts reply, a relational database management
system also manages *transaction* and resolves conflicting access to data
(particularly write accesses) at the finest level of granualarity.  This
way it is possible to maximize the throughput of several simulteneous
writer/updaters to the database.

This could also be managed with ENQUE/DEQUE facilities in most operating
systems, but a particular application could not have a global view of the
usage of a database among several users so it would be difficult to
control conflicting accesses at the application code level without all
sorts of kludgery.

Admittedly, DBMS systems at this state of technology are resource hogs,
but they do repay by providing safety, and integrity of the data, which
would be difficult, if not impossible, with descrete applications.

Robert J. Kolker

-- 
"If you can't love the Constitution, then at least hate the Government"
Newsgroups: comp.databases.oracle
Subject: Question about Mac Excel & Oracle tables
From: joaquin@nemesis.etsimo.uniovi.es (Joaquin Ordieres Mere)
Date: Wed, 23 Dec 1992 08:02:04 GMT
Organization: Universidad de Oviedo.

Hi,

I'm apologize if it's a FAQ, but we would like a hot
link between Mac Apllications (Excel mainly) and tables living on
unix system under oracle.
Some weeks ago I had see some references to DAL products on Mac,
but I don't know what's necessary to have over the host computer
(OracleNet ???) in order to be enabeled this hot data link.

Could someone point out some idea. Any idea would be wellcome.

Thanks in advance.
			Joaquin
From: zhou@igd.fhg.de (Zhou Jian)
Newsgroups: comp.databases.oracle
Subject: How to install SQL*Forms
Date: 30 Dec 92 14:59:20 GMT


I am installing SQLFORMS on a SUN-SPARC/SLC, using  SunOS Release
4.1.1 and X11R5.  I used the utility crt and created the file
XTERM.crt. However, when I call sqlforms to run examples in the
SQL*Forms Designer's Tutorial, sqlforms hangs up after I input userid
and password.

Can anyone give me some tips on how to install SQL*Forms under X11(mwm
window is used)? PLease send your suggestions to
    zhou@igd.fhg.de
I use Oracle RDBMS  V6.0.33.1.1 and SQL*Forms 2.3.31.1.4.

Thank you in advance.

+----------------------------------------------------------------+
| Jian Zhou -- Jaegertorstr. 41 -- 6100 Darmstadt 12 -- Germany  |
| email: zhou@igd.fhg.de                Home:   +49/6151/377537  |
| Fax: +49/6151/155199                  Office: +49/6151/155141  |
+----------------------------------------------------------------+

P.S. When I installed the whole oracle rdbmsseveral months ago, I used
oracle.install to install the SQL*Forms. oracle.install automatically
selected sun-cmd as default terminal and created the file SUN-CMD.crt.
My SQL*Forms  currently works well under openwindow, but not under
X11R5/mwm.
From: cc920@cleveland.Freenet.Edu (Michael A. Rife)
Newsgroups: comp.databases.oracle
Subject: Re: Query only forms
Date: 30 Dec 1992 04:29:05 GMT
Organization: Case Western Reserve University, Cleveland, OH (USA)
Reply-To: cc920@cleveland.Freenet.Edu (Michael A. Rife)
NNTP-Posting-Host: hela.ins.cwru.edu


In a previous article, vkg1@Ra.MsState.Edu (VINAY GIDWANI) says:

>I have a form which I am invoking from a menu application.
>I want the form to be a only query form when I invoke it
>from a certain option in a menu. If I invoke it from another
>part it should be a form where I can commit changes etc.
>
>I tried the packaged procedure CALL_QUERY but could not 
>get it to work.
>
>Any suggestions or hints would be welcome.
>
>My email address is vkg1@ra.msstate.edu
>
>Thanks
>
>
>Vinay
>--
>
>Vinay Gidwani
>email vkg1@ra.msstate.edu
>

Situation:

You have menu MENU01 which has option #1 calling FORM01 in "data entry mode". 
You want option #2 menu MENU01 to call FORM01 in query-only mode (
ie. CALL_QUERY).

Solution:

Have option #2 run a FORM02, which in-turn does a CALL_QUERY
to FORM01 and then does an EXIT_FORM.  This can be accomplished in a 
KEY-STARTUP trigger or possibly a PRE-FORM.  Try it an see.
From: jdelacr@afterlife.ncsc.mil (Jorge DeLaCruz)
Newsgroups: comp.databases.oracle
Subject: Info: Oracle 3rd Party Front Ends
Date: 23 Dec 92 14:11:01 GMT
Organization: The Great Beyond


	I am requesting information (email unless other people want to know
   as well) about 3rd party front-end software for ORACLE.  We want a MOTIF
   interface that will run on Decstations (Ultrix, as well as the OSF) and SUN
   Sparc 4s.  The boss doesn't want to wait for SQLFORMS 4.0 and its MOTIF
   interface.

	If you don't know a number to call, please post the name of the
   company and maybe someone knows the phone number or address of the company.


	Thanks in advance.

					Jorge Delacruz
					internet: jdelacr@afterlife.ncsc.mil
From: Matt@chchp.ac.nz (Matt Thompson)
Newsgroups: comp.databases.oracle
Subject: Archive files with Oracle for Novell
Date: Tue, 22 Dec 1992 03:26:47 GMT
Organization: Christchurch Polytechnic
Distribution: world
NNTP-Posting-Host: 192.203.99.76


Does anyone know how to force Oracle to flush the current Archive logs  ???

This is with oracle running as a NLM under Novell 3.11.

This seems to be automatic with a database shutdown under OS/2 and Unix but 
not always the case under Novell.

Thanx.

Matt Thompson
Software Technician
Christchurch Polytechnic
New Zealand
From: alacy@hayes.com
Newsgroups: comp.databases.oracle
Subject: Oracle table security
Date: 22 Dec 92 17:28:31 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

My company is considering way of setting up tables to control Oracle 
security. The basic idea is to have a security officer to update tables 
via a form and then use SQL to read the tables and write the grant 
statements.
 
My question is, are we reinventing the wheel? Has anyone on the net done 
this, and do they have any advice on how?

Newsgroups: comp.databases.oracle
From: gene@aee.aee.com (Gene Kochanowsky)
Subject: Does anyone know the status of SQL*FORMS 5.0
Reply-To: gene@aee.aee.com
Organization: Associated Electronic Engineers
Date: Thu, 31 Dec 1992 04:12:21 GMT

To all Oracle Oracles,

	If any of you know what the status of SQL*FORMS 5.0 is please let me
know.

Thanks

Gene Kochanowsky
-- 
Gene Kochanowsky                           | "And remember ....
Associated Electronic Engineers, Inc.      |       The better you look ... 
(904)893-6741 Voice, (904)893-2758 Fax     |       the more you will see."
gene@aee.com                               |               Miss Lidia
Newsgroups: comp.databases.oracle
From: skanga@us.oracle.com (Shiraz Kanga)
Subject: Re: Loading Oracle 5.1A on OS/2 2.0 in a DOS BOX
Organization: Oracle Corporation, Redwood Shores CA 94065
Date: Tue, 22 Dec 1992 16:51:16 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 <1748@rwja.umdnj.edu> holowczk@rwja.umdnj.edu (Richard Holowczak) writes:
>orville%weyrich@uunet.uu.net (Orville R. Weyrich) writes:
>
>[Tale of Oracle install deleted]
>
>>Has anyone successfully installed this version of Oracle with OS/2 2.0?
>
>>How?
>
>>[Or does anyone have a developer's copy of Oracle that works with OS/2
>>for sale real cheap?]
>
>>Thanks for advice,
>          
>           In an OS/2 article in BYTE magazine, Oracle was one
>           application which was said to be incompatible with OS/2 2.0.
>           It seem the Oracle PME is not compatible with OS/2 2.0 XMS.
>           I have not tried it myself having read the article first.
>
>           Oracle has an OS/2 edition but it is currently only supported
>           by OS/2 1.x.
>
>

As I mentioned to Orville, SQLPME ( Oracle's protected mode executive for DOS ) needs to have a VCPI compliant memory manager (if any) installed. However the 
DOS box of OS/2 provides DPMI compliant memory so the PME will not work.

However OS/2 2.0 is COMPLETELY supported. You need the 6.0.34.2.1 database
(yes it is 32 bit) and the 6.0A tools for OS/2.

Hope this helps.

shiraz

-- 
Shiraz Kanga (skanga@oracle.com) Tel: (415)506-5412 Fax: (415)506-7822
Analyst -- Desktop Tools Group -- Worldwide Technical Support -- 3OP11
Oracle Corporation 500 Oracle Pkwy, MS 659311, Redwood Shores CA 94065
"I work for Oracle - I speak and type (over here at least) for myself"
From: jurista@cbnewsg.cb.att.com (james.jurista)
Newsgroups: comp.databases.oracle
Subject: SQL*Forms Trigger Optimization
Summary: Form- or block-level?
Keywords: efficiency triggers SQL*Forms
Date: 23 Dec 92 22:01:19 GMT
Organization: AT&T

Greetings, netters:

I'm using SQL*Forms 3.0 under Oracle v6, and my question is this:

Is is more efficient to code one form-level trigger or many block-level
triggers to accomplish a task.  For example, I have triggers with the
following structure:

	(Form level KEY-DOWN)
	declare
		valid boolean := TRUE;
	begin
		if :system.cursor_block = 'block1' then
			procedure1(valid);
		elsif :system.cursor_block = 'block2' then
			procedure2(valid);
		elsif :system.cursor_block = 'block3' then
			procedure3(valid);
		else
			valid := FALSE;
		end if;
		if (valid = TRUE) then
			down;
		end if;
	end;

	(Block level KEY-DOWN (one for each of blocks 1, 2, and 3))
	declare
		valid boolean := TRUE;
	begin
		procedureX(valid);
		if (valid = TRUE) then
			down;
		end if;
	end;


I believe that it's good practice to define each trigger as close as
possible to its point of use (in this case, at the block level), but
this can greatly increase the size of the INP file and thus, I assume,
the memory requirements since a larger program must be loaded at run
time.  From that perspective it would seem that the form-level approach
is more prudent.  

It comes down to this:  which is more efficient?  And, while we're at
it, which style do you prefer.

Please e-mail responses, I will post a summary.  Thanks in advance for
any assistance!

Jim

-=-=-=-=-=- Jim Jurista =-=-=-= Internet: jurista@llssak.attmail.com =-=-=-=-
                  "Musical elation is my only consolation..."
           Views/opinions above:  Mine, not AT&T's nor probably yours
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
From: tdonnell@ncrsoph.Sophia.NCR.COM (Tom Donnelly)
Newsgroups: comp.databases.oracle
Subject: Re: Monday Morning Blues?
Date: 29 Dec 92 10:34:47 GMT
Reply-To: tdonnell@ncrsoph.Sophia.NCR.COM (Tom Donnelly)
Organization: NCR European Development Center

In article <1992Dec28.181625.9736@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>We reboot our UNIX Oracle Server every weekend.  Every monday morning, all
>of our Oracle users complain about unusually slow performance.  Anyone have
>any clues why?  After a few hours it usually speeds up again, but the first 
>few hours of monday are slower than molasses(sp).

  I've seen this happen a few times, and in some other instances as well.  I
  think it may actually have something to do with disk / memory caching and the
  buffer caching of Oracle and Unix.  Until a system reaches a certain load, it
  seems to be a little sluggish.  After it gets ( I think ) its cache and buffer
  populated, it appears to gain in performance. 

  I have seen this happen on large systems where only 1 - 3 users log in.  After
  more users log on, the system performance actually increases.

Just my $.02

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

--------------------------------------------------------------------------------
These views are my own and do not represent those of my company.
No gaurantee, implied or other, unless specified by law. Details on back.
--------------------------------------------------------------------------------
Tom Donnelly               | WIN: Tom.Donnelly@Sophia
NCR Europe Group ISS       | UUCP: ..ncrcom!ncrsoph!tdonnell
Sophia Antipolis, Valbonne |                              
France			   | TEL: 33-92 94 45 40


Newsgroups: comp.databases.oracle