HDTenEightyP/NetNews huggingface dataset:
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: Is Oracle (Unix version) available on public domain site ??
Date: 4 Jan 93 13:06:56 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

srangan@mothra.syr.EDU (R A N G A N ) writes:

>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

Ho ho ho ho ho.

Just let Oracle Corp Hear This !!!!!!!

Seriously, in order
	NO
	AS MUCH AS IT CAN GET
	7

-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
From: ken@comanche.sbi.com (Ken Jones)
Newsgroups: comp.databases.oracle
Subject: SQL Net
Date: 7 Jan 93 16:49:14 GMT
Reply-To: ken@comanche.sbi.com (Ken Jones)

Dear Oracle Guru's

We looking at using Oracle in a distributed environment. I've heard that
this is accomplished using SQL net. But is it reliable? Is it a good product? 
Is it worth it.  Are there any alternatives?

I can post a summary to the net.

Ken Jones
From: pha@citi.umich.edu (Paul H. Anderson)
Newsgroups: comp.databases.oracle
Subject: PL/SQL and FORMS30 questions
Date: 7 Jan 1993 21:33:39 GMT
Organization: Center for Information Technology Intergration, University of Michigan
Distribution: world
NNTP-Posting-Host: antioch.ifs.umich.edu
Keywords: triggers unique keys forms

Howdy,

I have several problems with sqlforms30 that are really hanging me up:

1) setting the date in a displayed, but non-enterable field.

   I have a pre-record trigger that is attempting to automatically
   store the date of entry into a base table field.  If I convert the
   date, and store it in some other enterable field (e.g. a character
   comment field), etc, it shows up. (hence the trigger is working like I want).
   Likewise, if I set the field to be enterable, I can have it's value
   appear there (override any default value).
   However, when I do the fairly obvious, which is to set a displayed,
   but non-enterable date field equal to sysdate, nothing shows up.
   How can I do this?

2) getting a unique sequence number into a pl/sql local variable.

   I need to use a trigger to call a host program with a unique
   number.  To do this, I need to get the unique number into a
   local pl/sql variable.  I can use insert into <record> values (seq.nextval)
   to put it into the record, but I don't know how to get the record
   back out (since there are multiple forms users).  Apparently, the
   implementation context of the sequence makes it difficult for a
   trigger to get the value.  Any clues?

Thanks greatly for any advice!

Paul Anderson
pha@umich.edu
Newsgroups: comp.databases.oracle
Subject: Re: Help needed: Simple Forms V3 Qns.
From: bamon@ocvaxc.cc.oberlin.edu
Date: 12 Jan 93 08:39:49 EDT
Organization: Oberlin College

In article <1993Jan11.230248.8262@brt.deakin.edu.au>, ajmex@brt.deakin.edu.au writes:
> 
> 1. How do you disable key triggers? In V2 you just defined them with
>    text of "#EXEMACRO NULL", but I cant find an equivalent in V3 .

Use "null;" in the text of the trigger.

> 2. I want a screen to set off a background process that runs a SQL*Plus
>    routine. How do I run this under the same User/Passwd?

What operating system? If VMS, you can use the host command to submit
the background process to run in batch.

An example:

   DEFINE TRIGGER

      NAME = POST-COMMIT
      TRIGGER_TYPE = V3
      DESCRIPTION = Post Commit
      TEXT = <<<
      declare
       temp_command char(200);
      begin
        /* batch the program */
        select
            'batch/log=fa_log:fasj0630_BATCH.log' ||
            '/noprint/keep/noidentify/noconfirm fasj0630' ||
            '/param=("FASF0340","' ||
            :form_variables.test_only_flag ||
            '")'
        into temp_command from dual;
        host(temp_command,NO_SCREEN);
        message('Batched program FASJ0630.');
      end;
      >>>


   ENDDEFINE TRIGGER

> 3. In PL/SQL, if a SQL statement returns no rows, this is interpreted as an
>    error, and the exception handler is invoked. Is there no way to continue
>    processing at this point? Not all cases of "No rows found" are errors, in
>    my book. Not fatal errors, in any case.

In the exception section, use something like the following:

      exception
        when no_data_found then
          whatever;                 [put code or "null;" here.]
        when others then
          null;
      end;


