HDTenEightyP/NetNews huggingface dataset:
From: huynh@falcon.navsses.navy.mil
Newsgroups: comp.databases.oracle
Subject: Forms3 ERR - unable to INSERT record
Date: 22 Jul 92 15:53:29 GMT
Organization: NSWCCD, Naval Ship Systems Eng Sta, Phila PA

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.  A couple of data will be entered and
from there the rest of the information will be query in.  Then the user will 
have to enter some comments at the maximum of five lines.  After that, I want
to insert the information in the form to the database table.

For every execution, after hitting the commit key, I keep getting the error:
FRM 40508 : ORACLE ERROR -- unable to INSERT record

I have check the followings:
1) all the fields to be inserted are of 'base table'
2) all the 'not null' fields are filled with data
3) I do have access to create, insert and update the tables

I think the problem is that I have four tables in one forms, and that some 
fields are included in all tables.  Do I have to specify the exact table 
where each field should go to? 

I really only want to insert into one table, the new one; it is empty at this
point.  Aha!  Is it that the information in the other tables have already been
inserted, and they cannot be inserted again?  If so, how can I get around this
problem.

I hope I had explained the problems thoroughly.  Anyone who is interested in
the problem, but did not get a clear understanding at some point, please feel
free to ask.  I would be more than delighted to make myself clear.

Any suggestions would be appreciated.  Many thanks.
Newsgroups: comp.databases.oracle
From: dewey@centerline.com (Devan F. Dewey)
Subject: Re: Forms3 ERR - unable to INSERT record
Followup-To: comp.databases.oracle
Organization: CenterLine Software, Inc.
Date: Wed, 22 Jul 1992 15:43:17 GMT

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
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: (SOLUTION ENCLOSED) Re: SQL*Reportwriter last page eject
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Wed, 29 Jul 1992 13:21:10 GMT

dewey@centerline.com (Devan F. Dewey) writes:

>In article <fragante.712263892@unixg.ubc.ca>, fragante@unixg.ubc.ca (Gv
>Fragante) wrote:
>> 
>> Our SQL*Report always prints a blank last page on every report. How can we
>> get rid of this ?
>> 
>> Thanks.

>Make SURE this answer gets to the net!!! I feel like we kill about 18 trees
>a day due to this little gremlin.

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.)  

Now look at the Unix print spooler in (your mileage may vary) 

	* /usr/spool/lp/admins/lp/interfaces/{printername}

One of the last lines inside the print_copies loop is "echo "\014\c",
which says output a form feed.

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).

Two:

	Change the printer script to NOT emit that form feed.
	Side effect: OTHER printings from programs that don't do their
	own pagination and form feeding won't start at the beginning
	of a page.

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.


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

-Andy
 just an oracle customer

-- 
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: scott@prism.gatech.EDU (Scott Holt)
Newsgroups: comp.databases.oracle
Subject: V7 Questions
Date: 29 Jul 92 19:48:58 GMT
Organization: Georgia Institute of Technology


We just received V7 developers for AIX last week and a couple of questions
have been brought up I thought the net may be able to answer.

1) Under AIX, can V7 and V6 kernels cooexist on the same system - no 
   sharing data or any of that, just running together.

2) Can a client from a V6 release, say a Sun version for Forms, use the
   V7 database services? If so, does the restriction concering user
   exits (i.e. not yet supported in the AIX V7 release of Forms) still
   apply?

thanks,
Scott
-- 
This is my signature. There are many like it, but this one is mine.
Scott Holt                 		Internet: scott@prism.gatech.edu
Georgia Tech 				UUCP: ..!gatech!prism!scott
Office of Information Technology, Technical Services
Newsgroups: comp.databases.oracle
From: gopi@indetech.com (Prakash Gopinath)
Subject: Displaying variables in PL SQL
Organization: Independence Technologies, Inc. Fremont, CA
Distribution: usa
Date: Wed, 22 Jul 1992 20:35:58 GMT


I am using Oracle ver 6.0. I want to display variables used in PL SQl onto the console.
Is it possible? 

Please help!

Thanks
Gopinath
Newsgroups: comp.databases.oracle
From: fragante@unixg.ubc.ca (Gv Fragante)
Subject: Re: Displaying variables in PL SQL
Organization: University of British Columbia, Vancouver, B.C., Canada
Distribution: usa
Date: Thu, 23 Jul 1992 19:17:43 GMT

