HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.oracle
From: sstow@victory.oracle.uk.com (Simon Stow)
Subject: Re: Migration issues with CASE user extensibility.
Reply-To: sstow@victory.oracle.uk.com
Organization: Worldwide CASE Marketing, Oracle UK
Date: Thu, 15 Oct 1992 11:41:02 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 <1992Oct13.194833.24170@synapse.bms.com>,
sinha@watson.bms.com (Anil Sinha) writes:
|> I would appreciate some input about the risks involved with using USER
|> EXTENSIBILITY functionality within the CASE tool.
|> 
|> In the next release of CASE*Dictionary some of the above are used to provide
|> new enhancements.
|> 
|> IMHO Using current migration utility and other scripts provided with 
|> CASE*Dictionary will result in lossing the entity type, association
type and 
|> property definitions and probably loose data or have data integrity problems
|> later.
|> 
The use of User Extensible elements and properties will, of course,
be taken into account when any new versions of CASE*Dictionary are
released. Migration procedures will protect the integrity of user
extended definitions and associated data.

Regards

	Simon Stow
	Product Manager
	CASE Worldwide Marketing
	Oracle UK, Chertsey
Newsgroups: comp.databases.oracle,comp.databases.sybase
From: ozsu@cs.UAlberta.CA (Tamer Ozsu)
Subject: Re: Advertisement by Oracle about two phase commit attacking SYBASE.
Organization: University of Alberta, Edmonton, Canada
Distribution: usa
Date: Wed, 7 Oct 1992 13:00:40 GMT

kortikar@mipos2.intel.com (Aniruddha Kortikar) writes:


>I am talking about recent advt by Oracle whch mentions that it's two phase
>commit is automatic (in v7). It shows a page full of sybasesybase  code 
>for a typical Debit/Credit operation requiring two phase commit 
>(if the data is on multiple machines).

>the left window shows a page full of sybase code taken from a book on SYBASE
>server (I think book is written by Date), and on the right side it shows just
>4 lines of equivalent oracle code.

>so where is the catch ?

>or is oracle v7  simply too good for sybase for these kind of things ?

>I am curious!

>Aniruddha Kortikar (kortikar@mipos2.intel.com) 

>-------------------------------------------------------------------------------
>Disclaimer : standard_disclaimer 
>-------------------------------------------------------------------------------
>Aniruddha Kortikar			| Main's Law :


As far as I know, Sybase does not automatically handle one client
accessing multiple servers, which requires some sort of commit
protocol (e.g., 2PC) to ensure the ACID properties of transactions
(particularly the Atomicity and Durability). Sybase provides the
necessary commands (begin-transaction, prepare-to-commit, commit) at
the server interface for the application programmer to implement 2PC
within the application. My understanding is that Oracle V7 does this
automatically. I suspect that the additional code in the ad (which I
have not seen) may be due to 2PC implementation within the program.
--
____________________________________________________________________________
M. Tamer Ozsu			   Internet: ozsu@cs.ualberta.ca	
Department of Computing Science    Tel: (403) 492-2860; Fax: (403) 492-1071
University of Alberta		   Edmonton, Alberta, Canada T6G 2H1
From: dewey@centerline.com (Devan F. Dewey)
Newsgroups: comp.databases.oracle
Subject: Re: forsm conversion from 2.0 2.1 to 3.0
Date: 15 Oct 92 16:08:56 GMT
Followup-To: comp.databases.oracle
Organization: CenterLine Software, Inc.
NNTP-Posting-Host: 140.239.3.212

In article <1992Oct13.152827.9840@oracle.us.oracle.com>,
wkaufman@us.oracle.com (William Kaufman) wrote:
> 
> In article <ncronin.718968921@unix1.tcd.ie> ncronin@unix1.tcd.ie (noel cronin) writes:
> ] 	We recently converted some forms from 2.0, 2.1
> ] 	to 3.0. They work etc. but when we try to call
> ] 	up the trigger text it's not there. Any ideas.
> 
>     The 2.x-to-3.0 forms converter doesn't actually change the trigger,
> it just marks the trigger as V2-style..  You need to press [Zoom In] in
> the trigger window to see thye V2 text.