> Thanks for any help given. E-mail prefered. Alister Miller.

I tried to use e-mail, but with no luck.

_____________________________________________________________________
Jennifer R. Amon     FREENET: aa1190@freenet.lorain.oberlin.edu
Oberlin College      FREENET: cc312@cleveland.freenet.edu
Oberlin, OH 44074   *INTERNET: bamon@ocvaxc.cc.oberlin.edu
PH: (216) 775-6987   BITNET: bamon%ocvaxc.cc.oberlin.edu@ocvaxc.bitnet
FAX: (216) 775-8573  *use the internet address if possible        
_____________________________________________________________________
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: Copy objects in Oracle froms 3.0
Date: 12 Jan 93 13:47:35 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

445362@llnl.gov (Grant Johnson) writes:

>Objects can only be copied from forms saved in the database.  Try saving the .inp and then copying...


I know but I would LOVE a #include <fred.inc> like statement.


David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
From: hudek@polaris.llnl.gov (David Hudek)
Newsgroups: comp.databases.oracle
Subject: Pro*C / C++ ??
Keywords: Pro*C, C++, integration
Date: 7 Jan 93 22:26:49 GMT
Organization: Lawrence Livermore National Labs, Livermore CA
Originator: hudek@roxanne.llnl.gov

<||>

Question about Oracle's Pro*C precompiler:

As I understand it and from a quick look at some output, this simply takes
source code statements that start with a key phrase (EXEC SQL...) and
translates them into C code and Oracle system calls.

Given that, is there any reason why the output of Pro*C couldn't then be
run through Sun's C++ compiler and produce good executables? (since the
C++ compiler can obviously handle straight C code).  

We're in the process of moving from an old Sequent box to a Sun
Workstation/Fileserver mode of operation and for various reasons
(maintenance agreements, licenses, upgrades, beauracracy) it's
much more convenient to pay for just a C++ compiler and drop the 
separate C compiler. We would initially still be writing code
in C, but with the intent to migrate to C++ in the future.

It seems like this should work out OK, but has anyone actually done it? 
I've written a number of applications in C with embedded SQL, using the
Pro*C precompiler on the Sequent, but just as a useful system capability...
I didn't install/administer it and the person who did is no longer here.
Are there any strange administrative quirks to be aware of?  Reasons 
why Pro*C and the C++ compiler won't work together on a Sun?

The only potential problem I can think of at the moment from a programming
standpoint is how function declarations are handled... Pro*C outputs
something like "void sqlxxx1();" in the traditional C style, with the
parameters unspecified. I don't know if the latest Sun compilers require
functions to be declared in prototype form (i.e., the parameter types to also
be declared at the time the function is, like "void sqlxxx1(int, float);" 
for example).

Any advice/help? Will it work?


Thanks in advance,
dave hudek
djh@llnl.gov

< standard disclaimer: these are personal opinions only >
< I do not speak for any organization >

Newsgroups: comp.databases.oracle
From: prs9k@brain.med.virginia.edu (Phil Scarr)
Subject: Oracle7 on the HP9000/8x7 series
Organization: Neuroclinical Trials Center, University of Virginia
Date: Fri, 8 Jan 1993 02:35:25 GMT

What kind of performance are people getting from Oracle7 on the HP9000
series systems?  Is anyone using Oracle7 on these platforms?  How
difficult to tune is Oracle7?  I understand that it is geared for SMP
and that it can be difficult to tune on a single processor system.

	-Phil
-- 
(--)======================================================================(--)
 ||                                                                        ||
 ||  As evey cell in Chile will tell / The cries of the tortured men       ||
 ||  Remember Allende in the days before / Before the army came            ||
 ||  Please remember Victor Jara / In the Santiago Stadium / Es verdad     ||
 ||              Those Washington Bullets Again!      --The Clash          ||
 ||                                                                        ||
(--)== prs9k@virginia.edu === Phil Scarr === Department of Neurosurgery ==(--)
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: ORACLE ftp sites
Keywords: This field is intentionally left blank
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Mon, 11 Jan 1993 16:37:05 GMT