In <1992Jul22.203558.25081@indetech.com> gopi@indetech.com (Prakash Gopinath) writes:


>I am using Oracle ver 6.0. I want to display variables used in PL SQl onto the console.
>Is it possible? 

>Please help!

>Thanks
>Gopinath

Use the Message() function. As in MESSAGE(:GLOBAL.MY_VARIABLE). If you want
to display a numeric variable, use the TO_CHAR() function as in
MESSAGE(TO_CHAR(:GLOBAL.MY_NUM_VARIABLE)).

Use Message() to display :SYSTEM, :GLOBAL and local variables. YOu can string
variables together so that you can see them in one MESSAGE() command.
Newsgroups: comp.databases.oracle
From: kjou@us.oracle.com (Kathy Jou)
Subject: Re: National Language Support in ORACLE v.6
Followup-To: kjou@us.oracle.com
Organization: Oracle Corporation, Redwood Shores CA 94065
Distribution: comp.databases.oracle
Date: Tue, 28 Jul 1992 17:25: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 <1992Jul28.121659.6252@rz.uni-karlsruhe.de> rz34@rz.uni-karlsruhe.de writes:
>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

Did you restart the datbabase after making the change to the init{SID}.ora
file?  From sqldba, after you connect internal or to system, issue "show
parameter language".  Does it reflect what you have entered (just in case it
was placed in the wrong init ora file)?

In order to receive German error messages, you also need to set the LANGUAGE
environment variable to the same value as language in the init ora file.  The
wrong character set will only limit you to what type of characters you may 
enter, not the language.  The appendix of the DBA guide talks about this in
a little more detail.  Also check for online readme files regarding supported
character sets on HP/UX.

Regards,

Kathy Jou
Oracle Corporation

Newsgroups: comp.databases.oracle
From: brett@citr.uq.oz.au (Brett Jordan)
Subject: SQLFORMS and ANSI SQL
Summary: Is there a version of forms that uses ANSI SQL only?
Keywords: sqlforms ansi sql
Organization: Prentice Centre, University of Queensland
Date: Thu, 23 Jul 1992 02:05:19 GMT

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.
From: kml@cellar.org (bdfh)
Newsgroups: comp.databases.oracle
Subject: Correction to script in Oracle magazine Sum 92
Date: 20 Jul 92 15:31:38 GMT
Organization: The Cellar BBS and public access system

There is a minor typo in the "Lies, Damned Lies, and Hit Ratios" article
that appears in the Summer 92 edition of Oracle Magazine.  The code in the 
bottom-left corner of page 45 contains an Update command.  In the Where
clause of the subquery of that command, the same mistake is made twice.
The lines "where h2.check_date=hitratios.check_date and h2.check_hour =
hitratios.check_hour" should be modified, replacing "hitratios" with
"hit_ratios".  This is a minor point, but typing it as shown in the 
article will result in a table-or-view-does-not-exist error.

-Kevin.

------
kml@cellar.org (bdfh)
The Cellar BBS - (215) 654-9184
Newsgroups: comp.databases.oracle
From:  Neil Greene <deepthought!neil@ms.uky.edu> 
Subject: Selecting sequences into form fields
Reply-To:  Neil Greene <deepthought!neil@ms.uky.edu> 
Organization: ARCI, Inc.
Date: Wed, 29 Jul 1992 17:23:46 GMT

I have 3 sequences: seq_nasrisid, seq_rulingid, seq_licensid.  Each of these  
sequences are displayed in a different block on a different page of the form.

I have a trigger that catches KEY-CREREC which then uses an if statement to  
determine which block I am in and then fetch the next available sequence into  
the form for that record.

> if (:SYSTEM.CURSOR_BLOCK = 'MASTER') then
>     clear_MASTER_details(TRUE, DO_COMMIT);
>     create_record;
>     select SEQ_NASRISID.NEXTVAL into :MASTER.NASRISID from dual;

This works fine, however, the if statements do not work for the other two  
sequences.  

> elsif (:SYSTEM.CURSOR_BLOCK = 'RULINGS') then
>      create_record;
>      select SEQ_RULINGID.NEXTVAL into :RULINGS.RULINGID from dual;
> end if;

Could someone explain what I am doing wrong.  Table and sequence permissions  
are set correctly.

