HDTenEightyP/NetNews huggingface dataset:
From: claborne@npg-sd.SanDiegoCA.NCR.COM (Chris Claborne)
Newsgroups: comp.databases.oracle
Subject: Re: MS-Windows based tools
Date: 13 Oct 92 16:41:44 GMT
Distribution: na
Organization: NCR Corp., Network Products - San Diego


Newsgroups: comp.databases.oracle
Subject: Re: MS-Windows based tools
Distribution: na

In <1992Oct7.055014.18461@usl.edu> cdc6586@usl.edu (Charbonnet Clement D) writes:
[stuff deleted]

>I would like to find some third party tools that will allow me 
>to replace SQL*Forms, SQL*Menu, and SQL*ReportWriter with a 
>Windows based product.  The report capabilities of the tool 
>must be able to handle preprinted forms on a laser printer and 
>a line printer.  I would also prefer a tool that included free 
>runtimes, though this is not needed.

>Any help would be greatly appreciated.


I am currently learning Gupta's SQL Windows, and have written some applications
with it. 
Our Corp. folks are getting ready to use PowerBuilder to develop some company
wide apps.  I have also heard of some rather large applications
build using powerBuilder.  These are the only two that I know of that have a 
router / interface to Oracle backends.

I am going to COMDEX next month and am going to review Powerbuilder to see if 
this is the way to go.  I like the Gupta product.  The object oriented language
is great for devellopeing and integrated development environment they give you 
is one of the best I've seen.

I am not too crazzzzy about their solution for reporting though.

Please let me know about other replys that you get on this as I need to 
commit to something soon and go for the full training.


                                    ...  __o
                                   ..   -\<,
chris.claborne@sandiegoca.ncr.com  ...(_)/(_).                 CI$: 76340.2422
Newsgroups: comp.databases.oracle
From: wkaufman@us.oracle.com (William Kaufman)
Subject: Re: forsm conversion from 2.0 2.1 to 3.0
Keywords: forms conversion
Organization: Oracle Corporation, Redwood Shores CA
Date: Tue, 13 Oct 1992 15:28:27 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 <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.

                                           -- Bill K.

Bill Kaufman,          | "People look better under arrest,... it gives you
wkaufman@us.oracle.com |  an aggressive fashion look."  -- John Waters
From: tumidity@netlink.cts.com (Joel Garry)
Newsgroups: comp.databases.oracle
Subject: Re: Recovering ORACLE db after system crash
Keywords: recover, oracle
Date: 15 Oct 92 01:41:40 GMT
Organization: NetLink Online Communications, San Diego CA

bill@chaos.cs.umn.edu ( Hari Seldon     psychohistorian ) writes:
> 
> >We are currently running ORACLE Version 6.0.31.0.1 on an RS/6000, running
> >AIX Version 3.2.  A power failure took out the machine the other day while
>                      ^^^^^
> >What should I have done?
> 
> very simply you should be using a ups. it should have sw to do a shutdown
> when the power goes away (for a specifiec period of time) and it should wait
> a bit after power coes back prior to restarting the machine.
> it's cheep, its simple, it's good insurance.

Yes, ours only cost $20,000 plus a diesel generator, concrete block
building and new transformers on the pole.  Then it blew up when the
electricians installed it and turned the lever that says "do not turn".

--                    
INTERNET:  tumidity@netlink.cts.com (Joel Garry)
UUCP:   ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
From: allardmj@rosalind (Michael J. Allard)
Newsgroups: comp.databases.oracle
Subject: SQL*Menu Initialization Error
Date: 8 Oct 1992 17:18:40 GMT
Organization: Computer Science Department at Rose-Hulman
Distribution: world
NNTP-Posting-Host: rosalind.cs.rose-hulman.edu

Hi.  I am posting this for a friend who has the ability to read news, but  
not to post it.  Please send all replies to him at:

	rma866@crane-ns.nwscc.sea06.navy.mil

Thanks.
Mike (allardmj@cs.rose-hulman.edu)

-------------- (His message...) ----------------

Hello,

In attempting to write a forms application integrated with a SQL*Menu, I  
keep running up against the same error.

In a trigger I have the procedure call

	REPLACE_MENU('my_menu', PULL_DOWN, 'mymenu');