ole@dc.dk writes:
>In article <1993Jan8.230350.4281@kakwa.ucs.ualberta.ca> oschnire@handlova.ucs.ualberta.ca writes:
>>In  <31367@nntp_server.ems.cdc.com>  btreuman@ems.cdc.com (Bob Treumann) writes:
>>> In article <479@ptt-iat>, roo@ptt-iat (? Roo) writes:
>>> |> Hi,
>>> |> I'm looking for ftp sites where I can find ORACLE stuff.
>>> |> Especially I'm looking for DBA utilities.
>>> |> Can anyone e-mail the addresses of some sites to me ?
>>> |> Thanks in advance
>>> |> Peter de Roo.
>>>  
>>>  
>>> I would like to know this too.  
>>>      
>So would I !!!!

When we go live on the Internet - I will be more than happy to provide
an Internet site for anonymous FTP of Oracle related materials.
This is scheduled for 2Q 93.
-Andy

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.

"[The author] neither accidentally nor intentionally omits or includes 
anything that could support a preconceived thesis." - C&EN 21-DEC-92 p.72
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: OPS$LOGIN login for oraperl
Date: 4 Jan 93 13:02:20 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

peter@ml.csiro.au (Peter Campbell) writes:

>Is it possible to get oraperl to login to a database just using a / the way
>sqlplus etc. can on my Sun?

Try '/' for username parameter,
    ''  (or a space) for password - I forget which

dtb@otto.bf.rmit.oz.au

David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius

-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
Newsgroups: comp.databases.oracle
From: xmpp@uxa.ecn.bgu.edu (Melody Paul)
Subject: What is ORACLE
Organization: Educational Computing Network
Date: Wed, 6 Jan 1993 17:25:05 GMT

Can someone give me a laymans definition of ORACLE and how it works?  Also
does anyone know of any universities specific departments using ORACLE?  Who
are the primary users most seen on campuses?  Do they have any newletter
articles advertising ORACLE and it's users?

Thank you.
         
-- 
Melody P. Paul			Office:   708/534-0200
Technical Editor		Fax:      708/534-2042
Educational Computing Network	Internet: xmpp@uxa.ecn.bgu.edu
University Park, IL 60466	BITNET:   xmpp@ecnuxa
From: etche@reseau.onecert(Groupe SUPAERO)
Newsgroups: comp.databases.oracle
Subject: ORACLE-2ndWIND-EXCEL ?
Date: 12 Jan 93 10:24:09 GMT
Reply-To: etche@onecert.fr
Distribution: world
Organization: ENSAE France


 Hi,

 I'm using 2ndWIND on a macintosh (quadra 700) to access
 a remote oracle database on a HP9000.
 The results to my queries are all rights but the returned
 records are displayed 6 per 6 on my excel worksheet, so 
 it's very slow.

 What can i change on 2ndWIND or on my oracle database to 
 improve the display's speed ?

 Thanks in advance.

  -----------------------------------------
  ------  email : etche@onecert.fr  -------
  -----------------------------------------
  ------  ETCHEVERRIA Guillaume     -------
  ------  ENSAE,                    -------
  ------  Toulouse (FRANCE)         -------
  -----------------------------------------
From: pvelasq@uswnvg.com (Patrica Velasquez)
Newsgroups: comp.databases.oracle
Subject: ORACLE*Mail (Faxes??)
Date: 6 Jan 93 22:55:19 GMT
Organization: U S WEST NewVector Group, Inc.
X-Newsreader: Tin 1.1 PL5

Has anyone used Oracle*Mail to send and receive FAXES?

	I have heard that you can do this but I want to find out
	how hard/easy it is to use?  Does it require special 
	hardware, software in addition to the Oracle*Mail product?
	
	This is our environment:
		Sequent Dynix/Ptx V2.3.0 Oracle 6.0.36.4.1 

Please send me your experience with the product.  I will
post a summary to this newsgroup by 1Feb.

Thank you in advance,  Patty
________________________________________________________________________________
								||
      Patty Velasquez                  |                   |  \ ___\
      Analyst                          |                   |   |   |
      .                                |                   |   |___|
      These views are my own and do    |                   |  /    /
      not represent those of my        |                   |  |123|
      company.                         |                   |  |456|
      .                                |                   |  |789|
      No guarantee, implied or other,  |                   |  |*0#|
      unless specified by law.         |                   |   \___\
      Details on back.                 |                    \  |   |
      .                                |                     \ |___|