You can also use a product from PTI (Performance Technology, Inc.) called
Ace*Converter which actually converts V2 to V3 code (quite elagantly I
might add). PTI is located in Boston, MA.

-Devan
                             
               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
Newsgroups: comp.databases.oracle
From: mrb@earth.wustl.edu (Mike Bray)
Subject: oracle6/NeXT DBKit problem with db:notificationFrom:::
Organization: Washington University, St. Louis MO
Date: Wed, 14 Oct 1992 02:06:53 GMT

I'm looking for information about the error code returned by 
DBDatabase's delegate "db:notificationFrom:message:code:".  

I have a test database running under oracle 6.0.30.3.1 under
NextStep 3.0.  It has 3 columns, (firstname char(20), 
lastname char(20), key number not null), and a unique index
on column "key".  I have three text windows to see the results 
of database operations that the DBDatabase object makes 
available through it's delegates, db:log:, db:notificatioFrom:message:code:,
and db:willEvaluateString:usingBinder:.  Everything works great, but 
there's an inconsistency in the "code" variable returned by 
db:notificationFrom:message:code:.  

If I attempt to insert a row of nulls into the database, db:notificationFrom
shows (among other things):
"notification:(code -1400) Can't execute oracle cursor.
	ORA-01400:mandatory (NOT NULL) column is missing or NULL during
insert"

This seems reasonable.  Other tests return reasonable codes, always
with the "code" variable matching the "ORA-xxxxx" message.

However, attempting to insert a row with a duplicate key value returns
two different values.  The oracle error message is "ORA-00001", 
duplicate key in index, which is correct, but code comes through
as -9.  What's going on?  If the error code is not what Oracle returns,
where is the definition of these codes?

I called Oracle Tech support, and they tell me that -9 is the code
that Oracle Version 2 used for this condition.  This code is 
still available in version 6 OCI libraries, for backwards compatibility.
Is it possible that this variable is being used by mistake in the 
Oracle DBKit adaptor?

Thanks,
Mike Bray  mrb@earth.wustl.edu
Newsgroups: comp.databases.oracle
From: sinha@watson.bms.com (Anil Sinha)
Subject: Migration issues with CASE user extensibility.
Organization: Bristol-Myers Squibb PRI
Date: Tue, 13 Oct 1992 20:48:00 GMT

I would appreciate some input about the risks involved with using USER
EXTENSIBILITY functionality within the CASE tool.

Heres an example:

Assume that Entity type E8 and Association type A12 is used to define new 
element and association type. New properties (used PROPERTY1) are added to an 
existing entity type TAB.

In the next release of CASE*Dictionary some of the above are used to provide
new enhancements.

IMHO Using current migration utility and other scripts provided with 
CASE*Dictionary will result in lossing the entity type, association type and 
property definitions and probably loose data or have data integrity problems
later.

Please understand that I am not trying to flame anyone because I liked the User
extensibility functionality provided with CASE*Dictionary but the migration
issues worry me so much that I would avoid using it.

Any input about its limitations would be appreciated and summarized.

Thanks in advance.

********************************************************************************
Include Standard Disclaimers:   and so  ..............  life goes on  
********************************************************************************
Anil Sinha           internet:sinha@watson.bms.com           Work:(609) 252 4788
                                                             Home:(201) 366 0608
Newsgroups: comp.databases.oracle
Subject: Re:  Oracle Application Standards
From: tumidity@netlink.cts.com (Joel Garry)
Date: Thu, 15 Oct 92 14:00:12 PDT
Organization: NetLink Online Communications, San Diego CA

