HDTenEightyP/NetNews huggingface dataset:
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: PL/SQL and FORMS30 questions
Date: 8 Jan 93 08:07:22 EDT
Distribution: world
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1ii7jjINNoi3@terminator.rs.itd.umich.edu>, pha@citi.umich.edu (Paul H. Anderson) writes:
> 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?

	Try using a PRE-INSERT / PRE-UPDATE trigger (one or both, depending
	on your circumstances) to set the field to SYSDATE.
> 
> 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?

	You are apparently inserting the sequence numberdirectly into the
	data table.  Try creating it to a field in the form and then 
	commiting / updating the record.  In this fashion, you will still
	have a copy of the number after the record is committed.

	If you are moving across forms, store the sequence in a global
	variable and then retrieve it a s needed.

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek)
Subject: shutdown on SGI
Reply-To: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek 
Organization: NASA/GSFC, Code 902.2
Date: Wed, 6 Jan 1993 14:00:46 GMT

Has anyone else seen and/or have suggestions for avoiding the following 
problem?:  We are running Oracle on an SGI under IRIX 4.0.  When we try to
shutdown oracle while a process is running sqlplus, the shutdown 
procedure halts.  We would prefer the shutdown to continue without caring
if someone is currently connected.  Any suggestions?

Thanks.


Joe Fulson-Woytek
Code 902/Goddard DAAC
NASA/Goddard Space Flight Center
joefw@eosdev1.gsfc.nasa.gov  
Newsgroups: comp.databases.oracle
From: sonya@zoo.toronto.edu (Sonya Neufer)
Subject: Oracle Card v.s. SQL*FORMS 4.0
Date: Wed, 6 Jan 1993 21:16:21 GMT
Organization: U of Toronto Zoology

An Oracle DBA friend has this query:

Does anybody know when the next version of Oracle Card and SQL*FORMS
4.0 is to be released?  Since SQL*FORMS 4.0 is going to be a Windows
Application what is the difference between it and Oracle Card?

Please post or mail replies to this account.  Thanks.
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: Copy objects in Oracle froms 3.0
Date: 12 Jan 93 09:00:07 +0100
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

In article <ncronin.726772229@unix1.tcd.ie>, ncronin@unix1.tcd.ie (noel cronin) writes:
> 	Can anybody enlighten me with regard to copying Oracle objects?
>  	When I load a form (using .inp file only) and try to copy an
> object such as a trigger from another .inp file, SQL*forms tells me that the
> object was not found. We need to copy blocks/triggers etc. Has anybody
> had problems doing this ?
> 
> 	Noel Cronin (ncronin@unix1.tcd.ie)
>  
-- 

You can only copy objects from saved forms. Save your source form in the 
database. Then load your destination form and copy objects. 


kind regards

Mike

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Ing. Klaus-Michael Hatzinger       mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
 Bankgasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================
Newsgroups: comp.databases.oracle
From: rsimkin@dlogics.com (Rick Simkin)
Subject: Using Pro*C from inside a Windows DLL
Organization: Datalogics, Inc.
Date: Thu, 07 Jan 93 20:46:48 GMT

I've been asked to find out...

Is it possible to write a DLL for Microsoft Windows which uses Pro*C?  Are
there special restrictions, limitations or tricks that you need to know?
Has anybody out there actually written a DLL that uses Pro*C?

Thanks for any help you can give me on this. (I myself have no experience
with Pro*C or DLLs--at least, not yet :-)

================ I speak for myself only, not for my employer ================
Rick Simkin                                 UUCP:     uunet!dlogics!rsimkin
Datalogics, Inc.                            INTERNET: rsimkin@dlogics.com
441 W. Huron St.                            PHONE:    +1 312 2664437
Chicago, Illinois  60610-3498  USA          FAX:      +1 312 2664473
Newsgroups: comp.databases.oracle
From: jstander@ml.csiro.au (Jeff Stander)
Subject: Re: Importing files from LOTUS
Reply-To: jstander@ml.csiro.au
Organization: CSIRO Marine Laboratories
Date: Thu, 7 Jan 1993 05:09:20 GMT


---

I can't remember if LOTUS can export in a dBase format, but I routinely
need to import data into our Oracle system running on a Sun and I use
a home-grown program that reads dBase or Foxpro files directly, rewrites
the data and data structure as a text file, and then creates the .sql and
.ctl files for table creation and loading.  

___________________________________________________________________________