From: maria@mgr.hjf.org (Maria Capule)
Newsgroups: comp.databases.oracle
Subject: SQL Forms Question
Date: 7 Jan 93 18:51:01 GMT
Organization: HJF AIDS Research Project, Washington DC


I am a novice Oracle person, so please forgive my ignorance. I was
wondering if there is a way to split a character field in a SQL Form.
I am currently using Oracle 6.0A for DOS and am creating forms using
the SQL Forms Designer. I am used to using Informix and can easily
write within the .per file.

       d1 = table.field[1,20];
       d2 = table.field[21,40];

to accomplish this. Can somone also tell me if the SQL Forms designer
is the only method by which to create forms? Thanks. 


Please e-mail all replies. Thanks again...


Maria Capule
Newsgroups: comp.databases.oracle
From: oschnire@handlova.ucs.ualberta.ca
Subject: Re: ORACLE ftp sites
Organization: University Of Alberta, Edmonton Canada
Date: Fri, 8 Jan 1993 23:03:50 GMT

In  <31367@nntp_server.ems.cdc.com>  btreuman@ems.cdc.com (Bob Treumann) writes:
> In article <479@ptt-iat>, roo@ptt-iat (? Roo) writes:
> |> Hi,
> |> I'm looking for ftp sites where I can find ORACLE stuff.
> |> Especially I'm looking for DBA utilities.
> |> Can anyone e-mail the addresses of some sites to me ?
> |> Thanks in advance
> |> Peter de Roo.
>  
>  
> I would like to know this too.  
>      
Newsgroups: comp.databases.oracle
From: ttabet@currie.tansu.com.au (Tabet Tabet)
Subject: Re: Archive files with Oracle for Novell
Reply-To: ttabet@currie.tansu.com.au
Organization: AOTC - CSSC
Date: Fri, 8 Jan 1993 06:18:06 GMT

Hi folks,

Is anyone out there has a response to my following question:

 I am designing a form using version 2.3, the form consists of multi-block.
 The problem that I am having is that:

 Entering a value for a database field and updating that value in two separate tables.
I.e I want to be able to enter field value once in one block, but update it in two data
base tables.


I appreciate if anyone has an answer .

Thanks
Tabet Tabet
Telecom CSSC : Tel: (03) 253 8911.
From: jlove@ivrit.ra.itd.umich.edu (Jack Love)
Newsgroups: comp.databases.oracle
Subject: Re: What is ORACLE
Date: 6 Jan 1993 18:01:49 GMT
Organization: /usr/local/trn/lib/organization
NNTP-Posting-Host: ivrit.ra.itd.umich.edu

In article <C0G0Du.14C@uxa.ecn.bgu.edu> xmpp@uxa.ecn.bgu.edu (Melody Paul) writes:
>Can someone give me a laymans definition of ORACLE and how it works?  Also
>does anyone know of any universities specific departments using ORACLE?  Who
>are the primary users most seen on campuses?  Do they have any newletter
>articles advertising ORACLE and it's users?

It seems like these questions keep coming up. Does anyone have 
a prepared FAQ for it? Should I attempt one and upload it for
criticism?
-- 
________________________________________
Jack F. Love	| 	Opinions expressed are mine alone.
		|	(Unless you happen to agree.)
Newsgroups: comp.databases.oracle,comp.databases.informix
From: kevin@mpls911.uucp (Kevin Herrboldt)
Subject: ORACLE or Informix on NCR 3550?
Organization: City of Minneapolis Emergency Communications
Date: Tue, 12 Jan 1993 01:15:42 GMT

We're running 3B2's with ORACLE v6.0.30.3.1.  We are migrating our application
to NCR 3550's for speed and capacity reasons.  We use the database for real-time
logging of events as they happen in a public safety environment, as well as
retrieval of recent events.  Our data (~500MB) is completely cycled in six weeks,
which means we're constantly deleting data in large (~100MB) increments.

We had planned to move to Informix, because we are extremely unhappy with the
memory/disk management of ORACLE.  ORACLE is amazingly capable of recovering
from a system crash, but that's about the only nice thing I'm willing to say
about it.  We know a lot of our problems are due to the 'frozen' version of
ORACLE on the 3B2's.

