HDTenEightyP/NetNews huggingface dataset:
From: rock@kami.uucp ( Rock Lee)
Newsgroups: comp.databases.oracle,comp.databases,alt.books.technical,misc.books.technical,alt.books.reviews
Subject: Books on Oracle wanted!
Date: 30 Jul 92 02:21:44 GMT
Organization: TANDEM Computers, Inc (CS2)

Hi, Oracle gurus:

A friend of mine is learning how to use Oracle. A good introductory book
certainly will help. Any comment on the following two books?

1. "ORACLE: the complete reference" by George Koch, 1991, Osborne McGraw-Hill
2. "ORACLE: database developer's guide" by Ulka Rodgers, 1991, Prentice-Hall

It will be even better if you can recommend some other better book(s) on
Oracle. Thanks in advance for your valuable information.


-- Y. Rock Lee
   512-795-2119
   mpd.tandem.com
Newsgroups: comp.databases.oracle,comp.os.msdos.programmer,comp.windows.ms.programmer
From: pkoch@news.weeg.uiowa.edu (Peter F Koch)
Subject: Oracle V6.0 and Borland C++ 3.0 ???
Organization: University of Iowa, Iowa City, IA, USA
Distribution: usa
Date: Thu, 23 Jul 1992 13:37:52 GMT

I bought Borland C++ V3.0 recently.  I will soon be getting Oracle V6.0
for MS-DOS and want to develop Windows database applications. Does Oracle 
support Borland C++ or do I have to use Microsoft's compiler?

===========================================================================
Peter Koch                                              Phone: 708-534-5200
Weston Gulf Coast Labs                     email:pkoch@umaxc.weeg.uiowa.edu
2417 Bond St.
University Park, IL 60466
===========================================================================
Xref: sparky comp.databases.oracle:1112 comp.databases:5761
From: biwine@vaxsar.vassar.edu
Newsgroups: comp.databases.oracle,comp.databases
Subject: Platforms for Oracle development
Date: 22 Jul 92 14:07:19 +1000
Organization: Vassar College

We are looking for a low cost Unix platform for Oracle database
development (not production).  We are considering the HP 9000-705 and
the IBM RS 6000/320H with 16MB of memory and 400MB of disk (and adding
an external third party SCSI disk).  Does anyone have experience
running Oracle on either of these platforms?  Are they appropriate
platforms for Oracle development?

Thanks for your comments.

Bill Wine
System Manager
Vassar College
biwine@vassar.edu
Newsgroups: comp.databases.oracle
From: dbmoore@us.oracle.com (Dennis Moore)
Subject: Re: Forms3 ERR - unable to INSERT record
Summary: ON-INSERT, -UPDATE, -DELETE triggers
Organization: not an official statement of Oracle Corporation, Redwood Shores CA
Date: Sat, 25 Jul 1992 02:22:06 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 <dewey-220792114200@sebastian.centerline.com> dewey@centerline.com (Devan F. Dewey) writes:
>In article <1992Jul22.105329.244@falcon.navsses.navy.mil>,
>huynh@falcon.navsses.navy.mil wrote:
>> 
>> Greetings,
>>            thanks for reading.
>> I am doing a project on SQLFORMS version 3.0.  The project is simply to join
>> three tables in addition with a new one.  
>> 
>> For every execution, after hitting the commit key, I keep getting the error:
>> FRM 40508 : ORACLE ERROR -- unable to INSERT record
>>
>> Any suggestions would be appreciated.  Many thanks.
>
>You cannot use Forms to insert or update data in a view. Forms acutally
>uses the rowid field when performing these tasks and there is no rowid
>field for a view. Views are only useful for query only blocks.
>
>You are going to have to break up the blocks so that the block you which to
>insert from has a base table which is a true table, not a view.
>
>                             
>               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

Actually, see the manual sections on the ON-INSERT, ON-UPDATE, and ON-DELETE.
These triggers are specifically useful for updating through views.
Incidentally, the fact that Forms uses ROWID has nothing to do with updating
or inserting into views based on multiple tables -- this is a SQL restriction.

Good luck!

-- Dennis Moore, my own opinions, etcetcetc
Newsgroups: comp.databases.oracle
From: sinha@watson.bms.com (Anil Sinha)
Subject: Application Security.
News-Software: VAX/VMS VNEWS 1.4-b1  
Keywords: Security, Application
Organization: X
Date: Tue, 21 Jul 1992 20:00:00 GMT

Hi Database Gurus,

     I would appreciate feedback as how is/was security implemented in your 
