HDTenEightyP/NetNews huggingface dataset:
From: deepthought!neil@ms.uky.edu (Neil Greene)
Newsgroups: comp.databases.oracle
Subject: Re: Multiple Screens in SQEL*FORMS
Date: 24 Jul 92 14:29:32 GMT
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.

In article <1992Jul24.083034.1@cc.helsinki.fi> jaakola@cc.helsinki.fi writes:
> 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

In the issue of linking sql*menu and sql*forms, I just cannot get this to  
happen yet.  I have tried reinstalling, recompiling and all with no success.  I  
don't mind the extra processes, but sure would like to link the two  
applications.  

I am running oracle v6.x.x.x, sqlforms 3.0, sqlmenu 5.0 on a NeXTcube (bsd 4.3  
unix).

-- 
Neil Greene
ARCI, Inc.
President, Kentucky NeXT User Group, Inc.
Phone: 606.254.4060
Newsgroups: comp.databases.oracle
Subject: How to delete another user's forms that are loaded in the database
From: suskind@bbs.mdcbbs.com
Date: 30 Jul 92 04:24:56 GMT
Organization: E-SYSTEMS
Nntp-Posting-User: suskind

This may be a re-post, sorry if you have already seen it.


As the DBA I would like to delete the FORMS (2.3) that a user has loaded on
my system. I know I can change the user's password, then drop them from
IAC, however I do not know his current password, so I will not be able to
change it back.

Is there a way for the DBA to clean out another user's forms?

+---------------------------------------------------------------------+
Barry A. Suskind                  Internet:   suskind%edoras@mdcbbs.com
MaBell: 703-560-5000x2348             UUCP: uunet!mdcbbs!edoras!suskind
E-Systems / Melpar Division 7700 Arlington Blvd, Falls Church, VA 22046
JSNM                                             Just Stark Naked Magic

Newsgroups: comp.databases.oracle
From: klm@atlanta.dg.com (Kim Medlin)
Subject: Re: SQL*Reportwriter scroll down?
Date: Wed, 29 Jul 92 20:46:30 GMT
Organization: Data General Corp. ASSD, Atlanta, GA

