HDTenEightyP/NetNews huggingface dataset:
From: news@inews.Intel.COM (USENET News System)
Newsgroups: comp.databases.oracle
Subject: Can I use struct of varchars like varchars in PRO*C
Date: 17 Nov 92 19:04:04 GMT
Organization: Intel Corporation, Santa Clara, CA USA

declaration section ......
struct table_name {
	varchar field1[10];
	varchar	field2[10];
} tab;
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
I fill the tab by reading from some file.
	if (sscanf(file_descriptor,"%[^|]|%[^|]",tab.field1.arr,tab.field2.arr))
		.....
set the length elements ..
	tab.field1.len=strlen(tab.field1.arr);
	...

now how can I update the table tab2
insert into tab2 field (f1,f2) values (:tab.field1,:tab.field2) fails !!!
it says PCC-S-0026 : undeclared host var tab.field1 ....
offcourse I can pad tab.field.arr and then use it. but can I use struct instead?

Aniruddha Kortikar(kortikar@mipos2.intel.com)




-------------------------------------------------------------------------------
E-mail 	: kortikar@mipos2.intel.com | A billion here, a billion there ...
Phone(W): 408 765 5515              | pretty soon it adds upto real money.
-------------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: socrates@npac.syr.edu (Socrates Costicoglou)
Subject: ORACLE technical papers needed ...
Organization: Northeast Parallel Architectures Center at Syracuse University (NPAC)
Date: Mon, 16 Nov 92 13:06:19 EST

I am interested in ORACLE technical papers with regard the 
new ORACLE parallel server running on NCUBE2 (v7).

Please email me any information how I can obtain copies of
them.

Thanks in advance
-Socrates

================================================================================
Northeast Parallel Architectures Center  |    Socrates L. Costicoglou
Syracuse University                      |     socrates@npac.syr.edu
111 College Pl. Rm=1-019,                |
Syracuse, NY 13244=4100                  |
================================================================================
Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: Re: SNMP/SMP MIB for Oracle from Oracle?
Organization: Colonial Mutual Group 
Date: Tue, 17 Nov 1992 22:38:54 GMT

In article <1992Nov17.053940.14114@cmutual.com.au>, aaj@cmutual.com.au (Tony Jambu)
> In article <1992Nov12.022001.6131@indetech.com>, rec@indetech.com () writes:
> > 
> > I've heard a glimmer of a rumor that Oracle may have made available
> > an SNMP or SMP Management Information Base for Oracle databases.
> > 
> > 1. Is there such a beast?
> > 
> > 2. What sort of proxy-agent technology does it require?
> > 
> > 3. Is this a "real" Oracle product, a "consulting" Oracle product,
> >    or a "future" Oracle product?
.
.
stuff deleted

> Yes there is such a beast out there and it is called DDS/Patrol (ie if it
> is what you are referring to).   DDS stands for distributed Data Systems The
> product is written by a company in Sydney, Australia and Oracle financed
> part of the development.  One of the main developers name is Martin
> Picard.  Yes, all you Oracle staff out there, Martin Picard was a former
> Oracle staff who used to work in the networking area.
> 
.
.
stuff deleted


Sorry, I forgot that there is another product on the market that is based
on SNMP and has a customise/private MIB (Management Information Base) for
Oracle.  The name of the product is iView.  I just received information on
this product last week.  Again this product comes with the Manager and
Agent module.  It comes with an Agent kit that allows you to define your
own private MIB.

I do not know who developed the product, but if you want an Australian contact
phone number, send me an email or give me a call.



-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
 \_______/                   |PHONE:  +61-3-6076448       FAX:  +61-3-6076198
Newsgroups: comp.databases.oracle
From: nmrdb@vms.macc.wisc.edu (BEVERLY SEAVEY)
Subject: In what file are Pro*C externs  sqloca,sqlsca,sqlcom,etc defined?
Organization:  University of Wisconsin Academic Computing Center
Date: 18 NOV 92 09:16:12    