database application using Oracle 6.# and plans as to how they would do it
in version 7. Especially taking into consideration the following

a. Maximum level to which the security could be implemented so that whatever 
tools the user used to logon to the database, this minimum level of security
would be available  at the data level. Egs Using views or other means. How
about row level security or am I just dreaming ? 

b. One has a situation in which the user can only modify the data using this
application.  So develop the application such that only one Oracle username
is used to logon to database but provide within the application
username/password implementation which looks like database username. In this
case the user does not know the application username/password so cannot log on
using other tools like Sql*Plus or third party tools. The draw back to such an
implememtation is that one is reinventing the wheel to implement security level
which may be available at the database level (egs. Roles in version 7.0 ).

	Or forget the overhead, its not worth it
	Or go for Trusted Oracle 


Thanks in advance.

Anil Sinha
internet: sinha@watson.bms.com 
Newsgroups: comp.databases.oracle
From: fragante@unixg.ubc.ca (Gv Fragante)
Subject: Re: (SOLUTION ENCLOSED) Re: SQL*Reportwriter last page eject
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Wed, 29 Jul 1992 18:10:33 GMT

In <1992Jul29.132110.21823@homebase.vistachrome.com> andy@homebase.vistachrome.com (Andy Finkenstadt) writes:

>Actually, it is the print spooler that prints that extra blank page
>at the end.  Print to "File" sometime in SRW and you will notice that
>the last character in the file is the form-feed character.  (This only
>applies to ascii print definitions, the postscript definitions
>do not suffer from this problem with the right filter.)  

Yes, that's correct. Printing to a "file" will not produce a form feed charac-
ter. Also, you're right that Postscript printers do not exhibit this problem,
but Epson and Laserjet printers do.


>There are three possible changes that will fix this problem!

>One:

>	Change the Oracle PRINTDEF.DAT file for your printer definition(s)
>	to include the "fs" option.  To wit:  there is currently a setting
>	for ff=(Control-L) and no fs setting for the ascii printers.  There
>	is an 'fs' for the postscript printers that does "erasepage 
>	initgraphics" which prevents the extra-page problem.  Add an "fs=:"
>	(ie: nothing) to the 'wide' and 'dflt' definitions (if that's all
>	you use).

Looks like the most viable method.


>Three:

>	Write a custom filter in your favorite language that removes
>	blank pages at the end of a file.  This is certainly the hardest
>	of any changes.

I did something similar, in which the report was written to a file and then
send to the printer. Not an elegant solution, that's why I asked if there was
anything else out there in the net.


>My permission granted to include this in any materials with proper
>attribution.


>-Andy
> just an oracle customer


Thanks.

GV
Newsgroups: comp.databases.oracle
From:  Neil Greene <deepthought!neil@ms.uky.edu> 
Subject: SQL*Reportwriter scroll down?
Reply-To:  Neil Greene <deepthought!neil@ms.uky.edu> 
Organization: ARCI, Inc.
Date: Wed, 29 Jul 1992 12:43:54 GMT

I have successfully found the default scroll down key when viewing a report on
the screen, ESC UP-ARROW and ESC DOWN-ARROW.  However, these keys scroll up
and down a page at a time and not necessarily a line at a time.  The problem I
face is if the report is only one page, I can only view the top half of the
report on the page.  I have looked through the manual and do not see a default
key to scroll down 6 or 12 lines at a time.  Is my only solution to modify my
terminal definitions to include this feature or am I missing a key sequence?
-- 
Neil Greene -----------	Director, Computer Information Systems ARCI, Inc.
606.254.4060 (P)	President, Kentucky NeXT User Group, Inc.
606.254.4864 (F)	Email: deepthought!neil@ms.uky.edu [NeXTmail]
Newsgroups: comp.databases.oracle
From: nasris@deepthought.uucp (Neil Greene)
Subject: Calling for in QUERY ONLY mode from Menu 5.0
Organization: ARCI, Inc.
Date: Thu, 30 Jul 1992 23:26:03 GMT

Is there a way to call a form in query only mode from sql*menu??

-- 
Neil Greene -----------	Director, Computer Information Systems ARCI, Inc.
606.254.4060 (P)	President, Kentucky NeXT User Group, Inc.
606.254.4864 (F)	Email: deepthought!neil@ms.uky.edu [NeXTmail]
From: jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
Subject: Re: Multiple Screens in SQEL*FORMS
Date: 24 Jul 92 06:30:34 GMT
Organization: University of Helsinki