Jeff.Stander@ml.csiro.au         _--_|\        Database Analyst
CISRO Division Of Fisheries     /      \       Pelagic Fisheries Resources
GPO Box 1538, Hobart            \_.--._/       Tel: +61-02-206-206
Tasmania 7001, Australia              v        Fax: +61-02-240-530
___________________________________________________________________________
From: dewey@centerline.com (Devan F. Dewey)
Newsgroups: comp.databases.oracle
Subject: last_day vs '31-JAN-93'??
Followup-To: comp.databases.oracle
Date: 8 Jan 1993 17:33:52 GMT
Organization: CenterLine Software, Inc.
Distribution: world
NNTP-Posting-Host: 140.239.3.212


If I wrote a query with a where clause:

											where transdate between '01-JAN-93 and '31-JAN-93'

why would my results differ from:

											where transdate between '01-JAN-93 and last_day(sysdate)


Any hints on how the last_day function returns the time component
might be helpful.

-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
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: Copy objects in Oracle froms 3.0
Date: 12 Jan 93 07:54:13 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <ncronin.726772229@unix1.tcd.ie>, ncronin@unix1.tcd.ie (noel cronin) writes:
> 	Can anybody enlighten me with regard to copying Oracle objects?
>  	When I load a form (using .inp file only) and try to copy an
> object such as a trigger from another .inp file, SQL*forms tells me that the
> object was not found. We need to copy blocks/triggers etc. Has anybody
> had problems doing this ?
> 
> 	Noel Cronin (ncronin@unix1.tcd.ie)
>  
When Oracle copies a trigger / procedure from another form into your current
form, it doesn't use the .INP file.  It goes to the SAVEd copy of the source
INP file.  You need to load the source file and then SAVE it.  After that,
your copy should operate correctly.

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------
From: idixon@infocom.UUCP (Ian Dixon)
Newsgroups: comp.databases.oracle
Subject: Re: Importing files from LOTUS
Date: 5 Jan 93 21:39:10 GMT
Organization: INFOCOM Public Unix Server, +44 [0] 734 340055
X-Newsreader: TIN [version 1.1 PL7]

Richard Snyder (rsnyder@ems.cdc.com) wrote:
> We have an application that requires data to be imported to Oracle 
> tables from a LOTUS spreadsheet.  I don't believe there is any
> Oracle utility to do this. However, I would like the benefit of others
> experience as to how to go about this. The following comes to mind:
> 
> 1) Are there any Oracle utilities to do the import written by 
> A   Oracle, LOTUS or others?

The version of the Oracle toolset that I use (PC version 6 point something) 
has a utility called (I think ) 123prep.com . I've not used it but as far as 
I recall it pre-processes Lotus files into a format suitable for SQL*Loader. 
This might do the trick.

> 2) If not what is the best approach to import the LOTUS data?
>    a) Write a script in LOTUS to do the import directly.
>    b) Put the LOTUS data into a flat file and then reformat the flat
>       file to an Oracle Import format.
>    c) Some other method.

You could always right the LOtus data to an ASCII file - either fixed-frmat 
or comma-delimited then use SQL*LOader to bring this into your database.

Hope this is some help

Regards

Ian
Newsgroups: comp.databases.oracle
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: Oracle Card v.s. SQL*FORMS 4.0
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Thu, 7 Jan 1993 14:13:00 GMT

In article <C0GB3B.KzB@zoo.toronto.edu>, sonya@zoo.toronto.edu (Sonya Neufer) writes...
>An Oracle DBA friend has this query:
> 
>Does anybody know when the next version of Oracle Card and SQL*FORMS
>4.0 is to be released?  Since SQL*FORMS 4.0 is going to be a Windows
>Application what is the difference between it and Oracle Card?
> 
>Please post or mail replies to this account.  Thanks.

I've seen OracleCard demonstrated on a MacIntosh computer.  I assume that the
appearance is the same or similar on Microsoft Windows.

I also have glossy release sheets describing SQL*Forms 4.0.  From what I can
tell, it will also be available on other windowing systems such as X-windows
(Motif, OpenLook), which is what interests me.  I've also been told (but not by
Oracle) that OracleCard is going to be available for X-windows in the future.
Can anyone comment on whether that's true or not, and when we might see either
of these products on the market?

Bill Thompson
Newsgroups: comp.databases.oracle
From: kmelcher@rafael.Arco.COM (Kenneth Melcher)
Subject: Create database problems on SUN OS
Reply-To: kmelcher@rafael.Arco.COM
Organization: ARCO Exploration and Production Technology
Date: Mon, 4 Jan 1993 17:26:38 GMT


I am attempting to manually cerate a databse on Sun OS 4.1.1;

The create database statement works fine,  but when I attempt to @catalog.sql to build the catalog,  the database hangs after several of the views, synonyms, etc are cerated.  By "hangs" I mean that the xterm window running catalog.sql is frozen,  and I am unable to connect to the database from window via sql*plus.  I can connect internal from another window via sql*dba,  but any attempt to select anything just locks up the window.