-- 
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: HARM@SLACVM.SLAC.STANFORD.EDU
Newsgroups: comp.databases.oracle
Subject: Clear Access
Date: 31 Jul 92 17:54:52 GMT
Organization: Stanford Linear Accelerator Center

I have been assigned to find out about a product called "Clear Access".

I would appreciate it if someone could fill me in on the company
     responsible for it.  send me the name and phone number of the
     company, please.

It is supposed to be able to transfer data from ORACLE to Excel.

That's all I know and I haven't found it in my catalogs yet.

Email responses, please, to HARM@SLACVM.SLAC.STANFORD.EDU

THANK YOU, for your time.
From: jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
Subject: Re: Using Views for BLOCKS?
Date: 24 Jul 92 06:37:10 GMT
Organization: University of Helsinki

In article <m1gmq8-.sjs@netcom.com>, sjs@netcom.com (Stephen Schow) writes:
> I have heard that SQL*FORMS performance is a little better if I create a 
> view of a table and then base the form block on the view instead of 
> directly on the table.
> 
> Anyone have any experience to know if this is true or not?
If you have an one-to-one view from a single table, this is not true.
But if you have a base table and you must join data from several other
tables (i.e. you have and POST-QUERY trigger or POST-CHANGE triggers),
you can join the data in the view and avoid calling several SQL
statements for each fetched record during a query. This is very
important in client-server environments, particularly when clients are
PCs.

> 
> ALSO,
> 
> What if I created a view with a join and based a form on that view as
> if it was just one table.  Would I be able to update records and would
If the view is updatable, yes (see the manual on views).

> Oracle automatically update both the master and the detail records in the
> actual tables?
If the view fetches from many tables, the view most certainly is not
updatable. You have to make your own ON-LOCK and ON-UPDATE/DELETE/INSERT
triggers.
--
Juhani Jaakola
jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
From: GO.MSB@isumvs.iastate.edu 
Subject: Re: Clear Access
Organization: Iowa State University, Ames IA
Distribution: usa
Date: Fri, 31 Jul 1992 20:47:04 GMT

In article <92213.095452HARM@SLACVM.SLAC.STANFORD.EDU>,
HARM@SLACVM.SLAC.STANFORD.EDU writes:
>I have been assigned to find out about a product called "Clear Access".
>
>I would appreciate it if someone could fill me in on the company
>     responsible for it.  send me the name and phone number of the
>     company, please.
>
>It is supposed to be able to transfer data from ORACLE to Excel.
>
>That's all I know and I haven't found it in my catalogs yet.
>
>Email responses, please, to HARM@SLACVM.SLAC.STANFORD.EDU
>
>THANK YOU, for your time.
-------------------------------------------
ClearAccess is from Fairfield Software
                    200 West Lowe St.
                    Fairfield Iowa  52556
                    515.472.7077
                    1.800.522.4252

It is a Mac tool.  Accesses various DBMS's.

Marvin Beck  Iowa State University
From: jean@seismo.CSS.GOV (Jean Anderson)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle Backup
Date: 22 Jul 92 20:51:35 GMT
Organization: SAIC Open Systems Division, San Diego CA

In <45406@shamash.cdc.com>, ldh@svl.cdc.com (Lawrence D. Hare) writes:
> 1) How do you back up Oracle databases today?

Many of my sites do nightly full database exports out of cron.  We accept 
a 24 hour "worst case" data loss. This is not as bad as it might seem.
If "the worst" happens (which it has), we rebuild from the previous night's 
export and re-process, catching up to real-time in a matter of hours.

Back in April, I posted the instructions somebody sent me on compressing UNIX 
exports.  I have been running them since May and it has been great, reliable,
reducing the amount of disk we previously had to allocate for exports. I have
even had the misfortune of needing to restore from a compressed backup and
it worked.

Here are the instructions again.  The credit goes to somebody who wishes to 
remain anonymous because of the employer's restrictions on posting.

    I have found that the best way to do this is using Unix's named-pipes
    feature.  Simply:

    % mknod /tmp/compresspipe p
    % compress -c </tmp/compresspipe>/backup/oraexp/exp1MAY92.dmp &
    % exp system/manager full=y ..... file=/tmp/compresspipe

    Voila!  After the compress receives an EOF (sent by exp), it
    terminates, leaving a nice compressed file.  This saves using various
    undocumented features (as file=stdout must be?!)

    To import, do the same thing:

    % uncompress -c </backup/oraexp/exp1MAY92.dmp >/tmp/compresspipe &
    % imp system/manager .... file=/tmp/compresspipe
	