Our software vendor has made staying with ORACLE very attractive, but I dislike
it as an administrator.  I don't know if Informix is any better, so I'm looking
for performance as the deciding factor.  We do not need to support the 3B2's
once we're operational on the NCR 3550's.

So all hype aside, how does ORACLE (v6? v7?) compare with Informix?

-- 
Kevin Herrboldt                                                 kevin@mpls911
Minneapolis Emergency Communications Center         ...!mishima!mpls911!kevin
City Hall Room B-911, Mpls, MN  55415
(612) 348-7216
Xref: sparky comp.databases.oracle:2689 comp.os.ms-windows.apps:6686
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle,comp.os.ms-windows.apps
Subject: Re: Windows and Oracle access.
Date: 6 Jan 93 10:32:01 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

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

>I remember a recent thread on accessing Oracle from MS Windows, but I
>didn't pay any attention to it at the time.  Can someone bring me up to
>date on the thread?  Is there a way to access Oracle from MS Windows?
>Is there some sort of orasrv (SQL*NET) available for Windows??  Thanks.

I have used and seen USERS use Q&E to access Oracle.  Q&E (without Oracle
hooks) is distributed with Excel now, you just get the full version.

The nice thing is it does NOT attempt to fiddle with the SQL, just
hands it over to Oracle (cf MS-Access)

David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
Newsgroups: comp.databases.oracle
From: raph@panache.demon.co.uk (Raphael mankin)
Subject: Re: Pro*C / C++ ?? 
Distribution: world
Organization: Solvfield Ltd.
Reply-To: raph@panache.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.19)
Date: Fri, 8 Jan 1993 20:09:07 +0000

In article <145384@lll-winken.LLNL.GOV> hudek@polaris.llnl.gov writes:

><||>
>
>Question about Oracle's Pro*C precompiler:
>
>As I understand it and from a quick look at some output, this simply takes
>source code statements that start with a key phrase (EXEC SQL...) and
>translates them into C code and Oracle system calls.
>
>Given that, is there any reason why the output of Pro*C couldn't then be
>run through Sun's C++ compiler and produce good executables? (since the
>C++ compiler can obviously handle straight C code).  
>

Yes you can embed SQL in C++. There are minor caveats.

1. Function arguments and class members cannot be SQL variables (within a
	DECLARE SECTION).

2. ProC does not understand // comments.

3. ProC generates things like:
	struct sqlca sqlca;
  which causes a name conflict in C++. You have to run a ``sed'' script over 
  the generated C++ to substitute some of the names.

4. You will have to include in every module, probably in a header file, a whole
   raft of declarations of the form:
	extern "C" void sqlxyz(...);
   to link the Oracle library.

5. You _may_ have trouble with the AT&T C++ compiler. It compiles and links
   fine, but with some versions the code hangs when you connect to the DB.
   g++ is OK, as are newer versions of AT&T.

6. Be sure to have a DECLARE SECTION in file scope before any functions in
   each file. This is true for C as well. Otherwise some things will be 
   declared in the wrong scope.
--------------
Raphael Mankin			Nil taurus excretum
From: idixon@infocom.UUCP (Ian Dixon)
Newsgroups: comp.databases.oracle
Subject: Re: References in SQL*FORMS
Date: 6 Jan 93 22:18:03 GMT
Organization: INFOCOM Public Unix Server, +44 [0] 734 340055
X-Newsreader: TIN [version 1.1 PL7]

Rajasimha Aji (raja@well.sf.ca.us) wrote:
> 
> 
> I have used the "REFERENCE" feature of SQL*FORMS 3.0. While specifying
> the reference you have to give the username of the form owner in the
> database. The problem I have is - When I try to generate a form
> from another oracle username the generate command fails. Is there
> something I'm missing?
> How can I store a form with common objects in the database and let
> other users reference this form.
> 
I use the reference to get a standard form header into applications. What 
I've done is to put the form into a separate oracle account then grant each 
user access to it. I forget the forms menu title but its the left hand one. 
It works but I could do with a better solution!
My main problem though is in convincing other developers to actually use the 
reference option.

Regards

Ian