I have tried this now five different times changing parameters in init.ora as I go,  still to no avail.

Any suggestions?

Thanks in advance,

Ken Melcher
From: anil@umiami.ir.miami.edu
Newsgroups: comp.databases.oracle
Subject: I need to learn Oracle
Date: 12 Jan 93 16:02:57 EST
Organization: Univ of Miami IR

Can anyone recommend a really good (and simple) beginner's book on learning
Oracle?  I have very little database knowledge.

Thanx in advance,
-Anil.
From: mike.sullivan@sqlware.uunet.UU.NET (Mike Sullivan) 
Newsgroups: comp.databases.oracle
Subject: MULTIPLE LIST OF VALUES
Date: 11 Jan 93 11:44:00 GMT
Distribution: world
Organization: SQLWare Inc., Leesburg, VA - (703) 771-3979
Reply-To: mike.sullivan@sqlware.uunet.UU.NET (Mike Sullivan) 

I am running Oracle 6.0.34 on Interactive Unix w/ Sqlforms 3.0 and have
a question on how to do the following:

When a user enters a field, I'd like a list of values to appear. They
can scroll up and down the list and by hitting a key, select that item
(maybe going reverse video to show a selection), and then go on to
select another item. After choosing one or more items, they hit a key
and progress to the next field on the form. They can circle back to the
field w/ the LOV, with their previous selections in reverse video
(or whatever). When they are done with the present form, they hit Enter
Query to retrieve the records that matched the values set in the
multiple LOV as well as any other fields on the form.

Any suggestions.
                               