In article <j1gmxq-.sjs@netcom.com>, sjs@netcom.com (Stephen Schow) writes:
> I am new to Oracle and I am working in an application that requires 3
> seperate screens that are related to each other only in the sense that
> they are part of an all encompassing application.  There are no data
> relationships between them.  I am not sure if I should create 3 seperate
> forms or 1 form with seperate pages.  Note that each screen has a master
> detail relationship.  I have set something up that uses just 1 form with
> each logical screen on a different page.  Then I will set up a menu to call
> specific pages.  
> 
> Am I doi ng this the best way?  Would it be better to make seperate forms?
Well, if they are logically separate, keep them physically separate too!

> I do NOT want to have to exit all the way back to the OS and then call runforms
> again just to switch to another screen.  What I am worried about are potential
What's wrong with calling separate runforms? Of course starting a new
process takes a while, and stopping and starting a fresh runform clears
your GLOBAL variables. But you can use runform which is linked into
runmenu (version 5.0), so that the menu and all subsequent runforms run
IN THE SAME PROCESS and retain GLOBALs. Or you can create a dummy form
which calls other forms.

> problems that I might run into and have to program around by putting each
> screen on a different page of the same form.
If you want to switch screens very quickly, a single form might be
optimal. Make an experiment!

> 
> ------------------------------------------------------------------
> Steve Schow    | But you don't have to use the claw, if you
> sjs@netcom.com | pick the pear with the big paw paw......
>                | Have I given you a clue......?
>                |                       - Baloo the Bear
> ------------------------------------------------------------------
--
Juhani Jaakola
jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
From: dewey@centerline.com (Devan F. Dewey)
Subject: Re: SQL*Reportwriter scroll down?
Followup-To: comp.databases.oracle
Organization: CenterLine Software, Inc.
Date: Wed, 29 Jul 1992 14:47:14 GMT

In article <1992Jul29.043641.5728@deepthought.uucp>,
nasris@deepthought.uucp (Neil Greene) wrote:
> 
> I have successfully found the default scroll down key when viewing a report on
> the screen, ESC UP-ARROW and ESC DOWN-ARROW.  However, these keys scroll up
> and down a page at a time and not necessarily a line at a time.  The problem I
> face is if the report is only one page, I can only view the top half of the
> report on the page.  I have looked through the manual and do not see a default
> key to scroll down 6 or 12 lines at a time.  Is my only solution to modify my
> terminal definitions to include this feature or am I missing a key sequence?

You must first enter window mode using Esc-W then using the up and down
arrow (and left and right for wide reports) you can move around the page.

Cancel will get you from window to page mode, cancel again to get back to
sqlrep.  Good luck.

                             
               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
Xref: sparky comp.databases.oracle:1173 comp.sys.mac.misc:14089 comp.mail.misc:2513
From: matthews@oberon.umd.edu (Mike Matthews)
Newsgroups: comp.databases.oracle,comp.sys.mac.misc,comp.mail.misc
Subject: Oracle Mail to cc:Mail on Macintosh?
Date: 30 Jul 92 14:24:12 GMT
Reply-To: matthews@ectds.com
Originator: matthews@oberon.umd.edu

Sorry for posting to so many newsgroups, but I *think* they all could be
relevant.  If not, just edit the Followup-To: field if you followup (Email
replies are more welcome, though :-) ).

Anyway, on with the question.  I'm looking for any products or techniques to
gateway Oracle Mail with attachments to cc:Mail on the Macintosh.  A TCP/IP
connection is there.

Does such a beast exist? (No, not TCP/IP - I KNOW that one, the gateway! :-) )

Replies being sent to matthews@ectds.com.  Thanks for any information.  Email
and I'll summarize.
------
Mike Matthews, matthews@oberon.umd.edu (NeXTmail accepted)
------
Mistakes are often the stepping stones to utter failure.

Newsgroups: comp.databases.oracle
From: george@unixg.ubc.ca (George chow)
Subject: SQL*Forms 3.0 LOV, controlling the width...
Followup-To: comp.databases.oracle
Originator: george@unixg.ubc.ca
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Tue, 21 Jul 1992 21:33:06 GMT

I'm building a form with SQL*Forms 3.0 with a few LOV. Anyways, the columns 
in my tables are quite wide (just in case I need it in the future). For each 
LOV, I want to SELECT about 3-4 columns. The situation right now is that 
Forms will allocate space for each column in the LOV according to the declared 
width of the column from the table. Because my tables tend to have wide
columns, I can't see more than about 2.5-3 table columns in the LOV.
What I would prefer to do is to split the 80 columns among all four columns
from the tables. How can I control the width of the what SELECT returns? 
I don't think there is any way via (standard) SQL. But is there some way in 
Forms to do what I want?