Using debug I have determined that this is the statement that always  
causes an error, namely FRM-41809 'Error initializing SQL*Menu'.

My questions are:

	1) What is the initialization process that is failing?
	2) How can I correct it?

Please direct all replies to rma866@crane-ns.nwscc.sea06.navy.mil.

Thanks,
Matt Adams
From: ebuhob@ebu.ericsson.se (Hans Bergsten 6264)
Newsgroups: comp.databases.oracle
Subject: Setting FLOAT with OCI
Date: 10 Oct 92 00:46:14 GMT
Reply-To: ebuhob@ebu.ericsson.se
Organization: Ericsson Business Communications, Inc.
X-Disclaimer: This article was posted by a user at Ericsson.
              The opinions expressed are strictly those of the
              user and not necessarily those of Ericsson.

Hi,

I have problem with columns of type FLOAT, using the OCI functions in ORACLE 
V6.0.33.2.3, on SunOS 4.1, SPARCstation IPX. 

Reading columns of type FLOAT works fine, but I get a core dump from low level 
ORACLE routines when I insert a new row.

Sample program:

main()
{
  csrdef	csr;
  ldadef	lda;
  float		f;   
    .
    .
    .
  printf("Getting FLOAT value ...\n");
  if (oopen(&csr, &lda, -1, -1, -1, -1, -1)) {
    return (1);
  }
  if (osql3(&csr, "SELECT VALUE FROM FLOAT_VALUE WHERE ID = 1", -1)) {
    return (1);
  }
  if (odefin(&csr, 1, &f, sizeof(float), 4, -1, -1, -1, -1, -1, -1, -1)) {
    return (1);
  }
  if (oexec(&csr)) {
    return (1);
  }
  if (ofetch(&csr)) {
    return (1);
  }
  printf("Got %f\n", f);
  
  printf("Setting FLOAT value ...\n");
  if (osql3(&csr, 
    "INSERT INTO FLOAT_VALUE VALUES(FLOAT_VALSEQ.NEXTVAL, :p_value)", -1)) {
    return (1);
  }
  if (obndrv(&csr, ":p_value", -1, &f, sizeof(float), 4, -1, -1, -1, -1, -1)) {
    return (1);
  }
  if (oexec(&csr)) {
    return (1);
  }
    .
    .
    .
  exit(1);
}

The program produces this output:

  Getting FLOAT value ...
  Got 2.340000
  Setting FLOAT value ...
  Segmentation fault (core dumped)

The table FLOAT_VALUE is created as:

  create table float_value (id integer not null, value float not null);

and a value inserted via SQL*Plus:

  insert into float_value values(1, 2.34);

dbx shows me the following call stack when I analyze the core file:
  atom% dbx t1
  Reading symbolic information...
  Read 1397 symbols
  program terminated by signal SEGV (no mapping at the fault address)
  (dbx) where
  oarren() at 0x2d178
  ttcf2n() at 0x26890
  ttcacs() at 0x242e4
  ttcdrv() at 0x119d8
  osntwa() at 0xa15c
  upirtr() at 0x10aec
  upiexe() at 0xc6f4
  ociexe() at 0x3c08
  main(), line 52 in "t1.c"

Any help would be appreciated!

/Hans

-----
Hans Bergsten                 	     Internet : ebuhob@ebu.ericsson.se
Ericsson Business Communications     MEMO     : ERI.EBU.EBUHOB (God forbid.)
525 N. Muller St.                    Voice    : +1 (714) 491-6264
Anaheim, CA 92803, USA               FAX      : +1 (714) 535-1789
From: loffredo@nprdc.navy.mil (Rick Loffredo)
Newsgroups: comp.databases.oracle
Subject: Force TO_CHAR to eliminate the leading blank during display
Date: 13 Oct 92 20:00:21 GMT
Reply-To: loffredo@nprdc.navy.mil (Rick Loffredo)
Distribution: usa
Organization: Navy Personnel R&D Center, San Diego

I wrote a small SQLPLUS script to convert the Oracle data to an ASCII file.
As you can see from the script, I had 1 numeric field in the table.  In 
addition, I also put out 4 '|'s as field delimiters.  QUESTION: How come there
is alwayw an extra blank preceeding the numeric field (Argument_Number), even 
though I explicitly set "space 0", and provided the TO_CHAR function with a
format of '09'.