I'm just working on my first Pro*C program, and when I compile I get
complaints that there are unresolved references: sqloca,sqlsca,..
about 15 in all. When I examine the precompiler output I see
references like

EXTERN sqlca

for each. Where are these things defined? Is there some file I need
to #INCLUDE, or a compiler option I  don't know about? 
Newsgroups: comp.databases.oracle
From: twood@windward.it.uswc.uswest.com (Tim Woodward)
Subject: Re: Long insert statement in PCC ireclen exceeded.
Organization: U S WEST Information Technologies
Date: Fri, 20 Nov 1992 15:37:13 GMT

In article <BxvLKB.4uC@inews.Intel.COM> kortikar@mipos2.intel.com (Aniruddha Kortikar) writes:
>I have a long insert statement in PRO*C insert into table ( ....) values (...)
>ireclen is exceeded.
>
>I tried 
>char stmt[1000];
>sprintf(stmt,"insert into ... values (:v1,:v2);");
>exec sql execute s using :val1,:val2 ....
>but even then the exec sql execute s using is about 300 chars long.
>

 Did you set IRECLEN=1000 (or whatever size is needed) on the
 precompiler invocation line?

 Tim Woodward
 U S WEST
From: zhang@cs.rochester.edu (Zhang Ju)
Newsgroups: comp.databases.oracle
Subject: SQLAssist in ORACLE environment
Date: 18 Nov 92 00:12:20 GMT
Organization: Computer Science Department University of Rochester



I am considering using SQLASSIST in a product on the job I am doing
in a company. It has a query builder, a report writer, etc.

Anybody had any experience of using it? I would be very interested especially
when  it is in an  ORACLE environment.

Looks like it's kind of a simple minded product. But whatever time it can
save on development would be worth it.


Ju Zhang
zhang@dlbsys.com
Newsgroups: comp.databases.oracle
From: pld@fc.hp.com (Paul_Dineen)
Subject: Basic info on Oracle Database Server?
Organization: HP CLO/CoLL, Fort Collins, CO
X-Newsreader: TIN [version 1.1.4 PL6]
Date: Fri, 20 Nov 1992 03:32:56 GMT

  Would a kind soul indulge this request from my wife?...

> I'm writing some documentation for something I know absolutely nothing
> about.  The system I'm working with is an Oracle Database Server.  What
> is a Database Server and what are the particulars on the Oracle database
> server?  If you have a notes group on servers can you please post this.
> I just want a general description of what this is (in laymans terms).
> What is it that these database servers actually do etc....
> 
> Thanks!

  Thanks!
Organization: Carnegie Mellon, Pittsburgh, PA
Newsgroups: comp.databases.oracle
Date: Mon, 23 Nov 1992 14:21:09 -0500 
From: "Albert L. Evans, IV" <ae0i+@andrew.cmu.edu>
Subject: Forms 3.0 question


Is it possible to center a string of text in a field and if so, how?  Hopefully
there is an easy way to do it, rather than having to resort to obscure SQL
text manipulation functions.  Thanks,

Bert Evans
Newsgroups: comp.databases.oracle
From: Neil Greene <deepthought!neil@ms.uky.edu>
Subject: SUGGESTION: Corrupt data block 
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.
Date: Sun, 22 Nov 1992 20:59:27 GMT

I have received the following corrupt data block error from Oracle running  
v6.x.x on a NeXTCube (NeXTSTEP 3.0, BSD/Mach).

I was wondering what suggestions may be recommended to me in efforts to  
correct this problem.  Will I end up dumping the data and table and  
recreating the tablespace.  I would like some more insight into this  
problem before I contact Oracle directly.  Thanks in advance for your  
recommendations.