stroup@grove.ops.lmsc.lockheed.com () writes:

> 
> I'd appreciate any information on how you control your production 
> applications.  
> 

We don't!  One of the advantages or disadvantages of the prototyping
method!

--                    
INTERNET:  tumidity@netlink.cts.com (Joel Garry)
UUCP:   ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
From: ballt@osshe.edu (Terry Ball)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle file managerCLOSE
Date: 7 Oct 92 14:50:54 GMT
Article-I.D.: news.BvrAKv.695
Organization: Oregon State System of Higher Education

We currently have one database on a raw device.  In order to make a backup
of this database, we have a background process start up each evening to
make an export of the database.  It is NOT possible to make a backup of
the files from the raw device.

Terry Ball
Newsgroups: comp.databases.oracle
From: nakkala@cs.tamu.edu (Venkatesh Nakkala)
Subject: Need Info .. Re.. Ver 7.0 's Multiprotocol Networking Software
Organization: Computer Science Department, Texas A&M University
Date: Tue, 13 Oct 1992 19:24:08 GMT

   
    Howdy, 

    I was just going through a previous posting in this group by Drucker
    from Oracle talking about Version 7's automatic  Multiprotocol
    Networking Software   that allows users to submit transactions that
    could have some data on an ORACLE database using TCP/IP and some on an IBM
    DB2 database that uses the SNA protocol. The posting said Version7's
    Multiprotocol Networking S/W could do automatic two phase commit for updates
    and also allow for distributed join queries in such a scenario.
    
   Now, suppose we have ORACLE on the DG that uses some protocol(the one used by
    DG's to communicate with one another..I think it's called CEO Connect
    -- for sure it does not support   TCP/IP)
    and ORACLE on the SUN which would normally use TCP/IP.
    Is it possible for the application software on these two machines 
    (either database to database or an application accessing a remote database)
    to communicate without the
    DG's having to go in for an ETHERNET card i.e. without TCP/IP. The way the
    Multiprotocol Network Software was described I thought 
    this might be possible (SQLNET TCP/IP is obviously not possible
    without having an Ethernet card on the DG's).
    Can anyone out there enlighten me as to whether this is POSSIBLE ??????
    
    This would make a Helluva lot of difference for our customers who have a
    nation-wide network of DG's and for whom we are developing some applications
    on the SUN SPARCstations using ORACLE Ver 6.0
    
    Thanks,
    
    Venkatesh Nakkala.  
--
-----------------------------------------------------------------------------
		     Venkatesh  Nakkala    nakkala@cs.neuron.tamu.edu 
 Off : (409)845-5481                       Res : (409)268-7404
 Dept. Of Comp Sci.,Texas A & M Univ.      Fax : (409)847-8578 
Newsgroups: comp.databases.oracle
From: mharper@well.sf.ca.us (Michael J. Harper)
Subject: Entering Hex Values 
Organization: Whole Earth 'Lectronic Link
Distribution: usa
Date: Thu, 8 Oct 1992 01:46:43 GMT

I have a table with a number column into which I would like to insert
hex values.  For example, I'd like to phrase my insert thusly:

insert into test(n)
values(0x20)

Is there a way to deal with hex values in Oracle in such a manner?

Michael J. Harper
mharper@well.sf.ca.us
Newsgroups: comp.databases.oracle
From: jimmy@namao.ucs.ualberta.ca 
Subject: Oracle for PCs
Keywords: Interested in Oracle info
Organization: University of Alberta
Distribution: na
Date: Thu, 15 Oct 1992 01:41:37 GMT

Hi folks, 
What is the name of the Oracle product that runs on PCs ? How much
does it cost, where can I get it and how much does it cost ?

Thanks,
Jimmy
Please email to jimmy@namao.ucs.ualberta.ca
--
jimmy@namao.ucs.ualberta.ca
Xref: sparky comp.databases.oracle:1794 comp.lang.c:14731
From: pape@plato.chemietechnik.uni-dortmund.de (David Pape)
Newsgroups: comp.databases.oracle,comp.lang.c
Subject: preprocessor line directives
Keywords: preprocessor,line,directive
Date: 9 Oct 92 15:00:18 GMT
Followup-To: comp.databases.oracle

I have a Pro*C (Oracle SQL) program that needs to be run through a preprocessor 
before compilation. The problem is that the Pro*C precompiler doesn't put
#line directives in the resulting *.c file, something which I would like
to have. Has anyone written a shell script/awk/c program to do this?

Specifically, all SQL statements start with:

EXEC SQL blah blah blah;	/* lets say were on line 25 of SQL_file */

and I would like to have:

#line 25 "SQL_file"
EXEC SQL blah blah blah;

in the SQL_file.

Any helpers out there??

--
David Pape                               | "Justice is inci- | 	       ///
pape@plato.Chemietechnik.Uni-Dortmund.DE |  dental to law    |  \\\ UNI_DO
Dortmund, Germany                        |  and order"       |   \\\///
tel: 49 231 7552682                      | - J. Edgar Hoover |    \\//
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases.oracle
Subject: Re: MS-Windows based tools
Date: 13 Oct 92 19:18:40 GMT
Distribution: na
Organization: Robert Wood Johnson Medical School, Piscataway NJ

jgb@prism.gatech.EDU (James G. Baker) writes:

>In article <1992Oct7.055014.18461@usl.edu> cdc6586@usl.edu (Charbonnet Clement D) writes:
>>I am currently running Oracle on a Data General AViiON 6220 
>>with DOS based clients communicating with SQL*Net TCP/IP.
>>I am not pleased with the fact that Oracle's tools are not 
>>compatible with the enhanced mode of MS-Windows which is our 
                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^
I think this is conflict between Windows 386-Enhanced mode and the SQLPME
program needed to run SQL*Net.

>>standard user interface.

>It depends how robust your needs are.  $300 at Egghead will get you
>ObjectVision Pro, which has SQL (SQL Server/Sybase, Oracle, etc)
>access included.  It is good for the price, but there are stronger
>products out there...  PowerBuilder is probably the leading one, IMHO,
>but it is a bit more in cost.  I am using MicroSoft Excel via Oracle's
>DDE Manager to access a server - it certainly has the reporting 
>capabilities, along with dialog boxes, custom menus, etc of Excel 4.0...
>It might be a good place to start... The DDE Manager (~$300) would let other
>programs, MS-Word, VisualBASIC, and even some C++ if you want... :-) 

