HDTenEightyP/NetNews huggingface dataset:
From: pveltkam@ems.cdc.com (Paula Veltkamp)
Newsgroups: comp.databases.oracle
Subject: Re: blank truncation on INSERTs
Keywords: Pro*C, dynamic
Date: 9 Oct 92 16:19:32 GMT
Reply-To: pveltkam@ems.cdc.com
Organization: Empros Systems International, a division of CDC

In article <1992Oct8.200941.6499@cas.org>, rwm26@cas.org (Ron McCamish) writes:
|> 
|>   I'm having a problem INSERTing fields using Pro*C 1.3 and dynamic sql,
|>  method 4.  If I try to insert a field with 1 or more blanks at the
|>  end, ORACLE seems to truncate the blanks.
|> 
|>   For example, in sql*plus,
|> 
|>       INSERT INTO CRAP(CRAP1, CRAP2) VALUES('XXXX ', 'XXX  ');...
|>
|>    bind_dp->N=bind_dp->F;
|>    bind_dp->L[0]=4;
|>    bind_dp->L[1]=5;
|>    bind_dp->V[0]="XXXX ";
|>    bind_dp->V[1]="XXX  ";
|>    bind_dp->I[0]=0;
|>    bind_dp->I[1]=0;
|>    bind_dp->T[0]=1;
|>    bind_dp->T[1]=1;
|> 

Ron,

   I noticed you have the bind_dp->T[] equal to the default 1 value (char).
   Try resetting them to 5 (null-terminated char) or 9 (VARCHAR).  In my programs,
   ORACLE couldn't handle the unterminated character strings correctly.

   Paula 
Xref: sparky comp.databases.oracle:1828 comp.databases.sybase:130 comp.databases.informix:2164
From: kono@csl.sony.co.jp (Shinji Kono)
Newsgroups: comp.databases.oracle,comp.databases.sybase,comp.databases.ingress,comp.databases.informix
Subject: Re: Did you use E-R modelling for your database design ?
Date: 14 Oct 92 00:40:42 GMT
Reply-To: kono@csl.sony.co.jp
Organization: Sony Computer Science Laboratory, Inc.

In article <Bw2spt.BIv@inews.Intel.COM> , 
	kortikar@mipos2.intel.com (Aniruddha Kortikar) writes 
>Specifically I would be interested in
>1. Did you use E-R modelling for database design project
Yes, we did.

>2. How big was the result (Approx no of tables  20,50,150 etc)
Very small less than 10.

>3. Did you use any software for designing the database. (to generate schema)
No. Sybase only.

>4. Are you aware of any company that has a business of database design ?
None.

>5. did you really benefit from such design efforts ?

We think so. It helps database extendability and dependency maintenance.
Anyway it is not so serious in case of small database.
---
Shinji Kono @           kono@csl.sony.co.jp
Sony Computer Science Laboratory, Inc,Japan
Newsgroups: comp.databases.oracle
From: cyf@sequent.com (Cyrus Foughty)
Subject: Re: the ultimate oracle machine ?
Keywords: machine architecture bus disk performance oracle dbms
Organization: Sequent Computer Systems Inc.
Date: Fri, 9 Oct 92 15:49:09 GMT

In article <21711@sbsvax.cs.uni-sb.de> rzsbf@sbusol.rz.uni-sb.de (Bernd Faerber) writes:
>Hello oraclers,
>
>has anybody got - good or bad - experiences with oracle applications
>running on different machines / cpu types / disk types ?
>
>What about performance ?
>
>
>Thanks for your help
The one benchmark that most customers look at is the TPC-A.  So look
at that and look at the background of the company.  A good strong
company is important.
-- 
Cy Foughty 
Sequent Computer Systems, Dallas, TX
cyf@sequent.com
Standard disclosure: This is my opinion and not Sequent's.
From: hans@iris.mincom.oz.au (Hans Plambeck)
Newsgroups: comp.databases.oracle
Subject: Re: Recovering ORACLE db after system crash
Date: 7 Oct 92 21:25:03 GMT
Organization: Mincom, Brisbane, Australia
X-Newsreader: TIN [version 1.1 PL6]

: I couldn't drop the table because ORACLE told me to put it offline, I 
: couldn't alter it offline either, neither could I recover tablespace
: "rollback_segment".