******************
* SQLPLUS Script *
******************

spool trargs.txt
TTITLE off
set heading off
set linesize 78
set pagesize 0
set feedback off
set space 0

select  
    Function, '|',		
    TO_CHAR(Argument_Number,'09'), '|',	
    Description, '|',		
    Data_Type, '|'		
    from TRANSFORMATION_ARGUMENTS order by 1 ASC, 3 ASC;
spool off
exit

*********
*Schema *
*********

CREATE TABLE TRANSFORMATION_ARGUMENTS
(
    Function        CHAR(30) NOT NULL,
    Argument_Number NUMBER(2) NOT NULL,
    Description     CHAR(40),
    Data_Type       CHAR(1)
);

****************************
*Sample Output: TRARGS.TXT *
****************************

Are_Lists_The_Same            | 01|First generic list                      |G|
Are_Lists_The_Same            | 02|Second generic list                     |G|
Extract_Sub_List              | 01|Original generic list                   |G|
Extract_Sub_List              | 02|Index of comparison column              |I|
			      	
Newsgroups: comp.databases.oracle
From: janis@solbourne.com (Janis Griffin)
Subject: Re: renaming tables
Organization: Solbourne Computer, Inc.
Date: Thu, 15 Oct 1992 14:56:17 GMT


When you rename a table, the grants and indexes go with it.  Therefore, when
you create a new table with the same name as the old, you'll need to give new
grants and create new indexes for that table.

I've created sql scripts that read the data dictionary and re-create the 
'create index' and grant statements.  Then I do the following:

	1.  Run the 'create index' and grant scripts for the table that I'm
	    going to rename.   This produces two files with the commands to
 	    to rebuild the indexes and grants.

	2.  Rename the table.

	3.  Drop the indexes... that is, if I want to use the same names
	    for the indexes on the new table.

	4.  Create the new table with the same name as the old table.

	5.  Execute the scripts that I created from step 1.

If you have synonyms for the table, you don't need to change them as these 
do not get updated when you rename the table.   However, it's a good idea to
check them out to make sure they are working properly after the rename.


Hope this helps.

Jan Griffin, DBA 	Solbourne Computers
303-678-4331		1900 Pike Road
			Longmont, Co. 80501
From: jos@and.nl (Jos Horsmeier)
Newsgroups: comp.databases.oracle
Subject: Re: preprocessor line directives
Keywords: preprocessor,line,directive
Date: 9 Oct 92 17:29:52 GMT
Organization: AND Software BV Rotterdam

In article <900@unidoct.chemietechnik.uni-dortmund.de> pape@plato.chemietechnik.uni-dortmund.de (David Pape) writes:
|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??

Maybe, if you stick a line like this:

#line __LINE__ __FILE__