George

Newsgroups: comp.databases.oracle
From: rz34@hp850.rz.uni-karlsruhe.de (Schillinger)
Subject: Re: National Language Support in ORACLE v.6
Reply-To: rz34@rz.uni-karlsruhe.de
Organization: University of Karlsruhe, Germany
Date: Tue, 28 Jul 1992 12:16:59 GMT

In article <1992Jul23.132010.2226@rz.uni-karlsruhe.de> rz34@rz.uni-karlsruhe.de writes:
>We're using ORACLE version 6.0.34.2.1 on an HP-UX Series 9000/800.
>
>I'm trying to get National Language Support to work and can't.
>I've followed the instructions in the DBA Guide, i.e. I added
>
>nls_sort = true
>germany_germany.WE8HP
>
>to init.ora.  Am I using the wrong character set?
>Can anyone help?  
>
>Thanks!
>Karen

Thanks again to those who replied.  Everyone told me to change
language=germany_germany.we8hp    
to
language=german_germany.we8hp

which I tried.  I also tried different combinations of upper and lower
case.  Still no luck.  Any other suggestions?

Karen
Newsgroups: comp.databases.oracle
From: al@cvgis.prime.com (Al Parker)
Subject: Re: Oracle V6.0 and Borland C++ 3.0 ???
Organization: Computervision GIS (Toronto)
X-Newsreader: Tin 1.1 PL4
Distribution: usa
Date: Thu, 23 Jul 1992 17:24:39 GMT

pkoch@news.weeg.uiowa.edu (Peter F Koch) writes:
: I bought Borland C++ V3.0 recently.  I will soon be getting Oracle V6.0
: for MS-DOS and want to develop Windows database applications. Does Oracle 
: support Borland C++ or do I have to use Microsoft's compiler?
: 
: ===========================================================================
: Peter Koch                                              Phone: 708-534-5200
: Weston Gulf Coast Labs                     email:pkoch@umaxc.weeg.uiowa.edu
: 2417 Bond St.
: University Park, IL 60466
: ===========================================================================
Hi Peter,
I'm using ORACLE V6.0 on a SUN at this point but I can tell you what
their approach seems to be. I have used C++ on UNIX and DOS.

The OCI (Oracle Call Interface) library should be usable from any
language capable of using a C calling convention and it is documented
for C, FORTRAN and COBOL. You'll be able to use it from either C++
but you'll have to build your own classes...

You'll probably be able to use Pro*C (embedded SQL) also but may have
to keep Pro*C modules separate from C++ modules.
-------------------------------------------------------------------------------
Al Parker, P.Eng, Sr Software Engineer - Computervision GIS
al@cvgis.prime.com	(416)508-8020(x881)
These opinions are my own and not those of my compnay.
-- 
-------------------------------------------------------------------------------
Al Parker, P.Eng, Sr Software Engineer - Computervision GIS
al@cvgis.prime.com	(416)508-8020(x881)
These opinions are my own and not those of my compnay.
Newsgroups: comp.databases.oracle
From: kmallory@us.oracle.com
Subject: Re: SQLFORMS and ANSI SQL
Organization: Oracle Corporation, USA
Date: Sun, 26 Jul 1992 01:19:03 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 <brett.711857119@citr.uq.oz.au>, brett@citr.uq.oz.au (Brett Jordan) writes:
> Haven't been reading this group, so forgive me if I am walking
> on old ground. 
> 
> Is there a version of SQLFORMS  that doesn't send ORACLE specific
> SQL to the database? We would like to use SQLFORMS against a
> non-ORACLE database via SQL*Connect and it is sending SQL that
> uses ORACLE specific pseudo-columns like "ROWID" and "ROWNUM"
> that are not ANSI standard.
> 
> We heard rumours a while ago that there was a version, but now
> we are serious about tracking it down.
> 
> Brett Jordan,
> CiTR
> University of Queensland,
> Australia.
> 

While this is mostly possible to do today with user exits, there are a few
sticky wickets that make it more difficult. (Lack of trigger points like
on-fetch, on-select ...)

Forms 4.0 will contain the support you need for Non-Oracle Data Sources.


-----------------------------------------------------------------------------
"QUALITY is never an accident; it is always the result of high intention,
 sincere effort, intelligent direction and skillful execution; it represents
 the wise choice of many alternatives."

Kevin Mallory                                           SQL*Forms Development
                                                        Oracle Corporation