You are right, you can not restore a rollback segment, only ordinary tablespaces
 Where would you restore it from ? Redo logs contain roll forward information,
 rollback segments contain data to roll backward, thus making sure a database
 contains only commited transactions. If redo log is stuffed, you can not
 recover or skip it either.

: 
: In the end we were desperate so we restored from tape.
: 
Wise decision.

: What should I have done?
: 
If you are sure (how would you?) that there are no transactions, you might
  want to try ALTER DATABASE DATAFILE file-spec OFFLINE, and then forget
  about it.

I believe in V7 you can 'mirror' these tablespaces and redo log files,
  adding more security. Anyone to comment on this?
-- 
Hans-J Plambeck   Mincom Pty Ltd       hans@mincom.oz.au  +61 (7) 364 9999
Newsgroups: comp.databases.oracle
From: sstephen@us.oracle.com
Subject: Re: Technical Bulletin 101451.515 wrap.c long field code
Followup-To: u6p86@lfhs2.hso.link.com
Organization: Oracle Corporation, USA
Date: Thu, 15 Oct 1992 22:15:46 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <1992Oct12.144243.12661@aio.jsc.nasa.gov>, u6p86@space.link.com (Susan A Lewis) writes:
> 
> We are running Oracle Version 6.0.33 on Solbournes connected with NFS from
> Servers to clients.  Our user requested a workaround to output longfields
> using sqlreport.  Long fields are truncated.  Oracle sent us the code wrap.pc 
> documented in Technical Bulletin 101451.515.  
> 
> Has anyone incorporated this code into their sqlrep?  We have found 
> several errors in use of 'c' functions memset & strlen.  
> 
> Has anyone else written any code to manipulate longfields with report
> writer?
> 
> -- 
>                 CAE-Link, Houston                       2224 Bay Area Blvd.
>                                                         Houston, TX  77058
>                  Susan Lewis                            Ph  713-280-4420
>                  u6p86@lfhs2.hso.link.com               Fax 713-280-4083
-- 

  What errors are you getting ?  Memset and strlen are about as standard as you
can get.  I was able to compile wrap.pc from that bulletin on a Solbourne
without any errors at all.  Are you able to compile any C programs at all ? 
From your message, it is ambiguous wether you are on a Solbourne or a client. 
If you are a client running a 16 bit operating system, you will very likely get
into a lot of problems.

  Only obvious thing I noticed is that the bulletin had translated all the tab
characters to "^"'s.  There should be no "^" characters in the file at all.

================================================================================
Scott Stephens				inet:	sstephen.us.oracle.com
Oracle WorldWide Support                Redwood City, California
Newsgroups: comp.databases.oracle
From: donald@devv03.distri.hydro.qc.ca (Donald Robidoux)
Subject: Re: Any experience/guidelines in SQL*Forms3.0/SQL*Menu5.0 in OPEN LOOK
Organization: Hydro-Quebec
Date: Tue, 13 Oct 1992 19:01:16 GMT


