| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> File: "ORACLE-L LOG9405"
Date: Mon, 2 May 1994 08:35:51 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Beverly Norwood <csvbcn_at_ADMIN.AC.EDU>
Subject: Re: Master/Detail Forms40
In-Reply-To: <9404292138.AA56923_at_admin.ac.edu>; from "Tom Coker" at Apr 29,
94 4:34 pm
Tom,
Even though the master-detail "hooks" are there in the field information, there are procedures which must exist and be called from the block navigational triggers to actually perform the detail blocks query. If these are Oracle case-generated forms, these procedures should be there. If they are not and the procedures do not exist, I could send an example if it would help.
>
> A collegue of mine is having problems with master detail relationships
> in Forms 4.0. Here is what she would like to ask:
>
>
>
> I am currently working on a form that contains three different blocks.
> 1- the key-block, 2- the maintenance block 3- and maintenance2 block
>
> The key block is the master block, making the other two blocks the
> detail blocks.
>
> I related the blocks using Forms 4.0 master-detail relationship, which
> created the necessary triggers and PL/SQL statements.
>
> The problem is when I do a query from the Key-block, the detail blocks
> do not retrieve the detail blocks data.
>
> The key block information is in table 1. The maintenance Block information
> is in table 2. And the maintenance2 block information is in table 3.
>
> There is data in the tables that relates the blocks together.
>
> Does anyone have any idea why this wouldn't work????? Any tips will be
> appreciated.
>
>
>
> --
> _______ | Tom Coker, Sr. Programmer/Analyst
> /_ __ ___ | SCT Public Sector, Lexington, KY
> /(_)//( / _ /_/_ _ | EMAIL: tcoker_at_sctcorp.com
> _________ /___(_)/ \(-'/ | PHONE: (606) 231-0519
> /_________________ | FAX..: (606) 253-2142
>
Beverly Norwood, Systems Manager
Augusta College
(706) 737-1484 or GIST 337-1484
Internet: bnorwood_at_admin.ac.edu
Date: Mon, 2 May 1994 10:39:13 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Richard K Hooper <HOOPER_at_UBVM.BITNET> Subject: Unknown objects
I've been attempting to execute the CATBLOCK script which creates the DBA_LOCKS, DBA_DML_LOCKS, DBA_DDL_LOCKS, DBA_WAITERS and DBA_BLOCKERS views. This script fails due to "ORA-00942: table or view does not exist" on objects x$kgllk, x$kglpn, and x$kglob. Does anyone know what these objects are and how to create them?
Thanks,
Dick H.
Date: Mon, 2 May 1994 12:02:54 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: TOM MERCADANTE <MERCADTF_at_SNYPLAVA.BITNET> Organization: SUNY at Plattsburgh, New York, USA Subject: Re: Unknown objects
Date sent: 2-MAY-1994 12:00:50
Dick,
These tables exists under the SYS user. I am guessing that you are attempting to run the scripts under another user.
Run the script through SQLDBA connect internal command, and you should be fine.
Tom
>I've been attempting to execute the CATBLOCK script which creates the
>DBA_LOCKS, DBA_DML_LOCKS, DBA_DDL_LOCKS, DBA_WAITERS and DBA_BLOCKERS
>views. This script fails due to "ORA-00942: table or view does not exist"
>on objects x$kgllk, x$kglpn, and x$kglob. Does anyone know what these
>objects are and how to create them?
>
>Thanks,
>Dick H.
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % % % Tom Mercadante % % Database Administrator % % SUNY Plattsburgh % % % % BITNET : MERCADTF_at_SNYPLAVB.BITNET % % INTERNET : MERCADTF_at_SPLAVA.CC.PLATTSBURGH.EDU Computer Systems Center % % PHONE : (518)564-3013 Kehoe 507 % % Plattsburgh, NY 12901 % % % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ========================================================================= Date: Mon, 2 May 1994 09:40:31 U Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "McShane, John P" <mcshane_at_MDAW.MDC.COM> Subject: Re: Unknown objects
I think they are hiden tables within Oracle. Are you running the script as 'SYS'?
I've been attempting to execute the CATBLOCK script which creates the DBA_LOCKS, DBA_DML_LOCKS, DBA_DDL_LOCKS, DBA_WAITERS and DBA_BLOCKERS views. This script fails due to "ORA-00942: table or view does not exist" on objects x$kgllk, x$kglpn, and x$kglob. Does anyone know what these objects are and how to create them?
Thanks,
Dick H.
We are a site using Oracle Client/Server v 7 running on Sparc 10 Solaris 4.1. Our applications front end is Oracle's text based SQL*forms v 3.0. We intend to move to a Graphical User Interface (GUI) front end running under Windows 3.1. We were considering a number of GUI front end tools such as Visual Basic v 3.0, Power Builder v 3.0, Object View v 3.0 from Knowledgeware, and of course Orcale's expensive proprietary CDE tools (SQL*forms v 4.0 etc).
The question remains, did any of you use any of the previously mentioned products to develop Oracle databases? If so please forward the pros and cons of your GUI front end tool for your Oracle back end RDBMS server. Please emphasis criterias such as ease of use, application development time, license per end user, cost, also other relevant recommendations from your experience.
Thank You.
Hani Atalla
E-Mail HATALLA_at_USAID.GOV
Date: Tue, 3 May 1994 08:19:14 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Pat Foley <pfoley_at_GTEC3.NDHM.GTEGSC.COM> Subject: Re: canned oracle installations
>I would like to set up an installation script for
>performing canned (not default) oracle7 installations
>in batch. According to the docs and Oracle Support,
>there is no way to do this with the current Oracle
>Installer.
>Apparently, the best I can do with the Installer is to
>copy a file with my preferred responses into
>$ORACLE_HOME/orainst/usrdfl.log. Then, when I run the
>Installer (even the first time), I will get my preferred
>responses as defaults instead of the Oracle defaults.
>Has anyone else out there tried to do something similar?
>Any ideas or suggestions?
>Thanks in advance,
>Tony DiPesa
>MIT/OFMS
>P.S. I'm using v7.0.15 of the rdbms and v3.0.9 of orainst
>on solaris 2.3.
Oracle has had a number of requests for this capability.
There was a group at Oracle that had been working on it, but it was shelved for a number of reasons. As of 2 weeks ago, according to my source, this work as been reactivated.
Pat
pfoley_at_gtec3.ndhm.gtegsc.com
(617) 455-5629
Date: Tue, 3 May 1994 09:44:29 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Julie R. McLain-Harper" <julie_r_mclain-harper_at_MILACRON.COM> Subject: Export / fetched column truncated System: HP9000 series 800
I have exported this table successfully with size 4096 using Export version 6.0.37.0.1, with Oracle 6.0.37 database. I am exporting other tables with no trouble using this same 7.0 release.
Can anyone give me some ideas on how to accomplish my export, either by using a different array buffer size or changing some init.ora parameter?
Thanks -
Julie R. McLain-Harper
Cincinnati Milacron Products Division - DBA
julie_r_mclain-harper_at_milacron.com
Date: Tue, 3 May 1994 10:25:08 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Dave Gardner - TCC X4-3007 <GARDNER_DM_at_CORNING.COM> Subject: Re: Oracle GUI Front End Tool
Hani,
I have played with VisualBasic using OracleGlue and PowerBuilder. I have also done some playing with ObjectView. Our I/S group has chosen PowerBuilder and Oracle7 as standards within our Organization. Iwork in a group that supports R&D. We will be following I/S's guidelines. I recently finished PowerBuilder training. VisualBasic is a little easier to learn, make that a lot easier to learn. PowerBuilder has a steep learning curve. It is a great product, just takes time to learn it. PowerBuilder and VisualBasic both have free runtime deployment. OracleGlue also has free runtime deployment, it should for $3000. Bottom line, cost is similar, VisualBasic is easier to use but in the long run PowerBuilder is a more robust tool. You won't have PowerBuilder applications built real fast at first. Once the programmers get in the swing of things the reusabilty of the objects will increase productivity. I think ObjectView falls in the same category as PowerBuilder and may be a little easier to learn.
Dave Gardner
CORNING Inc.
GARDNER_DM_at_CORNING.COM
Date: Tue, 3 May 1994 13:42:12 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Karl Campbell <kcampbel_at_BAOSC.COM> Subject: Re: Export / fetched column truncated
Julia,
I am not sure why the error is happening but I suggest increasing the buffer size. According to Oracle (for whatever its worth), available memory is the only constraint.
We have been successful in using buffer=300000000 (approx 300MB) to perform an entire export of a 14 GB Version 6.0.36 database on a Pyramid MIS12 (6 cpu, 768MB total memory). The same goes for import buffer size (but for very large tables, set commit=y, with a buffer size <= the largest rollback segment so that the import does not run out of rollback space).
Try it and let me know if increasing the buffer size works.
Karl Campbell
Oracle Database Administration Group
Bell Atlantic Information Systems
11700 Beltsville Drive, Suite 600
Beltsville, MD 20705
Internet: kcampbel_at_baosc.com
Telephone: (301)-595-2117
>From owner-oracle-l_at_CCVM.SUNYSB.EDU Tue May 3 11:30:22 1994
>Date: Tue, 3 May 1994 09:44:29 EDT
>Reply-To: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu>
>Sender: "ORACLE database mailing list." <ORACLE-L@CCVM.sunysb.edu>
>From: "Julie R. McLain-Harper" <julie_r_mclain-harper_at_MILACRON.COM>
>Subject: Export / fetched column truncated
>X-To: oracle-l_at_CCVM.sunysb.edu
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.sunysb.edu>
>Content-Length: 1080
>
>System: HP9000 series 800
>Oracle: 7.0.15
>Export: 7.0.15.4.0
>While attempting to export a table with a possible longest length of 621
>characters, I am receiving the error message "ORA 1406 - fetched column
>value was truncated". My default array buffer size that comes up in the
>export is 4096 - the Oracle block size that I have set up the database
>to be. The DBA Admin guide says that if you have a very long row length,
>set the array size to 0 and 1 row at a time will be fetched; however, when
>I try to enter 0 during the export, it doesn't seem to take it (the export
>just re-displays the Enter Array Buffer Size (4096)).
>
>I have exported this table successfully with size 4096 using Export
>version 6.0.37.0.1, with Oracle 6.0.37 database. I am exporting other
>tables with no trouble using this same 7.0 release.
>
>Can anyone give me some ideas on how to accomplish my export, either by
>using a different array buffer size or changing some init.ora parameter?
>
>Thanks -
>Julie R. McLain-Harper
>Cincinnati Milacron Products Division - DBA
>julie_r_mclain-harper_at_milacron.com
>
Date: Tue, 3 May 1994 16:02:59 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Richard K Hooper <HOOPER_at_UBVM.BITNET> Subject: Re: Unknown objects
You were right, running the CATBLOCK script under user SYS worked.
Thanks again,
Dick H.
Date: Tue, 3 May 1994 16:48:57 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Chuck Hasenauer <CHUCK_at_JHUDEV.DEV.JHU.EDU> Subject: Oracle App Development and DEC Tools
Does anyone out there have experience managing a moderate to large Oracle Application (Forms 3.0/Menu 5.0) using DEC CMS and MMS utilities? Care to share your wisdom?
Chuck Hasenauer
Johns Hopkins University
chuck_at_jhudev.dev.jhu.edu
Date: Wed, 4 May 1994 08:27:53 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Bob Belt <bbelt_at_SCTLRS2.SCTCORP.COM> Subject: More on Master/Detail in Forms40
Believe we found the cause of the problem that Tom Coker reported last week. We were using CHAR datatype for some index columns. After switching to VARCHAR2 datatype, the retrieval problem disappeared.
Also got note from Oracle tech support about a workaround using rpad on the query columns. We found out couple weeks back that Forms 40 uses non-padded comparison semantics for all queries - for backward compatibility.
We had used the rpad but code gets bit cumbersome and adds to form size.
FYI - you can duplicate our problem with the EMP and BONUS tables by changing ENAME to CHAR in both and setting up a master/detail relation in Forms40. Use DEPT with no changes.
--
+---------------------------------------------------------------+
| Bob Belt |
| SCT Public Sector e-mail: bbelt_at_sctcorp.com |
| 1733 Harrodsburg Road phone: (606) 277-1500 |
| Lexington, KY 40504-3617 fax: (606) 277-2300 |
+---------------------------------------------------------------+
=========================================================================
Date: Wed, 4 May 1994 07:38:43 U
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Steve Quigley <squigley_at_SCTCORP.COM>
Subject: None
None
Any info would be appreciated.
Steve Quigley
squigley_at_sctcorp.com
Date: Wed, 4 May 1994 07:48:27 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: TOM MERCADANTE <MERCADTF_at_SNYPLAVA.BITNET> Organization: SUNY at Plattsburgh, New York, USA Subject: Re: Oracle App Development and DEC Tools
Date sent: 4-MAY-1994 07:45:26
Chuck,
We are using the DEC CMS utility for storage and control of our application library. We store Forms3.0, SQR programs, COM files etc. within the library and reserve/replace elements via an internal Application Maintenance Form.
We have had absolutely zero problems with the CMS software. It has great capability for tracking changes, and being able to retrieve previous versions of the application.
If you want more detailed info concerning how we use it, please feel free to contact me either by E-MAIL or phone.
Tom
>
>Does anyone out there have experience managing a moderate
>to large Oracle Application (Forms 3.0/Menu 5.0) using DEC
>CMS and MMS utilities? Care to share your wisdom?
>
>Chuck Hasenauer
>Johns Hopkins University
>chuck_at_jhudev.dev.jhu.edu
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % % % Tom Mercadante % % Database Administrator % % SUNY Plattsburgh % % % % BITNET : MERCADTF_at_SNYPLAVB.BITNET % % INTERNET : MERCADTF_at_SPLAVA.CC.PLATTSBURGH.EDU Computer Systems Center % % PHONE : (518)564-3013 Kehoe 507 % % Plattsburgh, NY 12901 % % % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ========================================================================= Date: Wed, 4 May 1994 14:18:17 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Lester Welch <WELCHL_at_EPNMV1.NCIFCRF.GOV> Subject: sql*net 1.2.9.8 exist or not?
I'm getting conflicting stories about what is supposed to cure the latest sql*net bug at my site. One story has it that 1.2.9.8 will cure it. Some in ORACLE haven't heard of this version.
Any of you have it on ANY platform? If yes - please let me know.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Lester C. Welch 301-846-5282 | | WELCHL_at_EPNMV1.NCIFCRF.GOV |-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Date: Wed, 4 May 1994 14:21:13 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Bob Belt <bbelt_at_SCTLRS2.SCTCORP.COM> Subject: More on Master/Detail in Forms40
Believe we found the cause of the problem that Tom Coker reported 4/29. we were using CHAR datatypes for some index columns. After switching to VARCHAR2 datatypes, the retrieval problem disappeared.
Also got a note from Oracle tech support about a workaround using rpad on the query columns. We found out couple weeks back that Forms40 uses non-padded comparison semantics for all queries - for backward compatibility.
We had used the rpad but code gets bit cumbersome and adds to the form size.
FYI - you can duplicate our problem with the EMP and BONUS tables by changing the ENAME datatype to CHAR in both and setting up a master/detail relationship in Forms40.
--
+---------------------------------------------------------------+
| Bob Belt |
| SCT Public Sector e-mail: bbelt_at_sctcorp.com |
| 1733 Harrodsburg Road phone: (606) 277-1500 |
| Lexington, KY 40504-3617 fax: (606) 277-2300 |
+---------------------------------------------------------------+
=========================================================================
Date: Wed, 4 May 1994 14:39:20 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Chad A. Tompkins" <tompkinc_at_SPACENET.COM>
Subject: Re: None
In-Reply-To: <9405041624.AA10972_at_uu5.psi.com>; from "Steve Quigley" at May 4,
94 7:38 am
> Forms 4.0 questions:
> 1) Can procedure calls be built and called dynamically?
> 2) If you are currently developing in a client/server environment, what
> mechanisms are you using for version control, access control, searching
> (through the modules)?
> 3) What problems have you found with libraries, if any?
>
> Any info would be appreciated.
>
> Steve Quigley
> squigley_at_sctcorp.com
You can create procedures and functions in any pl/sql block. I think these procedures have to be defined before generation. We found it disappointing that Forms 4 doesn't support PL/SQL v2 which includes support for packaged procedures in the database, geometric functions, and many of the neater aspects of Oracle7.
There isn't much support for versioning. You can save the files as ASCII and use any normal versioning software, but the ASCII file is not supposed to be converted back to binary.
The database stored libraries seem to work well. We use a common library for routines common to all our applications and an application library for each application's forms. Eventually these are generated to the file system, but given the non-dynamic nature of libraries, this has not been a big deal.
FYI. --
Chad A. Tompkins, Programmer II GTE Spacenet Voice : 703-848-0121 1700 Old Meadow Road Internet: tompkinc_at_spacenet.com McLean, Va 22102 U.S.A. ========================================================================= Date: Wed, 4 May 1994 14:21:23 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Brian Turcotte <brian.turcotte_at_SFWMD.GOV> Subject: Pro*Fortran 1.5 and Oracle7
Help me please. Here's the scenario:
We have a Pro*Fortran 1.5 program that ran with Oracle 6 under SunOS.
The program declared a host variable as CHARACTER*8.
i.e. .. .. ..
.. .. ..
Brian Turcotte
brian.turcotte_at_sfwmd.gov
Reply to: RE>>None
The release notes talk about a FORMS_DDL built in which is supposed to be able
to handle the execution of dynamic pl/sql (thanks to one of my co-workers who
pointed me in that direction). Problem is, I have been unsuccessful in
implementing it. The only results I can uncover is an ERROR_CODE of '-0'.
Also, anthor of my co-workers has in fact generated the fmt file, modified it
and converted it back to an fmb. Not highly recommended. Prior to 4.0.12 I
could not get that to work.
Steve Quigley
squigley_at_sctcorp.com
Received: by smtpgw.sctcorp.com with SMTP;4 May 1994 16:31:25 U Received: from by sctsun9.sctcorp.com (4.1/3.1.090690-Systems & Computer Technology)
id AB27342; Wed, 4 May 94 16:26:26 EDT Message-Id: <9405042026.AB27342_at_sctsun9.sctcorp.com> Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2)
with BSMTP id 5990; Wed, 04 May 94 14:54:38 EDT Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 3347; Wed, 4 May 1994 14:54:16 -0400 Date: Wed, 4 May 1994 14:39:20 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> Sender: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> From: "Chad A. Tompkins" <tompkinc_at_SPACENET.COM>
Subject: Re: None X-To: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.sunysb.edu> In-Reply-To: <9405041624.AA10972_at_uu5.psi.com>; from "Steve Quigley" at May 4,
94 7:38 am
> Forms 4.0 questions:
> 1) Can procedure calls be built and called dynamically?
> 2) If you are currently developing in a client/server environment, what
> mechanisms are you using for version control, access control, searching
> (through the modules)?
> 3) What problems have you found with libraries, if any?
>
> Any info would be appreciated.
>
> Steve Quigley
> squigley_at_sctcorp.com
You can create procedures and functions in any pl/sql block. I think these procedures have to be defined before generation. We found it disappointing that Forms 4 doesn't support PL/SQL v2 which includes support for packaged procedures in the database, geometric functions, and many of the neater aspects of Oracle7.
There isn't much support for versioning. You can save the files as ASCII and use any normal versioning software, but the ASCII file is not supposed to be converted back to binary.
The database stored libraries seem to work well. We use a common library for routines common to all our applications and an application library for each application's forms. Eventually these are generated to the file system, but given the non-dynamic nature of libraries, this has not been a big deal.
FYI. --
Chad A. Tompkins, Programmer II GTE Spacenet Voice : 703-848-0121 1700 Old Meadow Road Internet: tompkinc_at_spacenet.com McLean, Va 22102 U.S.A. ========================================================================= Date: Wed, 4 May 1994 15:09:58 U Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "McShane, John P" <mcshane_at_MDAW.MDC.COM> Subject: Re: Pro*Fortran 1.5 and Oracle7
Try inserting a first statement 'Set Compatibility V6' before the rest of your statements?
Help me please. Here's the scenario:
We have a Pro*Fortran 1.5 program that ran with Oracle 6 under SunOS.
The program declared a host variable as CHARACTER*8.
i.e. .. .. ..
.. .. ..
Brian Turcotte
brian.turcotte_at_sfwmd.gov
I am running a form under ver 2.3. Tring to use the CASE to call different forms from the menu. I have the following in a KEY-ENTER trigger. But I get an error: IAXMAC: MISSING ARGUMENT FOR FUNCTION CODE. But tossed all my old 2.3 manuals. I don't remember the syntax. Can anybody give me an example or correct the following. Thanks. #exemacro CASE CHOICEFLD IS WHEN '1' THEN CALL 'FORMNO1';
WHEN '2' THEN CALL 'FORMNO2';
END CASE;
Date: Thu, 5 May 1994 07:55:38 MDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gary Wood <GWOOD_at_REGISTRAR.UALBERTA.CA> Organization: Office of the Registrar, U of A Subject: Re: Pro*Fortran 1.5 and Oracle7
We also ran into a similar scenario on development that I was doing in Oman, and the easiest way to get around the problem was to reassign all VARCHAR data to itself, and in this fashion ORACLE7 automatically RTRIM'ed the data, and thus cleared up the indicated problem.
> Date: Wed, 4 May 1994 14:21:23 EDT
> Reply-to: "ORACLE database mailing list."
<ORACLE-L_at_CCVM.sunysb.edu>
> From: Brian Turcotte <brian.turcotte_at_SFWMD.GOV>
> Subject: Pro*Fortran 1.5 and Oracle7
> X-To: ORACLE-L_at_CCVM.sunysb.edu
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_CCVM.sunysb.edu>
> Help me please. Here's the scenario:
> We have a Pro*Fortran 1.5 program that ran with Oracle 6 under
SunOS.
> The program declared a host variable as CHARACTER*8.
> i.e.
> ..
> ..
> ..
> EXEC SQL BEGIN DECLARE SECTION
> STATION_ID CHARACTER*8
> EXEC SQL END DECLARE SECTION
> ..
> ..
> ..
> The program referenced a column STATION_ID CHAR(8).
> The program now references a column STATION_ID VARCHAR2(8)
> in the Oracle 7 database.
> We now have gone to Oracle 7 and Solaris 2.3 .
> There is a runtime error in the way blank padding is
> handled. The Precompiler supplement gives examples of
> changing the host variable declarations to VARCHAR and
> adding new variables for the length and array for each variable.
> Alternately, we could RTRIM every host variable in each SQL
> statement. We've also tinkered with the mode=ANSI|ORACLE
> on the precompiler. Is there any solution that anybody
> is aware of so we don't have massive code changes. We don't
> want to declare our database variable length strings as CHAR under
> Oracle7 because we would be wasting a lot of space.
>
> Brian Turcotte
> brian.turcotte_at_sfwmd.gov
>
>
> ----- End Included Message -----
>
Gary T Wood
Systems Analyst, Information Systems
Office of the Registrar
University of Alberta
Telephone: Office (403) 492-3372
Home (403) 430-8289
Fax (403) 492-7172
Date: Thu, 5 May 1994 10:35:02 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Luke Lau <llau_at_COMINCO.MHS.COMPUSERVE.COM> Subject: Pro*Fortran 1.5 and Oracle7 -Reply
Brian,
If the error you are getting has to do with the fetched value being null, then the following is what we did to overcome the problem without changing our source programs nor changing the database structure.
We don't use Pro*Fortran, but we do use Pro*C and Pro*COBOL. By using the "DBMS=V6" switch with the pre-compiler command, the problem seems to have disappeared. If you don't use this switch, you'll have to modify your programs to use indicator variables. We did not choose this option (don't want to modify programs). See your pre-compiler user's guide.
I hope this helps.
Luke Lau
Systems Analyst
Cominco Fertilizers Ltd.
Calgary, Alberta
T2W 3X6
Canada
Phone: (403) 258-5702
Fax: (403) 258-5700
e-mail: llau_at_cominco.mhs.compuserve.com
Date: Thu, 5 May 1994 10:46:02 U
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Chris Insley <Chris_Insley_at_CATS.NAVY.MIL>
Subject: Re: CASE command
RE>CASE command
Then we would use the global in the EXEMACRO stmt.
Step 2:
#exemacro CASE CHOICEFLD IS WHEN '1' THEN CALL &GLOBAL.FORMNAME1;
WHEN '2' THEN CALL &GLOBAL.FORMNAME1;
END CASE;
WHEN '2' THEN CALL 'FORMNO2';
END CASE;
Date: Thu, 5 May 1994 11:00:13 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Ken Parsons <kparsons_at_COMINCO.MHS.COMPUSERVE.COM> Subject: Legent's ACE*Insight Package
We are currently evaluating Lecent's ACE*Insight package. (It scans
source code for SQL*Forms, SQL*Plus, SQR, etc. and produces reports
about the SQL statements contained in the source code.) Does anybody
have any comments about their experience with this package? Thanks
in advance.
Regards,
Ken Parsons (403)258-5712
Data Administrator
Cominco Fertilizers Ltd.
Calgary, Alberta, Canada
CompuServe: mhs:kparsons_at_cominco
Date: Thu, 5 May 1994 14:10:00 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Teri Perrell <Teri.Perrell%dp-06_at_MAILGW.ER.DOE.GOV> Subject: Re: CASE command
Message authorized by:
: ?PZD_at_PCCJES2.BITNET_at_internet at X400PO
We converted to 3.0 sometime ago, but I remember that we, as
a rule, always qualified a varible as Block.Varible. Try
putting the block name before the ChoiceFld. Hope that
works.
Teri Perrell
Dept. of Energy
______________________________ Reply Separator _________________________________
Subject: CASE command
I am running a form under ver 2.3. Tring to use the CASE to call different forms from the menu. I have the following in a KEY-ENTER trigger. But I get an error: IAXMAC: MISSING ARGUMENT FOR FUNCTION CODE. But tossed all my old 2.3 manuals. I don't remember the syntax. Can anybody give me an example or correct the following. Thanks. #exemacro CASE CHOICEFLD IS WHEN '1' THEN CALL 'FORMNO1';
WHEN '2' THEN CALL 'FORMNO2';
END CASE;
Date: Thu, 5 May 1994 12:28:43 U Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "McShane, John P" <mcshane_at_MDAW.MDC.COM> Subject: PC Client Config
What is a good PC hardware configuration for an Oracle Client
(with FormsV4, etc) connected to a Vax Server
using either a Lan gateway or ethernet?
John McShane MDA-West
Huntington Beach, CA
mcshane_at_mdaw.mdc.com
Date: Thu, 5 May 1994 13:39:34 MDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Bob OConnor <boconnor_at_VINES.COLOSTATE.EDU> Subject: Version 7 trigger info request
Is anyone aware of a Version 7 trigger, package, procedure or mechanism that can be fired when a user disconnects from the instance, either normally or abnormally?
Please reply to me at the address below.
Thanks,
Bob O'Connor
System Administrator/DBA
Colorado State University
Information Systems
Internet: boconnor_at_vines.colostate.edu _ _ ___ __o Phone: (303)491-5916 _ _ __ _ \<_ Fax: (303)4911958 ____ (_)/(_)____ ========================================================================= Date: Thu, 5 May 1994 14:13:18 -0600 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Scott Fehr <scottf_at_APLDSS.APL.CUL.CA> Subject: FRM-30096 Error
I am getting the following error when trying to compile a v3 SQL*Form:
FRM-30096 Couldn't create form output file lpsfac99.inp
Form not created
We are running on SUN OS (Oracle v7.0.15) and the file and directory permissions all look fine. When I rename the inp file to something else, say test.inp, it compiles fine.
Anyone have any ideas?
Thanks in advance
Scott Fehr
Alberta Power Limited.
Edmonton, AB
CANADA
scottf_at_apldss.apl.cul.ca
Date: Thu, 5 May 1994 17:47:55 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Leonardo Fernandez <lfernand_at_ve.oracle.com>"
<lfernand_at_VE.ORACLE.COM>
Subject: Re: CASE command
In-Reply-To: VESUN1:owner-oracle-l_at_CCVM.SUNYSB.EDU's message of 05-05-94 09:16
Hi pattu,
I have few tips for you ....
I Suggest that you put the name of the path and the form into a field,
And then use:
#exemacro call &field
Other things are :
Do not use '' for the name of the form.
You should use call
#exemacro call name_of_form (without '').
Do you have '_' caracter in the name of the form ?
remove it and try again.
Tecrep extracted
Good luck
Leonardo Fernandez
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
Received: 05-05-94 12:22 Sent: 05-05-94 09:16From: VESUN1:owner-oracle-l_at_CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L ORACLE-L_at_CCVM.SUNYSB.EDU Subject: CASE command
I am running a form under ver 2.3. Tring to use the CASE to call different forms from the menu. I have the following in a KEY-ENTER trigger. But I get an error: IAXMAC: MISSING ARGUMENT FOR FUNCTION CODE. But tossed all my old 2.3 manuals. I don't remember the syntax. Can anybody give me an example or correct the following. Thanks. #exemacro CASE CHOICEFLD IS WHEN '1' THEN CALL 'FORMNO1';
WHEN '2' THEN CALL 'FORMNO2';
END CASE;
Date: Thu, 5 May 1994 15:00:27 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Tim <tnfraser_at_CSUPOMONA.EDU> Subject: Re: Version 7 trigger info request
Bob,
I'm not aware of any ORACLE-provided triggers that will serve your needs. How about writing your own trigger? You could base your trigger off of the system audit trail.
Hope this helps
Tim Fraser
DBA
California State Polytechnic University
Pomona, California
Date: Fri, 6 May 1994 12:09:36 +0200 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Kevin Jonhson Serco DPE/IO <Kevin.Johnson_at_MAIL.ESRIN.ESA.IT> Subject: Configuring SOLARIS 2.2 for ORACLE 7.0.15.4.0
Is anyone running multiple ORACLE databases on a similar configuration to this :
HARDWARE : SUN SPARCSERVER 1000
1 PROCESSOR
32Mb MEMORY
100Mb SWAP SPACE
Many GB's of disk space
SOFTWARE : Solaris 2.2
ORACLE 7.0.15.4.0
If so, what are your configurations for :
Shared Memory
Semaphores
ORACLE initialisation (init.ora) parameters
The ORACLE ICG for ORACLE 7.0.13 on Solaris 2.2 just says
"THE (kernel and shared memory) PARAMETERS THAT INTERACT WITH ORACLE ARE
SHOWN IN THE FOLLOWING TABLE WITH THEIR RECOMMENDED VALUES"
However, the table only mentions the number of ORACLE processes with
regard to the number of semaphores in a set. All the other parameters
are constants. Does this mean :
(a) The constants are correct, regardless on how many instances
will be running, and how they are configured (init.ora params). (b) The constants are sufficiently high to cope with as many
databases/instances as anyone is ever likely to need,
regardless on instance size.
(c) These are the values needed to create a database during
installation and they will need to be changed for
multiple instances of different sizes
(if so, what determines their values).
(d) Anything else ????
We tried starting a second instance, and the system crashed, (maybe just coincidence) hence my preference to obtain more information, rather than just experimenting.
Thanks in advance for any help, Kevin.
Kevin Johnson EMAIL : johnson_at_mail.esrin.esa.it
Information Administrator
European Space Agency DISCLAIMER : These views are mine
ESRIN, FRASCATI, ITALIA. and are not based on
anyone else's tables.
======================================================================
=========================================================================
Date: Fri, 6 May 1994 11:45:40 BST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Peter Hill <peteh_at_DBADMIN3.AMGEN.COM>
Subject: Re: Configuring SOLARIS 2.2 for ORACLE 7.0.15.4.0
I seem to remember that you need 50 semaphores per instance under Unix.
We are running ORACLE7.0.14 on SunOs 4.1.3.
Date: Fri, 6 May 1994 07:26:46 U
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Steve Quigley <squigley_at_SCTCORP.COM>
Subject: Re: FRM-30096 Error
Reply to: RE>FRM-30096 Error
Received: by smtpgw.sctcorp.com with SMTP;5 May 1994 18:32:23 U Received: from CCVM.sunysb.edu (ccvm.cc.sunysb.edu) by sctsun9.sctcorp.com (4.1/3.1.090690-Systems & Computer Technology)
id AA05374; Thu, 5 May 94 18:27:05 EDT Message-Id: <9405052227.AA05374_at_sctsun9.sctcorp.com> Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2)
with BSMTP id 8675; Thu, 05 May 94 16:20:41 EDT Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 2355; Thu, 5 May 1994 16:20:29 -0400 Date: Thu, 5 May 1994 14:13:18 -0600 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> Sender: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> From: Scott Fehr <scottf_at_APLDSS.APL.CUL.CA>
Subject: FRM-30096 Error X-To: ORACLE-L_at_CCVM.SUNYSB.EDU
I am getting the following error when trying to compile a v3 SQL*Form:
FRM-30096 Couldn't create form output file lpsfac99.inp
Form not created
We are running on SUN OS (Oracle v7.0.15) and the file and directory
permissions
all look fine. When I rename the inp file to something else, say test.inp,
it compiles fine.
Anyone have any ideas?
Thanks in advance
Scott Fehr
Alberta Power Limited.
Edmonton, AB
CANADA
scottf_at_apldss.apl.cul.ca
Date: Fri, 6 May 1994 09:33:35 -0300 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Michael W. Bates" <mbates_at_SCTCORP.COM> Subject: Re: Configuring SOLARIS 2.2 for ORACLE 7.0.15.4.0In-Reply-To: <9405061155.AA06329_at_sctsun9.sctcorp.com>
Actually, what I have seen documented and in practice is that you need a semaphore for each prcess defined for to the Oracle Instance. If you have process=50 you need 50 semaphores.
I normally set semaphores per semaphore set to 20
semaphore sets to 20
total semaphores to 400
and set oracle processes a multiple of 20 in the init.ora. As
I add instances I would increase semaphore sets and total semaphores as
needed.
Hope this helps.
Regards
Mike
Michael W. Bates E-Mail: mbates_at_sctcorp.com Senior Technical Consultant Phone: (610) 640-5240System and Computer Technology, Corp.
Date: Fri, 6 May 1994 08:19:00 PST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: John Tay <CVABA357_at_CSUPOMONA.EDU> Subject: Oracle User
Hello,
Can all the Oracle user on the west coast(California,Arizona, Seattle, Oregon) please raise their hand. Thanks. Just to survey how many Oracle platform are there? Please include platform, version and tools use. Thanks. John
Date: Wed, 6 Apr 1994 10:09:55 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Jennifer R. Amon (216) 775-6987" <BAMON_at_OCVAXC.CC.OBERLIN.EDU> Subject: Re: Access control by users to forms?
>Subj: Access control by users to forms?
>
>I need to have "application-level security" in
>my ORACLE system. The current system uses
>SQL*Forms 2.3 with ORACLE version 6 (and
>*no* use of SQL*Menu).
>
>The requirement is to be able to control
>access by various users to the different
>forms that make up the application; and
>if possible, log an audit trail access
>to them on the fly.
>
>Has anyone seen or developed something
>similar? And how long will SQL*Forms 2.3
>continue to be supported?
>
>Thanks in advance
>David D'Lima
>dlima_at_tcsernet.tcs.ernet.in
I've done this.
If you are using a sql*form as a menu, then the logic can go there and
dynamically determine which items show up on your menu.
If you are just using forms directly, then the logic would go in a pre-form (did that exist in 2.3?) or a key-startup.
You have to put your security information into a table in the database (i.e. which users can use which forms, and then check there on the basis of the value of USER, to see if the user is permitted to run the current form.
I'm sure there are other ways to handle it, but that's how I did it.
Jennifer R. Amon PHONE: (216) 775-6987 Houck Computing Center FAX: (216) 775-8573 Oberlin College Oberlin, OH 44074 INTERNET: bamon_at_ocvaxc.cc.oberlin.edu _____________________________________________________________________ ========================================================================= Date: Fri, 6 May 1994 09:20:00 -0800 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Frank Rothacker <FRANK_at_SLACVM.SLAC.STANFORD.EDU> Subject: Table Rotation Operator
Suppose you want to know which student is in what classroom during each of 8 periods. There are two different ways to set up a table to store this information.
One way is to have one record for each student, with the student number being the primary key, and one column for each period:
Student# P1 P2 P3 P4 P5 P6 P7 P8
The other way is to have 8 rows for each student, with the student number and period number being the primary keys:
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
The question is: How can I convert from one form to the other, using SQL operators? While there are a number of report writers that can create reports in either form from either table organization, I can't seem to find any reasonable way to do it with SQL. I would like to be able to CREATE VIEW AS SELECT, or CREATE TABLE AS SELECT, rotating the table in the process.
I have run into a lot of data base applications where I need to rotate a table as illustrated above. Does anyone know how to solve this problem? Does anyone know if this problem has been solved in SQL90 or SQL92?
Thanks very much.
Date: Fri, 6 May 1994 09:54:24 -0700
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Al Lau <allau_at_SEQUENT.COM>
Subject: Re: Oracle User
In-Reply-To: <9405061629.AA00645_at_gateway.sequent.com> from "John Tay" at May 6,
94 08:19:00 am
I'm running 6.0.37, 7.0.15 (OPS) and 7.0.16 on a Sequent.
>
> Hello,
> Can all the Oracle user on the west coast(California,Arizona, Seattle,
> Oregon) please raise their hand. Thanks. Just to survey how many Oracle
> platform are there? Please include platform, version and tools use. Thanks.
> John
>
--
Al Lau Sequent Computer Systems, Inc.
allau_at_sequent.com 15450 SW Koll Parkway +----+
Software Engineer Beaverton, OR 97006 | #|
Phone: (503) 578-4063 | |
Standard disclaimers apply Fax: (503) 578-9890 +----+
=========================================================================
Date: Fri, 6 May 1994 13:26:03 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "L. Carl Pedersen" <L.Carl.Pedersen_at_DARTMOUTH.EDU>
Subject: Re: Table Rotation Operator
One way is to have one record for each student, with the student number being the primary key, and one column for each period:
Student# P1 P2 P3 P4 P5 P6 P7 P8
The other way is to have 8 rows for each student, with the student number and period number being the primary keys:
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
Student# Period Room
The question is: How can I convert from one form to the other, using
SQL operators? While there are a number of report writers that can
create reports in either form from either table organization, I can't
seem to find any reasonable way to do it with SQL. I would like to be
able to CREATE VIEW AS SELECT, or CREATE TABLE AS SELECT, rotating the
table in the process.
--- end of quoted material ---
In ORACLE, first thing that comes to mind for wide to long is something like:
create view long(student,period,room) as
select student, 1, p1 from wide union select student, 2, p2 from wide union select student, 3, p3 from wide union select student, 4, p4 from wide union select student, 5, p5 from wide union select student, 6, p6 from wide union select student, 7, p7 from wide union select student, 8, p8 from wide;
Going the other way is trickier:
create view wide as
select student,
max(decode(period,1,room)) p1,
max(decode(period,2,room)) p2,
max(decode(period,3,room)) p3,
max(decode(period,4,room)) p4,
max(decode(period,5,room)) p5,
max(decode(period,6,room)) p6,
max(decode(period,7,room)) p7,
max(decode(period,8,room)) p8
The above may appear to be nonsense at first glance, but it works.
Hint: The MAX function only gets one non-null value for each student.
This trick has been passed around for years and is very useful in a variety of situations. Oracle should put it in the SQL Reference Manual.
Date: Fri, 6 May 1994 10:43:18 PST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Larry Crawford <LCRAWFOR_at_CVDLS.UCDAVIS.EDU>
Subject: Re: Oracle User
In-Reply-To: Message of Fri,
6 May 1994 08:19:00 PST from <CVABA357_at_CSUPOMONA.EDU>
We are just installing Oracle 7 (OracleWare) on an HP Pentium Server. We have not chosen tools yet.
On Fri, 6 May 1994 08:19:00 PST John Tay said:
>Hello,
> Can all the Oracle user on the west coast(California,Arizona, Seattle,
>Oregon) please raise their hand. Thanks. Just to survey how many Oracle
>platform are there? Please include platform, version and tools use. Thanks.
>John
Larry Crawford \ / California Veterinary Diagnostic Lab Information Systems Specialist - * - University of California at Davis lcrawfor_at_cvdls.ucdavis.edu / \ Davis, CA 95616 (916) 752-4407 ========================================================================= Date: Fri, 6 May 1994 11:33:06 -0700 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Catherine King <caking_at_UCDAVIS.EDU> Subject: Re: Oracle User
>
> Hello,
> Can all the Oracle user on the west coast(California,Arizona, Seattle,
> Oregon) please raise their hand. Thanks. Just to survey how many Oracle
> platform are there? Please include platform, version and tools use. Thanks.
> John
>
Oracle v 6 for OS/2 server. SQLLoader, Export/Import Utilites, SQL*Plus. (Oracle database clients will use FoxPro.)
We have a site license for Oracle here at U.C. Davis, so there are a few other Oracle users on this campus as well.
# Catherine King #
### caking_at_ucdavis.edu ###
## ## Programmer/Analyst ## ##
# # (916) 752-8090 # #
#### #### Office of the Vice Chancellor for Research #### ####
# # U.C. Davis # #
### Davis, CA 95616 ###
=========================================================================
Date: Fri, 6 May 1994 14:44:28 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Julie R. McLain-Harper" <julie_r_mclain-harper_at_MILACRON.COM>
Subject: ACE*Insight
I evaluated the ACE*Insight package approximately 1 year ago (I don't know if Legent has come up with another version since then). As a database administrator, I have written several tools in SQL*PLUS to query DBA views, quite similar to the reporting available through ACE*Insight. Since we run a purchased application, I did not feel that it was up to us to scan the code that someone else had responsibility for creating. As far as the database reporting, I didn't feel that the product offered any more that I had already written; however, if your group does not write many SQL scripts, this would be a good front end/user tool, kinda like using the new SQL*DBA menu-driven monitor (doing the function, but not really knowing the syntax of the commands behind the scenes).
Julie
Cincinnati Milacron Products Division
Database Administrator
Date: Fri, 6 May 1994 15:47:37 EST5EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Ross Greenberg <ROSS_at_UMS1.LAN.MCGILL.CA> Organization: McGill University Subject: Windows apps on OS/2 clients; SQL*VDM
We would like to run Oracle Databrowser under Win OS/2, communicating with an Oracle NLM (Netware) server using SPX/IPX. I've been told by Oracle Corp that instead of SQL*Net for Windows or OS2, we need something called SQL*VDM - Virtual DOS Machine - to make this work. Anybody know anything about this product, or any have advice or experience to share? Thanks.
Ross Greenberg Tel: (514)-398-4423
Senior Project Manager Fax: (514)-398-4758
Information Systems Resources Internet: ross_at_ums1.lan.mcgill.ca
McGill University Montreal, Quebec, Canada H3A 2T5
=========================================================================
Date: Fri, 6 May 1994 13:31:25 PDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: DDavis <3544P_at_NAVPGS.BITNET>
Subject: Re: Oracle User
In-Reply-To: Message of Fri,
6 May 1994 10:43:18 PST from <LCRAWFOR_at_CVDLS.UCDAVIS.EDU>
We're on a Sun Work station , using 7.17, operating client/server w/most users on PC's using windows. We use Access, Excel 4.0 (soon to be 5.0), VB, Gupta, and are considering Oracle's CDE quite seriously.
Sonoma State University
Lou Ann Seaman, Assist Dir Admin Computing
e-mail - seaman_at_sonoma.edu -or- (707) 664-3089
Date: Fri, 6 May 1994 15:50:35 -0800 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Robert L Nerenberg <nerrlx00_at_CCMAIL.IASL.CA.BOEING.COM> Subject: Re: ORACLE User
>Hello,
> Can all the Oracle user on the west coast(California,Arizona, Seattle,
>Oregon) please raise their hand. Thanks. Just to survey how many Oracle
>platform are there? Please include platform, version and tools use. Thanks.
>John
ORACLE Server for Macintosh (V.6), on a Quadra 900. Tools: SQL*Plus, Server Manger, ORACLE Card, HyperCard, Pro*Pascal, DataPrism.
R. L. Nerenberg
nerrlx00_at_ccmail.iasl.ca.boeing.com
Date: Mon, 9 May 1994 08:41:36 +0100 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Lex Sijtsma <lex_at_PYTHON.KONBIB.NL> Subject: Powerbuilder
We are thinking of using Oracle and Powerbuilder for our systems development.
Does anybody has experience in connecting to a Oracle database on a DEC Alpha and an application built with Powerbuilder. The app. runs on a PC using TCP/IP _and_ Novell.
Do I need anything special on either side, e.g. apart from SQL*Net or the Powerbuilder enterprise edition.
Also comments on the use of Powerbuilder and Oracle in general are much appreciated.
Thanks in advance.
Date: Mon, 9 May 1994 07:05:15 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Paul Dorsey <DORSEY_at_RIDER.BITNET> Subject: Re: Powerbuilder
That is all you need.
Powerbuilder is fine. The only down side is the lack of CASE tool
support. If you are building a new, large DBMS then you should use
CASE. If you are working with new apps on a mature system, then
your decision looks fine.
The new GUI CASE tools are easy enough that I think the level that
CASE is becoming viable is down to maybe a 40 table DB (unless
you are doing a very strange DB.)
Paul Dorsey
Rider U
Date: Mon, 9 May 1994 06:38:35 -0700 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Dadvantage est rarement suffisant <JAMIE_at_BMT.CA.BOEING.COM> Subject: Oracle
We have Oracle V7.015 on a VAX 4000-100.
Jamie Kessel...JAMIE_at_BMT.CA.BOEING.COM
Date: Mon, 9 May 1994 09:33:30 CDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gigi Suardi <gigi_at_SOFTINT.COM> Subject: Re: Powerbuilder @ @ Also comments on the use of Powerbuilder and Oracle in general are much @ appreciated. @
i like PB. it is easy to learn and rich enough to allow development of interesting applications. i used it to develop data entry for an oracle database. data retrieval and reporting was done using other tools (SQLAssist).
question for PB experts:
one thing i would like to learn about PB is how to write sort of table independent applications... assume your simple application runs against table T1. i want to be able to change an application level parameter so that the application runs against table T2 (which has the same definition of T1). how do i do that in PB? is user objects the only way? thanks for any help.
luigi.
we have to learn the language of Nature
to be able to understand her.
Hundertwasser
=========================================================================
Date: Mon, 9 May 1994 10:27:54 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Karen Huguley <khuguley_at_MAIL.CASI.STI.NASA.GOV>
Subject: Re: Windows apps on OS/2 clients; SQL*VDM
My knowledge of this product is certainly limited, but it is my understanding that SQL*VDM provides the communication link between Win OS/2 and OS/2. It is basically a virtual SQL driver whose purpose is to intercept the calls to the SQL*Net interface and send them off to the underlying SQL*Net driver.
K. Huguley
Center for Aerospace Information
______________________________ Reply Separator _________________________________Subject: Windows apps on OS/2 clients; SQL*VDM Author: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> at smtplink-casi
>From owner-oracle-l_at_CCVM.SUNYSB.EDU
X-Envelope-From: owner-oracle-l_at_CCVM.SUNYSB.EDU
Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2)
with BSMTP id 0926; Fri, 06 May 94 15:49:55 EDT Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU (L Mail V1.2a/1.8a) with BSMTP id 0154; Fri, 6 May 1994 15:49:41 -0400
Date: Fri, 6 May 1994 15:47:37 EST5EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> Sender: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> From: Ross Greenberg <ROSS_at_UMS1.LAN.MCGILL.CA> Organization: McGill University Subject: Windows apps on OS/2 clients; SQL*VDM X-To: ORACLE-L_at_CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.sunysb.edu>We would like to run Oracle Databrowser under Win OS/2, communicating with an Oracle NLM (Netware) server using SPX/IPX. I've been told by Oracle Corp that instead of SQL*Net for Windows or OS2, we need something called SQL*VDM - Virtual DOS Machine - to make this work. Anybody know anything about this product, or any have advice or experience to share? Thanks.
Ross Greenberg Tel: (514)-398-4423
Senior Project Manager Fax: (514)-398-4758
Information Systems Resources Internet: ross_at_ums1.lan.mcgill.ca
McGill University Montreal, Quebec, Canada H3A 2T5
=========================================================================
Date: Mon, 9 May 1994 11:07:32 CST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Morgan, Madeline" <mmorgan_at_CCMAIL.UWSA.EDU>
Subject: Re: Windows apps on OS/2 clients; SQL*VDM
I access remote Oracle db's on Unix, and on Oracle netware server from
my os/2 workstation using Powersoft products (though thru TCP/IP, and
not SPX). When I first installed SQL*NET, I couldn't make the
connection via a Windows product. As soon as I installed SQL*VDM, the
database was accessible. I was informed that this would work with
data browser as well, but have not tried that product yet. You need
the Virtual Dos Machine to convert the APIs.
Madeline Morgan, Data Admin
University of Wisconsin System Administration
mmorgan_at_ccmail.uwsa.edu
______________________________ Reply Separator _________________________________
Subject: Windows apps on OS/2 clients; SQL*VDM
Author: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> at internet
Date: 5/6/94 5:18 PM
Received: by ccmail from CCVM.sunysb.edu
>From owner-oracle-l_at_CCVM.SUNYSB.EDU
X-Envelope-From: owner-oracle-l_at_CCVM.SUNYSB.EDU
Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2)
with BSMTP id 0927; Fri, 06 May 94 15:51:37 EDT
Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU
(L
Mail V1.2a/1.8a) with BSMTP id 0161; Fri, 6 May 1994 15:49:45 -0400
Date: Fri, 6 May 1994 15:47:37 EST5EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> Sender: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> From: Ross Greenberg <ROSS_at_UMS1.LAN.MCGILL.CA> Organization: McGill University Subject: Windows apps on OS/2 clients; SQL*VDM X-To: ORACLE-L_at_CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.sunysb.edu>
We would like to run Oracle Databrowser under Win OS/2, communicating with an Oracle NLM (Netware) server using SPX/IPX. I've been told by Oracle Corp that instead of SQL*Net for Windows or OS2, we need something called SQL*VDM - Virtual DOS Machine - to make this work. Anybody know anything about this product, or any have advice or experience to share? Thanks.
Ross Greenberg Tel: (514)-398-4423
Senior Project Manager Fax: (514)-398-4758
Information Systems Resources Internet: ross_at_ums1.lan.mcgill.ca
McGill University Montreal, Quebec, Canada H3A 2T5
=========================================================================
Date: Mon, 9 May 1994 12:23:00 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Leonardo Fernandez <lfernand_at_ve.oracle.com>"
<lfernand_at_VE.ORACLE.COM>
Subject: Foxpro -> Oracle 7
Hi,
I have a customer with a Foxpro database and he plans to migrate to
Oracle 7 ( on Unix or Netware ).
Are there any tips or advice to migrate from Foxpro to Oracle 7?
Any references on a customer with the same problems ?
Note : Is a big customer ...
Best regards,
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
=========================================================================
Date: Mon, 9 May 1994 13:15:26 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "L. Carl Pedersen" <L.Carl.Pedersen_at_DARTMOUTH.EDU>
Subject: char vs varchar2 space usage
oracle 7 documentation recommends varchar2 over char "to store data more efficiently".
however, it seems to me it must be using at least two bytes to hold the current length of each value for a varchar2 (or a trailing null?), while the length of a char needs to be stored only once per table.
i would also suspect that comparing two chars would be less costly than comparing two varchar2s, assuming all were the same length, on the grounds that the comparison would need to take the stored length into account for the varchar2s - etc.
hence, i would guess that if the lengths of all values in a column was known not to vary (e.g., for a ssn), that it would be more efficient both in space and time to use char instead of varchar2.
i also guess that char would be more advantageous for shorter values (since the percent overhead for the length would be higher).
my theories about this are rather difficult to test accurately, and the documentation isn't detailed enough to know for sure.
does anyone know any more about this?
please email to me, not the list. i'll post a summary if i get anything useful.
Date: Mon, 9 May 1994 16:45:05 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Wayne Belles [LWCC]" <74224.2774_at_COMPUSERVE.COM> Subject: Legent's ACE*Insight Package
We have purchased Ace*Insight and find it to be very useful.
We have been able to look at all the SQL in our system, well over 800 programs, and tell which programs hit certain tables, indexes, among other features. It has given us, if you'll pardon the pun, greate insight into our application. We can determine very easily which programs will be effected by a change in the database.
Another plus side to Legent/PTI, the publishers of ACE*Insight, is their technical support. I have never had a problem getting a response from them, usually same day. They are also very responsive to suggestions for enhancements to their software.
We also purchased another of their products, ACE*Tester, and find that to be useful, also. It is a tester, debugger for SQL*Forms.
Overall I am very pleased with the products.
Wayne Belles
Date: Mon, 9 May 1994 16:45:18 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Wayne Belles [LWCC]" <74224.2774_at_COMPUSERVE.COM> Subject: Oracle App Development and DEC Tools
We use CMS to maintain an application with approximately 800 programs, SQL*Forms, SQL*Plus, SQR, Pro*C and DCL command files. We do not use MMS, but we are looking at it for future use.
We have a library of each type of code we have, each element in the library has a reference copy so developers can look at code without FETCHING that element and we can reference files that are INCLUDed in our Pro*C and SQR files. All the elements in our libraries are accessed in non-concurrent mode. Non-concurrency allows access without the posibility of someone over writing someone elses work. The developers have the capability to FETCH,RESERVE,UNRESERVE any element in the libraries, but they cannot REPLACE. There are only two people that can REPLACE, myself and my manager, this affords us a chance to make sure that our procedures have been followed before we place something into production.
Security on the libraries is accomplished via ACLs at both the VMS and CMS levels. We have created rights identifiers to identify the developers and the managers and incorporate these rights identifiers into the ACLs.
CMS does a good job of managing our code. It was a little difficult to set up the ACLs on the directories and files at first but once we got one done it was a piece of cake.
Wayne Belles
Date: Mon, 9 May 1994 12:52:09 ARG Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Alvaro Pereira <apereira_at_GELLYO.JUS.GOV.AR> Subject: Powerbuilder 2
We are beginning to study the possibility of moving from SQL*Forms to
PowerBuilder. I know nothing about PowerBuilder so I want to make another
question about it.
What kind of support does it provide for managing automatically the interactions
with the database, for example, for querying tables and keeping track of new,
modified and deleted records and submitting the corresponding SQL statements?
Thanks in advance for any information.
Date: Mon, 9 May 1994 07:43:01 -0700 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: RDB8%IC%DCPP_at_BANGATE.PGE.COM Subject: Re: Oracle User
> Can all the Oracle user on the west coast(California,Arizona, Seattle,
>Oregon) please raise their hand. Thanks. Just to survey how many Oracle
>platform are there? Please include platform, version and tools use. Thanks.
Oracle Rdbms 6.0.33 for Banyan Vines (on a CNS box)
SqlForms 3.0 Windows
Sqlplus for Windows
MicroSoft Access
Pro*C
R&R Writer for Windows 4.0
Planning on moving to SCO for Vines or HP/UX for the Server.
Rick Box : System Analyst Pacific Gas & Electric Internet : rdb8_at_pge.com Diablo Canyon Nuclear Power Plant
P.O.Box 56 I&C 102/2
Avila Beach, CA 93424
Tel: (805) 545-4229 Fax: 545-3373
---------------------------------------------------------------------------
*** The views expressed here are my own and do not necessarily ***
*** reflect those of PG&E. ***
---------------------------------------------------------------------------
=========================================================================
Date: Mon, 9 May 1994 17:46:07 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Jay Mehta <mehtaj_at_SPACENET.COM>
Subject: Re: Version 7 trigger info request
In-Reply-To: <9405060446.AA07605_at_uu5.psi.com>; from "Tim" at May 5, 94 3:00 pm
I tried to define after-insert trigger on user_audit_session using system account, but Oracle didn't let me. Have you found any other ways to define an after-insert trigger on user_audit_session ?
Thanks,
Jay Mehta
GTE Spacenet
1700 Old Meadow Road
McLean, VA 22102
703-848-1569 ( voice )
Date: Mon, 9 May 1994 17:32:56 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Jay Mehta <mehtaj_at_SPACENET.COM>
Subject: Re: Powerbuilder
In-Reply-To: <9405091547.AA17621_at_spcseq.spacenet.com>; from "Gigi Suardi" at
May 9, 94 9:33 am
Hi Gigi,
I am not a PB expert, but We have done the same at the server level. We have def ined synonyms for every production tables. We don't use actual table names in ou r GUI, but refer to public synonyms. For example, We have created T1 and T2 tables, both identical except one is being used by end users and the other one is being prepared for the use. If we want to use table T1, we create public synonym T for table T1. If we want to use table T2, we crea te public synonym T for table T2. In both cases, we refer to public synonym T in our GUI. This mechanism allows us to perform 'database switch-over' at midnight. We have written SQL scripts to do the same.
Jay Mehta
GTE Spacenet
1700 Old Meadow Road
McLean, VA 22102
703-848-1569 ( voice )
Date: Mon, 9 May 1994 19:22:15 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Dagmar A. Bogan." <DAGMARA_at_DELPHI.COM> Subject: Re: Access control by users to forms?
I have done this upteen times in 2.3. Basically, you create your menu based on a form and trap information (i.e., you can use select user from dual to find out the user account, if accounts are unique, there are ways to capture the host account as well). I stuffed this value into a global, and passed it from form to form. A trigger verified that the user had access, and if so, what level (some users had read-only, or could only update certain fields in the form). The problem you will run across is creating the logic to check the user validity. In our case, accounts were alphanumeric, and we used a substring scheme to verify the users access level. The alternative is to use a table.
Dagmar
Kopania & Komerovski
Richardson, TX 75081
Date: Mon, 9 May 1994 19:26:04 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Dagmar A. Bogan." <DAGMARA_at_DELPHI.COM> Subject: Re: Powerbuilder
I do not have direct experience with ORACLE and Powerbuilder, but I did have a client who built a prototype with a Powerbuilder front-end, accessing ORACLE 6, ORACLE7, and Sybase. I have no idea how much smoke and mirrors were in this application, but it did look slick and was fairly fast; so it can be done.
Dagmar
Date: Mon, 9 May 1994 20:28:42 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Steven F Medin <smedin_at_WORLD.STD.COM> Subject: Re: Powerbuilder 2
On Mon, 9 May 1994, Alvaro Pereira wrote:
> We are beginning to study the possibility of moving from SQL*Forms to
> PowerBuilder. I know nothing about PowerBuilder so I want to make another
> question about it.
> What kind of support does it provide for managing automatically the
interactions
> with the database, for example, for querying tables and keeping track of new,
> modified and deleted records and submitting the corresponding SQL statements?
The short answer is that PB handles all these issues. The long answer: the PowerScript Retrieve command executes the SQL query you associate with a visual display of data (or datawindow). Each row and column within row has one of these four statuses: New, NewModified, NotModified or DataModified. These determine what is automatically built into the SQL batch by the PowerScript Update command, combined with the update specifications of a datawindow. These specs identify the table to update, whether to update-in-place or delete/insert, and what to build into the where clause:primary key only, key+updatable, or key+modified columns. It also identifies the primary key and the updatable columns.
I haven't used SQL*Forms, so unfortunately I can't draw a comparison. I *have* worked with PB for 2 1/2 years and can answer any other questions, preferably through e-mail since this is an Oracle listserv.
Steve Medin
Date: Mon, 9 May 1994 23:33:45 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Stuart Cracraft <cracraft_at_AI.MIT.EDU> Subject: deadlock
What causes the deadlock in the following? How do I fix it?
SQL*DBA: Version 6.0.36.7.1 - Production on Mon May 9 20:02:49 1994
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
ORACLE RDBMS V6.0.36.7.1, transaction processing option - Production PL/SQL V1.0.36.2.2 - Production
ORACLE instance started.
Database mounted.
ORA-00060: deadlock detected while waiting for resource
Attempting to dismount database........Database dismounted.
Attempting to shutdown instance........ORACLE instance shut down.
SQL*DBA complete.
Database "ludb" warm started.
Date: Wed, 31 Dec 1969 23:59:59 GMT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Kerry Thompson <hori!kerry_at_DELPHIC.ATTMAIL.COM> Subject: Re: Stuart Cracraft's deadlock
Probably a severe resource shortage problem.
Have you changed init.ora recently ?
Was there anything reported in ~/rdbms/log/alert_ludb.log ?
Kerry Thompson eMail kerry_at_delphic.attmail.com Delphic Medical Systems Voice +64 9 630 3554 Auckland, New Zealand. Fax +64 9 630 8135 ========================================================================= Date: Tue, 10 May 1994 17:14:22 +1000 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Tony Jambu <TJambu_at_CMUTUAL.COM.AU> Subject: Experience Oracle V6 to Oracle7
People
Hi there. I am posting this query for a site that is in the process of planning a conversion project to convert an Oracle V6 database to Oracle7 and would like pick some of your brains.
These are some of the questions I have. I am more interested particularly in the resources required by Oracle7 ie memory, filestore and CPU.
This information might be of some help.
- Operating Sys = UNIX - available memory = 32M - current V6 sga = 1M - Max Users = 8 - Application = Pro*Cobol
Performance is not an issue.
Can you please let me know what I can expect in terms of the additional resources for the following:
SGA - By what factor will I need to increase? Shadow process - By what factor can I expect it to increase/decrease?
2. Disk/Filestore
Filestore for Application - Will the application (Pro*Cobol) be increased
or decreased? A test program compiled against
7.0.13 showed a 100% increase in size.
3. CPU Can I expect more, less or the same number CPU load with Oracle7?
Any feedback is greatly appreciated.
PS. Before you say the amount of additional resources is not significant,
let me say that they have hundreds of these databases and applications
out there to upgrade.
Thanks
tony
_____ ________ / ____ |Tony Jambu, Database Administrator /_ _ /_ __ / |Colonial Mutual Invest Mgmt,Aust (ACN004021809) /(_)/ )(_/ \_/(///(/_)/_( |EMAIL: TJambu_at_cmutual.com.au \_______/ |PHONE: +61-3-2831639 FAX: +61-3-2831090 ========================================================================= Date: Tue, 10 May 1994 07:59:41 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Anna L. Olson" <annao_at_TECNET1.JCTE.JCS.MIL> Subject: Posix and Oracle
I was wondering if anyone is running Posix and Oracle on the same machine? If so how?
Also, I just received a trail copy of DBVisions and was wondering if anyone else has had any experiences with this product?
Thanks alot!
Anna Olson (annao)
Computer Sciences Directorate
Date: Tue, 10 May 1994 07:22:10 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: RDB8%IC%DCPP_at_BANGATE.PGE.COM Subject: PowerBuilder
Anyone know of a Mailing List for PowerBuilder.
Rick Box : System Analyst Pacific Gas & Electric Internet : rdb8_at_pge.com Diablo Canyon Nuclear Power Plant
P.O.Box 56 I&C 102/2
Avila Beach, CA 93424
Tel: (805) 545-4229 Fax: 545-3373
---------------------------------------------------------------------------
*** The views expressed here are my own and do not necessarily ***
*** reflect those of PG&E. ***
---------------------------------------------------------------------------
=========================================================================
Date: Tue, 10 May 1994 10:27:46 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Denise Gwinn <DENISE_at_WVNVMS.BITNET>
Organization: West Virginia Network
Subject: Re: Posix and Oracle
We are running Posix and Oracle under VMS 5.5-2. ORA_RDBMS:INSLIBS.COM is the file causing your problem. It wants to install some of the libraries as protected that VMS has installed as shared.
Denise Gwinn
denise_at_wvnvms.wvnet.edu
Date: Tue, 10 May 1994 11:40:35 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Comments: Resent-From: James Bush <JBUSH_at_VDH> Comments: Originally-From: James Bush <JBUSH_at_VDH> From: James Bush <JBUSH_at_VDH.BITNET> Subject: Oracle Mail
Is anyone using Oracle Mail, and how is it performing. I am asking since the OIR division is planning to use it in a network environment with about 600 users. Please address replies directly to me as I am not on to list.
Date: Tue, 10 May 1994 11:29:06 PST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Larry Crawford <LCRAWFOR_at_CVDLS.UCDAVIS.EDU> Subject: Re: Oracle Mail
We are considering using Oracle Office. I'd like to hear from others using it
what their experiences are in terms of performance, ease of use, administration
etc.
Thanks,
On Tue, 10 May 1994 11:40:35 EDT James Bush said:
>Is anyone using Oracle Mail, and how is it performing. I am asking since
>the OIR division is planning to use it in a network environment with about
>600 users. Please address replies directly to me as I am not on to list.
Larry Crawford \ / California Veterinary Diagnostic Lab Information Systems Specialist - * - University of California at Davis lcrawfor_at_cvdls.ucdavis.edu / \ Davis, CA 95616 (916) 752-4407 ========================================================================= Date: Tue, 10 May 1994 13:45:30 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Bob Williams <williamsbc_at_CCVAX.CCS.CSUS.EDU> Subject: **HELP!**With SQLLoader
I am working on a system that tracks 3 levels of appeals for parking violations at a university campus. Each level of appeal includes a field for the amount of the violation fine.
I'm using SQLLoader to load violation data into a database; the appeals data is entered later using SQLForms v3.0.
What I would LIKE to do is enter the fine (called "v_penalty") into the appeals fine fields (called "ah_penalty,""ar_penalty," and "muni_penalty") upon loading the original data into the database. Currently the latter three fields are null after the load.
I would like the value for v_penalty to be used as a default for the other 3 fields.
Any suggestions?
Date: Tue, 10 May 1994 18:54:11 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Steven F Medin <smedin_at_WORLD.STD.COM> Subject: Re: PowerBuilder
On Tue, 10 May 1994 Rick Box wrote:
> Anyone know of a Mailing List for PowerBuilder.
I don't know of a listserv yet, but the Usenet application for comp.soft-sys.Powerbuilder is currently under review. Voting closed on March 5, 1994, so it should be up this summer. Some listserv site will probably pick it up then.
I don't mean to imply that there is definitely no PB listserv, just that I haven't found one yet. Maybe I'm just roadkill on the Information Highway, though.
-Steve Medin
Date: Tue, 10 May 1994 19:33:26 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Ricardo Cardenas <rcardena_at_PR.ORACLE.COM> Subject: [oracle-l] **HELP!**With SQLLoader
Are you using ORACLE7? If so, try this before-insert trigger --
create trigger default_appeal_penalties
before insert on penalties_table
for each row
begin
:new.ah_penalty := :new.v_penalty;
:new.ar_penalty := :new.v_penalty;
:new.muni_penalty := :new.v_penalty;
end;
The elegance is that this will work regardless of the method used for data loading (SQL*Loader, SQL*Forms, SQL*Plus, Pro*C, etc.).
If you don't have Oracle6, SQL*Loader can also do this. Just use the same "field position specifier" for several columns, e.g.
load data insert into table penalties_table
(v_penalty position (1:6) integer external,
ah_penalty position (1:6) integer external,
ar_penalty position (1:6) integer external,
muni_penalty position (1:6) integer external
...
Regards -Ricardo
I am working on a system that tracks 3 levels of appeals for parking violations at a university campus. Each level of appeal includes a field for the amount of the violation fine.
I'm using SQLLoader to load violation data into a database; the appeals data is entered later using SQLForms v3.0.
What I would LIKE to do is enter the fine (called "v_penalty") into the appeals fine fields (called "ah_penalty,""ar_penalty," and "muni_penalty") upon loading the original data into the database. Currently the latter three fields are null after the load.
I would like the value for v_penalty to be used as a default for the other 3 fields.
Any suggestions?
Deadlock is caused by two or more processes trying to access the same resources at the same time. You probably need to kill the processes. I don't what your host O/S is; in UNIX, you can do ps -aux | grep oracle and see what is running.
Dagmar
Kopania & Komerovski
Richardson, TX
Date: Tue, 10 May 1994 21:39:13 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "L. Carl Pedersen" <L.Carl.Pedersen_at_DARTMOUTH.EDU> Subject: Surprising aspects of comparisons to CHAR fields.
I can compare a CHAR field to a constant in a WHERE clause, and get results as if the constant was blank-padded. This is as I expect.
However, results are surprising when I compare a CHAR column to a VARCHAR2 column, or when I compare a CHAR to a constant in a DECODE expression. In those cases, no blank-padding occurs on the compare. Hence, things you might think are equal turn out to be unequal.
I'm inclined to label both of these as bugs, but I admit I am uncertain of all the implications.
Clearly, the way it works now is surprising and hence dangerous in some cases. Perhaps there would be surprising and dangerous things that would happen it it worked the other way, too.
Can anyone defend the way it works, or provide more support for the idea that it should be changed?
If you email responses, I will summarize in a few days.
Here are some examples:
SQL*Plus: Release 3.1.3.1.1 - Production on Tue May 10 20:37:58 1994
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
Connected to:
ORACLE7 Server Release 7.0.16.4.0 - Production
With the procedural and Parallel Server options
PL/SQL Release 2.0.18.1.0 - Production
ADM> select count(*) from loan.label_ps_prolog; ADM> create table t(c char(4), v varchar(4)); Table created.
ADM> insert into t values('A','A');
1 row created.
ADM> insert into t values('ABCD','ABCD'); 1 row created.
ADM> select * from t where c = v;
C V
---- ----
ABCD ABCD
1 row selected.
ADM> select decode(c,'A','C IS A','C IS NOT A'), 2 decode(v,'A','V IS A','V IS NOT A') 3 from t;
DECODE(C,' DECODE(V,'
---------- ----------
C IS NOT A V IS A
C IS NOT A V IS NOT A
2 rows selected.
ADM> select decode(c,'A','C IS A','C IS NOT A'),
2 decode(v,'A','V IS A','V IS NOT A')
3 from t
4* where c = 'A'
DECODE(C,' DECODE(V,'
---------- ----------
C IS NOT A V IS A
1 row selected.
ADM>
Date: Tue, 10 May 1994 19:45:25 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Tim <tnfraser_at_CSUPOMONA.EDU> Subject: Re: Surprising aspects of comparisons to CHAR fields.
Carl,
This is no bug. When comparing a literal to a value in a CHAR type field, you will need to pad your literal with spaces otherwise the comparison will be false.
For example, your "decode" illustration will return expected results if you say: select decode(c,'A ','C IS A','C IS NOT A'). ORACLE treated your comparison unequal because you were comparing 'A' (length = 1) with 'A ' (length = 4).
Personally, I don't like the CHAR type because I think it can lead (and will lead) to these sort of problems. One of the reasons it was introduced was to circumvent problems with nulls.
Tim Fraser
Database Administrator
California State Polytechnic University
Pomona, California
Date: Wed, 11 May 1994 08:01:25 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Bob Belt <bbelt_at_SCTLRS2.SCTCORP.COM>
Subject: Re: Surprising aspects of comparisons to CHAR fields.
In-Reply-To: Letter from "L. Carl Pedersen" of May 10,
9:39pm "Surprising aspects of comparisons to CHAR fields."
On May 10, 9:39pm, "L. Carl Pedersen" wrote:
> Subject: Surprising aspects of comparisons to CHAR fields.
> I can compare a CHAR field to a constant in a WHERE clause, and get results
> as if the constant was blank-padded. This is as I expect.
>
> However, results are surprising when I compare a CHAR column to a VARCHAR2
> column, or when I compare a CHAR to a constant in a DECODE expression. In
> those cases, no blank-padding occurs on the compare. Hence, things you might
> think are equal turn out to be unequal.
>
> I'm inclined to label both of these as bugs, but I admit I am uncertain of
> all the implications.
>
> Clearly, the way it works now is surprising and hence dangerous in some
> cases. Perhaps there would be surprising and dangerous things that would
> happen it it worked the other way, too.
>
> Can anyone defend the way it works, or provide more support for the idea that
> it should be changed?
>
> If you email responses, I will summarize in a few days.
>
> Here are some examples:
>
>
> SQL*Plus: Release 3.1.3.1.1 - Production on Tue May 10 20:37:58 1994
>
> Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
>
> Connected to:
> ORACLE7 Server Release 7.0.16.4.0 - Production
> With the procedural and Parallel Server options
> PL/SQL Release 2.0.18.1.0 - Production
>
> ADM> select count(*) from loan.label_ps_prolog;
> ADM> create table t(c char(4), v varchar(4));
> Table created.
>
> ADM> insert into t values('A','A');
> 1 row created.
>
> ADM> insert into t values('ABCD','ABCD');
> 1 row created.
>
> ADM> select * from t where c = v;
>
> C V
> ---- ----
> ABCD ABCD
>
> 1 row selected.
>
> ADM> select decode(c,'A','C IS A','C IS NOT A'),
> 2 decode(v,'A','V IS A','V IS NOT A')
> 3 from t;
>
> DECODE(C,' DECODE(V,'
> ---------- ----------
> C IS NOT A V IS A
> C IS NOT A V IS NOT A
>
> 2 rows selected.
>
> ADM> select decode(c,'A','C IS A','C IS NOT A'),
> 2 decode(v,'A','V IS A','V IS NOT A')
> 3 from t
> 4* where c = 'A'
>
> DECODE(C,' DECODE(V,'
> ---------- ----------
> C IS NOT A V IS A
>
> 1 row selected.
>
> ADM>
>-- End of excerpt from "L. Carl Pedersen"
Carl,
FYI, Forms40 uses non-padded comparison semantics for compatibility with earlier releases. This bit us when we tried to use CHAR datatypes for some columns and VARCHAR2 for others.
Had several problems including Master/Detail record retrieval on the CHAR columns. RPAD will work, but adds to code (and form size).
Changing all fields to VARCHAR2 solved this. Oracle suggested we use VARCHAR2 exclusively.
Regards,
--
+---------------------------------------------------------------+ | Bob Belt | | SCT Public Sector e-mail: bbelt_at_sctcorp.com | | 1733 Harrodsburg Road phone: (606) 277-1500 | | Lexington, KY 40504-3617 fax: (606) 277-2300 | +---------------------------------------------------------------+ ========================================================================= Date: Wed, 11 May 1994 08:26:13 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "L. Carl Pedersen" <L.Carl.Pedersen_at_DARTMOUTH.EDU> Subject: Re: Surprising aspects of comparisons to CHAR fields.
i know how it works. when comparing a literal in a WHERE clause, it pads with blanks automatically - as required by the definition of CHAR.
your claim that it is "no bug" is just that - your claim.
i see no argument for the fact that it *should* work this way.
if i don't have to pad in a where clause, why should i have to pad (or trim) in a decode?
the advantages of varchar are fairly clear, but char has its own advantages:
for a one-byte code, for example, char is almost certainly superior to varchar. for the title of a book, varchar is probably superior. each has its advantages and disadvantages. choosing the best type for a given case is our job. it makes sense to have both types in a system. some things that might surprise unwary programmers are not avoidable due to the definition of char. however, i don't see a good reason why the decode and the compare of char to varchar should work the way they do.
i see no evidence for your claim that char was "introduced to circumvent problems with nulls". i have always considered the fact that a zero-length varchar is treated as a null to be a bug and i still do, but i don't feel that the char type in any way "circumvents" this. varchars are useful on their own, as i'm sure you realize, and a zero-length varchar ought to be distinct from a null. naturally, there'd be hell to pay if oracle changed this now. (varchar3?, varchar4?, yech!) this is why its a good idea to think hard about how you do some things in the first place. if you aren't sure what something should mean, you should forbid it.
in fact, i would probably not consider it a bug if oracle rejected my surprising examples with an error message.
Date: Wed, 11 May 1994 14:18:47 +0100 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Andrew Morris <morrisa_at_HEAC006.GB.EC.PS.NET> Subject: Forwarded mail...
Folks,
I would like to hear of anybody's experience(s) with SQL*FORMS4 on Sequent platforms, in particular:
I know that the scope of the above is very broad, but I am looking for as much information as people are able to provide.
Thanks in anticipation...
Andrew Morris,
DBA Perot Systems Europe.
Date: Wed, 11 May 1994 08:38:26 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: The ORACLE <KEENE_at_RCKHRST2.BITNET> Organization: Rockhurst College; Kansas City, MO Subject: Re: Surprising aspects of comparisons to CHAR fields.
In Oracle7, if you are going to use the CHAR data type, then only use it with fields that are fixed and fully qualify the field (always fill the field like a flag field, phone numbers, zip code, etc.). VARCHAR2 is for everything else or for all the character fields, if you want things to work like previous versions of Oracle.
Jim Keene, SJ
Rockhurst College
Date: Wed, 11 May 1994 09:27:07 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Kurt Jordan CUSS <jordanka_at_PUCAL1A.CALUMET.PURDUE.EDU> Subject: EXPORT hangs up
I'm having a problem with export. When I set the buffer= parameter in the parfile to 45056, everything works fine.
If I set it to 46080 or higher, the export hangs after copying 17k of the table and just sits there.
I am using the fast two task driver with a buffer of 512k on oracle 6.0.36 on a Sequent running UNIX.
Can anyone enlighten me on what I'm doing wrong?
Kurt Jordan
System Administrator
Purdue University Calumet
Hammond IN 46383
219 989 2590
Date: Wed, 11 May 1994 10:53:13 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Leonardo Fernandez <lfernand_at_ve.oracle.com>"
<lfernand_at_VE.ORACLE.COM>
Subject: Fwd: deadlock
Hi Stuart,
Cause for the ORA-00060 error :
If ora-1116 ora ora-7360 exits, the solution is the following :
startup mount
connect internal
alter database datafile '../../..' offline;
alter database open
alter tablespace XX offline;
XX is the name the rollback's tablespace.
drop tablespace XX including contents;
and create it afterwards ...
- if the datafile is of a any's tablespace (is not TABLESPACE SYSTEM) :
startup mount
connect internal
alter database datafile '../../..' offline;
alter database open
NOTE : All the information storaged in the datafile, was losted !!!
- if the datafile is of the tablespace SYSTEM :
I'm sorry for you ...
You must create the database.
Good luck,
Leonardo Fernandez
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
Received: 05-09-94 23:38 Sent: 05-09-94 23:33From: VESUN1:owner-oracle-l_at_CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L ORACLE-L_at_CCVM.SUNYSB.EDU Subject: deadlock
What causes the deadlock in the following? How do I fix it?
SQL*DBA: Version 6.0.36.7.1 - Production on Mon May 9 20:02:49 1994
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
ORACLE RDBMS V6.0.36.7.1, transaction processing option - Production PL/SQL V1.0.36.2.2 - Production
ORACLE instance started.
Database mounted.
ORA-00060: deadlock detected while waiting for resource
Attempting to dismount database........Database dismounted.
Attempting to shutdown instance........ORACLE instance shut down.
SQL*DBA complete.
Database "ludb" warm started.
Date: Wed, 11 May 1994 14:47:19 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Stuart Cracraft <cracraft_at_AI.MIT.EDU> Subject: oracle financials installation error
Anyone know about these errors in the Financials install?
IMP-00019: row rejected due to ORACLE error 1 IMP-00021: operating system error - error code (dec 2, hex 0x2) IMP-00003: ORACLE error 1 encountered ORA-00001: duplicate key in index IMP-00003: ORACLE error 1556 encountered ORA-01556: maximum number of 121 extents exceeded
Thanks in advance...
--Stuart
Date: Wed, 11 May 1994 12:46:53 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Tim <tnfraser_at_CSUPOMONA.EDU> Subject: Re: oracle financials installation error
Stuart -
These messages are occurring because one or more of the tables/indexes owned by Finance have initial storage extents that are too low.
To find out which tables/indexes have a high number of extents, perform a query on DBA_SEGMENTS looking for any segments that have (for example) more than 50 extents. Once you identify these tables/indexes, you will need to recreate them with larger initial extents or increase the size of the next extent before you go any further.
Tim Fraser
DBA
California State Polytechnic University
Pomona, California
Date: Wed, 11 May 1994 16:06:00 PST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: John Tay <CVABA357_at_CSUPOMONA.EDU> Subject: Deleted table
Hello,
I create a table called part4.dbs and accidently deleted using the
delete command on vms. I tried restoring from my tape backup and then
startup the database. But I kept getting the message
ora-01113: file 11 needs media recovery.
ora-01110: data file '...'
Any ideas how I can restore my instance without creating a new instance.
Thanks.
Date: Wed, 11 May 1994 16:46:42 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Wayne McGill <wmcgill_at_CIM1.CHINALAKE.NAVY.MIL> Subject: Re: Oracle User
We are currently using Oracle 6.0.37 on a VAX 4000-200 running VMS 5.5-2 but will be installing Version 7 in a couple of weeks. We use SQL*Plus (3.0), SQL*Report (1.1), SQL*ReportWriter (1.1), SQL*Forms (2.3), Pro*C (1.4), SQL*Menu (4.1) and SQL*Loader (1.1). These are the current versions which will all be upgraded with the new installation. BTW, most users access the database using VersaTerm on Macintoshes.
Wayne McGill
wmcgill_at_cim1.chinalake.navy.mil
Date: Wed, 11 May 1994 16:46:20 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Tim <tnfraser_at_CSUPOMONA.EDU> Subject: Re: Deleted table
You'll need to restore all of your database files. This includes your control files, redo log files, and database files.
Date: Thu, 12 May 1994 09:44:36 +0100
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Dawn Ashbourne <ashbourd_at_HEAC006.GB.EC.PS.NET>
Subject: Re: ORACLE-L Digest - 10 May 1994 to 11 May 1994
In-Reply-To: <no.id> from "Automatic digest processor" at May 12,
94 01:19:59 am
>
> 1. Surprising aspects of comparisons to CHAR fields. (3)
It behaves as it does to bring ORACLE in compliance with ANSI standards...
Date: Thu, 12 May 1994 10:58:18 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Teresa A Larson <larson_at_SLED.GSFC.NASA.GOV> Subject: This is a test
I am new listserv user and am just testing to see if I can successfully post a message.
Teresa Larson
--
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ | Teresa A. Larson - Hughes STX Corporation | | NASA/GSFC Code 933.0 voice: (301) 286-7867 | | Greenbelt, Maryland 20771 fax: (301) 286-1777 | | larson_at_sled.gsfc.nasa.gov | +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ ========================================================================= Date: Thu, 12 May 1994 08:21:00 U Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "McShane, John P" <mcshane_at_MDAW.MDC.COM> Subject: West Coast User
At MDA-West we have VAX and HPUX with RDBMS
versions 6.0.34 and 6.0.36 in production and
version 7.0.15 in test. We are using
Forms, Menus, Reportwriter.
Date: Thu, 12 May 1994 15:09:06 EST5EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Ross Greenberg <ROSS_at_UMS1.LAN.MCGILL.CA> Organization: McGill University Subject: Roles, Privileges, and Creating Stored Objects
As I understand it, using roles is a good thing; you assign the necessary system and object privileges to a role ("CLERK" or "EXECUTIVE") and then grant the role to the users who currently require it.
At the same time, tools like Oracle Databrowser recommend, even *require* that each user be able to create views; Databrowser tries to create a view matching each stored query, so that it can be used as a data source for other queries. In fact this is the only way to do complex queries with subqueries.
But: ORA-01933: cannot create a stored object using privileges from a role. Therefore each Databrowser user must be granted all access rights directly. Am I missing something? Thank for comments or advice.
Ross Greenberg Tel: (514)-398-4423 Senior Project Manager Fax: (514)-398-4758 Information Systems Resources Internet: ross_at_ums1.lan.mcgill.ca McGill University Montreal, Quebec, Canada H3A 2T5 ========================================================================= Date: Fri, 13 May 1994 08:52:43 CDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gigi Suardi <gigi_at_SOFTINT.COM> Subject: powerbuilder and TCP
hi oracle-l,
is anybody out there using Powerbuilder through TCP/IP
to access Oracle from a PC client?
we do not have any problem going through DECNET.
what needs to be different to use TCP?
is the same DLL (ora6win) ok? do we need sqldnt?
thanks for any help.
later.
luigi.
we have to learn the language of Nature
to be able to understand her.
Hundertwasser
=========================================================================
Date: Fri, 13 May 1994 10:03:08 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: James Payne <jpayne_at_DITALIX.COAT.COM>
Subject: Oracle in NW Connecticut
Ok, I know this has no bearing on most or all of you, but...
I'm pondering moving to northwestern CT, one of the most beautiful spots on earth (your mileage may vary).
The only thing is, is this... I don't know of any tech- nical recruiters or Oracle shops up there.
Do any of you?
I'm looking in the Torrington-Danbury-Hartford region, I guess. Torrington would be best.
I have 5+ years with Oracle (6, but I've read the 7 docs) as well as 2 with c/Pro*c. Oh, and 3 years VAX/VMS.
Help?
Thank you... please respond backchannel.
James Payne
Date: Fri, 13 May 1994 12:51:59 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gary Nystrom <GARY_NYSTROM_at_DSC.UMICH.EDU> Subject: Roles, Privileges, and CreatingIn-Reply-To: The letter of Friday, 13 May 1994 3:25am ET
We have found this to be true. In order to create a view the user must be granted select on the table directly, not via a role. Roles have been helpful to us, except for this situation. We have some vendor code on ID card issuing stations which creates views and we have had to grant select on those tables directly to the operators' Oracle IDs. Select authority on other tables still comes from the role we set up for the operator IDs.
I have not heard the reasoning behind it, and I haven't taken the time to think it through. Maybe someone could shed some light on the subject. But as far as creating views, we're back to Oracle 6 user administration schemes.
Date: Fri, 13 May 1994 10:12:49 CDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Dan Howard <dan133_at_SILICON.RELAY.UCM.ORG>
Hello All-
With all the latest discussion on PowerBuilder, can anyone out there
recommend a good source of training material or documentation for a new
PB programmer? I haven't seen any commercially available books on the
subject yet. Anyone found any good materials??
Thanks,
Dan
Date: Fri, 13 May 1994 14:30:25 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Jennifer R. Amon (216) 775-6987" <BAMON_at_OCVAXC.CC.OBERLIN.EDU> Subject: Re: Roles, Privileges, and Creating Stored Objects
>As I understand it, using roles is a good thing; you assign the
>necessary system and object privileges to a role ("CLERK" or
>"EXECUTIVE") and then grant the role to the users who currently
>require it.
>
>At the same time, tools like Oracle Databrowser recommend, even
>*require* that each user be able to create views; Databrowser tries to
>create a view matching each stored query, so that it can be used as a
>data source for other queries. In fact this is the only way to do
>complex queries with subqueries.
>
>But: ORA-01933: cannot create a stored object using privileges from a
>role. Therefore each Databrowser user must be granted all access
>rights directly. Am I missing something? Thank for comments or
>advice.
No, you are not missing anything, and yes, it's a pain in the neck.
We have granted direct select privilege to our users for all tables, while all update, etc. privileges are granted via roles. This way, we can also enable roles in our applications, i.e. forms, Pro*C programs, etc. and the user's default privileges are for select only. That way, even the users with SQL access can't hurt anything, and they can create the views they need for our Natural Language ad hoc query tool.
Oracle has not yet provided an explanation for this restriction that satisfies me. The explanation I heard had something to do with the difficulty of tracking privileges that could be granted recursively and from multiple sources.
J. Amon
bamon_at_ocvaxc.cc.oberlin.edu
Date: Fri, 13 May 1994 15:46:07 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Iraida Becerra <ICBHC_at_CUNYVM.BITNET> Subject: Forms4 Text Book
Could anyone recommend me some text books for ORCACLE/FORMS4.
Thank you,
Iraida
Date: Fri, 13 May 1994 14:01:04 MDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Margaret Ausen <MAUSEN_at_VM.UCS.UALBERTA.CA>
Subject: Case Dictionary: AutoGen option
We're developing (permanently, it seems) many applications, and
I've run across a feature I can't find a definite explanation for.
It's the 'Sequence within Parent' option, within the Automatically
Generated feature on page 2 of the Column Definition screen in
Case Dictionary.
It looks like something I'd like to use..if only I knew what it did. The only explanation I've found on the screen, in the manuals, in the course notes is that it's 'An indicator showing whether or not this is to be automatically generated. [List] is available for this field.' Does anyone know how it works, or can perhaps at least point me toward some more definitive documentation??
Thank you!
Date: Fri, 13 May 1994 16:13:24 PDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Peter Kane <pkane_at_CISCO.COM>
Subject: Re: Case Dictionary: AutoGen option
In-Reply-To: <199405132241.PAA17348_at_hubbub.cisco.com>; from "Margaret Ausen"
at May 13, 94 2:01 pm
I just got out of a case class today, and we used this. "Sequence within parent" creates a sequence, similar to the normal sequences, but in this case the sequence is tied to the master table in a master-detail relationship (i.e., "sequence within parent" only makes sense for the detail table within a master-detail relationship).
If the two tables are as follows:
header
po_num (primary key)
customer
detail
po_num (foreign key from header)
line_num (primary key)
then you can have data like:
header
po customer
1 xerox
2 ibm
detail
po line_num
1 1
1 2
1 3
2 1
2 2
where the line_num starts over again at 1 when the foreign key changes. So, the sequence only exists within the parent, and it's called "sequence within parent."
> We're developing (permanently, it seems) many applications, and
> I've run across a feature I can't find a definite explanation for.
> It's the 'Sequence within Parent' option, within the Automatically
> Generated feature on page 2 of the Column Definition screen in
> Case Dictionary.
> It looks like something I'd like to use..if only I knew what it
> did. The only explanation I've found on the screen, in the manuals,
> in the course notes is that it's 'An indicator showing whether
> or not this is to be automatically generated. [List] is available
> for this field.' Does anyone know how it works, or can perhaps
> at least point me toward some more definitive documentation??
> Thank you!
>
Date: Sat, 14 May 1994 16:42:01 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: James Blackwell <JMB4_at_DELPHI.COM> Subject: Oracle Database Mailing List
Please stop sending me messages. I don't know how this all began, but please do not send me any more messages. Thank you very much. Jim Blackwell
Date: Mon, 16 May 1994 12:02:36 +0100 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Lex Sijtsma <lex_at_PYTHON.KONBIB.NL> Subject: Powerbuilder and Oracle
Some time ago i asked about using Powerbuilder and Oracle. Many thanks for the replies. This time i want to ask something about the network specifics of working with PB and Oracle.
We have a multi-protocol environment on our PC supporting TCP/IP, IPX and Netbios. We want to connect to a Oracle database via TCP/IP using an application generated with Powerbuilder.
Question: What do i need on the client/server side. Does it work with our IP-stack without extra software? Please distinguish two situations:
Thanx in advance.
Date: Mon, 16 May 1994 07:40:54 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Beverly Norwood <csvbcn_at_ADMIN.AC.EDU>
Subject: Re: powerbuilder and TCP
In-Reply-To: <9405131849.AA37436_at_admin.ac.edu>; from "Gigi Suardi" at May 13,
94 8:52 am
We at Augusta College are using Powerbuilder installed on a 3-Com network. We installed FTP's TCP/IP, Trumpet Winsock, and SQLNet on the network in order to access our 6.0.34 database on an RS6000 and a 7.0.13 database on a Sun Sparc4. We used the ora7win.dll.
>
> hi oracle-l,
>
> is anybody out there using Powerbuilder through TCP/IP
> to access Oracle from a PC client?
> we do not have any problem going through DECNET.
> what needs to be different to use TCP?
> is the same DLL (ora6win) ok? do we need sqldnt?
> thanks for any help.
> later.
>
> luigi.
>
Beverly Norwood, Systems Manager
Augusta College
(706) 737-1484 or GIST 337-1484
Internet: bnorwood_at_admin.ac.edu
Date: Mon, 16 May 1994 07:44:34 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Paul Dorsey <DORSEY_at_RIDER.BITNET> Subject: Re: Powerbuilder and Oracle
You will need SQL*net in either case. There may be other products that will do the same function (or you can write your own) but you need to have some way to have a virtual Oracle instance on the client side. SQL*NET will take care of all the netork bundeling for you.
Be sure to get SQL*NET on both the client and server side for your specific netowrk protocol.
(I have not hooked PB apps to Oracle so PB may have its own solution,
but I really doubt it.)
Paul Dorsey
Rider U
Date: Mon, 16 May 1994 08:52:00 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "tauler,juan" <$J2T_at_PCCJES2.BITNET> Subject: powerbuilder with oracle
To those who are using Powerbuilder with Oracle:
Do I need to have an Oracle instance on the Pc in order to access the server on the Mainframe, via SQL*Net or Decnet ?
Can I access the Server using PB without having Oracle on the client ?
Date: Mon, 16 May 1994 09:02:04 -0500
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Danny Dills <danny_dills_at_OIT.PEACHNET.EDU>
Subject: Re: powerbuilder with oracle
Reply to: RE>powerbuilder with oracle
No, it my understanding all you need on the PC is the PB products,
Oracle's SQL*NET TCP/IP and a supported TSR TCP/IP kernel such as PC/NFS from
SUN or FTP Inc PC/TCP. If your net work is TCP/IP?
with BSMTP id 4821; Mon, 16 May 94 08:55:54 EDT
Received: from UGA.CC.UGA.EDU (NJE origin LISTSERV_at_UGA) by UGA.CC.UGA.EDU
(LMail V1.1d/1.7f) with BSMTP id 1558; Mon, 16 May 1994 08:55:53 -0400
Date: Mon, 16 May 1994 08:52:00 EDT
Reply-To: "ORACLE database mailing list."
<ORACLE-L%SBCCVM.BITNET_at_UGA.CC.UGA.EDU>
Sender: "ORACLE database mailing list." <ORACLE-L%SBCCVM.BITNET_at_UGA.CC.UGA.EDU>
From: "tauler,juan" <$J2T%PCCJES2.BITNET_at_UGA.CC.UGA.EDU>
Subject: powerbuilder with oracle
To: Multiple recipients of list ORACLE-L
<ORACLE-L%SBCCVM.BITNET_at_UGA.CC.UGA.EDU>
To those who are using Powerbuilder with Oracle:
Do I need to have an Oracle instance on the Pc in order to access the server on the Mainframe, via SQL*Net or Decnet ?
Can I access the Server using PB without having Oracle on the client ?
Date: Mon, 16 May 1994 08:03:01 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: DIPESA_at_CARLA.MIT.EDU Subject: windows-based case tools
Does anyone out there have experience using any of the following windows-based case tools with Oracle7?
ERWin/ERX
Silverrun
S-Designor
Visible Analyst Workbench
Date: Mon, 16 May 1994 09:33:00 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "tauler,juan" <$J2T_at_PCCJES2.BITNET> Subject: Client/Server Tools
I would like to know if anyone is using:
VisualWorks from ParcPlace Systems
Parts Workbench for OS/2 from Digitalk Inc,
VisualAge from IBM
I am particulary interested in information about using these products with:
Client being an IBM pc using Oracle7 (os/2) Server being an MVS mainframe.
Middleware : sql*net, TCP/IP, DECNET
Any information would be greatly appreciated.
Juan S Tauler
Parklawn Computer Center,
(301) 443-1416
Date: Mon, 16 May 1994 09:34:34 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Leonardo Fernandez <lfernand_at_ve.oracle.com>"
<lfernand_at_VE.ORACLE.COM>
Subject: Fwd: deadlock
Please,
What was the solution ?
I sent a mail and I did not get any aswers about it ...
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
Received: 05-09-94 23:38 Sent: 05-09-94 23:33From: VESUN1:owner-oracle-l_at_CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L ORACLE-L_at_CCVM.SUNYSB.EDU Subject: deadlock
What causes the deadlock in the following? How do I fix it?
SQL*DBA: Version 6.0.36.7.1 - Production on Mon May 9 20:02:49 1994
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
ORACLE RDBMS V6.0.36.7.1, transaction processing option - Production PL/SQL V1.0.36.2.2 - Production
ORACLE instance started.
Database mounted.
ORA-00060: deadlock detected while waiting for resource
Attempting to dismount database........Database dismounted.
Attempting to shutdown instance........ORACLE instance shut down.
SQL*DBA complete.
Database "ludb" warm started.
Date: Mon, 16 May 1994 11:03:39 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Leonardo Fernandez <lfernand_at_ve.oracle.com>"
<lfernand_at_VE.ORACLE.COM>
Subject: Problems with CALLQRY
Hi oracle-l,
I have a customer that converted forms V2.3 to V3.0., Aprox. 250
forms.
The application makes the following :
Form1 call main-menu
main-menu call a Form2
And when ...
Form2 calls a Form3 ( With the function CALLQRY(2.3) and does not
return at the previuos item of the main_menu ).
Form2 call a Form3 ( With the function CALL_QUERY(3.0), returns
at the previuos item of the main_menu
perfectly ).
Any suggestions or advices will be wellcome ...
Thanks ,
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
=========================================================================
Date: Mon, 16 May 1994 13:29:47 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Jim Foley <JFOLEY_at_BENTLEY.BITNET>
Subject: Re: Problems with CALLQRY
Lenardno,
You need to increase the savepoints parameter in your INIT.ORA file. We had this problem and increase the savepoints from the default of 5 to 24 and the problem went away. Savepoints are discussed in the SQL*FORMS 3.0 Designer's Reference in chapter 3. I hope that this helps.
Jim Foley
Manager of Data Administration
Bentley College
Waltham, MA 02154-4705
(617)891-3419
JFOLEY_at_BENTLEY.EDU
Included text:
Hi oracle-l,
I have a customer that converted forms V2.3 to V3.0., Aprox. 250
forms.
The application makes the following :
Form1 call main-menu
main-menu call a Form2
And when ...
Form2 calls a Form3 ( With the function CALLQRY(2.3) and does not
return at the previuos item of the main_menu ).
Form2 call a Form3 ( With the function CALL_QUERY(3.0), returns
at the previuos item of the main_menu
perfectly ).
Any suggestions or advices will be wellcome ...
Thanks ,
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
=========================================================================
Date: Mon, 16 May 1994 14:40:00 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "durairaj,pattu" <$PZD_at_PCCJES2.BITNET>
Subject: Re: Client/Server Tools
DOES IT MAKE ANY DIFFERENCE WHETHER YOUR SERVER IS A MAINFRAME OR A MINI? NICE GOING. GOOD LUCK.
------------------------------TEXT-OF-YOUR-MAIL--------------------------------
> Received: (from MAILER_at_GWUVM for $PZD_at_PCCJES2 via NJE)
> (UCLA/Mail V1.500 M-RSCS1029-1029-27); Mon, 16 May 94 09:36:30 EDT
> Received: from GWUVM.GWU.EDU by GWUVM.GWU.EDU (Mailer R2.10 ptf000) with BSMTP
> id 4037; Mon, 16 May 94 09:35:50 EDT
> Date: Mon, 16 May 1994 09:33:00 EDT
> Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> From: "tauler,juan" <$J2T_at_PCCJES2.BITNET>
> Subject: Client/Server Tools
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_SBCCVM.BITNET>
>
> I would like to know if anyone is using:
>
> VisualWorks from ParcPlace Systems
> Parts Workbench for OS/2 from Digitalk Inc,
> VisualAge from IBM
>
> I am particulary interested in information about using these products with:
>
> Client being an IBM pc using Oracle7 (os/2)
> Server being an MVS mainframe.
>
> Middleware : sql*net, TCP/IP, DECNET
>
> Any information would be greatly appreciated.
>
> Juan S Tauler
> Parklawn Computer Center,
> (301) 443-1416
Date: Mon, 16 May 1994 14:45:00 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "durairaj,pattu" <$PZD_at_PCCJES2.BITNET> Subject: Re: powerbuilder with oracle
Juan,
Whenever you say client/server it automatically implies distributed processing
or distributed databases. To process data ona client you need oracle on your
PC. The answer is yes. You will need oracle instance on PC. Otherwise
you do not need SQL*Net at all.
------------------------------TEXT-OF-YOUR-MAIL--------------------------------
> Received: (from MAILER_at_GWUVM for $PZD_at_PCCJES2 via NJE)
> (UCLA/Mail V1.500 M-RSCS9375-9375-15); Mon, 16 May 94 08:54:24 EDT
> Received: from GWUVM.GWU.EDU by GWUVM.GWU.EDU (Mailer R2.10 ptf000) with BSMTP
> id 3165; Mon, 16 May 94 08:53:52 EDT
> Date: Mon, 16 May 1994 08:52:00 EDT
> Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> From: "tauler,juan" <$J2T_at_PCCJES2.BITNET>
> Subject: powerbuilder with oracle
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_SBCCVM.BITNET>
>
> To those who are using Powerbuilder with Oracle:
>
> Do I need to have an Oracle instance on the Pc in order to access the server
> on the Mainframe, via SQL*Net or Decnet ?
>
> Can I access the Server using PB without having Oracle on the client ?
Date: Mon, 16 May 1994 17:26:41 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Tom Griffin <tgriffin_at_SCTLRS2.SCTCORP.COM> Subject: Visual Basic Pro and Oracle 7
Does anyone have information on accessing an Oracle 7 server using Visual Basic Pro v 3.0 and SQL*Net v 2? That is, does it work and, if so, what does it take? I have the ORA7WIN.DLL ODBC driver but VB refuses to connect. The folks at Microsoft don't seem to have alot of ideas.
TIA --
/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
/ Tom Griffin Internet: tgriffin_at_sctcorp.com /
/ Technical Specialist Phone: 606-277-1500 x225 /
/ SCT Public Sector, Lexington KY Fax: 606-277-2300 /
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=========================================================================
Date: Mon, 16 May 1994 18:30:00 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Eclipse Technology Inc." <0006410539_at_MCIMAIL.COM>
Subject: Executing "Print" from SQL*FORMS 4.0
Greetings,
We have an application which executes a windows program from the menu under Forms 4.0.12 under Windows 3.1. The program creates a log file which we then want to offer the option to print using Windows print manager. We can connect to the print manager just fine.....but all we get is blank paper! The file we try to send to the que never seems to get there?
We are running a client/server application where the server is Oracle 7.0.15.4 under Solaris 2.3 using TCP to connect an IBM compatible with SUN PC-NFS v.5. We want to avoid using "host" to DOS "PRINT" commands.
Any ideas from Windows gurus would be appreciated.
Regards,
Powel Crosley
Eclipse Technology, Inc.
6410539_at_mcimail.com
Date: Mon, 16 May 1994 20:55:52 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Paul Dorsey <DORSEY_at_RIDER.BITNET> Subject: Re: powerbuilder with oracle
You do not need Oracle on the client, but you do need SQL*net on the
client.
Paul Dorsey
Rider U
Date: Mon, 16 May 1994 21:04:27 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Paul Dorsey <DORSEY_at_RIDER.BITNET> Subject: Re: powerbuilder with oracle
You DEFINATELY do NOT need Oracle on the client side. ONLY if you want
to STORE data at the client will you need Oracle locally. Otherwise,
all you need is SQL*Net.
Paul Dorsey
Rider U
P.S. The other responder was right, you do also need the TCPIP (or whatever)
kernal. Actually though, I am not sure about that. I thought that
SQL*Net took over for the TCPIP software at the client so that it ws no
longer necessary. I haven't done an install of SQL*Net in 4 months
so I might be remembering wrong. (Try it both ways.)
Date: Tue, 17 May 1994 10:42:16 CET Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Buergi Josef <nbuejo_at_HASLER.ASCOM.CH> Subject: HOST command
Hello
I am developping a client/server application (DOS/VMS) using SQL*Forms 3.0, ORACLE version 6.0 (on both sides). So I wrote a help-engine in C++, and call it by the HOST-command with passing parameters.
DOS HOST('CCM_HLP.EXE [help-file] [window-title]');
This works fine, but I didn't find out how to put environment-variables into that string, f.e
HOST('%CCM_D%\CCM\CCM_HLP.EXE %CCM_D%\CCM\[help-file] [Window-title]')
The DOS-varible %CCM_D% won't be read and substituted! What's wrong ?
Does anybody has a workaround about this or any idea ????
Please reply direct to my eMail address!
Regards Joseph Buergi
Ascom Ericsson Transmission AG
Switzerland
eMail NBUEJO_at_HASLER.ASCOM.CH
Date: Tue, 17 May 1994 10:00:30 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "L. Carl Pedersen" <L.Carl.Pedersen_at_DARTMOUTH.EDU>
Subject: SUMMARY: Re: char vs varchar2 space usage,
Re: Surprising aspects of comparisons to CHAR fields.
recently, i posted two messages about char vs varchar2 in oracle 7. in one i asked whether char was more efficient than varchar2 for values that were always the same length and/or short. in the other, i described some "surprising" aspects of comparisons to char values.
i received a number of replies to both messages, but none of them cited any authoritative references, aside from the ANSII standard for SQL-92. more than one person opined i was right about efficiency, but presented no convincing evidence.
on the issue of efficiency, i eventually decided to do some testing on my own. i created two tables with about 200000 rows and one column containing more or less randomly distributed single-character values. one of the tables defined it as a char. the other as a varchar2(1). by looking at segments and counting blocks, the two tables were identical in size. counting rows where the column was equal to a particular value took the same amount of time (etc.) for both tables (within random variation). counting all distinct values using a "group by" took the same time for both tables.
thinking that perhaps overhead was dominating, i created a similar table with 5 columns. the results were the same. it's possible results would vary in more complex situations. i didn't try indexing, for example. if anyone has any data that shows a material difference in some cases, let's see it. (don't forget to repeat every test at least twice to compensate for caching effects.)
i am beginning to suspect that oracle is actuallu storing the length, even for char values, so that there is no difference in efficiency either in space or time. if anyone has any really solid evidence on way or another on this, i'd like to see it.
regarding the "surprising" behavior i noted, i am embarrassed to say it is documented in the SQL language reference manual.
i think oracle corp. got into a box on this issue. the varchar2 type and decode are not part of the standard. hence, you would think oracle would have the freedom to make less-surprising choices in these areas. however, the standard requires blank-padded compares on two literals. for example:
where 'A' = 'A '
this is *true* according to the standard. in order to follow this, which they did, oracle made all text literals type "char" (not varchar2 as you might expect). so, how about:
where foobar = 'A '
assuming foobar was assigned a single-character 'A', then the above is supposed to be true when foobar is a char and false when foobar is a varchar2. since the literal is a char, oracle was forced into saying that the padded-comparisons would be used only when *both* operands were char (not varchar2).
the decode is a separate issue. i think they decided to use non-padded compares on decode just because they obviously prefer to do it that way. it is documented, anyway.
my conclusion, in all this, is that the only advantages to using char are that:
by "some cases", i mean those where the values are truly always the same length, e.g., a social-security-number. when i say "more clear", i'm talking about the human-readability of the code. that is, for a human, it makes more sense to use char for an ssn, instead of varchar, since varchar implies vairability and an ssn doesn't actually vary in length. the value of this is similar to the value of an unenforced constraint in oracle 6.
i have concluded that it's dangerous to use char is those cases where the values might have trailing spaces, especially if they are being using in a system that also has varchar2 values.
Date: Tue, 17 May 1994 10:21:48 -0500
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: TOM MERCADANTE <MERCADTF_at_SNYPLAVA.BITNET>
Organization: SUNY at Plattsburgh, New York, USA
Subject: Re: SUMMARY: Re: char vs varchar2 space usage,
Re: Surprising aspects of comparisons to CHAR fields.
Date sent: 17-MAY-1994 10:16:57
Hello All,
I want to thank L.Carl for his research and report on this issue. To be honest, I did not give a thought to using CHAR variable types after we converted to Oracle7. Since the convert process changed everying to VARCHAR2, we have been happy to use them.
While Carl reports no differences in querying things from these variable types, we have noticed a definite difference when populating tables that have CHAR datatype rather than VARCHAR2 datatypes.
We noticed that SQR programs that created temporary tables (that we missed converting when we changed to Oracle7) ran *forever* with CHAR datatypes.
When we changed the program to VARCHAR2, they completed inm the normal amount of time.
I can only assume that Oracle7 was busy padding each field with spaces while an insert was occuring.
Anyway, thanks again Carl.
Tom
>
>recently, i posted two messages about char vs varchar2 in oracle 7. in one i
>asked whether char was more efficient than varchar2 for values that were
>always the same length and/or short. in the other, i described some
>"surprising" aspects of comparisons to char values.
>
>i received a number of replies to both messages, but none of them cited any
>authoritative references, aside from the ANSII standard for SQL-92. more
>than one person opined i was right about efficiency, but presented no
>convincing evidence.
>
>on the issue of efficiency, i eventually decided to do some testing on my
>own. i created two tables with about 200000 rows and one column containing
>more or less randomly distributed single-character values. one of the tables
>defined it as a char. the other as a varchar2(1). by looking at segments
>and counting blocks, the two tables were identical in size. counting rows
>where the column was equal to a particular value took the same amount of time
>(etc.) for both tables (within random variation). counting all distinct
>values using a "group by" took the same time for both tables.
>
>thinking that perhaps overhead was dominating, i created a similar table with
>5 columns. the results were the same. it's possible results would vary in
>more complex situations. i didn't try indexing, for example. if anyone has
>any data that shows a material difference in some cases, let's see it.
>(don't forget to repeat every test at least twice to compensate for caching
>effects.)
>
>i am beginning to suspect that oracle is actuallu storing the length, even
>for char values, so that there is no difference in efficiency either in space
>or time. if anyone has any really solid evidence on way or another on this,
>i'd like to see it.
>
>regarding the "surprising" behavior i noted, i am embarrassed to say it is
>documented in the SQL language reference manual.
>
>i think oracle corp. got into a box on this issue. the varchar2 type and
>decode are not part of the standard. hence, you would think oracle would
>have the freedom to make less-surprising choices in these areas. however,
>the standard requires blank-padded compares on two literals. for example:
>
> where 'A' = 'A '
>
>this is *true* according to the standard. in order to follow this, which
>they did, oracle made all text literals type "char" (not varchar2 as you
>might expect). so, how about:
>
> where foobar = 'A '
>
>assuming foobar was assigned a single-character 'A', then the above is
>supposed to be true when foobar is a char and false when foobar is a
>varchar2. since the literal is a char, oracle was forced into saying that
>the padded-comparisons would be used only when *both* operands were char (not
>varchar2).
>
>the decode is a separate issue. i think they decided to use non-padded
>compares on decode just because they obviously prefer to do it that way. it
>is documented, anyway.
>
>my conclusion, in all this, is that the only advantages to using char are
>that:
>
> 1) it's more standard
>
> 2) it may be more clear in some cases
>
>by "some cases", i mean those where the values are truly always the same
>length, e.g., a social-security-number. when i say "more clear", i'm talking
>about the human-readability of the code. that is, for a human, it makes more
>sense to use char for an ssn, instead of varchar, since varchar implies
>vairability and an ssn doesn't actually vary in length. the value of this is
>similar to the value of an unenforced constraint in oracle 6.
>
>i have concluded that it's dangerous to use char is those cases where the
>values might have trailing spaces, especially if they are being using in a
>system that also has varchar2 values.
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % % % Tom Mercadante % % Database Administrator % % SUNY Plattsburgh % % % % BITNET : MERCADTF_at_SNYPLAVB.BITNET % % INTERNET : MERCADTF_at_SPLAVA.CC.PLATTSBURGH.EDU Computer Systems Center % % PHONE : (518)564-3013 Kehoe 507 % % Plattsburgh, NY 12901 % % % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ========================================================================= Date: Tue, 17 May 1994 08:23:12 -0600 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Scott Fehr <scottf_at_APLDSS.APL.CUL.CA> Subject: PL/SQL
Does anyone know if it's possible to have a stored PL/SQL procedure or database trigger execute another program? For example, would it be possible in Oracle 7 to have a database trigger execute a runform command that would bring up a particular form whenever someone tried to insert a record on a given table?
Any insight appreciated.
Scott
scottf_at_apldss.apl.cul.ca
Date: Tue, 17 May 1994 11:12:07 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Betty Page (SSD)" <bpage_at_CENSUS.GOV> Subject: Oracle Case Tools
Our area is considering using Oracle's Case Tools for all database
application development. I would like to hear from people who are
using Oracle's Case in a production environment.
Please send to me directly.
bpage_at_census.gov
TIA
Date: Tue, 17 May 1994 10:51:02 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Chad A. Tompkins" <tompkinc_at_SPACENET.COM> Subject: SQL*Net SPX/IPX and HP-UX
We are considering purchasing SPX/IPX for our HP-UX hosts so we don't have to put TCP/IP drivers on all our Windows clients.
Does anyone out there have any experiences (good or bad) with using Oracle7 via SPX/IPX with Unix or anything host other than a Novell NLM?
Thanks in advance,
Chad
--
Chad A. Tompkins, Programmer II GTE Spacenet
Voice : 703-848-0121 1700 Old Meadow Road
Internet: tompkinc_at_spacenet.com McLean, Va 22102 U.S.A.
=========================================================================
Date: Tue, 17 May 1994 11:42:12 U
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Steve Quigley <squigley_at_SCTCORP.COM>
Subject: Images
Images
Date: Tue, 17 May 1994 12:38:05 CDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Tony Cillo <applmgr_at_VTPLACE.IDDE.SACI.ORG> Subject: Tablespaces
Is there any way through a sql job or such that will tell me what objects are in a particular tablespace?
TIA Tony
Date: Tue, 17 May 1994 12:42:01 CDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Steve Bailey <a0459970_at_SHHP827.DSEG.TI.COM>
Subject: Re: SQL*Net SPX/IPX and HP-UX
In-Reply-To: <199405171700.MAA24282_at_lobby2b.ti.com>; from "Chad A. Tompkins"
at May 17, 94 10:51 am
Yes, I have experience using SQL*Net TCP/IP on an HP-UX machine where PC Clients using Microsoft Lanman (Windows) are connecting to Oracle. We have had nothing but problems. Of course, we are using SQL*Net V1 (we plan to upgrade soon, unless we find a better solution than using Oracle*Forms and SQL*Net).
Here are some of the problems:
NETTCP - Message Receive Failure
NETTCP - Message Send Failure
We generally receive these errors when logging onto Oracle from the PC. I have worked with Oracle support and tried everything except changing the light bulbs in my office. Eventually Oracle support finally stopped calling me.
3) It is slow. PCs are not fast compared to our Oracle server.
>
> We are considering purchasing SPX/IPX for our HP-UX hosts so we don't have
> to put TCP/IP drivers on all our Windows clients.
>
> Does anyone out there have any experiences (good or bad) with using
> Oracle7 via SPX/IPX with Unix or anything host other than a Novell NLM?
>
> Thanks in advance,
> Chad
>
> --
> Chad A. Tompkins, Programmer II GTE Spacenet
> Voice : 703-848-0121 1700 Old Meadow Road
> Internet: tompkinc_at_spacenet.com McLean, Va 22102 U.S.A.
--
Thanks
Steven J. Bailey - 459970 Texas Instruments
Telephone: 903-868-5018 Fax: 903-868-7240
Pager: 7570 Internet: sbailey_at_lobby.ti.com
IMS MSG ID: SJBA MS 860 HWY 75 South Box 84, Sherman TX 75090
*****************************************************************************
=========================================================================
Date: Tue, 17 May 1994 11:26:53 PST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Comments: Converted from PROFS to RFC822 format by PUMP V2.2X
From: "Leo de Sousa Phone:(604) 432-8629 Fax:(604) 439-6785"
<DSOL2935_at_BCIT.BC.CA>
Subject: CRT and CRTBOX Definitions for IBM3161
From: Leo de Sousa Phone:(604) 432-8629 Fax:(604) 439-6785
Systems Analyst - Computer Resources
British Columbia Institute of Technology
We have a requirement to allow IBM3161 terminals to access ORACLE applications.
Does anyone have the CRT and CRTBOX definitions they can send me? I don't feel like reinventing the wheel!!
Thank you very much in advance,
Leo de Sousa
CMS: DSOL2935 Internet: DSOL2935_at_bcit.bc.ca
Date: Tue, 17 May 1994 14:55:02 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Bob Belt <bbelt_at_SCTLRS2.SCTCORP.COM> Subject: Forms40 FRM-40035
Been getting the FRM-40035 'error creating per-block record manager context' when attempting to run a successfully generated form in character mode.
Puzzle is that this same form generates and run in windows with no problem.
We are running 7.0.15 on an RS/6000 with Forms 4.0.11 and Windows Forms 4.0.12.1.10 on client PCs. Have more than a hundred forms without seeing this particular error. Documentation not too helpful on this. Some in Chap 2 of Forms User's Guide is all.
Any help solving would be appreciated.
Thanks in advance,
--
+---------------------------------------------------------------+
| Bob Belt |
| SCT Public Sector e-mail: bbelt_at_sctcorp.com |
| 1733 Harrodsburg Road phone: (606) 277-1500 |
| Lexington, KY 40504-3617 fax: (606) 277-2300 |
+---------------------------------------------------------------+
=========================================================================
Date: Tue, 17 May 1994 14:43:00 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Al Sommar <Al_Sommar+aIS+aKoP%Elf_Atochem_at_MCIMAIL.COM>
Subject: Oracle Position (PA)
Senior Programmer/Analyst ORACLE Position Available
=====================================================
Elf Atochem North America is a major producer and marketer of chemical
and plastic products. We currently have an opening for an experienced
Programmer/Analyst for our scientific computing environment located at our
King of Prussia R&D center (suburban Philadelphia).
Requirements for this position include experience in project management, ORACLE 6 or 7 programming (especially SQL*Forms) preferably in a scientific or chemical environment. Additional experience in any of the following would be a plus: VAX/VMS, Unix, C programming, Banyan VINES LAN, and CASE tools.
Elf Atochem offers an excellent salary and a comprehensive benefits program. For immediate consideration, please send your resume with salary requirements to:
Manager of Employment OR Scott Gould
Elf Atochem NA Mgr., Scientific Systems
2000 Market Street INTERNET: 576-7144_at_MCImail.com
Philadelphia, PA 19103 COMPUSERVE: 72410,1315
FAX: 610-337-6784
=========================================================================
Date: Tue, 17 May 1994 17:19:55 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: James Payne <jpayne_at_DITALIX.COAT.COM>
Subject: Forms3.0 user exits
Say,
Is there a limit to the size of a field that may be passed from a form to a user exit? I'm using a long, 240 characters seems to be ok but 2400 doesn't seem to, unless there's something else weird lurking in my code (which isn't completely unreasonable to assume).
I'm using EXEC IAF GET to move the data.
Thanks...
James O. Payne, Jr. jpayne_at_coat.com
Completely Expendable Semi-Skilled Minor Functionary
Burlington Coat Factory Warehouse (609)387-7800x2582
1830 Rt. 130 North
Burlington, NJ 08016 This space for rent
====================================================================
=========================================================================
Date: Tue, 17 May 1994 17:31:31 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Teresa A Larson <larson_at_SLED.GSFC.NASA.GOV>
Subject: Re: Tablespaces
In-Reply-To: <9405172115.AA13950_at_sled.gsfc.nasa.gov> from "Tony Cillo" at May
17, 94 12:38:05 pm
>
> Is there any way through a sql job or such that will tell me what objects are
> in a particular tablespace?
>
>
You can query the system tables to find out all kinds of things, including what is stored where. Following is a query I frequently run to find out what user objects are stored where:
BREAK ON tablespace_name SKIP 2;
COMPUTE SUM OF used_blocks ON tablespace_name;
COMPUTE SUM OF used_bytes ON tablespace_name;
SELECT tablespace_name, segment_name, segment_type seg_type, extents,
SUM(bytes) used_bytes, SUM(blocks) used_blocks
FROM user_segments
This will return both the object name and it's type (i.e., index, table) amongst other things. Hope it helps.
Teresa Larson
--
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
| Teresa A. Larson - Hughes STX Corporation |
| NASA/GSFC Code 933.0 voice: (301) 286-7867 |
| Greenbelt, Maryland 20771 fax: (301) 286-1777 |
| larson_at_sled.gsfc.nasa.gov |
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
=========================================================================
Date: Tue, 17 May 1994 14:35:20 -0700
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Al Lau <allau_at_SEQUENT.COM>
Subject: Re: Tablespaces
In-Reply-To: <9405172116.AA29929_at_gateway.sequent.com> from "Tony Cillo" at May
17, 94 12:38:05 pm
When you look in the user_tables table, the second column is the tablesapce name this table is in.
Hope this is what you're looking for.
>
> Is there any way through a sql job or such that will tell me what objects are
> in a particular tablespace?
>
>
> TIA
>
> Tony
>
--
Al Lau Sequent Computer Systems, Inc.
allau_at_sequent.com 15450 SW Koll Parkway +----+
Software Engineer Beaverton, OR 97006 | #|
Phone: (503) 578-4063 | |
Standard disclaimers apply Fax: (503) 578-9890 +----+
=========================================================================
Date: Tue, 17 May 1994 14:34:54 -0700
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Ernest Simard <SIMARD_at_SONOMA.EDU>
Subject: Re: Tablespaces
SELECT TABLE_NAME,OWNER FROM DBA_TABLES WHERE TABLESPACE_NAME='name';
If thats not what your after peruse the DBA_xxxxx tables in appendix E of the DataBase Guide (v6) or appendix B of the Admin Guide (v7).
Good Luck
Ernie
Date: Tue, 17 May 1994 15:48:23 MDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Vijay V." <db1_at_COMAGIC.MNET.USWEST.COM>
Subject: Re: Tablespaces
In-Reply-To: <199405172115.AA19847_at_uswat.advtech.uswest.com>; from "Tony
Cillo" at May 17, 94 12:38 (noon)
>
> Is there any way through a sql job or such that will tell me what objects are
> in a particular tablespace?
>
>
> TIA
>
> Tony
>
Hai Tony,
You can find out what objects are there in a given tablespace by running
this query with sys account.
select ts$.name ts_name,
obj$.name obj_name,
decode(obj$.type, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY',
12, 'TRIGGER', 'UNDEFINED') obj_type
from ts$,obj$ where obj$.namespace = ts$.ts#
order by 1,3
please let me know if it solves your problem.
my address is db1_at_comagic.mnet.uswest.com
Good luck.
Vijay.
Date: Tue, 17 May 1994 16:15:52 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: shung <shung_at_VE.ORACLE.COM> Subject: Financials Applications
Does anybody know an ORACLE based Application that includes Human Resources, Accounting, Manufacturing and Maintenance in one whole application?
I would appreciate any information that you can send me.
Thanks in advance ...... Sue
*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
Sueyling Hung Phone: 58+2+993-65-14
Oracle Consulting 993-21-70
Oracle de Venezuela 993-46-05
993-29-25
Fax : 993-85-55
Email: shung_at_ve.oracle.com
*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
Date: Tue, 17 May 1994 20:40:08 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Phil Mclean <csdpjm_at_BOGART.DOWLING.EDU>
Subject: orawin.dll
I have seen some discussion about orawin.dll, with what package does
this file come with?
Thanks in advance,
csdpjm_at_bogart.dowling.edu
=========================================================================
Date: Wed, 18 May 1994 09:18:17 GMT0BST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Paul Manning <PCM_at_MCS.LE.AC.UK>
Organization: MCS, Leicester University
Subject: Test
This is to see if I'm on the list (properly), please ignore.
Sorry about the bandwidth usage.
Paul C. Manning
Senior Computer Officer
Department of Mathematics and Computer Science
University of Leicester
University Road
Leicester LE1 7RH
U.K.
tel: +44 533 522571
fax: +44 533 523604
e-mail: pcm_at_uk.ac.le.mcs
"Mmmmmmmmm - Glad to be of service - Mmmmmmmmm"
Date: Wed, 18 May 1994 10:42:36 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Louis-Marie Wattebled <WATTEBLE_at_FRESCP11.BITNET> Subject: Report Writer
Hi,
Does anyone know an oracle application that can be used to generate reports and that can be called within a C or C++ program ?
The environment used is an oracle Client under Windows and an oracle Server V7 on Unix (AIX).
We project to write a portable client side that could be run under Windows and under Mac; does anyone have experience with this environment ?
Thanks.
Date: Wed, 18 May 1994 16:23:55 +0000 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Surendra Reddy <reddy_at_ITCSERV.ITC.SOFT.NET> Subject: Re: Report Writer
We have developed a visual report definition workbench. You can define your report layouts using the visual tools or you can attach your report rules through a report language RDL. This compiler generates the pro*c code and you can call these programs from any c programs or can run independently from $ prompt.
If you need more infomation you can send a message to reddy_at_itcserv.itc.soft.net
>Hi,
>
>Does anyone know an oracle application that can be used to generate reports
>and that can be called within a C or C++ program ?
>
>The environment used is an oracle Client under Windows and an oracle Server
>V7 on Unix (AIX).
>
>We project to write a portable client side that could be run under Windows
>and under Mac; does anyone have experience with this environment ?
>
Yes, we have worked a lot of front-end systems for ORACLE/SYBASE. If you need more info. you can send message to reddy_at_itcserv.itc.soft.net
Surendra K.Reddy
(reddy_at_itcserv.itc.soft.net )
>Thanks.
>
Date: Wed, 18 May 1994 08:42:15 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Teresa A Larson <larson_at_SLED.GSFC.NASA.GOV>
Subject: Re: Test
In-Reply-To: <9405180815.AA09674_at_sled.gsfc.nasa.gov> from "Paul Manning" at
May 18, 94 09:18:17 am
Paul,
You message was posted. Welcome aboard!
Teresa Larson
--
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ | Teresa A. Larson - Hughes STX Corporation | | NASA/GSFC Code 933.0 voice: (301) 286-7867 | | Greenbelt, Maryland 20771 fax: (301) 286-1777 | | larson_at_sled.gsfc.nasa.gov | +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ ========================================================================= Date: Wed, 18 May 1994 06:14:58 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: M Chase <mchase_at_M100.KPT.NUWC.NAVY.MIL> Subject: LISTSERV
I need to make some changes to my LISTSERV status that the automated server won't handle. I've sent two messages to sk_at_ccvm.sunysb.edu without response.
If anyone has a good address for the human LISTSERV manager please send it to me off-line.
Thanks, Mac (mchase_at_kpt.nuwc.navy.mil)
Date: Wed, 18 May 1994 16:31:21 +0200 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Yves Noel <Yves.Noel_at_UNIV-LILLE1.FR> Subject: It's just a test !
It's just a test !
Date: Wed, 18 May 1994 12:03:11 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Mark Sminkey <sminkey_at_CSEIC.SAIC.COM> Subject: Passwords
Hello,
Does anyone know of a way to allow Oracle to automatically change your password after say 180 days. Or at least to notify you that you need to change it.
+-----------------------------------------------------------+ | Mark Sminkey | | Software Engineer | | SAIC | | McLean, VA | | | | sminkey_at_cseic.saic.com | +-----------------------------------------------------------+ ========================================================================= Date: Wed, 18 May 1994 17:33:35 GMT0BST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Paul Manning <PCM_at_MCS.LE.AC.UK> Organization: MCS, Leicester University Subject: Oracle under Windows
This is more of a gripe than anything else. I'm using Forms 4.0.11... under Windows over IPX to a Netware server running Oracle 7.0.15...
The system seems to be bug ridden, particularly for manipulating attributes for Buttons, Views, Windows, etc. Other strange things happen, like ABORT_QUERY no longer does the same thing as DO_KEY('ABORT_QUERY'); ! Do others have similar problems with Forms on other platforms or is it just Windows or even just me?
Also, why isn't SQL*PLUS a decent package? Cut and Paste seem to be restricted to 100 or so characters, I can launch an editor, but when I save the buffer it isn't re-read - so I have a Windows app which is restricted to a line editor (ugh!).
Sorry, but I've had a bad day!
Observations about the solidity of Forms 4 on Suns and Macintoshes welcome, since I'm going to have to move my application across to these platforms (if it ever works!).
Cheers, Paul.
Paul C. Manning
Senior Computer Officer
Department of Mathematics and Computer Science
University of Leicester
University Road
Leicester LE1 7RH
U.K.
tel: +44 533 522571
fax: +44 533 523604
e-mail: pcm_at_uk.ac.le.mcs
"Mmmmmmmmm - Glad to be of service - Mmmmmmmmm"
Date: Wed, 18 May 1994 11:29:07 CDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Mr David Brisco <dbrisco_at_EMH4.MPC.AF.MIL> Subject: User Exits
Hello all,
I am trying to call a Pro*Ada routine from one of my forms. In order to do that I must relink that sqlforms30 binary. The DEC Ada book states that if you call an Ada procedure from another language you must call the procedure ada_init_component before it and the procedure ada_complete_component afterwards, but since no source code was provided by Oracle I don't have an opportunity to call these two routines at the proper time.
Anyone ever experience this?
Thanks in advance,
David Brisco
dbrisco_at_emh4.mpc.af.mil
Date: Wed, 18 May 1994 12:47:22 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Leonardo Fernandez <lfernand_at_ve.oracle.com>"
<lfernand_at_VE.ORACLE.COM>
Subject: Re: Problems with CALLQRY
Hi Jim,
How are you ?
I hope you are fine.
Your suggestion did not work, but I would like to thank you for it.
Now, I open TAR (105 453.08) ...
Leonardo Fernandez.
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
Received: 05-16-94 15:27 Sent: 05-16-94 13:29From: VESUN1:<@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU> To: Multiple recipients of list ORACLE-L ORACLE-L_at_SBCCVM.BITNET Subject: Re: Problems with CALLQRY Reply-To: VESUN1:<@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU> Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Lenardno,
You need to increase the savepoints parameter in your INIT.ORA file. We had this problem and increase the savepoints from the default of 5 to 24 and the problem went away. Savepoints are discussed in the SQL*FORMS 3.0 Designer's Reference in chapter 3. I hope that this helps.
Jim Foley
Manager of Data Administration
Bentley College
Waltham, MA 02154-4705
(617)891-3419
JFOLEY_at_BENTLEY.EDU
Included text:
Hi oracle-l,
I have a customer that converted forms V2.3 to V3.0., Aprox. 250
forms.
The application makes the following :
Form1 call main-menu
main-menu call a Form2
And when ...
Form2 calls a Form3 ( With the function CALLQRY(2.3) and does not
return at the previuos item of the main_menu ).
Form2 call a Form3 ( With the function CALL_QUERY(3.0), returns
at the previuos item of the main_menu
perfectly ).
Any suggestions or advices will be wellcome ...
Thanks ,
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
=========================================================================
Date: Wed, 18 May 1994 14:57:53 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: pcrs28%doh1f_at_ALBNYDH2.BITNET
Dear Oracle-L subscribers a colleague asked that I post the message below. thanks...
==============start of cut===============================================Date: 17-May-1994
NYS OMRDD to other Oracle users
re QMX and Data Query
OMRDD currently uses QMX against Oracle RDBMS v6.0 on VAXes.
Oracle Corp is de-supporting QMX product in the future. OMRDD
has one application using Oracle RDBMS v7.0 and plans to move in
that direction. QMX cannot be used with v7.0 databases.
Oracle Corp has offered Data Query as QMX replacement.
OMRDD is currently evaluating D.Q. as compared to QMX and as
compared to general requirements for an ad hoc query product.
Early assessment: we may want to look at other products.
Conversion of large number of complex QMX queries appears to be
problemmatic.
Is there anyone out there facing the same situation: Oracle
user, moving from RDBMS v6.0 to v7.0, losing support of QMX,
evaluating Data Query and alternative products, need to convert
volumes of QMX queries?
Please share relevant experience.
======================end of cut==========================================
=========================================================================
Date: Wed, 18 May 1994 14:16:00 -0600
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Kerry Sesker <ksesker_at_CHEEC-PO.CHEEC.UIOWA.EDU>
Subject: PRO C with IBM C/SET2
Can anyone give me a few pointers. I am attempting to link
a proc program within workframe2. I have specified the
sql13dll.lib and path in the
link options/filename options/libraries to use.
I also have specified the path to this library in the
library search path under my language profile.
the link386 invocation string is
"<object filename> /M /W /SE:512 /ST:10240
/PM:VIO,<executable filename>,,path\sql13dll.lib;
however i get L2029 UNRESOLVED EXTERNAL ERRORS FOR
sqllo2
sqlca
sqlsca
Is there something I'm missing?
Thanks
kerry
=========================================================================
Date: Wed, 18 May 1994 19:03:53 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Paul Dorsey <DORSEY_at_RIDER.BITNET>
Subject: QMX, Data Query, related products
I did a paper the just came out in Network Computing and in the
Client Server insert in last week's info week the reviews some
ad hoc tools. I would direct you to those papers for my opinion.
I don't have any advice for converting large numbers of
QMX queries. I think that the QBE interface is not easily translated
to any non-QBE product. I am similarly interested if anyone has solved
that particular migration issue.
Paul Dorsey
Rider U
Date: Wed, 18 May 1994 19:16:00 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Wong, Debbie" <dwong_at_PO7.AHCPR.GOV> Subject: SQL*NET SPX LISTENER ON OS/2
We are running ORACLE Server for OS/2 (Netware Edition, V6) on a Netware 3.11 Local Area Network with mostly DOS clients. Occasionally, our client connection requests would hang. This happened at one time when the listener
screen showed the following: . .
C 2229 .
Current processes: 7 2231 .
. .
C 2219 .
2220 .
2222 .
2232 .
2235 .
What are the processes without a C or L designation? Has anyone experienced this? Any comments would be greatly appreciated.
Date: Thu, 19 May 1994 01:23:09 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Hani Atalla <hatalla_at_USAID.GOV> Subject: Oracle on Banyan Vines 5.5
We are a site running Oracle v 6 on Banyan Vines 4.11 LAN and Oracle v 7 on a SPARC 10 SunOS 4.1. Soon we will upgrade our Vines o/s from 4.11 to 5.5.
I have learnet that Oracle v 6 does NOT run on Banyan Vines v 5.5. True or False ?
Thank you
Hani Atalla
hatalla_at_USAID.GOV
Date: Thu, 19 May 1994 07:02:22 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Sangeet Arun Amin <Sangeet_Amin_at_SEAS-CPO_at_CCMAIL.GSFC.NASA.GOV>
Subject: Forms 4.0.11 on Solaris 2.X
Anyone have experience with Forms 4.0.11 on Solaris 2.X? I'm
discovering problems with referencing LOVs, Libraries, and
Alerts.
We are also having Forms 4.0.11 crash at twice a day...which
is quite irksome...causing us to save very frequently.
=========================================================================
Date: Thu, 5 May 1994 07:43:54 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: John Flack <John=C=Flack%OISM.DPS.H%ACF.WDC_at_BAN-GATE.ACF.DHHS.GOV>
Subject: Oracle Password ageing
Forwarded to: INTERNET[ORACLE-L_at_CCVM.SUNYSB.EDU]
cc:
Comments by: John C Flack_at_OISM.DPS.H_at_ACF.WDC
=======================================================================
Forwarded to: Angie Scott,Frank Chung, Linda Aspeslagh, Abe Klugman,
Richard Robinson
cc: John C Flack_at_OISM.DPS.H_at_ACF.WDC
Comments by: Deborah Ferrenz_at_OISM.CCS_at_ACF.WDC
Comments:
This seems like a good idea to me & I think we should get someone to work implementing it ASAP.
As to the problem of users writing their own stuff and bypassing the 'requirement', it seems to me those guys deserve to have their passwords changed on them after the 120 days or whatever & sent notification. If they used the system but didn't follow the rules, tough. Could we make some sort of program available to everyone that invoked this database, and, say, put it on the LAN?
The suggested work around is:
These steps are NOT necessarily a recommendation that we do this, but rather a statement of what is possible. Step 2 in particular will be hard to enforce, once we set users free with some tools to let them do some of their own application development. For instance, we might eventually give users PowerViewer to let them develope their own reports to be integrated with PowerBuilder systems. If step 2 is not followed religiously, step 3 will eventually drop some active users who shouldn't be dropped.
Date: Thu, 19 May 1994 07:41:25 -0500
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Hal Wigoda <hwigoda_at_ARLINGTONHGTS.PAMD.CIG.MOT.COM>
Subject: Re: Tablespaces
In-Reply-To: "Vijay V." <db1_at_comagic.mnet.uswest.com> "Re: Tablespaces" (May
17, 3:48pm)
On May 17, 3:48pm, "Vijay V." wrote:
> Subject: Re: Tablespaces
> >
> > Is there any way through a sql job or such that will tell me what objects ar
e
> > in a particular tablespace?
> >
> >
> > TIA
> >
> > Tony
> >
>
> Hai Tony,
> You can find out what objects are there in a given tablespace by running
> this query with sys account.
>
>
> select ts$.name ts_name,
> obj$.name obj_name,
> decode(obj$.type, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
> 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
> 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY',
> 12, 'TRIGGER', 'UNDEFINED') obj_type
> from ts$,obj$ where obj$.namespace = ts$.ts#
> order by 1,3
> /
>
>
> please let me know if it solves your problem.
>
> my address is db1_at_comagic.mnet.uswest.com
>
> Good luck.
>
> Vijay.
>-- End of excerpt from "Vijay V."
Is this valid for version 6 oracle?
--
#include <standard.disclaimer> #include <witty.saying> #include <fancy.pseudo.graphics> ========================================================================= Date: Thu, 19 May 1994 06:50:26 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: RDB8%IC%DCPP_at_BANGATE.PGE.COM Subject: Re: Oracle on Banyan Vines 5.5>From: Hani Atalla <hatalla_at_USAID.GOV>
>To: Multiple recipients of list ORACLE-L%SBCCVM.BITNET_at_uga.cc.uga.edu
Oracle V6 will run under Banyan 5.5 but support for V6 will be discontinued at the end of 94. Version 7 is not supported under Banyan 5.x. We're currently looking at the same situation but are trying migrate to V7 but requires us to upgrade to SCO Vines :-(
Rick Box : System Analyst Pacific Gas & Electric Internet : rdb8_at_pge.com Diablo Canyon Nuclear Power Plant
P.O.Box 56 I&C 102/2
Avila Beach, CA 93424
Tel: (805) 545-4229 Fax: 545-3373
---------------------------------------------------------------------------
*** The views expressed here are my own and do not necessarily ***
*** reflect those of PG&E. ***
---------------------------------------------------------------------------
=========================================================================
Date: Thu, 19 May 1994 08:57:10 MDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Vijay V." <db1_at_COMAGIC.MNET.USWEST.COM>
Subject: Re: Tablespaces (2)
In-Reply-To: <199405191247.AA09474_at_uswat.advtech.uswest.com>; from "Hal
Wigoda" at May 19, 94 7:41 am
>
> On May 17, 3:48pm, "Vijay V." wrote:
> > Subject: Re: Tablespaces
> > >
> > > Is there any way through a sql job or such that will tell me what objects
ar
> e
> > > in a particular tablespace?
> > >
> > >
> > > TIA
> > >
> > > Tony
> > >
> >
> > Hai Tony,
> > You can find out what objects are there in a given tablespace by running
> > this query with sys account.
> >
> >
> > select ts$.name ts_name,
> > obj$.name obj_name,
> > decode(obj$.type, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
> > 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
> > 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY',
> > 12, 'TRIGGER', 'UNDEFINED') obj_type
> > from ts$,obj$ where obj$.namespace = ts$.ts#
> > order by 1,3
> > /
> >
> >
> > please let me know if it solves your problem.
> >
> > my address is db1_at_comagic.mnet.uswest.com
> >
> > Good luck.
> >
> > Vijay.
> >-- End of excerpt from "Vijay V."
>
> Is this valid for version 6 oracle?
>
> --
>
> #include <standard.disclaimer>
> #include <witty.saying>
> #include <fancy.pseudo.graphics>
>
Yes i think so,
only changes you need to do is to get rid of the numbers in the decode
functions which are applicable to version seven only i.e., trigger,procedure,
function,package body etc.,
you can see the table obj$ what are the types available for a objects by selecting distinct type from obj$ table (needless to say from sys account).
Good luck.
Vijay.
Date: Thu, 19 May 1994 11:18:42 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Marilyn H. Wilson,
Senior Programmer/Analyst" <MWILSON_at_VDH.BITNET>
Subject: SQL*MENU V5
VDH, Division of Information Resources
PROFS: VDH(MWILSON) (804) 786-1545
Subject: SQL*MENU V5
Hello out there, I'm trying to pass the predefined substitution parameters in SQL*MENU (&UN and &PW) to a file outside of menu so I can read them into a pro*cobol program. Any advice on how to go about this would be greatly appreciated.
Date: Thu, 19 May 1994 12:52:57 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Bob Belt <bbelt_at_SCTLRS2.SCTCORP.COM>
Subject: Re: Forms 4.0.11 on Solaris 2.X
In-Reply-To: Letter from Sangeet Arun Amin of May 19,
7:02am "Forms 4.0.11 on Solaris 2.X"
On May 19, 7:02am, Sangeet Arun Amin wrote:
> Subject: Forms 4.0.11 on Solaris 2.X
> Anyone have experience with Forms 4.0.11 on Solaris 2.X? I'm
> discovering problems with referencing LOVs, Libraries, and
> Alerts.
>
> We are also having Forms 4.0.11 crash at twice a day...which
> is quite irksome...causing us to save very frequently.
>-- End of excerpt from Sangeet Arun Amin
You might talk to your Oracle tech rep about BUG 199948 - known problem with Forms 4.0.11 - on GPF on opening forms. Fix in 4.0.12.1.17 - supposed to be out shortly.
Problem is something to do with referenced visual attributes - corrupts the binary file. Our history is random failure, but have lost files.
Workaround until upgrade issued is to COPY any visual attribute. We also frequently save as different file name, just in case. Just lost one this morning on a referenced LOV, but Oracle says ANY referenced va. BTW, copying the va is unacceptable for our products.
We are running Forms 4.0.12 in client/server with RS/6000 host.
Wish you luck.
--
+---------------------------------------------------------------+
| Bob Belt |
| SCT Public Sector e-mail: bbelt_at_sctcorp.com |
| 1733 Harrodsburg Road phone: (606) 277-1500 |
| Lexington, KY 40504-3617 fax: (606) 277-2300 |
+---------------------------------------------------------------+
=========================================================================
Date: Thu, 19 May 1994 09:49:55 PST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Larry Crawford <LCRAWFOR_at_CVDLS.UCDAVIS.EDU>
In-Reply-To: Message of Wed,
18 May 1994 14:57:53 EDT from
<pcrs28%doh1f%ALBNYDH2.BITNET_at_uga.cc.uga.edu>
We are in the process of migrating from SQL/DS to Oracle7. We have made extensive use of QMF (The IBM product which QMX was built to emulate). So I also need a product to supply QMX type functionality.
Any suggestions would be appreciated.
On Wed, 18 May 1994 14:57:53 EDT <pcrs28%doh1f%ALBNYDH2.BITNET_at_uga.cc.uga.edu> s
>Dear Oracle-L subscribers a colleague asked that I post the message
>below. thanks...
>==============start of cut===============================================
>Date: 17-May-1994
>Posted-date: 18-May-1994
>Subject: D.Q. Internet
>Author: Judith P. Mijares
>
> NYS OMRDD to other Oracle users
>
> re QMX and Data Query
>
> OMRDD currently uses QMX against Oracle RDBMS v6.0 on VAXes.
> Oracle Corp is de-supporting QMX product in the future. OMRDD
> has one application using Oracle RDBMS v7.0 and plans to move in
> that direction. QMX cannot be used with v7.0 databases.
>
> Oracle Corp has offered Data Query as QMX replacement.
> OMRDD is currently evaluating D.Q. as compared to QMX and as
> compared to general requirements for an ad hoc query product.
>
> Early assessment: we may want to look at other products.
> Conversion of large number of complex QMX queries appears to be
> problemmatic.
>
> Is there anyone out there facing the same situation: Oracle
> user, moving from RDBMS v6.0 to v7.0, losing support of QMX,
> evaluating Data Query and alternative products, need to convert
> volumes of QMX queries?
>
> Please share relevant experience.
>======================end of cut==========================================
Larry Crawford \ / California Veterinary Diagnostic Lab Information Systems Specialist - * - University of California at Davis lcrawfor_at_cvdls.ucdavis.edu / \ Davis, CA 95616 (916) 752-4407 ========================================================================= Date: Thu, 19 May 1994 13:13:15 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: pcrs28%doh1f_at_ALBNYDH2.BITNET
We have developed an Oracle7 client server application using Sql*Forms 4.0. In order to ensure a read only security level for users using ad hoc tools we developed a read only role, for ad hoc users, and an update role for application users. The update role is password protected.
A group of developers developed the entire application using Sql*Forms 4.0 except for the initial startup form. This form was created by the DBA and its purpose is to set the application role to the update role for authorized users. The FMX file was the only file given out to either developers or users.
This process was working beautifully until we turned the trace function on in the development database and ran the application collecting statistics. One of the first statements processed by TKPROF was ALTER USER username SET ROLE update_role IDENTIFIED BY password. Some much for application tuning! Not that TKPROF can provide useful information when using a cost based optimizer anyways!
Any thoughts would be appreciated.
Richard Schroeder |pcrs28%doh1f_at_albnydh2 New York State Office of Mental Retardation|schroerf_at_delphi.com 800 N. Pearl St., Albany, NY 12204 | ========================================================================= Date: Thu, 19 May 1994 10:13:51 -0700 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Kip Bryant <Kip.Bryant_at_SILICONIX.COM> Organization: Siliconix incorporated Subject: Re: Tablespaces
On May 17, 3:48pm, "Vijay V." wrote:
> Subject: Re: Tablespaces
> >
> > Is there any way through a sql job or such that will tell me what objects ar
e
> > in a particular tablespace?
> >
> >
> > TIA
> >
> > Tony
> >
>
> Hai Tony,
> You can find out what objects are there in a given tablespace by running
> this query with sys account.
>
>
> select ts$.name ts_name,
> obj$.name obj_name,
> decode(obj$.type, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
> 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
> 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY',
> 12, 'TRIGGER', 'UNDEFINED') obj_type
> from ts$,obj$ where obj$.namespace = ts$.ts#
> order by 1,3
> /
>
>
> please let me know if it solves your problem.
>
> my address is db1_at_comagic.mnet.uswest.com
>
> Good luck.
>
> Vijay.
>-- End of excerpt from "Vijay V."
<<<Is this valid for version 6 oracle?
<--
Another 2 cent response --
SELECT * FROM USER_CATALOG;
will give you a list of views which you can query for tables, indexes, views,
sequences, etc...
Date: Thu, 19 May 1994 13:21:27 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Beverly Norwood <csvbcn_at_ADMIN.AC.EDU>
Subject: Re: SQL*MENU V5
In-Reply-To: <9405191659.AA83764_at_admin.ac.edu>; from "Marilyn H. Wilson,
Senior Programmer/Analyst" at May 19, 94 11:18 am
>
> VDH, Division of Information Resources
> PROFS: VDH(MWILSON) (804) 786-1545
> Subject: SQL*MENU V5
>
> Hello out there, I'm trying to pass the predefined substitution
> parameters in SQL*MENU (&UN and &PW) to a file outside of menu
> so I can read them into a pro*cobol program. Any advice on how
> to go about this would be greatly appreciated.
>
Marilyn,
We were able to do this in sqlmenu5 by creating a sqlmenu5 procedure
named trn033 like below. It runs Pro*Cobol program
/source/oasis/app/trn033 and feeds user/password to the program
when the procedure is called.
procedure trn033 is
begin
os_command('/source/oasis/app/trn033 &UN/&PW');
end;
Save the procedure and define the menu option to Sqlmenu as command
type 7, command line text: trn033;
This should work by substituting the name of your Pro*Cobol .
Hope it helps...
Beverly Norwood, Systems Manager
Augusta College
(706) 737-1484 or GIST 337-1484
Internet: bnorwood_at_admin.ac.edu
Date: Thu, 19 May 1994 14:19:00 ES
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: James Rogers at NSD12
<James_Rogers_at_NSD12.NID01_at_CSCMAIL.CSC.COM>
Subject: Re: SQL*MENU V5
New Text Item: SQL*MENU V5
Marilyn,
Below is the command that I have used to call a DOS batch file from SQL*MENU
V5. I hope this helps!!!
OS_COMMAND('(TYPE=2)printrpt &UN &PW');
'printrpt' is the DOS batch filename!
James
______________________________ Reply Separator _________________________________Subject: SQL*MENU V5
VDH, Division of Information Resources
PROFS: VDH(MWILSON) (804) 786-1545
Subject: SQL*MENU V5
Hello out there, I'm trying to pass the predefined substitution
parameters in SQL*MENU (&UN and &PW) to a file outside of menu
so I can read them into a pro*cobol program. Any advice on how
to go about this would be greatly appreciated.
Date: Thu, 19 May 1994 09:02:15 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Jill Zeitler <zeitlerj_at_DGABBY.MFLDCLIN.EDU> Subject: SQL*MENU V5
}]mCl#Please Confirm[{
From: "Marilyn H. Wilson,
Fwd: zeitlerj->oracle-l_at_ccvm.sunysb.edu~@
VDH, Division of Information Resources
PROFS: VDH(MWILSON) (804) 786-1545
Subject: SQL*MENU V5
Hello out there, I'm trying to pass the predefined substitution parameters in SQL*MENU (&UN and &PW) to a file outside of menu so I can read them into a pro*cobol program. Any advice on how to go about this would be greatly appreciated. $$HRComments by zeitlerj Thu May 19, 1994 -- 02:02:14 PM Marilyn -
This is something I do frequently (although to UNIX scripts, rather than Pro*Cobol programs) and here is an example of how I do it:
PROCEDURE PASS_UN_PW IS
host_command_string CHAR(80);
BEGIN
host_command_string := '(TYPE=2) my_prg_name ' || :UN || ' ' || :PW;
OS_COMMAND(host_command_string);
END;
You can go one step further and generalize by passing the procedure the name
of the file to be executed with the USERNAME and PASSWORD:
PROCEDURE PASS_UN_PW2 (exe_prg_name IN CHAR) IS
host_command_string CHAR(80);
BEGIN
host_command_string := '(TYPE=2) ' || exe_prg_name || ' ' || :UN || ' ' ||
:PW;
OS_COMMAND(host_command_string);
END;
Hope this helps you out -
Jill A. Zeitler
zeitlerj_at_dgabby.mfldclin.edu
Date: Thu, 19 May 1994 15:58:18 +0100 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Neil Wilberforce Kenneally <neil_at_EPIC.CO.UK> Subject: CASE v5.0
I am attempting to install CASE Dictionary, Designer etc. version 5.0 onto an Oracle V7 Server/Database (for OS/2 2.x; local Database etc.) installation (I don't have the V7 release number to hand, but it was released last week if that helps. )
When I tried to install CASE dictionary I got as far as installing the required support files and CASE Reporter. When it comes to installing the CASE dictionary files I am told that I can not proceed because one of; ReportWriter, Menus, Forms, Utilities, Tools etc. are not installed.
I have all of the products which were listed installed. The installer even reports those products as installed.
Is there some patch/update which I need to run CASE 5.0 with Oracle 7 ?
Is anyone running CASE 5.0 with Oracle 7 Server/Database ?
Neil
Date: Thu, 19 May 1994 16:01:26 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: John Flack <John=C=Flack%OISM.DPS.H%ACF.WDC_at_BAN-GATE.ACF.DHHS.GOV> Subject: Granting Select on a View
We're converting from Oracle V6 to Oracle7.
I have a view that is a join between one of my tables - tableA and tableB belonging to another user on which SELECT has been granted to PUBLIC. When I try to grant select on my view, Oracle7 tells me that I can't because I don't have grant option on tableB. There was no problem doing this on Oracle V6 - after all, I shouldn't NEED to grant select on tableB - it's granted to PUBLIC for heavens sake.
Is this a bug or a "feature"? Is there a work around? Can the creator of tableB grant select with grant option to PUBLIC, and will this solve the problem?
Date: Thu, 19 May 1994 15:40:57 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Mahesh Dalal <mdalal_at_BAOSC.COM>
Hi!
This is Mahesh. What is your telephone number?
Bye..
Date: Thu, 19 May 1994 17:35:32 U
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Chris Insley <Chris_Insley_at_CATS.NAVY.MIL>
Subject: Re: Granting Select on a Vie
RE>Granting Select on a View
I have a view that is a join between one of my tables - tableA and tableB belonging to another user on which SELECT has been granted to PUBLIC. When I try to grant select on my view, Oracle7 tells me that I can't because I don't have grant option on tableB. There was no problem doing this on Oracle V6 - after all, I shouldn't NEED to grant select on tableB - it's granted to PUBLIC for heavens sake.
Is this a bug or a "feature"? Is there a work around? Can the creator of tableB grant select with grant option to PUBLIC, and will this solve the problem?
Date: Thu, 19 May 1994 16:39:17 GMT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Chris Palmer <CPALMER_at_SYSUBMC.BMC.COM> Organization: BMC Software Subject: SQL*Loader Data Delimiters
Sorry to post to the ORACLE discussion list but I have been unable to locate an INFORMIX list and I was wondering if anybody knew of such a beast ?
I am trying to determine how data delimiters are handled by INFORMIX, i.e. the ORACLE equivalent of "terminated by" and "enclosed by".
Any help would be appreciated, thanks.
Date: Thu, 19 May 1994 16:10:36 -0700 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Comments: Warning -- original Sender: tag was steiger_at_UX5.LBL.GOV From: Daniel Steiger <steiger_at_CSR.LBL.GOV> Organization: LBL (Lawrence Berkeley Laboratory), ICSD Subject: EXP as DBA - IMP as Non-DBA ?
I exported my tables (I'm the owner and also DBA) from Oracle 6. Now, I wanna import these tables into a Oracle7 DB (I'm a user *only* on that DB, not a DBA):
Export file created by EXPORT:V06.00.31
IMP-00013: only a DBA can import a file exported by another DBA IMP-00021: operating system error - error code (dec 2, hex 0x2) IMP-00000: Import terminated unsuccessfully
Of course I tried to export these tables from another Oracle 6 account, which is not a DBA:
Table to be exported: (RETURN to quit) > steiger.sensor EXP-00009: no privilege to export STEIGER's table SENSOR
Any ideas how to solve this problem?
Thanks in advance!
Daniel Steiger Lawrence Berkeley Laboratory Tel: (510) 486-7420
<steiger_at_csr.lbl.gov> Mail Stop 50B-3238 Fax: (510) 486-4004
Berkeley, CA 94720, U.S.A
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=========================================================================
Date: Thu, 19 May 1994 18:31:03 -0500
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: James Melott <nerd_at_METRONET.COM>
Subject: Re: windows-based case tools
In-Reply-To: <199405161311.AA05188_at_metronet.com>
I've used a demo model of silverrun. It seems to work OK, but, as far as I know, will only create the sql code to create the database tables. It does do a fairly good job of helping you to organize the tables.
On Mon, 16 May 1994 DIPESA_at_CARLA.MIT.EDU wrote:
> Does anyone out there have experience using any of the
> following windows-based case tools with Oracle7?
> ERWin/ERX
> Silverrun
> S-Designor
> Visible Analyst Workbench
> In particular, I'm looking for strengths and weaknesses of
> the data modelling interface, DDL generation, RI trigger
> generation, repository, stored procedure support,
> reverse engineering and reporting.
> TIA,
> Tony DiPesa
> MIT/OFMS
>
Date: Thu, 19 May 1994 18:34:34 CDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Madhu Rajamani <rajamani_at_CS.IASTATE.EDU> Subject: Re: your mail
> Hi!
>
> This is Mahesh. What is your telephone number?
>
> Bye..
Hi!
This is Madhu. What is your telephone number?
Bye..
Who are you???????????????????????????????????????????????? ========================================================================= Date: Fri, 20 May 1994 11:25:50 +0800 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Wong Poey Yong <pywong_at_SG.ORACLE.COM> Subject: Re: CASE v5.0
In-Reply-To: SGUNIX:@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU's message of 05-19-94 15:58
Case 5.0 (at least on OS/2) is not certified against v7.
Regards,
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
Wong Poey Yong TEL : (065) 220 5488
Technical Support Consultant (RDBMS) DID : (065) 228 6124
FAX : (065) 224 7646
Oracle Systems SEA Singapore Pte Ltd
Received: 05-20-94 05:41 Sent: 05-19-94 15:58From: SGUNIX:@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L ORACLE-L_at_SBCCVM.BITNET Subject: CASE v5.0
I am attempting to install CASE Dictionary, Designer etc. version 5.0 onto an Oracle V7 Server/Database (for OS/2 2.x; local Database etc.) installation (I don't have the V7 release number to hand, but it was released last week if that helps. )
When I tried to install CASE dictionary I got as far as installing the required support files and CASE Reporter. When it comes to installing the CASE dictionary files I am told that I can not proceed because one of; ReportWriter, Menus, Forms, Utilities, Tools etc. are not installed.
I have all of the products which were listed installed. The installer even reports those products as installed.
Is there some patch/update which I need to run CASE 5.0 with Oracle 7 ?
Is anyone running CASE 5.0 with Oracle 7 Server/Database ?
Neil
Date: Thu, 19 May 1994 21:04:00 PST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: AlexTheodossis <ALEXTHEO_at_BEACH1.CSULB.EDU> Subject: phone number
what do you need my phone number for?
Date: Fri, 20 May 1994 10:54:14 GMT0 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Surendra K.Reddy" <reddy_at_ITCSERV.ITC.SOFT.NET> Subject: Re: your maila.cc.uga.edu>
> Date: Thu, 19 May 1994 18:34:34 CDT
> Reply-to: "ORACLE database mailing list." <ORACLE-L%SBCCVM.BITNET_at_uga.cc.
uga.edu>
> From: Madhu Rajamani <rajamani_at_CS.IASTATE.EDU>
> Subject: Re: your mail
> To: Multiple recipients of list ORACLE-L <ORACLE-L%SBCCVM.BITNET_at_ug
Surendra K.Reddy
reddy_at_itcserv.itc.soft.net
Date: Fri, 20 May 1994 09:15:16 +0200 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Kevin Jonhson Serco DPE/IO <Kevin.Johnson_at_MAIL.ESRIN.ESA.IT> Subject: Re: CASE v5.0
Neil,
We are running CASE V5.0 on ORACLE7 server and most features work fine (in part because of the SET COMPATIBILITY V6 option).
However, we have not found it possible to use the Reverse Engineering facility to import definitions from and ORACLE7 Data Dictionary into CASE Dictionary (v5.0), e.g. columns defined as VARCHAR2 are omitted. Let me know if you manage to do this.
Good luck, Kevin.
Kevin Johnson EMAIL : johnson_at_mail.esrin.esa.it
Information Administrator
European Space Agency DISCLAIMER : These views are mine
ESRIN, FRASCATI, ITALIA. and are not based on
anyone else's tables.
======================================================================
=========================================================================
Date: Fri, 20 May 1994 15:42:00 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "ZRobot:Internet Oracle" <0RIOracl_at_STNECSS.TELECOM.COM.AU>
Subject: Help - Oracle7/Netware DB backup problem
Help ---- Oracle7/Netware DB backup problem ---- Listeners,
We are currently running Oracle7 RDBMS 7.0.15.5.1 on Netware 3.12. What I wish to do is automate a full database backup procedure through some sort of batch file that runs at the same time each night.
This will involve:
(1) Accessing SQLDBA from the console (ie, rconsole) (2) Shutting down the database using SQLDBA. (3) Copying the database files to a backup location. (4) Starting the database using SQLDBA from the console again.
The problem I have is how do I automate getting access to the console to get access to SQLDBA ( ie. automate in a batch file or use another method) so I can then shutdown the database.
I look forward to hearing from anyone who has any suggestions about this matter.
Piantedosi, Gabriele
GPianted_at_STNECSS.TELECOM.COM.AU
Date: Fri, 20 May 1994 09:59:32 BST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Chris Sears <sears_at_KBSS.BT.CO.UK> Subject: one in a thousand
re
> Hi!
>
> This is Mahesh. What is your telephone number?
>
> Bye..
Hi!
This is Madhu. What is your telephone number?
Bye..
I don't know which is worse. The original going out to thousands of people or the reply, doing likewise.
By the way this is sexy Suzy on 0338-427001
48p/min peak rate 32p/min all other times
=========================================================================
Date: Fri, 20 May 1994 08:06:55 -0500
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: TOM MERCADANTE <MERCADTF_at_SNYPLAVA.BITNET>
Organization: SUNY at Plattsburgh, New York, USA
Subject: Re: your mail
Date sent: 20-MAY-1994 08:06:25
How come nobody wants MY phone number?
>From: IN%"ORACLE-L_at_SBCCVM.BITNET" "ORACLE database mailing list." 20-MAY-1994
01:38:18.62
>To: IN%"ORACLE-L_at_SBCCVM.BITNET" "Multiple recipients of list ORACLE-L"
>CC:
>Subj: RE: your mail
>
>Return-path: <@UBVM.CC.BUFFALO.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU>
>Received: from UBVM.CC.BUFFALO.EDU (MAILER_at_UBVM) by splava.cc.plattsburgh.edu
> (PMDF V4.2-11 #3312) id <01HCJMC2J0N499KU7F_at_splava.cc.plattsburgh.edu>; Fri,
> 20 May 1994 01:38:11 EST
>Received: from UBVM.CC.BUFFALO.EDU (NJE origin LISTSERV_at_UBVM) by
> UBVM.CC.BUFFALO.EDU (LMail V1.2a/1.8a) with BSMTP id 5476; Fri,
> 20 May 1994 01:38:54 -0400
>Date: Fri, 20 May 1994 10:54:14 GMT0
>From: "Surendra K.Reddy" <reddy_at_ITCSERV.ITC.SOFT.NET>
>Subject: RE: your mail
>Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_SBCCVM.BITNET>
>Reply-to: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
>Message-id: <01HCJMC2J0N699KU7F_at_splava.cc.plattsburgh.edu>
>X-Envelope-to: MERCADTF
>Content-transfer-encoding: 7BIT
>X-To: ORACLE-L%SBCCVM.BITNET_at_pucc.princeton.edu
>
>> Date: Thu, 19 May 1994 18:34:34 CDT
>> Reply-to: "ORACLE database mailing list." <ORACLE-L%SBCCVM.BITNET_at_uga.cc
.
> uga.edu>
>> From: Madhu Rajamani <rajamani_at_CS.IASTATE.EDU>
>> Subject: Re: your mail
>> To: Multiple recipients of list ORACLE-L <ORACLE-L%SBCCVM.BITNET_at_u
g
> a.cc.uga.edu>
>Madhu and Mahesh
>Whose telephone number you are searching for!!
>
>Surendra K.Reddy
>reddy_at_itcserv.itc.soft.net
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % % % Tom Mercadante % % Database Administrator % % SUNY Plattsburgh % % % % BITNET : MERCADTF_at_SNYPLAVB.BITNET % % INTERNET : MERCADTF_at_SPLAVA.CC.PLATTSBURGH.EDU Computer Systems Center % % PHONE : (518)564-3013 Kehoe 507 % % Plattsburgh, NY 12901 % % % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ========================================================================= Date: Fri, 20 May 1994 08:08:59 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Tony Frankland <5256_at_IBMMAIL.COM> Subject: ORACLE List ----------------------- Mail item text follows ---------------
From: Frankland, Anthony E
To: 'internet'
Subject: ORACLE List
Date: 1994-05-20 12:09
Priority:
SET ORACLE-L NOMAIL
A
Extra X400 information begins:
Originator
Name: (AE) FRANKLAND
Domain: GB/GOLD 400/ROLLS-ROYCE
Node.Userid: IBMX400.5256
Message Id: 0065
Sent by
Name: (AE) FRANKLAND
Domain: GB/GOLD 400/ROLLS-ROYCE
Node.Userid: IBMX400.5256
Free Fmt Name: Tony Frankland
Subject: ORACLE List
Recipients
Name: INET INET
Domain: GB/IBMX400/IBMMAIL
Node.Userid: IBMMAIL.INET
Free Fmt Name: IBMMAIL INTERNET Gateway
=========================================================================
Date: Fri, 20 May 1994 13:45:55 GMT0BST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Paul Manning <PCM_at_MCS.LE.AC.UK>
Organization: MCS, Leicester University
Subject: Dates in Forms 4
Forms 4.0.11... under MS-Windows
Server 7.0.15... under Netware
Client-Server over IPX/SPX.
Amongst a raft of problems I'm having with Forms I can't seem to insert a date in the database. I have a view for which I've over- ridden on-lock, on-update, on-insert and on-delete (as described in the Forms 3 advanced techniques manual). The view contains two date fields and referencing them from insert, update and select statements gives me an "ORA-1483 Invalid length for DATE or NUMBER variable".
The statements work if I ignore the date fields, so they are the problem. The forms fields are Text Items of type date with length 9 - generated with default block. One of offending statements is:
insert into has_supervisor (supervisor_id, student_id, start_date)
values (:supervisors.supervisor_id, :supervisors.student_id,
:supervisors.start_date);
I assume that the field holds a date. It can't be a character string since Forms' Compiler objects to TO_DATE(:supervisors.start_date).
Can anyone offer any insight?
Thanks in advance, Paul.
Paul C. Manning
Senior Computer Officer
Department of Mathematics and Computer Science
University of Leicester
University Road
Leicester LE1 7RH
U.K.
tel: +44 533 522571
fax: +44 533 523604
e-mail: pcm_at_uk.ac.le.mcs
"Mmmmmmmmm - Glad to be of service - Mmmmmmmmm"
Date: Fri, 20 May 1994 09:17:00 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Douglas C Bolinger <BOLINGERDC%A1%OCU1_at_MR.CTD.ORNL.GOV> Subject: Need scripts to extract DDL
I need some scripts to extract the DDL from existing Oracle databases. I prefer to have the DDL placed in separate files; one each for the tables, indices, constraints, and grants for the tables & views. The DDL needs to be in an executable and fairly nice format. I would normally try to do this myself, but this is needed within a few days and I already have too many commitments. Any help would be greatly appreciated.
Thanks,
Doug Bolinger (ydz_at_ornl.gov)
Martin Marietta Energy Systems, Inc.
Oak Ridge, TN
Date: Fri, 20 May 1994 09:34:31 CDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Madhu Rajamani <rajamani_at_CS.IASTATE.EDU> Subject: Re: your mail
My reply to Mahesh was to *hint* him that I cannot recall who he was and to know why he wanted my phone number.
And even if he knew me why did he have to mail in a listserver (or whatever) where there are multiple receipients and crowd everyone's mailbox. Such mails should be strongly discouraged.
Thank You and Sorry if this mail took much of your time.
Madhu Rajamani
>
> Date sent: 20-MAY-1994 08:06:25
> How come nobody wants MY phone number?
>
> >From: IN%"ORACLE-L_at_SBCCVM.BITNET" "ORACLE database mailing list." 20-MAY-19
94
> 01:38:18.62
> >To: IN%"ORACLE-L_at_SBCCVM.BITNET" "Multiple recipients of list ORACLE-L"
> >CC:
> >Subj: RE: your mail
> >
> >Return-path: <@UBVM.CC.BUFFALO.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU>
> >Received: from UBVM.CC.BUFFALO.EDU (MAILER_at_UBVM) by splava.cc.plattsburgh.edu
> > (PMDF V4.2-11 #3312) id <01HCJMC2J0N499KU7F_at_splava.cc.plattsburgh.edu>; Fri,
> > 20 May 1994 01:38:11 EST
> >Received: from UBVM.CC.BUFFALO.EDU (NJE origin LISTSERV_at_UBVM) by
> > UBVM.CC.BUFFALO.EDU (LMail V1.2a/1.8a) with BSMTP id 5476; Fri,
> > 20 May 1994 01:38:54 -0400
> >Date: Fri, 20 May 1994 10:54:14 GMT0
> >From: "Surendra K.Reddy" <reddy_at_ITCSERV.ITC.SOFT.NET>
> >Subject: RE: your mail
> >Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_SBCCVM.BITNET>
> >Reply-to: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> >Message-id: <01HCJMC2J0N699KU7F_at_splava.cc.plattsburgh.edu>
> >X-Envelope-to: MERCADTF
> >Content-transfer-encoding: 7BIT
> >X-To: ORACLE-L%SBCCVM.BITNET_at_pucc.princeton.edu
> >
> >> Date: Thu, 19 May 1994 18:34:34 CDT
> >> Reply-to: "ORACLE database mailing list." <ORACLE-L%SBCCVM.BITNET_at_uga.
cc
> .
> > uga.edu>
> >> From: Madhu Rajamani <rajamani_at_CS.IASTATE.EDU>
> >> Subject: Re: your mail
> >> To: Multiple recipients of list ORACLE-L <ORACLE-L%SBCCVM.BITNET
@u
> g
> > a.cc.uga.edu>
> >Madhu and Mahesh
> >Whose telephone number you are searching for!!
> >
> >Surendra K.Reddy
> >reddy_at_itcserv.itc.soft.net
> %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
> % %
> % Tom Mercadante %
> % Database Administrator %
> % SUNY Plattsburgh %
> % %
> % BITNET : MERCADTF_at_SNYPLAVB.BITNET %
> % INTERNET : MERCADTF_at_SPLAVA.CC.PLATTSBURGH.EDU Computer Systems Center %
> % PHONE : (518)564-3013 Kehoe 507 %
> % Plattsburgh, NY 12901 %
> % %
> %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Date: Fri, 20 May 1994 09:45:12 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Jill Zeitler <zeitlerj_at_DGABBY.MFLDCLIN.EDU> Subject: SQL*Loader Data Delimiter
}]mCl#Please Confirm[{
From: Chris Palmer <CPALMER_at_SYSUBMC.
Fwd: zeitlerj->oracle-l_at_ccvm.sunysb.edu~@
Sorry to post to the ORACLE discussion list but I have been unable to locate an INFORMIX list and I was wondering if anybody knew of such a beast ?
I am trying to determine how data delimiters are handled by INFORMIX, i.e. the ORACLE equivalent of "terminated by" and "enclosed by".
Any help would be appreciated, thanks.
$$HRComments by zeitlerj Fri May 20, 1994 -- 09:46:02 AM
Chris -
The address that I have for the Informix List is :
informix-list_at_rmy.emory.edu
Have fun!
:)
Jill A. Zeitler
zeitlerj_at_dgabby.mfldclin.edu
Date: Fri, 20 May 1994 10:45:06 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: shung <shung_at_VE.ORACLE.COM> Subject: Oracle 7 under DINIX
Hi everybody,
Does anybody knows if Oracle 7 run under DINIX? (Dinix is an Operating System
for Unysis machine).
If so, please send me back, customer references (name, site, telephone, fax and
contact).
Thanks very much in advance !!!!
Saludos ...... Sue
*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
Sueyling Hung Phone: 58+2+993-65-14
Consulting Manager 993-21-70
Oracle de Venezuela 993-46-05
993-29-25
Fax : 993-85-55
Email: shung_at_ve.oracle.com
*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
Date: Fri, 20 May 1994 08:00:00 MST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: radams <radams_at_MSGATE.MDHC.MDC.COM> Subject: Re: Help - Oracle7/Netware DB backup pro
We have just tested and are implementing "Phantom of the Console" (from Circuit Masters (800) 764-5444 ) to schedule our Netware database shutdowns and startups. Its doing very well. I have it installed on the production server and it is controlling this as well as a development server. At this point backups are taken during the shutdown window by a scheduled backup server.
Date: Fri, 20 May 1994 08:12:27 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "JROSTOSK.US.ORACLE.COM" <JROSTOSK_at_US.ORACLE.COM> Subject: Fwd: Re: CASE v5.0
--Boundary-1822907-0-0
Please do not give out incorrect information -- if you check with us, you will find that we _have_ certified CASE 5.0 for OS/2 to run against Oracle7; this is now supported. For a while, it was not certified, but now it is. Oracle7 for OS/2 could be used as the repository, or SQL*Net could be used to get to Oracle7 across the network somewhere.
Jay
Character-mode RULES!!! Playing with mice all day is for cats, not computer professionals. And as for clicking...I'd rather SNAP, thank you.
Jay Rostosky, DMD Technical Pre-Sales
415/506-3826
jrostosk_at_us.oracle.com
--Boundary-1822907-0-0
X-Orcl-Content-Type: message/rfc822
Received: 19 May 1994 20:32:45 Sent: 19 May 1994 20:32:17From:"Wong Poey Yong " <owner-oracle-l_at_CCVM.SUNYSB.EDU> To: Multiple,recipients,of,list,ORACLE-L,ORACLE-L_at_SBCCVM.BITNET Subject: Re: CASE v5.0
In-Reply-To: SGUNIX:@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU's message of 05-19-94 15:58
Case 5.0 (at least on OS/2) is not certified against v7.
Regards,
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
Wong Poey Yong TEL : (065) 220 5488
Technical Support Consultant (RDBMS) DID : (065) 228 6124
FAX : (065) 224 7646
Oracle Systems SEA Singapore Pte Ltd
Received: 05-20-94 05:41 Sent: 05-19-94 15:58From: SGUNIX:@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L ORACLE-L_at_SBCCVM.BITNET Subject: CASE v5.0
I am attempting to install CASE Dictionary, Designer etc. version 5.0 onto an Oracle V7 Server/Database (for OS/2 2.x; local Database etc.) installation (I don't have the V7 release number to hand, but it was released last week if that helps. )
When I tried to install CASE dictionary I got as far as installing the required support files and CASE Reporter. When it comes to installing the CASE dictionary files I am told that I can not proceed because one of; ReportWriter, Menus, Forms, Utilities, Tools etc. are not installed.
I have all of the products which were listed installed. The installer even reports those products as installed.
Is there some patch/update which I need to run CASE 5.0 with Oracle 7 ?
Is anyone running CASE 5.0 with Oracle 7 Server/Database ?
Neil
--Boundary-1822907-0-0--
Date: Fri, 20 May 1994 11:49:37 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Wendy Woodhouse <wendyw_at_OVCNET.UOGUELPH.CA> Subject: Re: Oracle 7 under DINIX
I am currently running ORACLE 7 under Dynix. Our production system is still running under 6 but the final cutover is scheduled for early July.
Wendy Woodhouse
Senior Analyst
OVC Computer Group
Ontario Veterinary College
University of Guelph
(519) 824-4120 ext. 4770
FAX: (519) 767-0440
Date: Fri, 20 May 1994 12:42:21 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "C. W. Pritchard" <dr826_at_CLEVELAND.FREENET.EDU> Subject: ORACLE POSITION AVAILABLE
Cleveland-based Open Software, Inc. has an immediate opening for an Oracale guru with solid Unix experience and general PC familiarity. $$$40,000 - 65,000+ depending on experience.
Call Chris Pritchard (800) 367-3787 Ext 6218 for details. local Cleveland (i.e. Solon, Ohio) # is 349-7908.
I am the Employment Manager at OSI's former parent company... i.e. this is not a headhunter advertisement.
Thanks.
--
Christopher W. Pritchard (CWP)
Date: Fri, 20 May 1994 09:05:33 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Larry Tredway <lrtredwa_at_GOPHER.RDYNE.ROCKWELL.COM> Subject: Madhu & Mahesh
Cybernetic love on the internet is intertaining, but you may wish to take it to a little more private than the ORACLE list. Say, use each others individual mailing address? :-)
Date: Fri, 20 May 1994 11:45:01 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Mahesh Dalal <mdalal_at_BAOSC.COM> Subject: Re: your mail
Hello!
I am sorry. I am a first time user of internet. So, by mistake, I sent my personal mail in the listserver.
Can one create more than one cursor in the same PL*SQL query and then nest the open cursors and fetches in nested loops?
create cursor1 from table1
create cursor2 from table1
create cursor3 from table1
open cursor1
loop
fetch cursor1
open cursor2
loop
fetch cursor2
open cursor3
loop
fetch cursor3
.
.
.
end loop
end loop {etc ... [ran out of space]
=========================================================================
Date: Fri, 20 May 1994 13:01:13 MDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Vijay V." <db1_at_COMAGIC.MNET.USWEST.COM>
Subject: Re: PL*SQL V1 - Cursors
In-Reply-To: <199405201759.AA17455_at_uswat.advtech.uswest.com>; from "Gary
Sanford" at May 20, 94 2:45 pm
>
> Can one create more than one cursor in the same PL*SQL query and then
> nest the open cursors and fetches in nested loops?
>
> create cursor1 from table1
> create cursor2 from table1
> create cursor3 from table1
> open cursor1
> loop
> fetch cursor1
> open cursor2
> loop
> fetch cursor2
> open cursor3
> loop
> fetch cursor3
> .
> .
> .
> end loop
> end loop {etc ... [ran out of space]
>
Yes, you can declare any number of cursors and open them ,fetch them and process them in a pl/sql block in nested loops.
i dont remember if there is any restriction in version 1 (if at all there is a restriction it should be six , i am not sure).
Vijay.
Date: Fri, 20 May 1994 16:11:36 GMT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gary Sanford <fswa/S=G.SANFORD/OU1=R06A_at_MHS.ATTMAIL.COM> Subject: Forwarded: Re: PL*SQL V1 - Cursors Content-Type: text
From: Gary G. Sanford:R6/PNW
Date: ## 05/20/94 12:11 ##
I guess the crux of my question is, Can one have more that one open
cursor for the SAME table? I don't seem to be able to find a
restriction in the manual yet am getting ORA-06511: PL/SQL: cursor
already raised in a statement ...
Thanx, ViJay, for the reply
Gary Sanford, Computer Specialist
USDA, Forest Service, 333 SW First St., Portland, OR 97208
Internet ---> FSWA/S=G.SANFORD/OU1=R06A_at_MHS.ATTMAIL.COM Internet ---> Osprey_at_Netcom.Com Voice-------> 503.326.4960 FAX --------> 503.326.5743
Previous comments:
From: Vijay V.:X400
Date: ## 05/20/94 15:02 ##
From: C=US/ADMD=ATTMAIL/ORG=ATTMAIL/PN=Vijay V./
DD.ID=internet(b)COMAGIC.MNET.USWEST.COM(b)db1/
In Reply to Message :- 199405201759.AA17455(a)uswat.advtech.uswest.com
Content-Type: ForwardedIPmessage
Content-Length: 00000001007
Message-Version: 2
UA-Content-ID: <0q4Zpk.1hZ85o(a)pjl53wo.i-p.attmail.com> End-of-Header: EMail-Version: 2 UA-Message-ID: <0q4Zpk.1hZ85o(a)pjl53wo.i-p.attmail.com> P2-Originator: internet!COMAGIC.MNET.USWEST.COM!db1End-of-Protocol:
>
> Can one create more than one cursor in the same PL*SQL query and then > nest
the open cursors and fetches in nested loops?
>
> create cursor1 from table1
> create cursor2 from table1
> create cursor3 from table1
> open cursor1
> loop
> fetch cursor1
> open cursor2
> loop
> fetch cursor2
> open cursor3
> loop
> fetch cursor3
> .
> .
> .
> end loop
> end loop {etc ... [ran out of space]
>
Yes, you can declare any number of cursors and open them ,fetch them and process them in a pl/sql block in nested loops.
i dont remember if there is any restriction in version 1 (if at all there is a restriction it should be six , i am not sure).
Vijay.
Date: Fri, 20 May 1994 14:07:04 MDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Vijay V." <db1_at_COMAGIC.MNET.USWEST.COM>
Subject: Re: Forwarded: Re: PL*SQL V1 - Cursors
In-Reply-To: <199405201920.AA20136_at_uswat.advtech.uswest.com>; from "Gary
Sanford" at May 20, 94 4:11 pm
Hai Gary ,
I was referring to multiple cursors on same table only. It works in pl/sql version 2.0
I have modified the example supplied by Oracle Corpn which resides in the directory ORACLE_HOME/plsql/demo and tested it. It works fine.
I have duplicated the cursor by adding 1 to the existing cursor (i.e, my_cursor is existing, my_cursor1 is added.)
rem
rem $Header: examp4.sql 2001200.1 92/06/19 11:45:35 sylee Generic<base> $
rem
Rem Copyright (c) 1991 by Oracle Corporation
Rem NAME
Rem examp4.sql - <one-line expansion of the name>
Rem DESCRIPTION
Rem <short description of component this file declares/defines>
Rem RETURNS
Rem
Rem NOTES
Rem <other useful comments, qualifications, etc.>
Rem MODIFIED (MM/DD/YY)
Rem rvasired 05/12/92 - Creation
/* ** This block finds all employees whose monthly wages (salary plus ** commission) are higher than $2000. ** ** An alias is used in the cursor declaration so that the subsequent ** use of %ROWTYPE is allowed. (Column names in a cursor declaration ** must have aliases if they are not simple names.) ** ** Copyright (c) 1989,1992 by Oracle Corporation*/
DECLARE
CURSOR my_cursor IS SELECT sal + NVL(comm, 0) wages, ename
FROM emp;
CURSOR my_cursor1 IS SELECT sal + NVL(comm, 0) wages, ename
FROM emp;
my_rec my_cursor%ROWTYPE;
my_rec1 my_cursor%ROWTYPE;
FETCH my_cursor INTO my_rec;
EXIT WHEN my_cursor%NOTFOUND;
IF my_rec.wages > 2000 THEN
INSERT INTO temp VALUES (NULL, my_rec.wages,
my_rec.ename);
OPEN my_cursor1;
LOOP
FETCH my_cursor1 INTO my_rec1;
EXIT WHEN my_cursor1%NOTFOUND;
IF my_rec1.wages > 2000 THEN
INSERT INTO temp VALUES (NULL, my_rec1.wages,
my_rec1.ename);
END IF;
END LOOP;
CLOSE my_cursor1;
END IF;
>
> Content-Type: text
> Content-Length: 00000000805
>
> From: Gary G. Sanford:R6/PNW
> Date: ## 05/20/94 12:11 ##
> I guess the crux of my question is, Can one have more that one open
> cursor for the SAME table? I don't seem to be able to find a
> restriction in the manual yet am getting ORA-06511: PL/SQL: cursor
> already raised in a statement ...
>
> Thanx, ViJay, for the reply
>
> Gary Sanford, Computer Specialist
> USDA, Forest Service, 333 SW First St., Portland, OR 97208
> Internet ---> FSWA/S=G.SANFORD/OU1=R06A_at_MHS.ATTMAIL.COM
> Internet ---> Osprey_at_Netcom.Com
> Voice-------> 503.326.4960
> FAX --------> 503.326.5743
>
> Previous comments:
> From: Vijay V.:X400
> Date: ## 05/20/94 15:02 ##
> From: C=US/ADMD=ATTMAIL/ORG=ATTMAIL/PN=Vijay V./
> DD.ID=internet(b)COMAGIC.MNET.USWEST.COM(b)db1/
>
> In Reply to Message :- 199405201759.AA17455(a)uswat.advtech.uswest.com
>
>
> Content-Type: ForwardedIPmessage
> Content-Length: 00000001007
>
>
> Message-Version: 2
> UA-Content-ID: <0q4Zpk.1hZ85o(a)pjl53wo.i-p.attmail.com>
> End-of-Header:
> EMail-Version: 2
> UA-Message-ID: <0q4Zpk.1hZ85o(a)pjl53wo.i-p.attmail.com>
> P2-Originator: internet!COMAGIC.MNET.USWEST.COM!db1
> End-of-Protocol:
> Content-Type: text
> Content-Length: 730
>
> >
> > Can one create more than one cursor in the same PL*SQL query and then > nest
> the open cursors and fetches in nested loops?
> >
> > create cursor1 from table1
> > create cursor2 from table1
> > create cursor3 from table1
> > open cursor1
> > loop
> > fetch cursor1
> > open cursor2
> > loop
> > fetch cursor2
> > open cursor3
> > loop
> > fetch cursor3
> > .
> > .
> > .
> > end loop
> > end loop {etc ... [ran out of space]
> >
>
>
> Yes, you can declare any number of cursors and open them ,fetch them and
> process them in a pl/sql block in nested loops.
>
> i dont remember if there is any restriction in version 1 (if at all there is a
> restriction it should be six , i am not sure).
>
> Vijay.
>
Date: Sat, 21 May 1994 12:42:20 -0300 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Rodolfo Jose Leite Netto <rodolfon_at_FEE.UNICAMP.BR> Subject: Re: Report Writer
You can call SQL*ReportWriter from PRO*C code. There is a programmatic interface to you. I know that's possible on Unix; I don't knonw if it's possible on Windows.
See srw.mk on sqlreport/admin/lib on your Unix box.
bye.
Date: Fri, 20 May 1994 16:04:04 ARG Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Alvaro Pereira <apereira_at_GELLYO.JUS.GOV.AR> Subject: 30 minutes generating a form
Hi ,
I moved a 6.0.36 database from one 486 to another (faster) one. Both have
SCO-Unix and 16 MB of memory.
I am having severe performance problems when generating forms. A form having about 20 references to forms stored in the database compiles in about 5 minutes when the database is just started up, but after some compilations performance degrades until it virtually kills the computer.
When this happens, a sar issued during generation reports 5% user time, 90% wio !!
I tried reorganizing the FORMS tables, increasing the SGA, moving the application to a database with plenty of space on all the tablespaces...
I also tried SQLDBA MONITOR but can't extract useful information from it.
I am the only user in the computer, and when the generation finishes everything seems to be fine again.
I suppose the Unix part really needs tuning, but I can't figure out what can be SO untuned!
Any help would be greatly appreciated.
Thanks in advance,
Alvaro Pereira Paz
email:apereira at minjus.gov.ar
Date: Mon, 23 May 1994 09:46:00 EDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "tauler,juan" <$J2T_at_PCCJES2.BITNET> Subject: Re: EXP as DBA - IMP as Non-DBA ?
Grant DBA to the instance where the Import will take place. Ideally make that t he same user name of that of the Export user id.
------------------------------TEXT-OF-YOUR-MAIL--------------------------------
> Received: (from MAILER_at_GWUVM for $J2T_at_PCCJES2 via NJE)
> (UCLA/Mail V1.500 M-RSCS7258-7258-37); Thu, 19 May 94 19:10:59 EDT
> Received: from GWUVM.GWU.EDU by GWUVM.GWU.EDU (Mailer R2.10 ptf000) with BSMTP
> id 1064; Thu, 19 May 94 19:10:40 EDT
> Date: Thu, 19 May 1994 16:10:36 -0700
> Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> Comments: Warning -- original Sender: tag was steiger_at_UX5.LBL.GOV
> From: Daniel Steiger <steiger_at_CSR.LBL.GOV>
> Organization: LBL (Lawrence Berkeley Laboratory), ICSD
> Subject: EXP as DBA - IMP as Non-DBA ?
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_SBCCVM.BITNET>
>
> I exported my tables (I'm the owner and also DBA) from Oracle 6.
> Now, I wanna import these tables into a Oracle7 DB (I'm a user *only* on
> that DB, not a DBA):
>
> Export file created by EXPORT:V06.00.31
> IMP-00013: only a DBA can import a file exported by another DBA
> IMP-00021: operating system error - error code (dec 2, hex 0x2)
> IMP-00000: Import terminated unsuccessfully
>
> Of course I tried to export these tables from another Oracle 6 account,
> which is not a DBA:
>
> Table to be exported: (RETURN to quit) > steiger.sensor
> EXP-00009: no privilege to export STEIGER's table SENSOR
>
> Any ideas how to solve this problem?
>
> Thanks in advance!
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~
> Daniel Steiger Lawrence Berkeley Laboratory Tel: (510) 486-742
0
> <steiger_at_csr.lbl.gov> Mail Stop 50B-3238 Fax: (510) 486-400
4
> Berkeley, CA 94720, U.S.A
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~
Date: Mon, 23 May 1994 13:30:16 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Sangeet Arun Amin <Sangeet_Amin_at_SEAS-CPO_at_CCMAIL.GSFC.NASA.GOV>
Subject: Re[2]: Forms 4.0.11 on Solaris 2.X
Thanks for your message. Just in: 4.0.12.X is supposedly out
on Solaris 2.X. I also received Bug# 181208 on the Forms
crashes. Hope all this is fixed in 4.0.12.X.
--Sangeet.
=========================================================================
Date: Mon, 23 May 1994 14:48:26 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Edward Nunez <enunez_at_ve.oracle.com>" <enunez_at_VE.ORACLE.COM>
Subject: Re: EXP as DBA - IMP as Non-DBA ?
In-Reply-To: VESUN1:<@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU>'s message of 05-23-94 09:46
If you are trying to import only the user, please try to run the imp with a DBA user and specify FROMUSER & TOUSER.
Hope this fixes your problem.
Best Regards,
/ Edward Nunez \
| Technical Support - TSC Group. |
| Oracle de Venezuela |
| Tel (58) 2 916487 |
| Fax (58) 2 9938555 |
| Internet Address: |
| enunez_at_ve.oracle.com |
\_________________________________________/
=========================================================================
Date: Mon, 23 May 1994 16:23:56 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Leonardo Fernandez <lfernand_at_ve.oracle.com>"
<lfernand_at_VE.ORACLE.COM>
Subject: O6 -> O7, migrations with Visual Basic.
Hi,
I have a customer who wants to migrate from Oracle 6.0 to Oracle 7.0
and he needs to know if his applications written with Visual Basic and
DDE Manager will have problems in this migration ?.
Is necessary to migrate the applications from DDE Manager to
Oracle*Glue for them to run correctly using Oracle Server 7 ?
Thanks in advance
Leonardo Fernandez.
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
=========================================================================
Date: Mon, 23 May 1994 18:20:00 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Kishore Mandava <0006649733_at_MCIMAIL.COM>
Subject: RUNFORM (ORACLE FORMS)
HI !
I have a problem in Oracle Forms 4.0. RDBMS is ver 7.0(may be useful)
running on a OS2 platform.
Now, my question is can we increase the size of the runtime screen(I
mean window). After running a form in RUNFORM 4.0, I am getting a default size
window, which is not full screen, to make it a full screen Iam maximizing it
later. Is there any option in Runtime preferences to get a full screen window.
Any solution to this problem will be greatly appreciated.
Thanks in advance.
kishore s.Mandava
Date: Tue, 24 May 1994 08:40:53 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Edward Nunez <enunez_at_ve.oracle.com>" <enunez_at_VE.ORACLE.COM> Subject: Re: RUNFORM (ORACLE FORMS)
In-Reply-To: VESUN1:<@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU>'s message of 05-23-94 18:20
Hi Kishore and Oracle-l!!!
Please try to use the FORMS_MDI_WINDOW, which is the handle or id for the runform window, you can then change the title, size, etc of this window. use set_window_property(FORMS_MDI_WINDOW,<property>,<value>);
Best Regards,
/ Edward Nunez \
| Technical Support - TSC Group. |
| Oracle de Venezuela |
| Tel (58) 2 916487 |
| Fax (58) 2 9938555 |
| Internet Address: |
| enunez_at_ve.oracle.com |
\_________________________________________/
Received: 05-23-94 19:26 Sent: 05-23-94 18:20From: VESUN1:<@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU> To: Multiple recipients of list ORACLE-L ORACLE-L_at_SBCCVM.BITNET Subject: RUNFORM (ORACLE FORMS)
HI !
I have a problem in Oracle Forms 4.0. RDBMS is ver 7.0(may be useful) running on a OS2 platform.
Now, my question is can we increase the size of the runtime screen(I mean window). After running a form in RUNFORM 4.0, I am getting a default size window, which is not full screen, to make it a full screen Iam maximizing it later. Is there any option in Runtime preferences to get a full screen window.
Any solution to this problem will be greatly appreciated.
Thanks in advance.
kishore s.Mandava
Date: Tue, 24 May 1994 08:49:43 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Tom Coker <tcoker_at_SCTLRS2.SCTCORP.COM>
Subject: Re: RUNFORM (ORACLE FORMS)
In-Reply-To: Letter from Kishore Mandava of May 23,
6:20pm "RUNFORM (ORACLE FORMS)"
On May 23, 6:20pm, Kishore Mandava wrote:
> Subject: RUNFORM (ORACLE FORMS)
> HI !
> I have a problem in Oracle Forms 4.0. RDBMS is ver 7.0(may be useful)
> running on a OS2 platform.
> Now, my question is can we increase the size of the runtime screen(I
> mean window). After running a form in RUNFORM 4.0, I am getting a default size
> window, which is not full screen, to make it a full screen Iam maximizing it
> later. Is there any option in Runtime preferences to get a full screen window.
> Any solution to this problem will be greatly appreciated.
>
> Thanks in advance.
> kishore s.Mandava
>-- End of excerpt from Kishore Mandava
We use Forms 4.0.12 for windows and it is our understanding that that will be a configurable option (in the oracle.ini file) available in 4.0.13. We'll see when it gets here.
--
_______ | Tom Coker, Sr. Programmer/Analyst
/_ __ ___ | SCT Public Sector, Lexington, KY
/(_)//( / _ /_/_ _ | EMAIL: tcoker_at_sctcorp.com
_________ /___(_)/ \(-'/ | PHONE: (606) 231-0519
/_________________ | FAX..: (606) 253-2142
=========================================================================
Date: Tue, 24 May 1994 13:54:36 LCL
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Gautam Shah <GAUTAM_at_BNK1.BNKST.EDU>
Subject: Re: your mail
Hi!
is there any way we can create responce window in oracle forms(v3.0). i.e in PowerBuilder we can create responce window using messagebox function.
Date: Tue, 24 May 1994 13:24:18 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Kevin E. Kline" <Kkline%ssdd_at_REDSTONE-EMH2.ARMY.MIL> Subject: SQL*Net v1.2
MAIL ORACLE-L Hi Ya'll,
I'm trying to connect a client PC running Forms 4.0, Reports 2.0, and the other CDE tools to a HP9000/750 using SQL*Net v1.1 for Windows. Despite the variations in setup that we use, we still get ORA-6108 'NETTCP Connect not Created'. Anyone have any ideas?
+---------------------------------------------------------------+ | | | Kevin Kline | | Nichols Research Corporation | | 4040 South Memorial Parkway, MS-912 | | Huntsville, Al 35802 | | v(205) 876-4921/ f(205) 955-6102 | | kkline%ssdd_at_redstone-emh2.army.mil | | | +---------------------------------------------------------------+ ========================================================================= Date: Tue, 24 May 1994 13:03:11 -0600 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "greg w. luft" <vgwlu_at_CHEVRON.COM> Subject: startup
Hi,
I am running Oracle version V6.0.37.3.1 on a Solaris 2.3 machine. When I go into sqldba and run a "startup" command I get the message
"Database Mounted"
and then it just sits there. I cannot connect external. Is there anyway to tell if a rollback is being done or to see what is going on?
gl
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Greg Luft Phone: (403) 234-6238Chevron Canada Resources
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
=========================================================================
Date: Tue, 24 May 1994 15:31:09 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Leonardo Fernandez <lfernand_at_ve.oracle.com>"
<lfernand_at_VE.ORACLE.COM>
Subject: CDE*TOOLS in V6 ?
Hi Friends,
I have a customer that has installed cde*tools with version V6.
Customer's Question :
1.- He wants to know if you recommend the above detailed ?
2.- Do you recommend that the cde*tools work with oracle V7 ?
Note : He has an application (forms 4.0) running with oracle V6 and has problems with the savepoints, they have edited the init.ora file to its fullest and haven't received a solution. But with Oracle V7 is running perfectly. Oracle V7 (is in DEMO/TEST) and Oracle V6 is in production.
Thanks in advance,
Leonardo Fernandez.
Leonardo Fernandez | Email : lfernand._at_ve.oracle.com
Technical Consultant, |
Oracle Venezuela |
----------------------------------------------------------------
=========================================================================
Date: Tue, 24 May 1994 16:34:24 LCL
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Gautam Shah <GAUTAM_at_BNK1.BNKST.EDU>
Subject: Re: SQL*Net v1.2
Hi,
how to connect powerbuilder and oracle on the same PC.
Date: Tue, 24 May 1994 16:41:00 LCL Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gautam Shah <GAUTAM_at_BNK1.BNKST.EDU> Subject: Re: RUNFORM (ORACLE FORMS)
I NEVER USED ORACLE 7.0 ,but I am doing same type of thing (maximizing window at runtime) using powerbuilder.It may give you some hint. In PB I change windowstate attribute to maximize! ( this is enumerated data type) from the click event of particular command button.
Date: Tue, 24 May 1994 19:00:30 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Edward Nunez <enunez_at_ve.oracle.com>" <enunez_at_VE.ORACLE.COM> Subject: Re: SQL*Net v1.2
In-Reply-To: VESUN1:<@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU>'s message of 05-24-94 13:24
Please Make sure the ORASRV is up & running on the server site. Generally, ORA-6108 happens because the orasrv is not running, Just try to do an "tcpctl start" on the server.
I hope this helps you,
Let me know it.
Best Regards,
/ Edward Nunez \
| Technical Support - TSC Group. |
| Oracle de Venezuela |
| Tel (58) 2 916487 |
| Fax (58) 2 9938555 |
| Internet Address: |
| enunez_at_ve.oracle.com |
\_________________________________________/
Received: 05-24-94 16:21 Sent: 05-24-94 13:24From: VESUN1:<@UGA.CC.UGA.EDU:owner-oracle-l_at_CCVM.SUNYSB.EDU> To: Multiple recipients of list ORACLE-L ORACLE-L_at_SBCCVM.BITNET Subject: SQL*Net v1.2
MAIL ORACLE-L Hi Ya'll,
I'm trying to connect a client PC running Forms 4.0, Reports 2.0, and the other CDE tools to a HP9000/750 using SQL*Net v1.1 for Windows. Despite the variations in setup that we use, we still get ORA-6108 'NETTCP Connect not Created'. Anyone have any ideas?
+---------------------------------------------------------------+ | | | Kevin Kline | | Nichols Research Corporation | | 4040 South Memorial Parkway, MS-912 | | Huntsville, Al 35802 | | v(205) 876-4921/ f(205) 955-6102 | | kkline%ssdd_at_redstone-emh2.army.mil | | | +---------------------------------------------------------------+ ========================================================================= Date: Tue, 24 May 1994 19:47:15 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Dagmar A. Bogan." <DAGMARA_at_DELPHI.COM> Subject: Re: 30 minutes generating a form
Alvaro;
Try executing TKPROF against the SQL in your form, and see if there are some full table scans that shouldn't, or if there are any recursive calls.
Tuning is tricky; unless you are an experienced DBA and UNIX guru, I would advise that you leave UNIX alone. In my experience, tuning the host only buys you maybe 5%, unless you have a vastly over-used system.
Dagmar Anne Bogan
Kopania & Komerovski
Richardson, TX 75081
Date: Wed, 25 May 1994 10:00:03 GMT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: FUCHS FRANCIS <frffu_at_EUROMIS.MILLIPORE.COM> Subject: Test & ask for list
Hi,
I am new listserv user and I'm just testing to see if I can successfully post
a message.
However I would like to know if someone knows about sone Sequent, C or C++ lists
thanks for any help
Francis
/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
/ Francis FUCHS /
/ System Administrator & Dba /
/ MILLIPORE S.A. EUROPE Internet: frffu_at_euromis.millipore.com /
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=========================================================================
Date: Wed, 25 May 1994 09:23:00 GMT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Huet Bartels <HUET1_at_VAXB.MIDDLESEX.AC.UK>
Subject: Re: CDE*TOOLS in V6 ?
From: CBS%UK.AC.EARN-RELAY::EARN.SBCCVM::ORACLE-L 24-MAY-1994 21:06:48.24
To: HUET1
Hi Leonardo,
CDE TOOLS are not support under V6 of Oracle, in the UK anyway
I know you can access a v6 database with CDE tools in some sort
of fashion. What sort of problems you will get who knows!
---------------------------<End Of Message>-------------------------------------
Huet Bartels
(Vax/Vms Oracle Systems Support)
Middlesex University
London
England.
Mail Address:
Janet :- HUET1_at_UK.AC.MIDDLESEX.CLUSTER
Internet :- HUET1_at_CLUSTER.MIDDLESEX.AC.UK
Fax :- 41-081-362-5967
Telephone :- 41-081-362-5591
=========================================================================
Date: Tue, 24 May 1994 13:28:22 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Robert M. Gross" <rmgross_at_DOW.COM>
Subject: Rdb V6.1 and Oracle
We are about to start upgrading a lot of systems to VMS 6.1, both VAX and AXP, and I'd like to check on potential problems regarding Oracle. Are any of you aware of any problems with Oracle (particularly V7) or any Oracle products relating to this upgrade?
Robert Gross
rmgross_at_dow.com
Date: Wed, 25 May 1994 10:09:09 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Marilyn H. Wilson,
Senior Programmer/Analyst" <MWILSON_at_VDH.BITNET>
Subject: SQL*MENU V5
VDH, Division of Information Resources
PROFS: VDH(MWILSON) (804) 786-1545
Subject: SQL*MENU V5
I want to thank everyone who replied to my SQL*MENU question on passing variables, they all worked beautifully!
Date: Wed, 25 May 1994 09:40:32 LCL Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gautam Shah <GAUTAM_at_BNK1.BNKST.EDU> Subject: clear field
Hi!,
I am novice in oracle.I have a problem of this type-
In one block I have two field (1) prodid(2)descrip
When I run form and press execute query (F8) on prodid I can get description
of that item in descrip field.If I enter a prodid value which is not exist
it still saw previous value in descrip field.How to get rid of this? Any
hint welcome
thanks in advance,
Gautam Shah
Date: Wed, 25 May 1994 10:05:33 LCL Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gautam Shah <GAUTAM_at_BNK1.BNKST.EDU> Subject: Re: one in a thousand
Hi!,
if you want to reply just to sender you can choose his/her address from FROM
field.
Date: Wed, 25 May 1994 15:52:00 GMT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Huet Bartels <HUET1_at_VAXB.MIDDLESEX.AC.UK> Subject: FORMS 3 help
Hi Oracle-L,
I have two problems I can't seem to find clean solutions too.
Sorry one more....
3) I would like to setup some of my fields as mutaly excluisive
using 'Y' or 'N' I am unsure what type of trigger to use and
if DECODE must be used. Could I use the space bar as a toggle
or any suggestions you may have as to a good key.
Thanks for reading this message and taking the time to reply
---------------------------<End Of Message>-------------------------------------
Huet Bartels
(Vax/Vms Oracle Systems Support)
Middlesex University
London
England.
Mail Address:
Janet :- HUET1_at_UK.AC.MIDDLESEX.CLUSTER
Internet :- HUET1_at_CLUSTER.MIDDLESEX.AC.UK
Fax :- 41-081-362-5967
Telephone :- 41-081-362-5591
=========================================================================
Date: Wed, 25 May 1994 10:55:37 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "ctorreal.VE" <ctorreal_at_VE.ORACLE.COM>
Subject: Problems with Entity Diagramer Oracle*Case
Hi everybody.
When we call the Entity Diagramer of Oracle Case we receive the next message.
Major opcode of failed request: 62 (xcopyarea)
Minor=opcode of failed request: 0
resource id in failed request 0xb00086
serial number of failed request: 646
current serial number in output string: 715
Somebody have any idea about that.
Any information will be preciate.
Carlos Torrealba
Technical Support Analyst
Oracle Venezuela
ctorreal_at_ve.oracle.com
Date: Wed, 25 May 1994 11:03:20 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Sangeet Arun Amin <Sangeet_Amin_at_SEAS-CPO_at_CCMAIL.GSFC.NASA.GOV>
Subject: Forms 4.0.12.X for Solaris in?
Hi there!
Has anyone yet received Forms 4.0.12.X on Solaris 2.3? I was
informed by Oracle that it is out. However, I have not seen
it yet.
--Sangeet.
=========================================================================
Date: Wed, 25 May 1994 09:52:13 MDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Vijay V." <db1_at_COMAGIC.MNET.USWEST.COM>
Subject: Re: clear field
In-Reply-To: <199405251434.AA27028_at_uswat.advtech.uswest.com>; from "Gautam
Shah" at May 25, 94 9:40 am
>
> Hi!,
>
> I am novice in oracle.I have a problem of this type-
> In one block I have two field (1) prodid(2)descrip
> When I run form and press execute query (F8) on prodid I can get description
> of that item in descrip field.If I enter a prodid value which is not exist
> it still saw previous value in descrip field.How to get rid of this? Any
> hint welcome
> thanks in advance,
> Gautam Shah
>
You create trigger key_nxtfld or post_change in which or any such triggers and use the clear_field package procedure as first statement and then use the appropriate error message to indicate that prodid does not exist in the table.
Vijay.
Date: Wed, 25 May 1994 10:04:12 MDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Vijay V." <db1_at_COMAGIC.MNET.USWEST.COM>
Subject: Re: FORMS 3 help
In-Reply-To: <199405251527.AA28908_at_uswat.advtech.uswest.com>; from "Huet
Bartels" at May 25, 94 3:52 pm
>
> Hi Oracle-L,
>
> I have two problems I can't seem to find clean solutions too.
>
>
> 1) With a list of values I would like to display an item and its
> description to the user, on selecting an item ONLY use the item
> not the description to populate the field.
>
> 2) I have a multi block form that has x columns, I would like some
> advice on how pass the primary key for the record my cursor is
> on to the calling form to be used as the foriegn key.
>
> Sorry one more....
>
> 3) I would like to setup some of my fields as mutaly excluisive
> using 'Y' or 'N' I am unsure what type of trigger to use and
> if DECODE must be used. Could I use the space bar as a toggle
> or any suggestions you may have as to a good key.
>
>
>
> Thanks for reading this message and taking the time to reply
>
> ---------------------------<End Of
Message>------------------------------------->
> Huet Bartels
> (Vax/Vms Oracle Systems Support)
>
> Middlesex University
> London
> England.
>
> Mail Address:
>
> Janet :- HUET1_at_UK.AC.MIDDLESEX.CLUSTER
> Internet :- HUET1_at_CLUSTER.MIDDLESEX.AC.UK
> Fax :- 41-081-362-5967
> Telephone :- 41-081-362-5591
Date: Wed, 25 May 1994 10:13:58 MDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Vijay V." <db1_at_COMAGIC.MNET.USWEST.COM>
Subject: Re: Forms 4.0.12.X for Solaris in?
In-Reply-To: <199405251534.AA29149_at_uswat.advtech.uswest.com>; from "Sangeet
Arun Amin" at May 25, 94 11:03 am
>
> Hi there!
>
> Has anyone yet received Forms 4.0.12.X on Solaris 2.3? I was
> informed by Oracle that it is out. However, I have not seen
> it yet.
>
> --Sangeet.
>
You have heard it right Oracle Forms 4.0.12.4.1 on Solaris 2.3
is released by oracle. We at US West Communications at Denver
have received last week and got it installed. However, we haven't
yet started using it.
Vijay.
=========================================================================
Date: Wed, 25 May 1994 13:39:05 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: "Jennifer R. Amon (216) 775-6987" <BAMON_at_OCVAXC.CC.OBERLIN.EDU>
Subject: Re: FORMS 3 help
>> 1) With a list of values I would like to display an item and its
>> description to the user, on selecting an item ONLY use the item
>> not the description to populate the field.
You can have an LOV that selects multiple fields, but only populates the first field of the "into" clause, i.e.
select field1,field2
into :block1.field1
from table_a
order by field1
Field2 will show up in the LOV display, but be discarded. Only field1 will be put into :block1.field1. Yes, it used to be that you had to have a dummy field into which you could select the second value, but that is no longer necessary.
bamon_at_ocvaxc.cc.oberlin.edu
Date: Wed, 25 May 1994 13:13:19 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gigi Suardi <gigi_at_SOFTINT.COM> Subject: powerbuilder question
hi there,
assume we have 2 different ORACLE databases in 2 different locations like houston and minneapolis. can we develop a powerbuilder application in houston and run it in minneapolis? what are the steps involved in this process other than creating (in minneapolis) the same set of tables (schema) that are used by the application in houston? any ideas or similar experiences are welcome. thanks.
luigi.
PS does anybody know how to contact powersoft via email
to ask then to start a listserver?
we have to learn the language of Nature
to be able to understand her.
Hundertwasser
=========================================================================
Date: Wed, 25 May 1994 11:57:00 PDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Larry Tredway <lrtredwa_at_GOPHER.RDYNE.ROCKWELL.COM>
Subject: C++ Lists
>However I would like to know if someone knows about sone Sequent, C or C++ list
s
I have not used it, but I saw a C++ list on the list of lists: INFO-C. Mail to info-c-request_at_research.att.com.
If anyone knows of a visual C++ list,
please let me know.
Thanks, Larry lrtredwa_at_gopher.rdyne.rockwell.com
Date: Wed, 25 May 1994 17:32:00 EST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Comments: <Parser> W: TO field duplicated. Last occurrence was retained. Comments: <Parser> W: TO field duplicated. Last occurrence was retained. Comments: <Parser> W: TO field duplicated. Last occurrence was retained. Comments: <Parser> W: TO field duplicated. Last occurrence was retained. Comments: <Parser> W: TO field duplicated. Last occurrence was retained. Comments: <Parser> W: TO field duplicated. Last occurrence was retained. Comments: <Parser> W: TO field duplicated. Last occurrence was retained. Comments: <Parser> W: TO field duplicated. Last occurrence was retained. Comments: <Parser> W: TO field duplicated. Last occurrence was retained. From: Kishore Mandava <0006649733_at_MCIMAIL.COM> Subject: Re: clear field
HI GAUTHAM ! For your problem in oracle forms, after performing the Execute_query
clear the block with clear_block procedure. This you can write in
different Triggers like key_commit(commit after doing some changes to
the queried record.),key_nxtfld or when you do enter_query prior to the
execute_query you don't need to clear the block(because enter_query by
default clears the block).
Hope this will help you !!
kishore s.mandava
Richardson, texas.
Date: Thu, 26 May 1994 10:36:55 MAL Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Gavin Bong Chun Jin <bongstar_at_APEC.MY> Subject: [off topic] Prison Management System
Hi
I am looking for a PRISON management system running on oracle or other databases or maybe even a native software with its own database system. It should run on UNIX/PC environment.
Thanks a lot.
Warmest Regards
Gavin Bong
=-------------=
Technical Support Analyst
email: bongstar_at_apec.my
Date: Thu, 26 May 1994 16:08:57 GMT0BST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Paul Manning <PCM_at_MCS.LE.AC.UK> Organization: MCS, Leicester University Subject: Re: BLACK SCREEN OF DEATH
Subject: Re: BLACK SCREEN OF DEATH
I've had similar problems with Oracle Forms 4.0 running under Windows 3.1 against an Oracle 7 database on a Netware server i.e. Black Screen of death. I talked to Oracle about it and there were two fixes required. Firstly, upgrade to the most recent versions of the sqlspx drivers (both PC and Unix ends). I did this - no cure. The second one is to upgrade my forms package to 4.0.12... which I am still waiting for! The explaination for the latter was that the application was using memory in the first 640K of REAL memory and not releasing it, the network drivers also use this memory, result - out of memory errors and crashes. I not convinced any one really knows what goes on! I've also using the latest netware DOS and Windows drivers (DOSUP9 and WINUP9) and the MS patches for Windows to get to version 3.11 (available from ftp.microsoft.com - can't remember the filename, sorry).
Anyway, I hope this is of some use, but I'm beginning to have doubts about Windows as a stable platform for Serious work.
Cheers, Paul.
> Date sent: Wed, 25 May 1994
10:28:10
CDT > Send reply to: Novell LAN Interest Group <NOVELL_at_SUVM.EARN>
> From: Sam Woo <SHWOO_at_YJ0090C.REMNET.ROCKWELL.COM>
> Subject: BLACK SCREEN OF DEATH
> Originally to: NOVELL_at_SUVM.SYR.EDU
> To: Multiple recipients of list NOVELL <NOVELL_at_SUVM.EARN>
> We have an application called PowerViewer version 3.0a from PowerBuilder
folks.
> This is basically a report generation program which accesses the Oracle7
> database residing on zuma (HP UNIX) machine. The communication takes place
> between client (PC) and the server (HP) is via sqlspx driver.
>
> There are two ways you can generate reports from the database using
PowerViewer.
> 1) Use PowerViewer and create reports.
> 2) Make an executable of the report programs and deploy them on novell
servers.
> This is where the problem is occuring. The latest version I am testing is on
my
> my local drive with necessary DLLs etc. When I run the executable, the program
> is able to connect to the database. Then when I click on the report, I see
> the program hanging up with black screen and the cursor on upper left hand
> corner.
>
> I called up PowerViewer and they seem to think it is novell problem. They told
> me this problem is called "Black screen of death" by novell!. Novell have some
> solution to this problem. However I don't understand how the reports work when
> using PowerViewer
>
> Does anyone out there know of or heard of this problem.
>
> Thanks
>
> Sam Woo
> Rockwell Aerospace
> shwoo_at_yj0090c.remnet.rockwell.com
Paul C. Manning
Senior Computer Officer
Department of Mathematics and Computer Science
University of Leicester
University Road
Leicester LE1 7RH
U.K.
tel: +44 533 522571
fax: +44 533 523604
e-mail: pcm_at_uk.ac.le.mcs
"Mmmmmmmmm - Glad to be of service - Mmmmmmmmm"
Date: Thu, 26 May 1994 06:51:47 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: RDB8%IC%DCPP_at_BANGATE.PGE.COM Subject: Re: powerbuilder question
>PS does anybody know how to contact powersoft via email
> to ask then to start a listserver?
There is a comp.sys.power.builder newsgroup available.
Rick Box : System Analyst Pacific Gas & Electric Internet : rdb8_at_pge.com Diablo Canyon Nuclear Power Plant
P.O.Box 56 I&C 102/2
Avila Beach, CA 93424
Tel: (805) 545-4229 Fax: 545-3373
---------------------------------------------------------------------------
*** The views expressed here are my own and do not necessarily ***
*** reflect those of PG&E. ***
---------------------------------------------------------------------------
=========================================================================
Date: Thu, 26 May 1994 09:17:47 -0700
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Binoj Kumar <Binoj.Kumar_at_AMD.COM>
Subject: SQLNET Error 6110
Hi,
I am working on developing a Windows application using Pro*C to access
the Oracle database on a UNIX server. I keep getting the 6110 error
on certain PCs, while it executes properly on other PCs.
I got a copy of the Bulletin that Oracle put out on this isuue. It suggests the following
1.Set the TCP/IP buffer size to 1024 in the connect string.
I set the buffer size in the connect string to 1024. This has reduced the frequency at which we were getting this problem earlier. However, we still get this error periodically.
2. A work-around for a Microsfot TCP v1.0 bug was to increase the MAXSENDSIZE in TCPUTILS.INI to 1024.
We are using PC-NFS v5.0 as the communication software. I could not find a TCPUTILS.INI on the PC.
Does any of you know of any other work-arounds or any ideas on what else I could try? I am using SQL*NET version 1.1.7.5 and Pro*C v1.5.
Thanks
-Binoj Kumar
AMD
Date: Thu, 26 May 1994 12:13:00 EST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Donald Welker <WELKER_at_NOR.NUWC.NAVY.MIL> Subject: Re: BLACK SCREEN OF DEATH
>Anyway, I hope this is of some use, but I'm beginning to have doubts
>about Windows as a stable platform for Serious work.
You're neither the first nor the last. MS-Windows is a master stroke of marketing, not technical, excellence. The compiler vendors have some room to improve in this area, also. So you've got buggy code with a buggy compiler running on top of a buggy OS -- problematic at best. It's a miracle that things work as well as they do.
(just my opinion)
Date: Thu, 26 May 1994 17:47:26 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "ctorreal.VE" <ctorreal_at_VE.ORACLE.COM> Subject: problems installing sqlnet tcpip on dos with pc-nfs v3.5
I tried to install tcpip on dos with pc-nfs version 3.5 and i get an ora-6107.
I check
and does not work.
any idea ?
if so , please send me information
thanks - gracias.
Date: Thu, 26 May 1994 17:38:31 ARG
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Alvaro Pereira <apereira_at_GELLYO.JUS.GOV.AR>
Subject: Re: FORMS 3 help
In-Reply-To: <9405251527.AAwrkv19552_at_relay1.UU.NET>; from "Huet Bartels" at
May 25, 94 3:52 pm
Hi Huet,
(1) Already answered...
(2) I'm not sure I undestood your question, but: If you want to pass values
between two forms, then you can either user global variables (:global.my_ var:=my_value) or insert values in a table (and exit the form with no_roll back).If you want to know the values of a field in the record where your cursor is, you can use :system.cursor_value (see also :system.cursor_field)
(3) You can use ON-VALIDATE-FIELD, or, if you will also execute queries in
that block, POST-CHANGE (or ON-VALIDATE combined with POST-QUERY). You don't have to use decode, just
if :block.field not in ('Y','N')
then
message('Press Y or N');
raise form_trigger_failure;
You may just let the user type Y or N in a field with auto-skip. I don't see a very natural way of using the space bar to toggle, but is you absolutely want it this way, you may use a dummy field with echo off and auto-skip, define the Y or N field as next in order to the dummy, use ON-NEW-FIELD- INSTANCE in the Y or N field to change its value and return to the dummy, and KEY-NXTFLD in the dummy (which is not fired if auto-skip is enabled) to navigate to the field next to 'Y or N field'.
Hope this helps...
Bye,
Alvaro Pereira Paz
Ministerio de Justicia
Buenos Aires
Argentina
e-mail:apereira at minjus.jus.gov.ar
>
> Hi Oracle-L,
>
> I have two problems I can't seem to find clean solutions too.
>
>
> 1) With a list of values I would like to display an item and its
> description to the user, on selecting an item ONLY use the item
> not the description to populate the field.
>
> 2) I have a multi block form that has x columns, I would like some
> advice on how pass the primary key for the record my cursor is
> on to the calling form to be used as the foriegn key.
>
> Sorry one more....
>
> 3) I would like to setup some of my fields as mutaly excluisive
> using 'Y' or 'N' I am unsure what type of trigger to use and
> if DECODE must be used. Could I use the space bar as a toggle
> or any suggestions you may have as to a good key.
>
>
>
> Thanks for reading this message and taking the time to reply
>
> ---------------------------<End Of
Message>-------------------------------------
> Huet Bartels
> (Vax/Vms Oracle Systems Support)
>
> Middlesex University
> London
> England.
>
> Mail Address:
>
> Janet :- HUET1_at_UK.AC.MIDDLESEX.CLUSTER
> Internet :- HUET1_at_CLUSTER.MIDDLESEX.AC.UK
> Fax :- 41-081-362-5967
> Telephone :- 41-081-362-5591
========================================================================= Date: Fri, 27 May 1994 09:05:00 GMT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Huet Bartels <HUET1_at_VAXB.MIDDLESEX.AC.UK> Subject: Re: problems installing sqlnet tcpip on dos with pc-nfs v3.5 Subj: problems installing sqlnet tcpip on dos with pc-nfs v3.5 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_EARN.SBCCVM>
>I tried to install tcpip on dos with pc-nfs version 3.5 and i get an ora-6107.
>
>I check
>
> - the TCP_SERVICES_FILE in the config.ora
> - for tabs in services file
> - a carriage return at the end of each entry in services file
> - /port number after server name or ip address
>
>and does not work.
>
>any idea ?
>
>if so , please send me information
>
>thanks - gracias.
>
>
I do not know PC-NFS, but I have some suggestions to try.
You need to include the name of you TCP/IP host in a file called HOST.LOCAL or HOST.ETC it is something like that. It has the word HOST in it somewhere, not just in your config.ora.
The format of the line you add is something like the following which is from the TCP/IP package UCX VAX/VMS.
158.94.1.23 BG1 bg1
The numbers are the IP address of the server node 158.94.1.23 The words in upper and lower case is the name of the server.
Once you find this file it should be clear how to format the line.
Hope this helps.
---------------------------<End Of Message>-------------------------------------
Huet Bartels
(Vax/Vms Oracle Systems Support)
Middlesex University
London
England.
Mail Address:
Janet :- HUET1_at_UK.AC.MIDDLESEX.CLUSTER
Internet :- HUET1_at_CLUSTER.MIDDLESEX.AC.UK
Fax :- 41-081-362-5967
Telephone :- 41-081-362-5591
=========================================================================
Date: Fri, 27 May 1994 10:40:44 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Matt Yardley <yardley_at_OFFSV2.CIS.MCMASTER.CA>
Subject: Rollback Segments
I know the purpose of the rollback segment, but, I was wondering what others were allocating for size of both the tablespace and the segments themselves.
I recently had a request to update one field in all 200,000 rows of a table and have been blowing the rollback segments. We are running oracle 7.0.15 with solaris 2.3. This may or may not be a request that is an exception. What have others done to accommodate such requests? Do they create temporary rollback tablespaces/segments huge enough to handle this? Currently I have 4 segments of 150K each and the tablespace is 20M.
Matt Yardley, DB/DC Analyst C.I.S. Phone: (905)525-9140 Ext. 24185 McMaster University Fax: (905)528-3773 Gilmour Hall, Room 217E Hamilton, Ontario, Canada, L8S 4L8 Email: YARDLEY_at_MCMASTER.CA ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 27 May 1994 10:04:53 MDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Pinchas Nissenson <62608_at_UCDASVM1.ADMIN.UCALGARY.CA> Subject: Rollback Segments
FROM: Pinchas Nissenson
Department of Admin. Systems
I would just issue a commit every 1000 records ....
University of Calgary Phone: 403-220-4447 Calgary, Alberta, Canada Fax: 403-282-9361Email: 62608_at_UCDASVM1.ADMIN.UCALGARY.CA
Date: Fri, 27 May 1994 12:32:57 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Matt Yardley <yardley_at_OFFSV2.CIS.MCMASTER.CA> Subject: Re: Rollback Segments
This would be possible if the SQL were part of a program. If it simply is one statement being issued from SQLPLUS 3.0 or SQLDBA such as
update schema.table
set fielda = 'xxx'
;
how would you commit every n records.
Matt Yardley, DB/DC Analyst C.I.S. Phone: (905)525-9140 Ext. 24185 McMaster University Fax: (905)528-3773 Gilmour Hall, Room 217E Hamilton, Ontario, Canada, L8S 4L8 Email: YARDLEY_at_MCMASTER.CA ------------------------------------------------------------------------------
On Fri, 27 May 1994, Pinchas Nissenson wrote:
> FROM: Pinchas Nissenson
> Department of Admin. Systems
> I would just issue a commit every 1000 records ....
>
> University of Calgary Phone: 403-220-4447
> Calgary, Alberta, Canada Fax: 403-282-9361
> Email: 62608_at_UCDASVM1.ADMIN.UCALGARY.CA
>
Date: Fri, 27 May 1994 13:55:52 EST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Sangeet Arun Amin <Sangeet_Amin_at_SEAS-CPO_at_CCMAIL.GSFC.NASA.GOV>
Subject: FORMS 4.0.12.X on 7.0.15.4 anyone?
Hi there:
Anyone successful in installing 4.0.12.X(the
Production 2 version) 7.0.15.4 on Solaris 2.3?
Supposedly its "certified" for both 7.0.16.4 and 7.0.15.4.
--Sangeet
=========================================================================
Date: Fri, 27 May 1994 13:19:53 U
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Chris Insley <Chris_Insley_at_CATS.NAVY.MIL>
Subject: Re: Rollback Segments
Reply to: RE>>Rollback Segments
You must utilize a WHERE clause to limit the number of rows updated. Perhaps
where fielda='xxx'
This would be possible if the SQL were part of a program. If it simply is one statement being issued from SQLPLUS 3.0 or SQLDBA such as
update schema.table
set fielda = 'xxx'
;
how would you commit every n records.
Matt Yardley, DB/DC Analyst C.I.S. Phone: (905)525-9140 Ext. 24185 McMaster University Fax: (905)528-3773 Gilmour Hall, Room 217E Hamilton, Ontario, Canada, L8S 4L8 Email: YARDLEY_at_MCMASTER.CA ------------------------------------------------------------------------------
On Fri, 27 May 1994, Pinchas Nissenson wrote:
> FROM: Pinchas Nissenson
> Department of Admin. Systems
> I would just issue a commit every 1000 records ....
>
> University of Calgary Phone: 403-220-4447
> Calgary, Alberta, Canada Fax: 403-282-9361
> Email: 62608_at_UCDASVM1.ADMIN.UCALGARY.CA
>
Date: Fri, 27 May 1994 14:37:56 EDT
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: Beverly Norwood <csvbcn_at_ADMIN.AC.EDU>
Subject: Re: Rollback Segments
In-Reply-To: <9405271446.AA60844_at_admin.ac.edu>; from "Matt Yardley" at May 27,
94 10:40 am
Matt,
What we usually do in such a situation is to create a huge rollback segment, take down the database (after hours, of course). Change initSID.ora so that it will use only this additional rollback segment, restart the database and perform the updates. This is all assuming that you have enough free disk space available to create the rollback segment.
If space is a problem in these situations, I usually write a sqlplus script that will perform the updates on a reduced set of records (e.g. id_numbers between '000000000' and '299999999') and commit, then perform the update on the next set, commit, ...
Hope this helps
By the way, we have 15 rollback segs in addition to the system rollback seg. One is 190 meg; the rest are 20 meg.
>
> I know the purpose of the rollback segment, but, I was wondering
> what others were allocating for size of both the tablespace and the >
segments themselves. > > I recently had a request to update one field in
all 200,000 rows > of a table and have been blowing the rollback segments.
We are running > oracle 7.0.15 with solaris 2.3. This may or may not be a
request that is > an exception. What have others done to accommodate such
requests? Do > they create temporary rollback tablespaces/segments huge
enough to handle > this? Currently I have 4 segments of 150K each and the
tablespace is 20M. > >
Beverly Norwood, Systems Manager/DBA
Augusta College
(706) 737-1484 or GIST 337-1484
Internet: bnorwood_at_admin.ac.edu
Date: Fri, 27 May 1994 16:01:43 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Kurt Jordan CUSS <jordanka_at_PUCAL1A.CALUMET.PURDUE.EDU> Subject: Re: rollback segments
I have run into the same rollback segment problem (oracle 6.0.36).
I created a 52Meg rollback segment in a tablespace set aside for only temporary segments and we use that for our large transactions that don't have intermediate commits.
You didn't mention how you are doing updates, or exactly what error condition was occuring (max extents, no space in the tablespace for the next allocation, etc.)
When we (application programmers and me) were oracle neophytes, we loaded 30000+ records ( initial data base load) and had to break the records down into groups to fit into the rb segments I had defined, insert a group, commit, insert another group, commit, etc. It took a long time, but we got them in.
Kurt Jordan
System Administrator
Purdue University Calumet
Hammond IN 46383
219 989 2590
Date: Fri, 27 May 1994 16:03:19 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Kurt Jordan CUSS <jordanka_at_PUCAL1A.CALUMET.PURDUE.EDU> Subject: Re: rollback segments
you could put:
insert into ...
where rowid < 1000;
commit;
insert into ...
where rowid > 1000 and < 2000;
commit;
etc.
slow, but effective.
Kurt Jordan
System Administrator
Purdue University Calumet
Hammond IN 46383
219 989 2590
Date: Fri, 27 May 1994 14:46:02 PDT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Jay Rostosky <JROSTOSK_at_US.ORACLE.COM> Subject: rollback segments
since 6.0.33 of ORACLE, one can say
"set transaction use rollback segment <rbs_name>"
That way you can have a big rbs for such txns and actually TELL ORACLE to use that particular one.
Or...you can COMMIT more often, like every 1000 rows.
Character-mode RULES!!! Playing with mice all day is for cats, not computer professionals. And as for clicking...I'd rather SNAP, thank you.
Jay Rostosky, DMD Technical Pre-Sales
415/506-3826
jrostosk_at_us.oracle.com
Date: Fri, 27 May 1994 15:41:03 PST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Larry Crawford <LCRAWFOR_at_CVDLS.UCDAVIS.EDU> Subject: E-Mail/Work Group Product for Novell
I am looking for some recommendations for e-mail/workgroup products for Windows clients attached to Netware Servers. We are currently considering Oracle Office. Is anybody using Oracle Office or a product with similar capabilities in this environment which they'd care to comment on?
Replies sent directly to me will be summarized and posted to the list if I get a significant number of responses.
Thanks,
Larry Crawford \ / California Veterinary Diagnostic Lab Information Systems Specialist - * - University of California at Davis lcrawfor_at_cvdls.ucdavis.edu / \ Davis, CA 95616 (916) 752-4407 ========================================================================= Date: Sat, 28 May 1994 12:30:08 -0300 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Rodolfo Jose Leite Netto <rodolfon_at_FEE.UNICAMP.BR> Subject: Forms4&Reports2 vs Powerbuilder vs SQL*Windows
Oracle-l:
Let's make a comparision of these tree front-ends for Oracle. It's usefull for all of us to know the best.
Send your opnions to rodolfon_at_fee.unicamp.br. I'll summaryze it to Oracle-l.
Until Jun, 15 -> 1st summary
Until Jul, 15 -> 2nd summary (you'll read other opnions and may change yours)
Thanks for all of us.
Date: Sat, 28 May 1994 16:38:52 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Steven F Medin <smedin_at_WORLD.STD.COM> Subject: Re: powerbuilder questionIn-Reply-To: <199405251955.AA14356_at_world.std.com>
> assume we have 2 different ORACLE databases in 2 different locations
> like houston and minneapolis. can we develop a powerbuilder
> application in houston and run it in minneapolis?
> what are the steps involved in this process other than
> creating (in minneapolis) the same set of tables (schema)
> that are used by the application in houston?
> any ideas or similar experiences are welcome.
> thanks.
>
> luigi.
There is no part of PowerBuilder that limits your ability to do this. If your network people can get the IP transports to do the habla, then PB can be pointed at data anywhere.
>
> PS does anybody know how to contact powersoft via email
> to ask then to start a listserver?
>
Look for comp.soft-sys.powerbuilder on Usenet soon. They are most of the
way through the application process. Once they're in Useland, some
school will probably start a listserver site.
-Steve.
Date: Sat, 28 May 1994 23:18:34 -0300 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Rodolfo Jose Leite Netto <rodolfon_at_FEE.UNICAMP.BR> Subject: Deleting few rows to save rollback> You must utilize a WHERE clause to limit the number of rows updated. Perhaps
>
> Reply to: RE>>Rollback Segments
loop
delete from table
where your-condition and
rownum <= 1000;
exit when sql%rowcount < 1000;
commit;
end loop;
=========================================================================
Date: Sun, 29 May 1994 13:00:00 PST
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: AlexTheodossis <ALEXTHEO_at_BEACH1.CSULB.EDU>
Subject: Re: Forms4&Reports2 vs Powerbuilder vs SQL*Windows
can somebody tell me how can I delete my name from this list?
Date: Mon, 30 May 1994 09:27:00 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Jeff Kohn <Jeff_Kohn-BPGM36_at_EMAIL.MOT.COM> Subject: POWERBUILDER/WATCOM BACKUP - HOW?
Would someone please give me a working syntax example of the use of DBBACKW - the Watcom SQL backup utility. When I translate the syntax listed in the Watcom manual shipped with PB 3 to action, all I get is a messagebox full of syntax and flags from Watcom - but no backup. Thanks.
Date: Mon, 30 May 1994 11:23:25 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: Danny Lepage <poutine_at_M3ISYSTEMS.QC.CA> Subject: ORA-01460: unimplemented or unreasonable conversion requested
Hi,
I'm getting an "ORA-01460: unimplemented or unreasonable conversion
requested" message when I try to a call a stored procedure from OCI.
Procedure:
CREATE OR REPLACE PACKAGE xxx AS
type CallNoArray is table of call.cal_no%TYPE
index by binary_integer;
PROCEDURE yyy(
array_size IN INTEGER,
call_no IN call.cal_ncall.cal_no%TYPE,
call_no_out OUT CallNoArray);
SELECT cal.cal_no
FROM call cal
WHERE cal.cal_no > call_no
ORDER BY cal.cal_no ASC;
FETCH yyy_cur INTO call_no_out(i);
IF yyy_cur%NOTFOUND THEN
exit;
END IF;
Finally, I'm calling this stored procedure as follow: BEGIN xxx.yyy(5, ' 7', :ph0); END;
(in OCI, doing the necessary parsing and binding before calling oexec).
Somebody has a clue of what might be the problem? I'm using Oracle 7 and OCI 1.5 (on OS 2.1), connected to a Novell Oracle 7 server via SQL*Net SPX/IPX V1.
Thanks in advance
Danny Lepage
poutine_at_M3iSystems.QC.CA
dlepage_at_altitude.CAM.ORG
Date: Mon, 30 May 1994 18:34:36 -0400 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Comments: Warning -- original Sender: tag was ALIEN_at_ENAPSTG1 From: Jc Duran <JCDURANN_at_ENAPSTG1.BITNET> Subject: Oracle on VM Performance
I monitor this ORACLE-L list periodically and almost all the contributors are talking about ORACLE running on UNIX-based or VMS-based machines.
What about running ORACLE on an IBM mainframe machine ?
We are currently running ORACLE V7.0.15.4 for VM/ESA 2.0 on an IBM 9221-150 proccessor : 9345 Dasd, 32 Mb Central Memory. It seems that it's not possible to achieve 'good' (subsecond response time) performance in this environment. As an example : The clock time in order to get into the first SQLFORMS menu is about 15 seconds from the moment at wich the SQLFORMS / command is entered at the CMS prompt.
I do recognize that a paging load of 250 pages/sec and a 80% CPU utilization (values at the time the above test was done) is not a good situation, but under this circunstances almost all the interactive load (exept ORACLE) is done with subsecond response time.
Oracle V7 on VM runs only on two-task mode and in this system ORACLE is configured in order to mantain five dedicated servers always waiting for a request to access Oracle from a CMS user. The CMS user run the tools code from a Saved Segment that is accessed while the virtual machine is in XA mode.
The dedicated servers and background machines are all with a graeter relative share than the common users.
Does somebody have any comments about this situation ?
Is an IBM 9221-150 32 Mb a ORACLEable machine ?
Can somebody point to me on where can I find more info relative to ORACLE performance running on VM/ESA ? (My ORACLE representative has not been able to give us this information)
Do I need a larger IBM processor to run ORACLE with 'good' response time ?
The expected workload is of about 20 Oracle users doing simple querys and update using a combination of SQLFORMS/SQLMENU apps.
Thanks a lot
Juan Carlos Duran (JCDURANN at ENAPSTG1.BITNET)
Empresa Nacional del Petroleo
Santiago - Chile
Date: Mon, 30 May 1994 17:35:00 CST Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "Mr. Rafael Salinas Sangines" <RSALINAS_at_ITESMVF1.BITNET> Subject: Arrays
Does any one knows if Oracle can work with arrays or how could we simulate one? We have been working with Oracle v 7.0 and it seems to be impossible. The only way around this problem seems to use a char type (fixed length) and assign posi tions to its contents... It is not the most efficient way to handle data, so we are looking for another way.
Thanks in advance
Rafael
Date: Mon, 30 May 1994 21:33:43 -0700 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: John Peterson <adp_john_at_WSC.COLORADO.EDU> Subject: Re: Oracle on VM Performance
I cannot speak of your machine, but when we first started using Oracle our vendor recommend a machine in the 4MIPS range, so we got an 8MIPS range machine, it worked ok until we started going into production with the DB, then we got a 24MIPS machine for about 60 users and have used it for a of years, it is now getting close to the time to go to the 50-100 MIPS ranges machine, machines are getting reasonable, disk drives also(need alot of disk drives), Oracle software???? May have some luck tuning the startup params, setting up disk drives to share the load, more memory may help a little. Keep asking Oracle, it may take awhile but you should find someone to help sometime.
Best wishes,
jep
>I monitor this ORACLE-L list periodically and almost all the contributors
>are talking about ORACLE running on UNIX-based or VMS-based machines.
>
>What about running ORACLE on an IBM mainframe machine ?
>
>We are currently running ORACLE V7.0.15.4 for VM/ESA 2.0 on an IBM 9221-150
>proccessor : 9345 Dasd, 32 Mb Central Memory. It seems that it's not possible
>to achieve 'good' (subsecond response time) performance in this environment.
>As an example : The clock time in order to get into the first SQLFORMS menu
>is about 15 seconds from the moment at wich the SQLFORMS / command is entered
>at the CMS prompt.
>
>I do recognize that a paging load of 250 pages/sec and a 80% CPU utilization
>(values at the time the above test was done) is not a good situation, but under
>this circunstances almost all the interactive load (exept ORACLE) is done with
>subsecond response time.
>
>Oracle V7 on VM runs only on two-task mode and in this system ORACLE is
>configured in order to mantain five dedicated servers always waiting for a
>request to access Oracle from a CMS user.
>The CMS user run the tools code from a Saved Segment that is accessed while
>the virtual machine is in XA mode.
>
>The dedicated servers and background machines are all with a graeter relative
>share than the common users.
>
>Does somebody have any comments about this situation ?
>
>Is an IBM 9221-150 32 Mb a ORACLEable machine ?
>
>Can somebody point to me on where can I find more info relative to ORACLE
>performance running on VM/ESA ? (My ORACLE representative has not been able
>to give us this information)
>
>Do I need a larger IBM processor to run ORACLE with 'good' response time ?
>
>The expected workload is of about 20 Oracle users doing simple querys and
>update
>using a combination of SQLFORMS/SQLMENU apps.
>
>
>Thanks a lot
>
>Juan Carlos Duran (JCDURANN at ENAPSTG1.BITNET)
>Empresa Nacional del Petroleo
>Santiago - Chile
___________ John Peterson USWest (303)943-3123
/ \ /\ / \ WESTERN State College of Colorado
/ \/ \/ \ Computer Services Internet
/ Mountaineers \ Gunnison, CO 81231 ADP_JOHN_at_WSC.COLORADO.EDU
Date: Tue, 31 May 1994 11:21:56 -0400
Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
From: John Carloni <JCARLONI_at_CCMAIL.SUNYSB.EDU>
Subject: PL/SQL STANDARD Package
State University of New York at Stony Brook
Stony Brook, NY 11794-2400
John Carloni
Computing Center
516 632-8028
31-May-1994 11:19am EDT
FROM: JCARLONI
TO: Remote Addressee ( _oracle-l_at_ccvm.sunysb.edu )
Subject: PL/SQL STANDARD Package
I tried to load and run a PL/SQL script (START <filename>) and received the
message:
PLS-00213 package STANDARD not accessible
What must be done to make STANDARD accessible?
- ORACLE 7.0.14.4.0 - PL/SQL Release 2.0.17.1.0 - SQLPLUS 3.1.2.3.1 - Procedural and Dist options - SOLARIS 2.3
Thanks - J.C.
Date: Tue, 31 May 1994 09:29:53 U Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "McShane, John P" <mcshane_at_MDAW.MDC.COM> Subject: Re: PL/SQL STANDARD Package
Try running ora_rdbms:catproc.sql as user account SYS.
State University of New York at Stony Brook
Stony Brook, NY 11794-2400
John Carloni
Computing Center
516 632-8028
31-May-1994 11:19am EDT
FROM: JCARLONI
TO: Remote Addressee ( _oracle-l_at_ccvm.sunysb.edu )
Subject: PL/SQL STANDARD Package
I tried to load and run a PL/SQL script (START <filename>) and received the
message:
PLS-00213 package STANDARD not accessible
What must be done to make STANDARD accessible?
- ORACLE 7.0.14.4.0 - PL/SQL Release 2.0.17.1.0 - SQLPLUS 3.1.2.3.1 - Procedural and Dist options - SOLARIS 2.3
Thanks - J.C.
Hello ... and HELP!!!
I am having difficulty transferring an .r file from Unix to Vax/VMS.
>From the Vax, I invoke Wollongong FTP and open the connection to the
Unix box. Then I set binary mode and issued a "get" to retrieve the
file from Unix. No errors were produced in the FTP session.
However, on the Vax side, when I ran Oracle*Terminal to look at the file, it appeared to be empty. Upon further investigation, I realized that the problem was that FTP created a 512-byte block file and an .r file is supposed to be 8192-byte blocks (I did a dir/full on some other .r files on the Vax).
Wollongong FTP can set a switch to transfer a file and maintain the original record structure ("rget"). However, Unix FTP doesn't recog- nize this animal, so it ignored the request and substituted binary mode -- which is where I was before.
I then tried convert/fdl on the Vax to convert from 512 to 8192. All I got was a bunch of nasty "information" warnings about the records being too short ... I knew that already :)
Then I decided to give up on transferring the file and started to modify an existing Vax .r file. Well, when I tried to do a File Save in oraterm, I waited ... and waited ... ten minutes of looking at the "Working..." message later, I was greeted with a core dump. Not at all nice! I can't copy and I can't seem to edit an existing .r file (don't know whether it got too big for oraterm).
Any suggestions would be greatly appreciated. We're trying to keep a semblance of consistency between our Forms applications on the Vax and on Unix ... but this is quite a roadblock. If it were a database, I'd use export/import. Why did Oracle decide to use an odd-sized block size in the first place? Oops ... sorry ... I forgot ... that would be assuming Oracle used logic. :(
Thanks in advance ... Roger (rcrowley_at_tecnet1.jcte.jcs.mil)
Date: Tue, 31 May 1994 09:55:40 U Reply-To: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET> From: "McShane, John P" <mcshane_at_MDAW.MDC.COM> Subject: Re: PL/SQL STANDARD Package
Re:STANDARD, Use the SYS account and run CATPROC.SQL to initialize procedural option tables. -JohnMc
State University of New York at Stony Brook
Stony Brook, NY 11794-2400
John Carloni
Computing Center
516 632-8028
31-May-1994 11:19am EDT
FROM: JCARLONI
TO: Remote Addressee ( _oracle-l_at_ccvm.sunysb.edu )
Subject: PL/SQL STANDARD Package
I tried to load and run a PL/SQL script (START <filename>) and received the
message:
PLS-00213 package STANDARD not accessible
What must be done to make STANDARD accessible?
- ORACLE 7.0.14.4.0 - PL/SQL Release 2.0.17.1.0 - SQLPLUS 3.1.2.3.1 - Procedural and Dist options - SOLARIS 2.3
Thanks - J.C.
I haven't worked with Oracle on an IBM mainframe and don't know if VM/CMS is your only option but when I DID work on a mainframe we found that VM/CMS was a real resource hog. It'll take a noticeable slice of your total capacity. When we dropped VM/CMS, response time in our OS/MVS environment was significantly improved. Received on Thu Mar 16 1995 - 17:46:45 CST
 |
 |