-------------------------------------------------------------------------------
From: rick@rick.cs.man.ac.uk (Rick Dipper)
Newsgroups: comp.databases.oracle
Subject: Re: Sharing of .frm files
Date: 21 Jul 92 11:36:21 GMT
Reply-To: rick@uk.ac.man.cs
Organization: University of Manchester, Dept. Computer Science

In article <radar.246@busadm1.cba.hawaii.edu>, radar@busadm1.cba.hawaii.edu (James Johnson) writes:
|> Sorry if this was posted twice, recieved an error message on first attempt.
|> 
|> 	Configuration   Kernal 6.0.30
|> 		   os	OS/2
|>               Network	Novell 3.11
|> 
|> 	Problem:
|> 	One of our developres wants to run .FRM, .REP, .DMU files from a
|>         shared network directory.  The reason for this is to make sure that
|>         users are using the latest version of form, report etc.. Up til now
|> 	to update versions the developer has had to copy the form to the 
|> 	endusers hard-drive. ( I know we could send the file to the users,
|>         instruct them to copy it the proper directory etc.) but this is an
|> 	institute of higher learning, need I say more.
|> 
|> 	To use a shared directory will allow more than one person to execute
|>         a the same .frm file which lead to many headaches. Am I wrong in 
|> 	this asumption? How do others handle distirbution of .frm files?
|> 
|> Thanks in advance
|> Jim
|> UH Manoa
|>  

I just put all my .frm & .sql files in a directory & tell
everyone to use them. I have never found a problem & see no
reason why there should be one. All my users also are
logged into the database automagicly as I have created a shell
script to do that fro them to. I just have a program SAD which
is the application name.

-- 
RICK DIPPER, Unix Systems Administrator                       rick@uk.ac.man.cs
Department of Computer Science, University of Manchester           061-275-5725
.............................Meemberrr the of Fumblee Ingers Culb..............
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Referencing a SEQUENCE from a trigger...
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Tue, 21 Jul 1992 11:50:13 GMT

george@unixg.ubc.ca (George chow) writes:
>
>Hello,
>I've got a situation where I need to insert rows into a table in a 
>ON-VALIDATE-FIELD trigger. For these rows, I need a serial no which I'm
>getting from a SEQUENCE. However, I can't seem to reference the SEQUENCE.

I've struggled with this problem as well.  I tried to use the same
method as the default value method and get the same error.  The way
to do it is to do

   SELECT V_REF_NO_SEQ.NEXTVAL into :new_ref FROM DUAL;

If you have any other 'select' statements guaranteed to return one
and only one row you can "piggyback" it onto that select statement
instead of generating a seperate one.

I've given this some thought and have decided that there is a rationale
for this "extra" select statement:  Sequence values are stored in the
RDBMS, not in the form.  You need to be talking to the RDBMS to get the
nextval .  Forms 3.0, when presented with :sequence.sequence_name.nextval
converts that to a SELECT statement ON-NEW-RECORD-INSTANCE (in effect).

>I'm doing something like:
>
>  new_ref := :SEQUENCE.V_REF_NO_SEQ.NEXTVAL;
>
>which gets me the error messages:
>
>  PL/SQL error 49 at line 10, column 16:
>     bad bind variable 'sequence.v_ref_no_seq'
>
>I've gone through the _SQL Language Reference_ and _SQL*Forms Designer 
>Reference_ and I can't find anything useful there. Is the ":SEQUENCE."
>syntax only valid for use with default value? 
>
>George
>george@unixg.ubc.ca
>

Hope that helps.

-Andy

PS - I don't work for Oracle, but I wouldn't mind.  <GRIN>
-- 
Andrew Finkenstadt       | Vista-Chrome, Inc.   |    NIC Handle: AF136
GEnie Unix Sysop/Manager | The Printing House   |   ...!uunet!rde!andy
+1 904 222 2639 home     | 1600 Capital Cir SW  |  andy@GEnie.geis.com
+1 904 575 0189 work     | Tallahassee FL 32310 | andy@vistachrome.com
From: sinha@watson.bms.com (Anil Sinha)
Newsgroups: comp.databases.oracle
Subject: Oracle CASE tools for version 7.0
Keywords: CASE, Version 7.0
Date: 22 Jul 92 16:26:00 GMT
Organization: X
News-Software: VAX/VMS VNEWS 1.4-b1

How soon after the release of production version of Oracle 7.0 will the next
release of Oracle CASE tools which will use capabilities of version 7.0 be
available ?

Thanks in advance.

     Anil Sinha
internet: sinha@watson.bms.com