I was doing some development with SQL*Forms/SQL*Menu under OSF/Motif lately.
I first done some migration of existing forms.  The problem is not the product
but the way GUIs are working vs caracter mode terminal.  The product is ok 
(almost no bugs with DEC Ultrix 4.2A, OSF/Motif 1.1.3 and ORACLE V6.0.36).
You'll have to redo your forms if you have multiple blocks on 1 page since 
block synchronisation is not working with the use of a mouse (you can go from 
a field in block 1 to a field in block 2 using the mouse and don't hit any key 
so the key-triggers used for the synchronization won't fire).

So don't make any commitment to your users since you have converted ALL the 
forms first.  Your local Oracle sale rep. can provide you a paper on how to
develop bit-mapped applications with SQL*Forms V3 that will be easily migrate
to SQL*Forms V4.

If you have specifics questions, contact me.

Cheers,


===============================================================================
Donald Robidoux
Conseiller

Oracle Corporation inc.
Montreal, Quebec, Canada
Tel:    	(514) 843-6762
Oracle*Mail:	drobidou.ca
Internet:	drobidou@ca.oracle.com
===============================================================================





Newsgroups: comp.databases.oracle
From: wayne@gbrmpa.gov.au (Wayne Amisano)
Subject: Re: Recovering ORACLE db after system crash
Organization: Great Barrier Reef Marine Park Authority
Date: Thu, 8 Oct 1992 22:54:59 GMT

hans@iris.mincom.oz.au (Hans Plambeck) writes:

>: I couldn't drop the table because ORACLE told me to put it offline, I 
>: couldn't alter it offline either, neither could I recover tablespace
>: "rollback_segment".

[...]

>: What should I have done?
>: 
>If you are sure (how would you?) that there are no transactions, you might
>  want to try ALTER DATABASE DATAFILE file-spec OFFLINE, and then forget
>  about it.

>I believe in V7 you can 'mirror' these tablespaces and redo log files,
>  adding more security. Anyone to comment on this?

In a recent DBA course, they gave an talk on what is in v7.  Adding
redundant database files, similar to allowing more than 1 control file,
was mentioned.

cul Wayne!


-- 
Wayne Amisano (VK4KT)    _-_|\\   E-Mail - wayne@gbrmpa.gov.au
Great Barrier Reef      /     \\  Phone  - +61 77 81 8861 (GMT+1000)
Marine Park Authority.  \_.-._/   Fax    - +61 77 72 6093
Our's to use Wisely!         v    Mail   - GPO Box 1379, Townsville QLD 4810
From: dewey@centerline.com (Devan F. Dewey)
Newsgroups: comp.databases.oracle
Subject: Strategies for SQL*RepWrtr version control???
Followup-To: comp.databases.oracle
Date: 16 Oct 1992 12:46:50 GMT
Organization: CenterLine Software, Inc.
Distribution: world
NNTP-Posting-Host: 140.239.3.212

We keep all our .inp and .sql files under source code control. This gives
us all the obvious advantages: branch versions, stepping back to old
version, etc.

But sql*reportwriter doesn't have the load function that sql*forms30 has.
This means you have to dumprep and loadrep all the time which is quite a
pain.

Also, .inp files can be loaded under any users un/pw, which is good because
we have multiple people developing who prefer to work in there own areas.

Does anyone have shell scripts or other strategies to administrate version
control for reports??? We are in a UNIX environment. We are currently
saving reportname1, reportname2, not for every verions, but as a primative
way of doing branches. Of course this doesn't solve the biggest problems:
being able to undo changes that don't work, and keeping a history of
changes made.

Thanks for any suggestions you might have.

-Devan

                             
               Devan F. Dewey | Senior Systems Analyst
          CenterLine Software | dewey@centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya
Newsgroups: comp.databases.oracle
From: mannhart@rzu.unizh.ch ()
Subject: Re: Oracle file managerCLOSE
Organization: Computer Centre, University of Zurich
X-Newsreader: Tin 1.1 PL5
Date: Fri, 9 Oct 1992 08:54:42 GMT

Terry Ball (ballt@osshe.edu) wrote:
: We currently have one database on a raw device.  In order to make a backup
: of this database, we have a background process start up each evening to
: make an export of the database.  It is NOT possible to make a backup of
: the files from the raw device.
: 
: Terry Ball

So, all the time I did a "cpio" backup of my raw device, there actually was
nothing in ???? I can't believe that . Somebody knows more about this ???
Thanks god nothing bad is happend 'til now (knock on wood)

LM
--
Leo Mannhart
Planning Office
University of Zurich                                phone: ++41 1 257 23 34
Kuenstlergasse 15                                     fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland                         eMail: mannhart@zuv.unizh.ch
From: batista@zach.fit.edu (Amina Batista)
Newsgroups: comp.databases.oracle
Subject: Oracle/posix
Date: 13 Oct 92 15:36:10 GMT
Distribution: usa
Organization: Florida Institute of Technology, Melbourne USA

Hi, I am posting these questions for someone who does not have
  access to Internet.  Please e-mail any responses directly to
              
            rcs55701@zach.fit.edu

1.  Has anyone been able to execute the SQL host command running
    running under the Posix environment on a VMS machine?

2.  Has anyone had success initiating a VMS process under th
    Posix environment?

Thanks in advance...
Amina Batista
 
Newsgroups: comp.databases.oracle
From: cdc6586@usl.edu (Charbonnet Clement D)
Subject: MS-Windows based tools
Organization: University of Southwestern Louisiana
Distribution: na
Date: Wed, 7 Oct 1992 05:50:14 GMT

I am currently running Oracle on a Data General AViiON 6220 
with DOS based clients communicating with SQL*Net TCP/IP.
I am not pleased with the fact that Oracle's tools are not 
compatible with the enhanced mode of MS-Windows which is our 
standard user interface.

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

Any help would be greatly appreciated.

---------------------------------------------------------------

                Clement D. Charbonnet
            Internet:  cdc6586@usl.edu
From: tdonnell@ncrsoph.Sophia.NCR.COM (Tom Donnelly)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle file managerCLOSE
Date: 9 Oct 92 10:12:20 GMT
Reply-To: tdonnell@ncrsoph.Sophia.NCR.COM (Tom Donnelly)
Organization: NCR European Development Center

In article <BvrAKv.695@news.orst.edu> ballt@osshe.edu (Terry Ball) writes:
>We currently have one database on a raw device.  In order to make a backup
>of this database, we have a background process start up each evening to
>make an export of the database.  It is NOT possible to make a backup of
>the files from the raw device.

Not true.  You can make backups of raw devices by taking an image copy of the 
raw device.  In Unix, that means using the dd command.  I have done this a
number of times on Pyramid, AT&T Starservers and NCR 3445s.  The standard
Unix backup script will not work, nor will cpio.  But using dd out to tape
works fine.  


--------------------------------------------------------------------------------
These views are my own and do not represent those of my company.
No gaurantee, implied or other, unless specified by law. Details on back.
--------------------------------------------------------------------------------
Tom Donnelly               | WIN: Tom.Donnelly@Sophia
NCR Europe Group ISS       | UUCP: ..ncrcom!ncrsoph!tdonnell
Sophia Antipolis, Valbonne |                              
France			   | TEL: 33-92 94 45 40
From: ae0i+@andrew.cmu.edu (Albert L. Evans, IV)
Newsgroups: comp.databases.oracle
Subject: renaming tables
Date: 14 Oct 92 13:50:47 GMT
Article-I.D.: andrew.oer9Mr200YUn4Fvmgj
Organization: Carnegie Mellon, Pittsburgh, PA

I was wondering if anyone has had experience renaming tables using the
SQL*Plus RENAME TO command.  Specifically,  are the grants and indexs
associated with that table automatically updated to reference the new table
name?  My experience seems to indicate that this is the case,  seeing as I
have renamed a table and subsequently named a new table with the same old
name.  The newly created table w2as not indexed, nor were there any grants
on the new table.  Any responses appreciated. 

Bert Evans
Xref: sparky comp.databases.oracle:1782 comp.databases:7127
From: pihlab@hhcs.gov.au
Newsgroups: comp.databases.oracle,comp.databases
Subject: INTERLINK
Date: 8 Oct 92 14:05:57 +1000
Organization: Aust. Dept. Health, Housing and Community Services


I need assistance and advice regarding the use of Oracle V6 across an
INTERLINK gateway joining VAX VMS (DECNET) sites and an Amdahl MVS site.

We are trying to use the MVS box as a database server for the VAX sites
in CLIENT(VAX)/SERVER(MVS) operation.

We are having difficulties maintaining connections (they just seem to
drop out randomly on large querries) and maintaining large numbers of
connections (can only get ~80 users concurrently).

We have been in contact with Oracle Australia and the local INTERLINK
supplier but they aren't much help.

We have a group looking at TCP/IP connections between VAX<->MVS but thats
only just getting started.

I need to discuss our setup with someone who is operating in a similar
environment successfully.

HELP.

-- 

Bruce...        pihlab@hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************
From: rzsbf@sbusol.rz.uni-sb.de (Bernd Faerber)
Newsgroups: comp.databases.oracle
Subject: the ultimate oracle machine ?
Keywords: machine architecture bus disk performance oracle dbms
Date: 9 Oct 92 09:48:17 GMT

Hello oraclers,

has anybody got - good or bad - experiences with oracle applications
running on different machines / cpu types / disk types ?

What about performance ?


Thanks for your help
Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: Re: Forms 4.0
Organization: Colonial Mutual Group 
Date: Wed, 7 Oct 1992 06:32:03 GMT

In article <swhite.717433105@fncduc>, swhite@fncduc (Stephen White) writes:
> Has anyone heard any details on Sql*Forms V4.0?  Such as when it will be 
> released, what it will do and the platforms it will be on (Sun, Vax, Mac)?
> 
> It would be real nice if one of you Oracle people would respond. 
> 

Forms 4.0 for character mode is in Beta mode and should be out in the next 6
months.  At the IOUW, San Francisco, they were pushing this product quite a
fair bit. 

I was fortunate enough to see the latest version of Forms 4.0 (bitmap) at 
Oracle, Redwood Shores.  It is very flexible and 'flash'.  The bitmap version
is in Alpha state and the word is, they are not intending to release it in the
next 6-9 months.  If it is as good as they make it out to be, then it will be
worth the wait.


-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
Newsgroups: comp.databases.oracle
From: johnh@nnshh127.uucp (John Hawkins)
Subject: two dates want the difference between them in hours & minutes
Organization: Northern Telecom Inc., Nashville, TN
Distribution: usa
Date: Mon, 12 Oct 1992 19:45:03 GMT

	
	I have two dates I subtract them and then want to get hours and
	seconds in terms of the difference, I know this has to be simple.
	But it's monday-> Brain dead day I guess. I have tried various
	formats of to_date, to_char, etc.. but haven't stumbled upon
	the correct one yet.

	This is a pro_c report which needs to be done asap...the 
	time is what is taking the time:)
	Do I have to put the dates in varchar and process them with
	a c-string date chomping function.  Surely not!

	Thanks for your help, 
	John Hawkins.
	nvjhh01@NT.COM