> Dump file /s1/oracle/rdbms/log/ora_2248.trc
> Sun Nov 22 01:40:49 1992
> ORACLE RDBMS V6.0.30.3.1 - Production
> ORACLE_HOME = /s1/oracle
> ORACLE_SID = nasris
> Oracle process number: 8	 Unix process id: 2248
> System name:	NeXT Mach 3.0
> Created:	Wed Jul 29 19:43:28 PDT 1992
> From:		root(rcbuilder):mk-127.15/BUILD/RELEASE_M68K
> Node name:	deepthought
> Configured for 1 processors, of which 1 are available
> Active processor(s): 0
> CPU type: MC680x0 (68040)
> Primary memory available: 36.00 megabytes
> Default processor set: 1 processor(s), 81 task(s), 118 thread(s)
> Load Average: 3.03, Mach factor: 0.25
> 
> ***
> Corrupt block=20000fa2 file=8. blocknum=fa2 found during buffer read
> on disk type=1. ver=1. dba=18000fa2 inc=14001 seq=2016ed incseq=400116ed
> ***
> Corrupt block=20000fa2 file=8. blocknum=fa2 found during buffer read
> on disk type=1. ver=1. dba=18000fa2 inc=14001 seq=2016ed incseq=400116ed
> Sun Nov 22 01:40:49 1992
> ksedmp:  internal or fatal error
> ORA-00600: internal error code, arguments: [3339], [402657186],  
[536874914], [], [], []
> 
> [stuff deleted]




-- 
Neil Greene
President, Kentucky NeXT User Group, Inc.
Email: neil@ms.uky.edu [NeXTMail]
From: grant@erich.triumf.ca (Peter A. Grant)
Newsgroups: comp.databases.oracle
Subject: Re: Will Oracle Provide USER EXITS in kernel ?
Date: 19 Nov 1992 10:15 PST
Organization: TRIUMF: Tri-University Meson Facility
Distribution: world
NNTP-Posting-Host: erich.triumf.ca
Summary: Request for rumors ?
Keywords: PL/SQL Stored procedures user_exit
News-Software: VAX/VMS VNEWS 1.41    

In article <dtb.722180073@otto>, dtb@otto (David Bath) writes...
> 
>Has anybody heard (or would like) the ability to link in user-exits
>into the oracle rdbms that could be called from the PL/SQL of stored
>procedures ?
>...