>There was a review in the September 29 PC Magazine for SQL Front Ends...

>Let me know if you need more info...  Good luck.

All of these are good tools.  The question is, do they allow access to
Oracle Databases via SQL*Net froom Windows in 386 Enhanced mode. I too
am using MS-Excel and can access databases using Windows in Standard mode.
I still can't get it to work in 386 Enhanced mode.  There was something
in the latest ORACLE magazine about this.  Oracle also makes Oracle Card
for both the Mac and MS-Windows.



Rich Holowczak
Rutgers University
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: renaming tables
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Thu, 15 Oct 1992 16:03:56 GMT

ae0i+@andrew.cmu.edu (Albert L. Evans, IV) writes:
>I was wondering if anyone has had experience renaming tables using the
>SQL*Plus RENAME TO command.  Specifically,  are the grants and indexs
>associated with that table automatically updated to reference the new table
>name?  My experience seems to indicate that this is the case,  seeing as I
>have renamed a table and subsequently named a new table with the same old
>name.  The newly created table w2as not indexed, nor were there any grants
>on the new table.  Any responses appreciated. 
>Bert Evans

Yes, the indexes automatically follow the previously created table
to its new name.  The reason for this is primarily - the OBJ$ table
owned by SYS contains the Object Name and Type for each database
object (Table, View, Sequence, Index, etc) and "All" a rename does
is change the NAME of the object and nothing else.  ALL other 
references to the object (except views which are a special case)
refer to the object NUMBER, not its name.