----
+--------------------------------------------------------------------------+
| SQLWare BBS  703-771-4158 (HST V.32BIS-Specializing in ORACLE and other  |
| RDBMS topics.  Sponsored by SQLWare Inc., Leesburg,VA-300 conferences.   |
+--------------------------------------------------------------------------+
Newsgroups: comp.databases.oracle
From: alaw@uucp (Alvin W. Law)
Subject: Re: shutdown on SGI
Organization: Oracle World HQ, Redwood Shores, California
Date: Thu, 7 Jan 1993 06:57:50 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 <1993Jan6.140046.28334@nsisrv.gsfc.nasa.gov> joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek  writes:
>Has anyone else seen and/or have suggestions for avoiding the following 
>problem?:  We are running Oracle on an SGI under IRIX 4.0.  When we try to
>shutdown oracle while a process is running sqlplus, the shutdown 
>procedure halts.  We would prefer the shutdown to continue without caring
>if someone is currently connected.  Any suggestions?

Try shutdown immediate (check your ORACLE DBA Guide).  It does exactly
what you desire.



-- 
 Alvin W. Law ........................................... Oracle Corporation
 Senior Applications Engineer ............... 300 Oracle Parkway, Box 659306
 Oracle Manufacturing ............................. Redwood Shores, CA 94065
 Email: alaw@oracle.com ....... Voice: 415.506.3390 ...... Fax: 415.506.7299
From: idixon@infocom.UUCP (Ian Dixon)
Newsgroups: comp.databases.oracle
Subject: Re: shutdown on SGI
Date: 7 Jan 93 22:55:36 GMT
Organization: INFOCOM Public Unix Server, +44 [0] 734 340055
X-Newsreader: TIN [version 1.1 PL7]

Joe Fulson-Woytek (joefw@eosdev1.gsfc.nasa.gov) wrote:
> Has anyone else seen and/or have suggestions for avoiding the following 
> problem?:  We are running Oracle on an SGI under IRIX 4.0.  When we try to
> shutdown oracle while a process is running sqlplus, the shutdown 
> procedure halts.  We would prefer the shutdown to continue without caring
> if someone is currently connected.  Any suggestions?
> 
I dont recognize the machine that you're running on but assuming that you're
running Oracle 6 and using SQLDBA then the question is : Are you entering
SHUTDOWN or SHUTDOWN IMMEDIATE ?
A straight SHUTDOWN will wait for any sessions currently going to complete 
whereas the IMMEDIATE normally causes Oracle to stop. I say normally because 
it hasnt always worked for me.

Hope this helps

Regards

Ian
Newsgroups: comp.databases.oracle
From: ncronin@unix1.tcd.ie (noel cronin)
Subject: Copy objects in Oracle froms 3.0
Summary: We load a form and attempt to copy a trigger from
Keywords: SQL*FORMS 3.0 VMS
Organization: Trinity College, Dublin
Date: Mon, 11 Jan 1993 17:10:29 GMT

	Can anybody enlighten me with regard to copying Oracle objects?
 	When I load a form (using .inp file only) and try to copy an
object such as a trigger from another .inp file, SQL*forms tells me that the
object was not found. We need to copy blocks/triggers etc. Has anybody
had problems doing this ?

	Noel Cronin (ncronin@unix1.tcd.ie)
From: dly@vms.macc.wisc.edu
Newsgroups: comp.databases.oracle
Subject: Double data entry comparisons
Date: 4 Jan 93 14:26:14 GMT
Organization: University of Wisconsin Academic Computing Center

I have a database design question on double data entry comparisons.
If it matters, we will be using ORACLE 7.0 (we haven't got it yet),
SQL*FORMS 3.0, on the Sun platform.

We will have different data entry clerks entering the same data.
Then we would like to compare only selected fields.  If there are
no disagreements, then the data is ready.  If not, then the data
is not ready for analysis (we have a manual arbitration step here).

The reason why I say selected fields, is that we will not be comparing
the long text fields (comments, etc).  Nor will we be comparing the 
auditing information (clerk id, time of start, time of post, etc).

I want to make sure that I can make comparisons fairly easily (there
will be about 30 different types of data entry forms, each with
6 to 80 fields).

So, is it easier to have just the fields to be compared in one table, 
and the auditing information in another?  

Should I have two different tables for each form, one for the first
data entry, the second for the second data entry?  

I would appreciate any ideas.  Especially, if you have any stories,
good or bad about similar designs.  

Thank you!
Debbie Yoshihara
Department of Biostatistics
DLY@MACC.WISC.EDU
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: How to do audit trail in Oracle 6
Date: 8 Jan 93 07:59:16 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1993Jan7.200617.4189@netcom.com>, sjs@netcom.com (Stephen Schow) writes:
> Anyone have any insights on the best way to implement an audit trail under
> Oracle 6?
> 
> Under Oracle7 it will be easy to set up RDBMS level triggers to automatically
> add transactions to an audit trail table whenever any transactions are made
> against the regular table.  
> 
> Absolutely any ideas or insights will be appreciated.
> 
> Thanks in advance
> -- 
> ------------------------------------------------------------------
> 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
> ------------------------------------------------------------------

Why not just add a post-insert trigger to each of the form blocks that copy
all / part of the data to an audit table?

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------
From: john@timer1.UUCP (john)
Newsgroups: comp.databases.oracle
Subject: How to save the query from the form and re-use it later?
Keywords: Oracle Form, Query by Form
Date: 8 Jan 93 21:06:16 GMT
Organization: Rightime Econometrics, Inc., The Forst Pavilion, Wyncote, PA 19095-1596

Hello, World:

We are implementing a form to access customer database. So, it is kind of
basic like name, address, phone numbers and titles etc.

Oracle Sql*Form 3.0 provides query by form (kind of nice). We would like to
use this feature but we also want to save the query for future use because
some queries can be so complicated and our users don't want to re-type it 
over and over again. In addition to that, we also like to dump the results
not only on the screen but also into a file so we can use it with mail
merger of word processor.

Is there any one out there who can give us a little guide, instruction or
pointer on how to implement this mechanism ?

Any help will be highly appreciated.


John Y. Chan
Newsgroups: comp.databases.oracle
From: dcriswel@oracle.uucp (David Criswell)
Subject: Re: Using Pro*C from inside a Windows DLL
Organization: Oracle Corporation, Redwood Shores CA
Date: Fri, 8 Jan 1993 20:24:37 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 <1993Jan07.204648.21545@dlogics.com> rsimkin@dlogics.com (Rick Simkin) writes:
>I've been asked to find out...
>
>Is it possible to write a DLL for Microsoft Windows which uses Pro*C?  Are
>there special restrictions, limitations or tricks that you need to know?
>Has anybody out there actually written a DLL that uses Pro*C?
>
>Thanks for any help you can give me on this. (I myself have no experience
>with Pro*C or DLLs--at least, not yet :-)
>
>================ I speak for myself only, not for my employer ================
>Rick Simkin                                 UUCP:     uunet!dlogics!rsimkin
>Datalogics, Inc.                            INTERNET: rsimkin@dlogics.com
>441 W. Huron St.                            PHONE:    +1 312 2664437
>Chicago, Illinois  60610-3498  USA          FAX:      +1 312 2664473

Yes, this works. Specify REENTRANT=YES on the Pro*C command line and include
only 1 function per .pc file. Declare the variables as local to the 
procedure, i.e.
	int proc ()
	{
	EXEC SQL BEGIN DECLARE SECTION
		char myvar
	EXEC SQL END DECLARE SECTION
	...
	}
The reentrancy stuff is due to the fact that under Windows, all instances of
a dll share the same data space - the reentrant problems crop up when a second
instance invokes the DLL. If the DLL is only to be used by 1 app, this isn't
necessary.

Dave Criswell
Oracle Desktop Products