The sample procedures in the ORACLE7 course I just took included calls to
`C' routines with the PRAGMA command.  (As one would assume if one knows
Ada at all...)  Is this the type of thing you were thinking of?


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

                  Chairperson, Vancouver Oracle Users Group

Xref: sparky comp.databases.oracle:2244 pnw.general:2796
From: michelle@Thalatta.COM (Michelle Wannamaker)
Newsgroups: comp.databases.oracle,pnw.general
Subject: Meeting of Puget Sound Oracle Users Group
Keywords: Meeting, PSOUG
Date: 18 Nov 92 22:27:46 GMT
Article-I.D.: Thalatta.1992Nov18.222746.2324
Distribution: pnw
Organization: Thalatta Corporation, Bellevue WA


The next meeting of the Puget Sound Oracle Users Group (PSOUG) will
be on Thursday, November 19th, at 4PM (Sorry for the short notice!).
It will be held at Airborne Express in the large conference room on
the 4th floor.  There is very limited parking available in the Airborne
Parking Garage just south of the Airborne building.  Otherwise, pay-for-
parking is available within short walking distance (looking at the map,
they appear to be primarily east and south of Airborne). 
                      
                      Airborne Express
                      3101 Western Avenue           281-3844
                      Seattle
        (This is an 8-story, roundish building)

The topic of the meeting will be an "Ask Oracle" session with some
of Oracle's representatives.  There are no fees for attending this 
meeting.    If you have any questions about this meeting, contact 
Sylvia DiAngelo at 544-8233.

If you have any questions about PSOUG or want to be put on the 
membership list for notification of future meetings, contact Ted 
Greeniaus, PSOUG Chairmain, at 233-3419.

-- 
-----------------------------------------------------------------------
In-Real-Life: Michelle Wannamaker                  Thalatta Corporation
              michelle@Thalatta.com                Bellevue, WA
From: dewey@centerline.com (Devan F. dewey)
Newsgroups: comp.databases.oracle
Subject: index column order perfomance effects
Followup-To: comp.databases.oracle
Date: 18 Nov 1992 19:57:19 GMT
Organization: CenterLine Software, Inc.
Distribution: world
NNTP-Posting-Host: 140.239.3.212

I have a view of my database which links three tables
by COMPANY#. One of these tables contains a rep_code and another
contains a followup_date.

There is an index on table1(rep_code).

When I create an index on table2(followup_date, company#)
and did:

select count(*) from view
	where rep_code = 'AA'
	and followup_date = TODAY;

the query took over an hour.

So I drops the index on table2 and created and index on the same
columns in a different order: table2(company#, followup_date).

Now the same query executed in 8 seconds.

I'm happy I got it working, but can anyone explain the dynamics of
why it works this way. I think I should know this before I
create too many more indexes.

Thanks for any info.

-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
From: herder@etek.chalmers.se (Jan Herder)
Newsgroups: comp.databases.oracle
Subject: MS-Windows,SQL*NET,PATHWORKS and TCP/IP
Date: 17 Nov 92 21:37:11 GMT
Organization: Chalmers University of Technology, Gothenburg, Sweden
Originator: herder@kajsa0

Has anyone tried to use SQL*NET from MS-Windows using PATHWORKS with TCP/IP as
transport layer. It works with Decnet and windows in standard mode. The local 
ORACLE Rep thinks that it should work with PATHWORKS over TCP/IP but didn't
know of anyone actually using it.
From: ebuhob@ebu.ericsson.se (Hans Bergsten 6264)
Newsgroups: comp.databases.oracle
Subject: Re: Will Oracle Provide USER EXITS in kernel ?
Date: 19 Nov 92 17:55:56 GMT
Reply-To: ebuhob@ebu.ericsson.se
Organization: Ericsson Business Communications, Inc.
X-Disclaimer: This article was posted by a user at Ericsson.
              Any opinions expressed are strictly those of the
              user and not necessarily those of Ericsson.

In article 722180073@otto, dtb@otto (David Bath) writes:
>
>Has anybody heard (or would like) the ability to link in user-exits
>into the oracle rdbms that could be called from the PL/SQL of stored
>procedures ?

At the ORACLE7 New Feautures and Options class (in LA, August -92),
they mentioned a package that would be released "three months after ORACLE7".
I believe it was called Open Gateway, and it would provide access to
procedures/functions written in a 3GL (like C) from PL/SQL.

/Hans

-----
Hans Bergsten                 	     Internet : ebuhob@ebu.ericsson.se
Ericsson Business Communications     MEMO     : ERI.EBU.EBUHOB (God forbid.)
525 N. Muller St.                    Voice    : +1 (714) 491-6264
Anaheim, CA 92803, USA               FAX      : +1 (714) 535-1789
Newsgroups: comp.databases.oracle
From: jjolly@jjolly.b24a.ingr.com (Jack G. Jolly)
Subject: Defrag the darn thing
Organization: Intergraph Corporation, Huntsville, AL.
Date: Mon, 23 Nov 1992 19:15:13 GMT

Had a (flawed) strategy to defrag a tablespace in the db.

	1) Export db
	2) Drop tablespace
	3) Create tablespace
	4) Import users

The problem was in step (2) - dropping a 300MB tablespace (non-empty)
generated so many transactions that I got the infamous "snapshot too
old" error.  I have 10 rollback seg's in their own (20MB) tablespace.  The
whole deal is on raw files.

I also read here about another strategy - create a table whose "initial"
parm is equal to the sum of all freespace extents in the db - the idea
was that the db would "collect the smaller extents into one big one",
and then you would drop the table.  I tried this idea without success -
came back with "unable to allocate extent of size XXX" where XXX was
the sum of all freespace in the tablespace.

Any ideas??  Should the second strategy work??  

JJ

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

  ^^^^^^^^^          Jack Jolly  @  jjolly@jjolly.b24a.ingr.com
 (| 0   - |)
  |   *   |             Intergraph Corporation, Huntsville AL
  \_______/                AEC Project Management Support
From: jjlink@netcom.com (John J. Link)
Newsgroups: comp.databases.oracle
Subject: Server Selection Compaq, Netframe, Pyrimid, 486/50, Netware...
Date: 22 Nov 92 20:35:52 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

We are about to pick a server platform, we are considering the following:


about 20 users using OMNIS 7 from Windows & MACs.

and one of the following -

Compaq SystemPro/XL, 486/50 with either SCO UNIX or Netware 3.11 / 4.0

Netframe using Netware 3.11/4.0


with around 128 Megs of memory,
and five GB of disk space.

Any experiances good or bad with Oracle for Netware, Compaq, or Netframe???




-- 
 /=========================================================\
 | John J. Link        Internet: JJLINK@NETCOM.COM         |
 | Lan Manager                   JJLINK@LMSC.LOCKHEED.COM  |
 | Lockheed                                                |
 | Sunnyvale, California, USA    72470.3300@COMPUSERVE.COM |
 \=========================================================/
From: ALANB@OWGVM0.VNET.IBM.COM (Alan Beal)
Date: Mon, 23 Nov 92 15:09:41 EST
Newsgroups: comp.databases.oracle
Subject: more XA problems
Organization: Federal Systems Company (IBM)

Using the 7.0.9 beta version of Oracle XA, we have experienced many
problems with invalid cursors using Encina.  We eliminated many
by specifiying RELEASE_CURSOR=YES during the Pro*C precompile.  Now
we experience invalid cursors after we get a not found during an
update or delete.  We already changed our code that used SELECT INTO
to use explicit cursors, and now we are doing the same with the
update and delete statements.  As anyone experience similiar problems
and are there any general rules of thumb when working in this
environment?

Alan Beal         alanb@owgvm0.vnet.ibm.com
                  (607)751-2026
From: leilas@ems.cdc.com (Leila Schneberger)
Newsgroups: comp.databases.oracle
Subject: ORACLE pmon crashed - is recovery possible?
Date: 17 Nov 92 18:05:04 GMT
Reply-To: leilas@ems.cdc.com
Organization: Empros Systems International, a division of Ceridian


  One of our Oracle-sid died mysteriously yesterday. I cannot bring it 
  back up again. 
  
  The SID-id is "develop". It seems to be choking in reading it's control
  file, and thinks some other process is using the same id. I tried 
  to reboot the machine, but result was the same error. 

  Oracle hotline was called; they don't know how to resolve this either.

  SQLDBA> startup
  ORACLE instance started.
  ORA-00205: error in identifying control file 'cntrldevelop.dbf'
  ORA-09782: sfifi: another instance has the same database mounted.
  Attempting to shutdown instance........ORACLE instance shut down.
  SQLDBA>  
 
-This is in my alert log:
Error signalled in file: $ORACLE_HOME/rdbms/log/4_200.trc
ORA-00604: error occurred at recursive SQL level 1
ORA-00472: PMON  process terminated with error
Mon Nov 16 15:11:19 1992

-This is in my trace file:
SMON: system monitor started
Mon Nov 16 14:52:09 1992
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-00472: PMON  process terminated with error
Mon Nov 16 14:52:09 1992
SMON: error 472 detected in other detached process
Mon Nov 16 14:52:09 1992
SMON: system monitor exiting.
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00472: PMON  process terminated with error
OPIRIP: Detached process complete.


Oracle support said to reinstall. Any other ideas would be greatly
appreciated. Please e-mail to me and I will summarize.

Thanks!

-- 

 Leila Schneberger                 leilas@ems.cdc.com  
Newsgroups: comp.databases.oracle
From: rheiger@renext.open.ch (Richard H. E. Eiger)
Subject: Re: Long insert statement in PCC ireclen exceeded.
Reply-To: rheiger@renext.open.ch
Organization: Olivetti (Schweiz) AG, Branch Office Berne
Date: Sun, 22 Nov 1992 18:01:13 GMT

In article <By0u21.I5A@da_vinci.it.uswc.uswest.com>  
twood@windward.it.uswc.uswest.com (Tim Woodward) writes:
> In article <BxvLKB.4uC@inews.Intel.COM> kortikar@mipos2.intel.com (Aniruddha  
Kortikar) writes:
> >I have a long insert statement in PRO*C insert into table ( ....) values  
(...)
> >ireclen is exceeded.
> >
> >I tried 
> >char stmt[1000];
> >sprintf(stmt,"insert into ... values (:v1,:v2);");
> >exec sql execute s using :val1,:val2 ....
> >but even then the exec sql execute s using is about 300 chars long.
> >
> 
>  Did you set IRECLEN=1000 (or whatever size is needed) on the
>  precompiler invocation line?
> 
>  Tim Woodward
>  U S WEST

This may not help. As far as I know the ireclen has an upper bound < 200 chars.  
However, you could always compose the statement using several steps so that no  
line is longer than say 132 chars (or even 80 chars for readability).

Hope this helps.

--
                         
    ___           _____2
   /   )  /  /   /        Richard H. E. Eiger
  /_ _/  /__/   /__       Ing. Informatik HTL
 /\     /  /   /          Unregistered NeXT fan
/  \   /  /   /_____      rheiger@renext.open.ch (NeXT mail welcome)
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Newsgroups: comp.databases.oracle
Subject: Long insert statement in PCC ireclen exceeded.
Date: 17 Nov 92 19:45:46 GMT
Organization: Intel Corporation, Santa Clara, CA USA

I have a long insert statement in PRO*C insert into table ( ....) values (...)
ireclen is exceeded.

I tried 
char stmt[1000];
sprintf(stmt,"insert into ... values (:v1,:v2);");
exec sql execute s using :val1,:val2 ....
but even then the exec sql execute s using is about 300 chars long.

is there any way out other than using :a1,:a2 as variable names.

Aniruddha Kortikar (kortikar@mipos2.intel.com)
-------------------------------------------------------------------------------
E-mail 	: kortikar@mipos2.intel.com | A billion here, a billion there ...
Phone(W): 408 765 5515              | pretty soon it adds upto real money.
-------------------------------------------------------------------------------
From: jstander@ml.csiro.au (Jeff Stander)
Subject: Oracle on Sun
Keywords: Sun
Reply-To: jstander@ml.csiro.au
Organization: CSIRO Marine Laboratories, Hobart Tasmania
Date: Sun, 22 Nov 1992 21:58:46 GMT

Just starting an application for a fisheries database on Sun workstations.  Would like
to query the group as to what Sun-specific or Xwindow interfaces are available to
facilitate data entry, programming, reporting on same.

Thanks

js
From: grant@reg.triumf.ca (Peter A. Grant)
Newsgroups: comp.databases.oracle
Subject: SQL*Forms support for ORACLE7
Date: 18 Nov 1992 22:44 PST
Organization: TRIUMF: Tri-University Meson Facility
Distribution: world
NNTP-Posting-Host: reg.triumf.ca
News-Software: VAX/VMS VNEWS 1.41    


Our local Oracle representatives have stated a number of times that SQL*Forms
2.3 is supported with ORACLE7.  (Including today, while wrapping up the 
ORACLE7 DBA Update course, and during the ORACLE7 roll-out presentations.)
The instructor was going to look into it.  

I was quick to point out that 50% of users here in Vancouver still use 2.3.
This is a non-trivial conversion which will prove to be quite a stumbling
block for a lot of shops.  Especially true as they have been stating that
it is possible to stick with 2.3.

I personally hope that we can beta 4.0 so we can avoid converting to 3.0.


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

                  Chairperson, Vancouver Oracle Users Group