Can you rename a column in the database?  The definitive answer
is YES, but I'll bet that Oracle doesn't support it.  Because the
data dictionary cache keeps the old name around and isn't updated
when you update COL$ directly, you have to shutdown and restart
the database to have the changes take effect without causing some
really wierd errors.  I would imagine that flushing the cache by
references lots of other objects would affect this, but shutdown/startup
was so easy to do.

-Andy

-- 
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
 <> Send mail to ora-request@vistachrome.com to join Unix, CASE, and
 <> Desktop Oracle discussions.
From: ccvern@uqvax.cc.uq.oz.au (Vern Bawden  Prentice Centre  UQ)
Newsgroups: comp.databases.oracle
Subject: SQL*ReportWriter problems with VMS V5.5-1
Date: 16 Oct 92 11:29:49 AEST
Organization: University Of Queensland

I have received the following query from a user who is running ORACLE
RDBMS V6.0.30.3.0 and SQL*ReportWriter V1.1.10.4 under newly installed
VAX/VMS V5.5-1.

------------------- Begin Included Message --------------------------------
SInce upgrading to Vax VMS 5.5-1 I have been unable to compile or run Reports   
generated in Oracle using SQL*reportwriter.  I've tried re-linking the complete 
suite of Oracle programs but to no avail.  The error message given when trying  
to run existing reports is "ORACLE error occurred ORA 02112 PCC Select ... into 
returns too many rows" - after which further attemts give an "ORACLE not        
connected " error.  The same occurs when trying to create new reports. The      
relevant error numbers do not exist in my list of Oracle error codes.  We're    
runnive oracle Version 6.0 on a Vaxstation 3100 under VMS 5.5-1. It all ran fine
on  VMS 5.3 and the RDBMS works fine on 5.5-1 for queries, forms and the SQL    
menu.                                                                           
-------------------- End Included Message ---------------------------------

Has anybody else been experiencing problems with VMS V5.5-1 as above? If
so how were the problems resolved? Any help will be greatly appreciated.
Newsgroups: comp.databases.oracle
Subject: Interested in Oracle
From: canderso@ericson.wright.edu (Chris Anderson)
Date: 13 Oct 92 16:43:42 EST
Distribution: world
Organization: Wright state University
Keywords: Capabilities, Performance, Maintainability

 I am in the process of gathering information about various Database platforms.  Any 
 comments about Oracle???  I have read alot of good press about the ease of use of
 this product...  

 Very interested in your views on this subject.

  Thanks    

Newsgroups: comp.databases.oracle
From: stroup@grove.ops.lmsc.lockheed.com ()
Subject:  Oracle Application Standards
Reply-To: stroup@grove.ops.lmsc.lockheed.com ()
Organization: Lockheed Missiles and Space Corp
Date: Wed, 14 Oct 92 20:16:37 GMT


We've been designing Oracle applications for several years now (under VMS) 
using some informal standards.  Now we're about to start up a standards team 
to address issues such as:

	Source Code Management (Forms, SQL scripts, Menus, etc.)
	Naming conventions
	Visual standards for Forms
	Etc, etc, etc....

I'd appreciate any information on how you control your production 
applications.  

					Thanks in advance
Newsgroups: comp.databases.oracle
From: sspencer@trl.oz.au (Simon Spencer)
Subject: Full text databases or Oracle used in Libraries
Reply-To: sspencer@trl.oz.au
Organization: Telecom Research Labs.
Date: Wed, 14 Oct 1992 22:26:59 GMT

Has anyone on the net had any experience in using Oracle to develop full text databases? We are in
the process of developing our system spec for replacing our existing library system and I keep hearing that 
Oracle is not really suited to library applications.  Is this true? are there any library systems developed using oracle,
i,e cataloging, circulations, journals etc???