just before and just followiing the embedded SQL statements in your code
and run the C preprocessor first, before running the SQL preprocessor 
(or precompiler?) I said `maybe,' because I don't know if all SQL 
statements are valid pp-tokens for the C preprocessor ... 

I hope this works, otherwise you have to do a lot of string fiddling
yourself ...

kind regards,

Jos aka jos@and.nl
From: dave@gough.GoldCoast.co.jp (Dave Madden)
Newsgroups: comp.databases.oracle
Subject: Pro*C vs. Oracle Call Interface...
Date: 16 Oct 92 00:49:57 GMT
Organization: Gold Coast Productions, Osaka, Japan [+81]6-241-6353

Hello, world.

  I've been writing C/Oracle programs under a very old version of
Oracle for DOS (around 5.1, I think), and I found the Oracle Call
Interface routines *much* easier to use than the Pro*C preprocessor,
so that's what I've been using.  Now, though, I've moved to v6 under
Unix, and I find that the OCI routines are no longer documented in the
Pro*C manual (although they are still in the library and my programs
still work).
  My questions are, should I change my programs to use Pro*C?  Should
I write future programs using Pro*C instead of OCI?  Does anybody else
prefer OCI to Pro*C?

Thanks,
dave
==========================================================================
L = dave madden                         i don't know about your brain, = L
  = dave@gcosaka.goldcoast.co.jp        but mine is really ... bossy.  =
P =      gold coast productions                       l. anderson      = P
  =      4-2-9 kyutaro-cho 3f                                          =
F =      chuo-ku, osaka japan 541                                      = F
============[country code 81]=vox:6-241-6353=fax:6-241-0189===============
Newsgroups: comp.databases.oracle
From: twod@socrates.demon.co.uk (Ian Parkin)
Subject: Unix Environmental Variables Withim Menu 5
Distribution: world
Organization: Horrendous Happenings Ltd.
Date: Thu, 8 Oct 1992 21:21:34 +0000

Yep, time for another one of those things that has been bothering me about
Oracle ....

OK, were running Menu 5 on a unix platform ( HP, but that is not important 
right now ), and would like to access a unix environmental variable for use in 
a global variable ( i.e. to set :global.shell_type = $SHELL ).

Is there a quick solution that can be used within menus to achieve this ( i.e.
call to os_command or something similiar ). At the moment I'm think of a dummy
form and user exit !!
_______________________________________________________________________________
Ian Parkin, twod@socrates.demon.co.uk
Newsgroups: comp.databases.oracle
From: grant@erich.triumf.ca (Peter A. Grant)
Subject: Vancouver Oracle Users Group (VOUG) meeting announcement
News-Software: VAX/VMS VNEWS 1.41    
Organization: TRIUMF: Tri-University Meson Facility
Date: Wed, 7 Oct 1992 20:32:00 GMT


The next Vancouver Oracle Users Group (VOUG) meeting will be held Tuesday,
October 13, 1992 in the basement conference room of 1055 West Hastings Street,
Vancouver, BC.  The agenda is:

   5:00 - 5:30  Registration and apetizers
   5:30 - 5:35  VOUG business
   5:35 - 6:25  Tricks and Tips for Forms 3.0:  New Applications with
                an Eye to Forms 4.0
   6:25 - 6:35  Break
   6:35 - 7:25  Reports from IOUW:  What the Future Holds in Store

For further information call me at (604) 222-1047.


Peter Grant           ////////  ///////  ////////  //    //  //    //  ////////
grant@reg.triumf.ca     //     //    //     //    //    //  ///  ///  //
                       //     ///////      //    //    //  ////////  ///////
                      //     //  //       //    //    //  // // //  //
                     //     //    //  ////////  //////   //    //  //
                                               Canada's National Meson Facility
__________________________________________ _        Vancouver, British Columbia

Newsgroups: comp.databases.oracle,comp.databases,comp.infosystems
From: johnh@nnshh127.uucp (John Hawkins)
Subject: Business Objects or Ad-hoc reporting tools
Organization: Northern Telecom Inc., Nashville, TN
Date: Wed, 07 Oct 1992 14:36:14 GMT


If you are using Business Objects currently we are interested in any
feedback on platforms, front-end, problems, pluses, really anything
you have to say about the product.  We are searching for an ad-hoc
reporting tool for our current application running Oracle version 6.0   
and would like to know what is currently being used!

Note: please respond to Internet: nvjhh01@NT.COM 

-- 
John Hawkins       }) #define disclaimer(x) printf(stderr," x\n");
Northern Telecom   }) Communication: Voice 615 734 4468   /* Able was I ere */
200 Athens Way     {)                Fax   615 734 4771   /* I saw Elba     */
Nashville TN 37728 {) Internet:  nvjhh01@NT.COM           /* Columbus ~1492 */
Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: Re: Recovering ORACLE db after system crash
Organization: Colonial Mutual Group 
Date: Fri, 16 Oct 1992 00:55:00 GMT

In article <1992Oct6.225552.27031@cerberus.bhpese.oz.au>,
brad@cerberus.bhpese.oz.au (Brad Keifer) writes:
> 
.
.
> Using SQLDBA to look at the rollback segments table indicated that one of
> the rollback segments had a status of "NEEDS RECOVERY".
> I couldn't drop the table because ORACLE told me to put it offline, I 
> couldn't alter it offline either, neither could I recover tablespace
> "rollback_segment".
> 
> In the end we were desperate so we restored from tape.
> 
> What should I have done?

There is an undocumented init.ora parameter that will help you.  I am not
exactly sure of its name but I think it is '_OFFLINE_ROLLBACK_SEGMENT'.  

What it does is force the DBMS to ignore or offlines the RBS.  This
would have saved you the trouble of recovering the DB.

Warning: Seek Oracle support before using any '_init_ora_parameter'.

tony

-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
 ______  /                   |PHONE:  +61-3-6076448
       \/                    |  FAX:  +61-3-6076198

-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
Newsgroups: comp.databases.oracle
From: colten@cbnewsb.cb.att.com (marc.colten)
Subject: Trigger problem in Form3.0
Keywords: Trigger, LOV, restricted procedures
Organization: AT&T
Date: Tue, 13 Oct 1992 13:58:22 GMT



I need some advice on a problem I'm having with triggers.

Basically what I am trying to do is call up a LOV without
the F6 key.  My idea was to create a one character field and
execute LIST_VALUES(NO_RESTRICT); if they go to that field and
enter a "Y".  The problem is LIST_VALUES is so restricted you
practically can't use it - except with ON-NEW-FIELD-INSTANCE and
they is wrong for me.  I tried POST-CHANGE and it rejected.

I tried "KEY-F1" and that didn't take and then I had the most
horrifying experience.  I tried "KEY-OTHERS" because the book said
that this would activate when I pressed a key "that could have
a function but didn't".  Great, I thought, I'll use this trigger
and when I press F1 (which tells me it's unassigned) it will work.

Well - F1 didn't activate the trigger (it still said "unassigned")
but every other function did!  Include "quit" from the button menu.
I couldn't get out of the form.  Whenever I chose quit or anything
else it attempted to bring up a LOV for the field I was in.  I
went to another window and killed the process - but the form wouldn't die!
It was still up  and running an LOV if I tried quit.

Does anyone know a way I can do this? I see that forms has "buttons" and
"check" items, but does not provide them for our use.  Please e-mail
any ideas as I don't get on here as much as I like.


thanks

marc colten

Newsgroups: comp.databases.oracle
From: heijink@athena.research.ptt.nl (Heijink R.J.)
Subject: Re: preprocessor line directives
Keywords: preprocessor,line,directive
Organization: PTT Research
Date: Mon, 12 Oct 1992 07:47:37 GMT

jos@and.nl (Jos Horsmeier) writes:

>In article <900@unidoct.chemietechnik.uni-dortmund.de> pape@plato.chemietechnik.uni-dortmund.de (David Pape) writes:
>|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??

>Maybe, if you stick a line like this:

>#line __LINE__ __FILE__

>just before and just followiing the embedded SQL statements in your code
>and run the C preprocessor first, before running the SQL preprocessor 
>(or precompiler?) I said `maybe,' because I don't know if all SQL 
>statements are valid pp-tokens for the C preprocessor ... 