Press the WINDOW key (whatever that maps to on your keyboard, it's ESC-W on mine).  Then you can use the directional keys (arrows) to move your display up, down, left, and right.  To leave window mode, press ACCEPT and you're back where you started from.


--
Kim Medlin                             Email:    klm@atlanta.dg.com
Atlanta Systems Integration Services   CEO:      Kim Medlin:DGC
Data General Corporation               Phone:    404 448-6072 ext 2007
----------------------------------------------------------------------
Be nice, because all we really have in this old world is each other.
  ... Joey the Clown, 1964
----------------------------------------------------------------------
The opinions expressed herein are my own and not those of my employer.
----------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: jfedorko@ncsa.uiuc.edu (Joel Fedorko)
Subject: Re: When if ORACLE V7 really going to come out?
Originator: jfedorko@mars.ncsa.uiuc.edu
Organization: Nat'l Ctr for Supercomp App (NCSA) @ University of Illinois
Date: Wed, 29 Jul 1992 18:24:11 GMT
Keywords: ORACLE7

Peter... The Oracle7 developers version is really out, I've been running it
for several weeks now(Vax version).  Rumor has it that v7 will be production
around august-sept.  As far as support goes... you may want to double check me
but I'd say buy it NOW.  It's my understanding that when 7 goes production and
you haven't had 6 support after  n  months your'e gonna have to PAY.

-Joel
From: kortikar@mipos2.intel.com
Newsgroups: comp.databases.oracle
Subject: Group positioning in sql*reportwriter v 1.1
Date: 28 Jul 92 16:16:36 GMT
Reply-To: kortikar@mipos2.intel.com ()
Organization: Microprocessor Component Group, Intel Corp., Santa Clara, CA

Hi

I would like to print report in sql*reportwriter V 1.1 as follows

Group1  		Group2
------			------

Group3
-------

Group4
-------

group 2 will be right of group1
however group 3 should be below group1 & NOT below group2. 
and group 4 below group group 3.

If I select group3 and group 4 in the right margin then my reportwriter will
chop off group 1 entries after <total-entries-in-group-2> are printed. and      
then it will print group 3 entries. (hence right margin option will work as
long as there are less entries in group 1 than group 2)
any solutions would be welcome.

I am using Oracle 6.0.33 + with sql*reportwriter v 1.1 + on AT&T unix 5.4
thanks in advance.

Aniruddha Kortikar (kortikar@mipos2.intel.com)
Newsgroups: comp.databases.oracle,comp.dcom.lans.ethernet
From: doc@magna.com (Matthew J. D'Errico)
Subject: SQL*Net - TCP/IP configs & Windows ?
Organization: Magna Software Corporation
Date: Sat, 25 Jul 1992 02:13:13 GMT

I'm running a LanManager 2.0 LAN with 3Com TCP 2.0...  When I
flipped through the SQL*Net manual this afternoon, it didn't
include any reference of 3Com TCP...  Nor did it tell me whether
it will run with MS Windows...

Does anyone know if ORACLE SQL*Net will indeed run with this type
of LAN configuration ?  I'd like to know before I completely unpack
and install everything...  I just recently had a bad experience
with another Database Net product.

Regards --

-- Doc
+-------------------------------+---------------------------------------+
|    Matthew J. D'Errico	| DOMAIN:	mderrico@magna.com	|
| Magna Software Corporation	| uucp:		uunet!magna!mderrico	|
|     275 Seventh Avenue	| CompuServe:	70744,3405		|
|	 20th Floor		+---------------------------------------+
|    New York, NY   10001	|	Voice	: 212 / 727 - 6737	|
|	    USA			|	Fax	: 212 / 691 - 1968	|
+-------------------------------+---------------------------------------+
Newsgroups: comp.databases.oracle
From: klm@atlanta.dg.com (Kim Medlin)
Subject: Re: (SOLUTION ENCLOSED) Re: SQL*Reportwriter last page eject
Date: Thu, 30 Jul 92 21:05:31 GMT
Organization: Data General Corp. ASSD, Atlanta, GA

Any MS-DOS solutions out there?


--
Kim Medlin                             Email:    klm@atlanta.dg.com
Atlanta Systems Integration Services   CEO:      Kim Medlin:DGC
Data General Corporation               Phone:    404 448-6072 ext 2007
----------------------------------------------------------------------
Be nice, because all we really have in this old world is each other.
  ... Joey the Clown, 1964
----------------------------------------------------------------------
The opinions expressed herein are my own and not those of my employer.
----------------------------------------------------------------------
From: sjs@netcom.com (Stephen Schow)
Newsgroups: comp.databases.oracle
Subject: Multiple Screens in SQEL*FORMS
Date: 23 Jul 92 17:13:23 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

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?
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
problems that I might run into and have to program around by putting each
screen on a different page of the same form.

Any help?
-- 
------------------------------------------------------------------
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
------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: newby@leland.Stanford.EDU (Matthew Newby)
Subject: FAQ?  Suggested Reading?  Need advice...
Organization: DSG, Stanford University, CA 94305, USA
Date: Wed, 22 Jul 92 03:19:57 GMT

Hello all you Oracle Gurus.  I have a possible job opportunity coming up, and
my main duties will involve moving a database currently on a Mac platform using
some sort of network database to a Sun platform using Oracle.  Problem:  I know
nothing about Oracle at the moment (other than the fact that it is a database
of some sort).  I have a very good understanding of the dBase family of 
languages (dBase II, III, III+, IV, Clipper, Foxpro, and FoxBase+), and of the 
UNIX environment (I own a couple of Sun 2s).

Question:  Is there a FAQ for this newsgroup?  I haven't been subscribed for 
very long, so I haven't seen one yet.

Question:  Given my background, what would you recommend as the best reading 
material for me to quickly get a grasp of the basic concepts of Oracle?  I 
would prefer any documentation available in electronic form (email or ftp is
fine by me) over books that need to be purchased in a store (unemployment 
doesn't go quite that far).

Please reply to me by mail, as I do not read news as often as I log in :-).

Thanks in advance!


-- 
   /\/\/\            |  ----------->> newby@leland.stanford.edu <<-----------
    / / /    __/__/_ |  Rom 10:9  If you confess with your mouth, "Jesus is
   / / / __,  /  /   |  Lord," and believe in your heart that God raised him
  / / (_/(_\_/\_/\_  |  from the dead, YOU WILL BE SAVED!
From: sjs@netcom.com (Stephen Schow)
Newsgroups: comp.databases.oracle
Subject: Inverse Fields in SQL*FORMS
Date: 23 Jul 92 17:06:22 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

I would alos like to know how to make a field appear in NON-inverse mode
on a form.  Any help?

-- 
------------------------------------------------------------------
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
------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: skaul@ms.uky.edu (Sanjay Kaul)
Subject: How to create ORACLE tables using data from a file?
Date: Wed, 29 Jul 1992 01:31:01 GMT
Organization: University Of Kentucky, Dept. of Math Sciences

I have to create ORACLE DATABASES from user files.
One file contains database description. So the CREATE TABLE command
has to execute using a file.
Another file contains raw data(tuples) to be inserted in the TABLE
created above.

Hence the database structure has to be created from the file and
then this database has to be filled(with rows) using another file.

Would appreciate any suggestions.

Thanks in advance.

Sanjay
-- 
***************************************************************
Sanjay Kaul                 * BITNET   :cs0768sk@ukcc.uky.edu *
700 Woodland Ave,           * INTERNET : skaul@ms.uky.edu     *
#F-209,Lexington,KY,40508   * TEL :(606) 258 -6221            *
From: jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
Subject: Re: Referencing a SEQUENCE from a trigger...
Date: 21 Jul 92 15:32:41 GMT
Followup-To: comp.databases.oracle
Organization: University of Helsinki

In article <1992Jul20.195514.8085@unixg.ubc.ca>, george@unixg.ubc.ca (George chow) writes:
> 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
You can't execute DML statements (inserts, updates, deletes) from an
ON-VALIDATE-FIELD trigger. You should think how you could do the job in
transactional triggers (pre/post-insert/delete/update etc). Or you have
to do your insert through the base table mechanism.

And using ON-VALIDATE-FIELD trigger is bad choise because it may happen
that the trigger gets executed many times, each of which grabs another
sequence number; and the user might rollback any changes, which leaves
gaps into your serial numbers. The gap problem is inherent with
sequences, but that's acceptable here, right?

> getting from a SEQUENCE. However, I can't seem to reference the SEQUENCE.
> I'm doing something like:
> 
>   new_ref := :SEQUENCE.V_REF_NO_SEQ.NEXTVAL;
Try to rethink this by using transactional triggers. There, if you are
not inserting via the base table mechanism, you can write:

  INSERT INTO the_table (serial_no, ...)
  SELECT v_ref_no_seq.nextval, :block.fieldname, ...
  FROM dual;

Maybe INSERT ... VALUES would do as well, look at the manual. This is
clean and avoids the PL/SQL variable new_ref. In my opinion, having many
scratch variables decreases readability and is not in 4GL spirit. This
solution obviously has the drawback that you have no way of knowing what
number just got inserted. If you really want to know that, use SELECT
v_ref_no_seq.nextval INTO new_ref FROM dual. The original assignment
statement is illegal, because you can reference sequences only in SELECT
column expressions.

> 
> 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? 
Yes.
--
Juhani Jaakola
jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
From: mark@homebase.vistachrome.com (Mark Alexander)
Subject: windows front end
Organization: Vista-Chrome Incorporated
X-Newsreader: Tin 1.1 PL4
Date: Thu, 30 Jul 1992 18:31:09 GMT

Has Anyone seen a good Windows 3.x front end to Oracle?
How about for MacIntosho
-- 

-----------------------------------------------------------------------
      Mark Alexander      alexand@nu.cs.fsu.edu    mark@vistachrome.com
                          Florida State Univ.      Vista-Chrome, Inc.
                          Tallahassee, FL          Tallahassee, FL 
-----------------------------------------------------------------------
From: littlec1@jaguar.uofs.edu (Chris Little)
Newsgroups: comp.databases.oracle
Subject: Re: Deleting Duplicates
Date: 23 Jul 92 14:16:11 GMT
Organization: University of Scranton

In article <VN70NB1w165w@iowegia.uucp>, bob@iowegia.uucp (Bob Powers) writes:
> How can I delete duplicate rows in a table using SQL*PLUS.  This is
> an unindexed table and I would like to keep it that way.

I'm relatively new at the job, but I suspect you could create a similar
table, do an INSERT SELECT UNIQUE from the old table to the new table,
delete all rows from the old table, copy all rows from the new table
to the old, and then drop the new one.  Maybe there's a better way.

Good Luck.

--
Chris Little, Programmer/DBA
                                                University Computing Systems
                                                University of Scranton
  LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510
From: mtoms@ems.cdc.com (Mark Toms)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*Forms 3.0 LOV, controlling the width...
Date: 22 Jul 92 17:40:25 GMT
Reply-To: mtoms@ems.cdc.com
Distribution: na
Organization: Empros Systems International, a division of CDC

In article <1992Jul21.213306.8315@unixg.ubc.ca>, george@unixg.ubc.ca (George chow) writes:
|> 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

George,

  We ran into a similar situation and solved it by using the following
within the FORM:

  select substr(functional_id,1,4), substr(functional_id_desc,1,50)
    into :functional_id

functional_id is char(4) and functional_id_desc is char(80)
 
 
  We did notice something strange, however.  You would think that since
functional_id is only 4 characters wide, you wouldn't need the
substr function.  When we did not include the substr function, only
the first 3 characters were displayed in the LOV.  

Good luck,
Mark


Sorry about the multiple postings...I was having trougle getting this 
message to post out of the building.

==========================================================================
J. Mark Toms                                email: mtoms@ems.cdc.com
Baltimore Gas & Electric, Company
C/O Empros Systems International            Phone: (612) 553-4423
2300 Berkshire Lane North                     FAX: (612) 553-4018
Plymouth, Minnesota  55441-3694 USA      Mailstop: PLY060
==========================================================================
From: ria@dash.udev.cdc.com (Richard Askew)
Newsgroups: comp.databases.oracle
Subject: Forms3 with Mouse Interface
Date: 30 Jul 92 16:38:15 GMT
X-Newsreader: Tin 1.1 PL3

Greetings,

Does anyone know if Forms3 can be Mouse driven on an X-term (such as an NCD).
I've experimented with BITMAP & XBITMAP, with partial success - display all
messed up , but functionally OK!

- Any experiences(Oracle!) much appreciated!

Regards,
--
Richard Askew
Information Management Centre
Control Data Systems Inc
London (UK)
Internet: ria@cdl.cdc.com
FAX (+44) 81 848 3134
From: kjou@us.oracle.com (Kathy Jou)
Newsgroups: comp.databases.oracle
Subject: Re: How to create ORACLE tables using data from a file?
Date: 30 Jul 92 00:36:49 GMT
Organization: Oracle Corporation, Redwood Shores CA 94065
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 <1992Jul28.213101.2345@ms.uky.edu> skaul@ms.uky.edu (Sanjay Kaul) writes:
>I have to create ORACLE DATABASES from user files.
>One file contains database description. So the CREATE TABLE command
>has to execute using a file.
>Another file contains raw data(tuples) to be inserted in the TABLE
>created above.
>
>Hence the database structure has to be created from the file and
>then this database has to be filled(with rows) using another file.
>

I would recommend SQ*Loader, which allows syntax for table creation in the
control file.  Take a look at the ORACLE RDBMS Utilities User's Guide.


-- Kathy Jou
-- Oracle Corporation
From: kortikar@mipos2.intel.com
Newsgroups: comp.databases.oracle
Subject: What are these values in dba_tab_grants ? (G,N,A,Y) ?
Date: 31 Jul 92 18:48:41 GMT
Reply-To: kortikar@mipos2.intel.com ()
Organization: Microprocessor Component Group, Intel Corp., Santa Clara, CA

hi there

could anyone please tell me meaning of G N A Y values in dba_tab_grants made
view for fields update_priv,insert_priv etc.

thanks in advance

Aniruddha Kortikar (kortikar@mipos2.intel.com)
Newsgroups: comp.databases.oracle
From: belk@dxcern.cern.ch (Andy Belk)
Subject: Occasional SQL*Net error 3111 - anyone else seen it ?
Summary: Infrequent internal Oracle error 3111
Keywords: SQL*Net error 3111 tcp/ip
Organization: CERN European Lab for Particle Physics
Date: Tue, 28 Jul 1992 13:58:43 GMT

Hi all,
        We are occasionally seeing an SQL*Net error (described in the 
manual as "This is an internal error message not normally issued" (aren't
they all) number ORA-03111 "break received on communication channel".

We're using an Apollo (Domain 10.3) to run the client program and the
orasrv program runs on a DEC 5000 at the other end of an FDDI link.

Whilst the error is attributed to Oracle by it's own error handling
mechanism, the problem seems to occur in the same function, which happens
to be doing a number of updates (about 100) on the same table in a short
space of time.

What we'd like to know is whether something the client is doing (the Pro*C
program) is likely to be causing the problem, or whether it is the result of
an overloaded orasrv/server computer/unreliable network. Any hints or clues
welcome - even just some confirmation that other people have seen the same
error.

Thanks,
        Andy Belk

-- 
					    ...   Anyd   ...
From: chia@hatteras.cs.unc.edu (Mr. Chia)
Newsgroups: comp.databases.oracle
Subject: SQL*FORM : execute_query and clear_block
Date: 24 Jul 92 14:57:04 GMT

Hi,

I am trying to build a block such that the operator can only update or query
about the table. He/She is not permitted to insert/delete a record.

I grant select and update privileges to the operator. Then I tried
execute_query; and clear_block('no_commit'); in the pre-block trigger.
When I execute the form, I got the following message:
execute_query; : illegal restricted procedure
clear_block :  unhandled exception: VALUE_ERROR

What is wrong? 
Thanks.

Wei-Jiun