Thanks for reading this far.

Simon Spencer
Systems Development
National Information Resource Centre - Telecom Australia
s.spencer@trl.oz.au

Newsgroups: comp.databases.oracle
From: rz34@hp850.rz.uni-karlsruhe.de (Schillinger)
Subject: Universal Key Mapping for SQL*Forms 3.0
Reply-To: rz34@rz.uni-karlsruhe.de
Organization: University of Karlsruhe, Germany
Date: Mon, 12 Oct 1992 10:09:49 GMT

We're using ORACLE v.6.0.34.2.1, SQL*Forms v.3.0.16.8.1 on a
HP/UX 9000 Series 800.  As terminals, we use vt220 (actually something
called pctcp if that means anything to anyone?) (on PCs) and hpterm.

I'm trying to set up a universal (uniform) key mapping for Forms so that
no matter what kind of terminal you're on, the function keys remain the
same.  I know this subject has come up a few times in this group, and I've
even got copies of those dORACLE*Terminal handbook.

I've tried the *u.r files which exist (in $oracle_home/forms30/admin/resource),
i.e. att600u.r, att730u.r, vt100u.r, vt220u.r, etc., but they don't work.
That is, a few keys work, but many don't.

So, I tried creating my own resource file. I copied oraterm.r, renamed
it to karenterm.r, and in it copied the device vt220, naming it pctcp.
I altered karenterm.r by changing the escape sequences under Device
Key Definition. (I got the escape sequences by pressing ctrl-v then 
the key in the vi editor.)

Again, the problem is that some keys work and some don't.  The function
keys 1 thru 4 work on the pc and on hpterm but I can't get f5 thru 58 
to work on the pc (they work on hpterm). 

I've kept the keys (1) to only those which are common to both the hp and 
to the pc and (2) have tried to make the functions based on the function
keys, similar to WordPerfect (e.g. F1 is List, Ctrl-F1 is Menu, Shift-F1
is Block Menu, etc.), so that I could use a template on the keyboard.
Number (2) is not essential, of course, but number (1) is.

I use the following command to call up Forms:

sqlforms30 -c karenterm:pctcp

and

sqlforms30 -c karenterm:hpterm 

Does anyone have any general information and/or tips on things I could
check for?

Thanks in advance!

Karen
rz34@hp850.rz.uni-karlsruhe.de

P.S. Please reply via E-Mail.  I'll post a summary if I get enough responses.






















Newsgroups: comp.databases.oracle
From: bill@chaos.cs.umn.edu ( Hari Seldon ... psychohistorian )
Subject: Re: MS-Windows based tools
Organization: University of Minnesota
Distribution: na
Date: Thu, 15 Oct 1992 17:43:55 GMT

In <1992Oct14.143635.1@us.oracle.com> sstephen@us.oracle.com writes:

>In article <1623@rwja.umdnj.edu>, holowczk@rwja.umdnj.edu (Richard Holowczak) writes:
>> jgb@prism.gatech.EDU (James G. Baker) writes:
>> 
>>>In article <1992Oct7.055014.18461@usl.edu> cdc6586@usl.edu (Charbonnet Clement D) writes:
>>>>I am currently running Oracle on a Data General AViiON 6220 
>>>>with DOS based clients communicating with SQL*Net TCP/IP.
>>>>I am not pleased with the fact that Oracle's tools are not 
>>>>compatible with the enhanced mode of MS-Windows which is our 
>>                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^
>> I think this is conflict between Windows 386-Enhanced mode and the SQLPME
>> program needed to run SQL*Net.
>>

you know another thing you could do is toss the windows, and run desqview.
or better yet desqviewX (if your using X, like we do here) runns fine.
now if only i could run multiple sql processes ... (without needing a
$15,000 solution)

bill pociengel
--
llbi locgeenpi " i'm a little confused right now"