This depends on the C preprocessor you use. You should be aware of
a number of problems:

1. PRO*C allows only a limited record length for input. Some C
macros are expanded to very long lines.

2. #define directives may interfere with SQL reserved words. The
best known example is NULL.

I tried the trick with two different C preprocessors. gcc works
fine in most cases, the VAX vcc preprocessor does not accept
constructs like 'abcdef', which are used in SQL. It says that a
character constant must consist of only one character.

There is one safe solution: write your own preprocessor to do all
actions you want and nothing else.

Purchase of PRO*C 2.0 may also be a good choice, since it has a C
like proprocessor built in, but I have no
experience with this product.
>I hope this works, otherwise you have to do a lot of string fiddling
>yourself ...

>kind regards,

>Jos aka jos@and.nl
-- 
Rudolf J. Heijink               phone : +31 70 332 5709
PTT Research POB 421            fax   : +31 70 332 6477
2260 AK  Leidchsendam  E-Mail: R.J.Heijink@research.ptt.nl (internet)
Netherlands                     
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Oracle Application Standards
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Thu, 15 Oct 1992 16:09:00 GMT

stroup@grove.ops.lmsc.lockheed.com () writes:
>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

Naming standards -- I try to name objects in a consistent fashion.
For example, a unique three character prefix for each application
in front of each table name.  Indexes are named for the object
and columns upon which they are based.  Constraints are named based
on the column/table and function (pk, fk, unique, check, etc).
ALL object names are constrained to 18 characters where absolutely
possible and to 27 otherwise because of the prefix.  NO public
synonyms for security reasons, but always named for the table
upon which they are based.
ZZ

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