+-----------------------------------------------------------------------+
| Jean Anderson, DBA                       email:  jean@seismo.css.gov  |
| SAIC Open Systems Division, MS A2-F         or:  jean@esosun.css.gov  |
| 10210 Campus Point Drive                 phone:  (619)458-2727        |
| San Diego, CA  92121                       fax:  (619)458-4993        |
+-----------------------------------------------------------------------+
|                     std_disclaimer("mine");                           |
+-----------------------------------------------------------------------+
From: george@unixg.ubc.ca (George chow)
Newsgroups: comp.databases.oracle
Subject: How to auto-start the field editor...
Date: 23 Jul 92 18:34:51 GMT
Organization: University of British Columbia, Vancouver, B.C., Canada
Originator: george@unixg.ubc.ca

(I'm using Forms 3.) I've been trying to get the Field Editor to start up
automatically upon entry of one of my fields. I've tried calling the 
packaged procedure EDIT_FIELD in both KEY-NXTFLD and PRE-FIELD triggers and
neither of them works. My situation is like this:

  FIELD         SEQ NO
  Building_Code   3
  Address         4

I attached the KEY-NXTFLD trigger to Building_Code but even with a go_field,
I get stuck editing the Building_Code field. With the PRE-FIELD trigger,
I can a run-time error of:

  FRM-40737: Illegal restricted procedure EDIT_FIELD in PRE-FIELD trigger.

I've gone through all the triggers and I can't see which other triggers I can
use to auto-start the field editor. Is this possible? Thanks for any help.

George
From: puckett@lambda.msfc.nasa.gov (Jim Puckett)
Newsgroups: comp.databases.oracle
Subject: How to monitor performance?
Summary: ...from Pro*C
Date: 30 Jul 92 16:39:41 GMT
Organization: NASA/MSFC

...so here's the deal.

using Pro*C, doing some _extremely_ IO bound stuff (massive array inserts)
and getting little bitty CPU figures  
BECAUSE
DBWRITEMON is doing all my IO work for me.

but i am trying to prototype here, and so I need to find out how much 
work DBWRITEMON is doing on my behalf - in terms of CPU usage and IO 
stuff.

any ideas? 

please email, and thanks in advance

jim p.

puckett@lambda.msfc.nasa.gov


-- 
Jim Puckett    NTI    puckett@freedom.msfc.nasa.gov     
Huntsville,AL (205)461-4922  
This life is a test. It is only a test. If it had been a real life, you 
would have been given instructions....
Newsgroups: comp.databases.oracle
From: srh@scammell.ecos.tne.oz.au (Shane Hocking)
Subject: Re: Forms3 ERR - unable to INSERT record
Organization: Telecom Australia, Information Technology Development
Date: Wed, 22 Jul 1992 23:27:06 GMT

>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.
>
>                             
You can use forms to insert, update, or delete data through a view (defined
as a base table in forms) even if that view is a multi table join. You must
however control the locking , inserting,updating and deleting through the 
following triggers.  ON-LOCK,ON-INSERT, ON-UPDATE & ON-DELETE.
This is a useful feature in Client-Server programming to minimise the
number of packets required to display a "block" of information.

-- 
Shane Hocking       srh@scammell.ecos.tne.oz.au
From: littlec1@jaguar.uofs.edu (Chris Little)
Newsgroups: comp.databases.oracle
Subject: DB file not in DBA_DATA_FILES - problem
Date: 21 Jul 92 16:22:52 GMT
Organization: University of Scranton


Major problem!!  While adding a database file to a tablespace, my main
process died.  Now upon recovery I see that the DBWR process is
accessing that file, but that file's description is not in DBA_DATA_FILES.
Also, I doubt the DBWR is writing to it because I HAD to add another file
in order to continue extending the database, which is what I was doing
in the first place.

Any suggestions?

--
Chris Little, Programmer/DBA
                                                University Computing Systems
                                                University of Scranton
  LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510
Newsgroups: comp.databases.oracle
From: nasris@deepthought.uucp (Neil Greene)
Subject: SQL*Reportwriter scroll down?
Organization: ARCI, Inc.
Date: Wed, 29 Jul 1992 04:36:41 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?

Thanks
-- 
Neil Greene
ARCI, Inc.
President, Kentucky NeXT User Group, Inc.
Phone: 606.254.4060