-- 
John Hawkins       }) #define disclaimer(x) printf(stderr," x\n");
Northern Telecom   }) Communication: Voice 615 734 4468   /* Able was I ere */
200 Athens Way     {)                Fax   615 734 4771   /* I saw Elba     */
Nashville TN 37728 {) Internet:  nvjhh01@NT.COM           /* Columbus ~1492 */
From: hans@iris.mincom.oz.au (Hans Plambeck)
Newsgroups: comp.databases.oracle
Subject: Re: blank truncation on INSERTs
Date: 12 Oct 92 02:17:29 GMT
Organization: Mincom, Brisbane, Australia
X-Newsreader: TIN [version 1.1 PL6]

This is a feature, with fixed length strings in Pro*... all trailing
 spaces gets chopped off, it even might result into a null string.

Use varchars (as sqlplus) to force writing trailing spaces.

-- 
Hans-J Plambeck   Mincom Pty Ltd       hans@mincom.oz.au  +61 (7) 364 9999
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: Force TO_CHAR to eliminate the leading blank during display
Date: 15 Oct 92 11:30:38 GMT
Distribution: usa
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

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


I think it's the space for the sign of the Number. Remove it with LTRIM.

> 
> ******************
> * SQLPLUS Script *
> ******************
> 
> spool trargs.txt
> TTITLE off
> set heading off
> set linesize 78
> set pagesize 0
> set feedback off
> set space 0
> 
> select  
>     Function, '|',		
>     TO_CHAR(Argument_Number,'09'), '|',	
>     Description, '|',		
>     Data_Type, '|'		
>     from TRANSFORMATION_ARGUMENTS order by 1 ASC, 3 ASC;
> spool off
> exit

column Argument_Number format a2

 select  
     Function, '|',		
     LTRIM(TO_CHAR(Argument_Number)) Argument_Number, '|',	
     Description, '|',		
     Data_Type, '|'		
     from TRANSFORMATION_ARGUMENTS order by 1 ASC, 3 ASC;



> 
> *********
> *Schema *
> *********
> 
> CREATE TABLE TRANSFORMATION_ARGUMENTS
> (
>     Function        CHAR(30) NOT NULL,
>     Argument_Number NUMBER(2) NOT NULL,
>     Description     CHAR(40),
>     Data_Type       CHAR(1)
> );
> 
> ****************************
> *Sample Output: TRARGS.TXT *
> ****************************
> 
> Are_Lists_The_Same            | 01|First generic list                      |G|
> Are_Lists_The_Same            | 02|Second generic list                     |G|
> Extract_Sub_List              | 01|Original generic list                   |G|
> Extract_Sub_List              | 02|Index of comparison column              |I|
> 			      	
-- 

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
 Bankgasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================