HDTenEightyP/NetNews huggingface dataset:
From: jean@seismo.CSS.GOV (Jean Anderson)
Newsgroups: comp.databases.oracle
Subject: Yoo Hoo--are you still there?
Summary: detecting dead processes
Keywords: ping
Date: 11 Nov 92 20:28:23 GMT
Followup-To: jean@esosun.css.gov
Organization: SAIC Open Systems Division, San Diego, CA

What's the cheapest way to tell from OCI if a frontend database connection 
is still alive? I want to do something like this:

	if(db_dead()==TRUE)
	{
		-- do something reasonable, maybe re-establish connection
	}

I'm looking for a cheap ping for db_dead(), maybe a "select 'x' from dual",
although I'd like to avoid a select.

Is there a better way to check, maybe already a hook I don't know about?

thanks,

 -jean

+-----------------------------------------------------------------------+
| Jean Anderson, DBA                       email:  jean@esosun.css.gov  |
| SAIC Open Systems Division, MS A2-F                                   |
| 10210 Campus Point Drive                 phone:  (619)458-2727        |
| San Diego, CA  92121                       fax:  (619)458-4993        |
+-----------------------------------------------------------------------+
|            execute disclaimer(opinion => 'mine');                     |
+-----------------------------------------------------------------------+
Newsgroups: comp.databases.oracle
From: Bruce_MacDonald@mindlink.bc.ca (Bruce MacDonald)
Subject: HELP! - Corrupted EXPort file
Organization: MIND LINK! - British Columbia, Canada
Date: Fri, 6 Nov 1992 21:46:12 GMT


I have just run into a problem that Oracle support has been unable to help
me resolve:

An export file was created using RDBMS 5.1.22, and subsequently copied
to tape.  Now when we try to import the file, we get a "Required
character set conversion not supported" immediately after specifying the
filename.

I tried importing into a V. 6 database with the same result (IMP-00016 is
the error message).

The system is VAX/VMS 5.4-3.  The structure of the dump file is fixed format,
4096 byte records which is as it should be.

Needless to say, we would REALLY like to get this data back.  Any suggestions
would be greatly appreciated!

Bruce MacDonald
Database Systems Consultant
E-Mail: Bruce_MacDonald@mindlink.bc.ca
Newsgroups: comp.databases.oracle
From: brent@spss.com (Brent Lambert)
Subject: Re: Case Studies of Distributed Databases in Oracle
Organization: SPSS, Inc. - portable code group
Date: Thu, 12 Nov 1992 16:16:35 GMT

In article <1992Nov12.034900.9780@colorado.edu>, sieh@csn.org (David Sieh) writes:
> 
> We are starting a project in which we must make a set of databases
> available to users over a wide area network...
> We are looking for help/advice in designs/implementations of
> similar database systems...We are especially interested in case studies.

A recent issue of Oracle's newsletter/magazine included several 'Lite'
case studies of large organizations that have committed to ORacle 7.
As I recall, at least one of them involved both distributed access and
distributed data.  Your Oracle rep might be able to get you a reprint.

Sorry I can't remember anything more specific ... can anyone else help
with the details?

-- 
The above statements are not the opinions or policies of SPSS Inc.
The above statements may not be the opinions of Brent Lambert.
The first disclaimer is a policy of SPSS Inc.
Subsequent disclaimers are probably the opinion of Brent Lambert.
From: nroworth@nl.oracle.com (Nick Roworth)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle 7.0.9.3, XA, and Encina
Date: 6 Nov 92 09:52:05 GMT
Organization: Oracle Europe

In article <3190@nlsun1.oracle.nl>, kverruyt@nl.oracle.com (Kees Verruyt) writes:
|> Alan Beal writes:
|> > Has anyone been successful using Oracle 7.0.9.3 with Transarc Encina
|> > 1.0.1a using the XA interface?  Using embedded SQL, we get data
|> > retrieved on the first Encina transaction and then get invalid
|> > cursor after that (sqlcode = 1001).  Oracle Support will not help
|> > because it is not a production product.  Any ideas?
|> >
|> > Alan Beal         alanb@owgvm0.vnet.ibm.com
|>  
|> Alan, 
|> 
|> I struggled with this myself -- just compile your Pro*C program with
|> 
|> EXEC ORACLE OPTION (RELEASE_CURSOR=YES);
|> 
|> Otherwise the Pro*C cursor cache gets in the way: Even if you CLOSE a cursor,
|> Pro*C tries to keep it open.
|> 
|> It should work fine after that.
|> 
|> Note: Since this is ORACLE7, closing a cursor in the front-end isn't so bad since
|>       the parsed SQL is kept around in the ORACLE7 server SGA.

An easier way to do this is to set the flag when using proc to compile the program
Just set release_cursor=yes in the makefile for the proc options.


-- 
Nick Roworth, ORACLE Europe             "Bugs Mr. Rico! Zillions of 'em!"
Rijnzathe 6, NL-3454 PV De Meern        Starship Troopers - Robert A. Heinlein
Phone: +31-3406-94211                     
nroworth@nl.oracle.com
From: beal@odin.Berkeley.EDU (Alan Beal)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle 7.0.9.3, XA, and Encina
Date: 5 Nov 92 21:07:11 GMT
Reply-To: beal@odin.Berkeley.EDU (Alan Beal)
Organization: IBM T. J. Watson Research

Yes, setting RELEASE_CURSOR=YES fixed the problem.  Thanks.
Newsgroups: comp.databases.oracle
From: bio@lis.rch.unimelb.edu.au (bio)
Subject: Backup scripts needed.
Organization: Computer Science, University of Melbourne, Australia
X-Newsreader: TIN [version 1.1 PL6]
Date: Tue, 10 Nov 1992 06:50:14 GMT

	I really need scripts to do on and offline backup of oracle database
	on unix, has any one got them, and if I can have a copy that would be
	appreciated.
	Thanks

	bio
Newsgroups: comp.databases.oracle
From: mharper@well.sf.ca.us (Michael J. Harper)
Subject: Eating it RAW
Organization: Whole Earth 'Lectronic Link
Distribution: usa
Date: Mon, 9 Nov 1992 16:45:37 GMT

I am trying to store data into a LONG RAW column, and I am running into
some difficulty.

The data I would like to store happens to be TIFF data.  Consequently, it
is a minimum of 4K or so in size.  When I tried using HEXTORAW with an 8K
string, I was told that my string was too long.  So, I divided the string
into a bunch of 254-character strings all concatenated.  No parse error,
but only the first 256 characters were stored anyway.  This gives me only
128 bytes of raw data, which isn't quite enough.

So, is there another way to issue an INSERT that will allow me to store up to
the full length of my LONG RAW?  

Also, I noticed that when I fetch this column, the first byte seems to be 
the row number in the query.  Does anyone know what this byte really means 
and what it's doing at the beginning of my raw data?

Thanks.
-- 
Michael J. Harper
mharper@well.sf.ca.us
Newsgroups: comp.databases.oracle
From: tony@cs.city.ac.uk (Tony Valsamidis)
Subject: oracle server termination when using sqldba
Organization: Systems Architecture Research Centre, City University, London
Date: 10 Nov 92 14:25:54

Has anyone else encountered this intermittent problem?  I'm running version
6.0.33.1.1 of sqldba with ORACLE RDBMS V6.0.33.1.1, transaction processing
option.  When I connect internal and type monitor process the program quits
unexpectedly with a message like:

unexpected oracle server termination by signal 6

I then have to reset the terminal to proceed.  A trace file is produced as
below:

Dump file /usr/oracle/rdbms/log/9_17474.trc
Tue Nov 10 13:06:38 1992
ORACLE RDBMS V6.0.33.1.1, transaction processing option - Production
ORACLE_HOME = /usr/oracle
ORACLE_SID = oracle
Oracle process number: 9         Unix process id: 17474
System name:    SunOS
Node name:      Paddington
Release:        4.1.2
Version:        3
Machine:        sun4

Tue Nov 10 13:06:38 1992
Exception signal: 11, code: 0x3, pc: 0x1ff058, addr: 0x23c000
----- Call Stack Trace -----
calling       entry         argument list...
location      point         arg values      
--------      -----         ----------      
Tue Nov 10 13:06:38 1992
Exception signal: 11, code: 0x3, pc: 0x1f9768, addr: 0x23d650

All suggestions gratefully received.
--

Tony Valsamidis				Email : tony@cs.city.ac.uk
Systems Architecture Research Centre	Tel: +44 71  477 8551
Computer Science Department, City University, London, UK, EC1V 0HB


Newsgroups: comp.databases.oracle
From: howard_nichols@med.umich.edu (Howard S. Nichols)
Subject: Re: Oracle.nlm and TCP/IP
Date: Tue, 10 Nov 92 17:31:13 EST
Organization: University of Michigan Department of Pathology

In article <guy.720987653@tdsb-s> guy@mais.hydro.qc.ca (Guy Harel) writes:
>Newsgroups: comp.databases.oracle
>Path: caen!zaphod.mps.ohio-state.edu!cs.utexas.edu!torn!utcsri!newsflash.concordia.ca!hobbit.ireq.hydro.qc.ca!guy
>From: guy@mais.hydro.qc.ca (Guy Harel)
>Subject: Re: Oracle.nlm and TCP/IP
>Message-ID: <guy.720987653@tdsb-s>
>Sender: news@ireq.hydro.qc.ca (Netnews Admin)
>Organization: Hydro-Quebec (DSB)
>References: <1992Oct26.173419.9317@jyu.fi>
>Date: Thu, 5 Nov 1992 18:20:53 GMT
>Lines: 26
>pl@jyu.fi (Panu Lehti) writes:
>
>>Hi,
>
>>I'm wondering, is it possible to use Oracle server v. 6.0 for Novell Netware
>>with TCP/IP. And if it's possible to connect to Oracle server for Novell
>>Netware from a Unix host using TCP/IP, how I should configurate my Oracle
>>server to get working with TCP/IP?
>
>>Panu Lehti
>
>
>I suggest you contact 1-800-NET-WARE, say you consider purchasing
>many Novell products, but you need technical advise before recommending
>the product.
>
>Worked wonderfully for me. They`ve fax me a 30 pages long Novell TCP/IP
>primer.
>
>Good luck
>
>
>P.S: I have no link whatsoever with NOVELL. Was I that lucky?
>
>--
> Guy Harel

Well Guy could you please go into more detail.  Does Oracle offer a tcpip 
server nlm that parallels their spxsrv.nlm ????

We need mac's using tcpip to communicate with our oracle database.

Does oracle off a mac extension that communicates with spxsrv.nlm?????

						Howard S. Nichols
From: alacy@hayes.com
Newsgroups: comp.databases.oracle
Subject: Which Cobol's work with Pro-Cobol?
Date: 9 Nov 92 11:04:08 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

Can some one tell me which UNIX Cobol Compilers will work with Oracle's 
Pro-Cobol?

And which MS-DOS Cobol Compilers will work with Pro-Cobol?

Thanks
-- 
Allen Lacy                    | internet:  alacy@hayes.com              
(404) 840-9200 (x.2131)       | uucp:      uunet!hayes!alacy     
Hayes Microcomputer Products  | U.S.Mail:  p.o.box 105203, Atlanta, GA 30348
From: dewey@centerline.com (Devan F. dewey)
Newsgroups: comp.databases.oracle
Subject: Anyone using PTI Products??
Followup-To: comp.databases.oracle
Date: 9 Nov 1992 14:09:47 GMT
Organization: CenterLine Software, Inc.
Distribution: world
NNTP-Posting-Host: 140.239.3.212


Is anyone using products from PTI (Perfomance Technology Inc.)?

Any industry analysts reading this???

What is the company's reputation? How stable are they? What do you think of
their products?

Any comments would be greatly appreciated.

Please e-mail to dewey@centerline.com


Thanks,
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: cec@planet.bt.co.uk
Newsgroups: comp.databases.oracle
Subject: Oracle Float Problem
Date: 6 Nov 92 10:57:20 GMT
Organization: DNM42, BT Labs, Martlesham Heath, Ipswich, UK.
Originator: cec@phoenix


System: Oracle 6.1.2, Sun Sparc 4.1.1

Does anyone know of a fix/workarround to the following problem caused
by using floats in ProC ?

I get a core dump, the trace is :

(dbx) oarren() at 0x5466b0
ttcf2n() at 0x5422c0
ttcacs() at 0x540828
ttcdrv() at 0x5378ac
osntwa() at 0x52c144
upirtr() at 0x536dac
upiexn() at 0x5332e4
sqlexe() at 0x51f09c
CreateScheduleActionRecord() at 0x9aa08
DatabaseCreate() at 0x9be00

Rumour has it that this is due to the fact that I am using BSD cc and 
standard libraries, whereas Oracle libraries were compiled with System V.
I can't use System V libraries, 
Can anyone help please ?

Thanks in advance

Chris Cox  (0473 644532)
Newsgroups: comp.databases.oracle
From: guy@mais.hydro.qc.ca (Guy Harel)
Subject: Re: Oracle.nlm and TCP/IP
Organization: Hydro-Quebec (DSB)
Date: Thu, 5 Nov 1992 18:20:53 GMT

pl@jyu.fi (Panu Lehti) writes:

>Hi,

>I'm wondering, is it possible to use Oracle server v. 6.0 for Novell Netware
>with TCP/IP. And if it's possible to connect to Oracle server for Novell
>Netware from a Unix host using TCP/IP, how I should configurate my Oracle
>server to get working with TCP/IP?

>Panu Lehti


I suggest you contact 1-800-NET-WARE, say you consider purchasing
many Novell products, but you need technical advise before recommending
the product.

Worked wonderfully for me. They`ve fax me a 30 pages long Novell TCP/IP
primer.

Good luck


P.S: I have no link whatsoever with NOVELL. Was I that lucky?

--
 Guy Harel
Newsgroups: comp.databases.oracle
From: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek)
Subject: Re: Getting out of Monitor
Reply-To: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek 
Organization: NASA/GSFC, Code 902
Date: Mon, 9 Nov 1992 13:38:08 GMT

I earlier posted a question concerning getting out of Monitor when logged
into an SGI from a SUN in VT100 mode.  Several people suggested Ctrl-C but 
none of the ctrl sequences have any affect (Ctrl C works fine outside of
Monitor).  One person noted a similar problem and said it seems to be
specific to accessing an SGI from a SUN.  Has anyone successfully run
Monitor on an SGI from a SUN?

Thanks.


Joe Fulson-Woytek
Code 902/Goddard DAAC
NASA/Goddard Space Flight Center
joefw@eosdev1.gsfc.nasa.gov
From: tssmith@netcom.com (Tim Smith)
Subject: Re: Yoo Hoo--are you still there?
Keywords: ping
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Thu, 12 Nov 1992 13:11:12 GMT

In article <51455@seismo.CSS.GOV> jean@seismo.CSS.GOV (Jean Anderson) writes:
>What's the cheapest way to tell from OCI if a frontend database connection 
>is still alive? I want to do something like this:
>
>	if(db_dead()==TRUE)
>	{
>		-- do something reasonable, maybe re-establish connection
>	}
>
>I'm looking for a cheap ping for db_dead(), maybe a "select 'x' from dual",
>although I'd like to avoid a select.
>
>Is there a better way to check, maybe already a hook I don't know about?
>
>thanks,
>
> -jean

Why not just try to oopen a new cursor using that LDA?  Something like

if (!oopen(&dummy_cursor, &dubious_lda, ...))
{
    printf("I'm still here!\n");
    oclose(&dummy_cursor);
}
else  /* you'll get ORA-01012 if it's dead */
{
/* do what's needed to re-establish the connection */
}

Or, you could try a parse of "select 'x' from dual" using a cursor
open on that connection, if you have a cursor to spare.  Make sure you
oparse in non-deferred mode.

--Tim (tssmith@netcom.com)



Newsgroups: comp.databases.oracle
From: kpalm@athena.qualcomm.com (Kent Palm)
Subject: Re: dd backup of databases on a raw device
Organization: Qualcomm, Inc., San Diego, CA
Date: Thu, 29 Oct 1992 00:20:29 GMT

Here's a little excerpt from my backup script that might help.  I've left out
some things (e.g., variable assignments), but you can easily set them up.

#!/bin/sh -h
#-------------------------------------------------------------------------------
CopyThisFile()
{
# Begin copying from the raw devices to the tape drive. 
#
# Don't use a bs size > 32.  Larger block sizes are less reliable.
# Also, the bs must be a multiple of the Oracle block size (i.e., 2048)
#
echo "Copying the ${File} File/Tablespace (${ORACLE_SID})..." | tee -a ${BackupLog}
echo "   Start: `date`." | tee -a ${BackupLog}
mt -f ${OutputDevice} status >> ${BackupLog} 2>&1
dd if=${InputFile}\
   of=${OutputDevice}\
   bs=${BlockSize}\
   count=${Count} >> ${BackupLog} 2>&1
echo "   Finish: `date`." | tee -a ${BackupLog}
return
}
#-------------------------------------------------------------------------------
if [ "${BackupType}" = "Cold" ]
then
   File=CONTROL InputFile=${CONTROL} BlockSize=32k Count=999999
   CopyThisFile
fi
#--------------------
File=REDO1 InputFile=${REDO1} BlockSize=32k Count=999999
CopyThisFile
#--------------------
File=REDO2 InputFile=${REDO2} BlockSize=32k Count=999999
CopyThisFile
#--------------------
File=Pfile InputFile=${PFILE} BlockSize=32k Count=999999
CopyThisFile
From: kurz.1@ipa.fhg.de (Hermann Kurz)
Newsgroups: comp.databases.oracle
Subject: Problem with ORACLE, E-SQL in COBOL
Date: 12 Nov 1992 15:49:45 GMT
Organization: IPA Stuttgart
Distribution: world
NNTP-Posting-Host: leila1.ipa.fhg.de

Hello,

the following message is forwarded from a person without netaccess.

-------------
COBOL program follows
-
DECLARE SECTION
	.
	.
   HOST_VAR1 PIC X(40)
	.
END DECLARE.

PROCEDURE DIVISION.
	.
	.
   MOVE SPACES TO HOST_VAR1.
	.
	SQL
	SELECT REC
		WHERE
		.
		.
		VAR1 >= : HOST_VAR1
		.
		.

----
the problem:

A host variable defined as CHAR and signed with "SPACE" will be set to 
"NULL" while the SQL-statement is executed, so the comparision 
VAR1 >= : HOST_VAR1 will *never* match.

This failure occurs only in E-SQL with HOST variable = SPACE.

Is there any solution known without the need to change the sourcecode ??

any help/solutions/pointers appreciated.
----
ern
From: vtl@tik.vtt.fi (Tapio Luukkanen)
Newsgroups: comp.databases.oracle
Subject: How to validate username and password ?
Date: 5 Nov 92 15:59:32
Organization: Technical Research Centre of Finland, Laboratory for Information
	Processing (VTT/TIK)
NNTP-Posting-Host: morko.tik.vtt.fi


We are developing a menu5.0 + forms3.0 application, where
we have our own logon screen, accessed via a 'dummy/dummy' user.
The logon form builds some form-global variables from 
Unix environment (via user exits), and returns, among others,
:global.user and :global.passwd to the calling menu.

In menu, I tried to use "new_user(:global.user || '/' || :global.passwd)"
and then check for ERROR_TYPE or ERROR_CODE to see
if I need to call "new_user('dummy/dummy')" again.
But, it appears that a failing "new_user" puts the menu
in LOGIN state, where er, "things don't quite work".

The solution I see (and know how to do, maybe the day-after-tomorrow)
is to call an user exit from the logon form, which tries
'EXEC SQL CONNECT :username' and checks for failure.

I vaguely recall reading about some other way to do this validation,
by applying some internal function to the password (& user),
a function, which returned true or false (or something else),
if it was a valid password. 

So, is there a solution without using an user-exit ?

    Tapio
--
! tapio luukkanen  !  vtl@hemuli.tik.vtt.fi (130.188.52.2)
! home (358-0) 811 211  !  work 456 6056
Newsgroups: comp.databases.oracle
From: Ronny G. Nordvik <nordvik@edb.uib.no>
Subject: Omnis 7 with SQL
Organization: Edb-senteret, UiB, Norway
X-Useragent: Nuntius v1.1
Date: Fri, 13 Nov 92 12:30:26 GMT

OMNIS 7 WITH SQL DATABASE - SYBASE OR ORACLE


I want information about Record Locking on rows and tables for
updating.... in a multiuser Omnis apllication, because we don't want
problems with many persons updating the same record(row). In Omnis i want
to lock the record(row) begfore I go into enter data mode, and release
the record lock when leaving enter data mode.

Please send me information and keep on with further discussion about
Omnis and SQL.

Greetings from

Ronny G. Nordvik

The Computing Centre
HighTechnlogy Centre in Bergen
N-5020 BERGEN
NORWAY

Tlf. 47 5 544100
Fax. 47 5 544299

E-mail: edorn@alf.uib.no   or.  nordvik@edb.uib.no
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Thanks for the solution : ) to "extent allocation?" & "Help! Oracle problem or my problem?"!
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Fri, 6 Nov 1992 16:59:23 GMT

un@gdstech.grumman.com (Un Fu) writes:
>As Scott and Andy stated to me, Oracle first looks for exact fit, then best
>fit, and then coalesce of smaller, CONTIGUOUS, extents when it allocates
>extents for object creation.  The DUMMY table creation above will force
>the coalesce of smaller, contiguous, extents into one large extent.  

Well, I was wrong about the Exact-fit first.  For some reason I was thinking
that Oracle did this, but a guy from Oracle (can't remember his name) 
corrected us.  It's possible that I was reading an outdated manual or
bulletin or something.

-Andy

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.
  Send mail to ora-request@vistachrome.com to join Unix, CASE, and 
  Desktop Oracle RDBMS Database discussions.
From: fragante@unixg.ubc.ca (Gv Fragante)
Newsgroups: comp.databases.oracle
Subject: SQL*REP - conditional printing of page header
Date: 6 Nov 92 22:26:31 GMT
Organization: The University of British Columbia
NNTP-Posting-Host: unixg.ubc.ca

How can I make the page header of a report print conditionally ? In my
application, I have to make a report that does not print the page number on
the first page, but does so on all succeeding pages (ie. pages > 1).

Thanks.
Newsgroups: comp.databases.oracle
From: un@gdstech.GRUMMAN.COM (Un Fu)
Subject: View questions...
Organization: Grumman Corporation
Date: Thu, 5 Nov 1992 17:02:54 GMT

How can I get the block usage of a view I created?  Looked
into "user_extents" and it only displays block usages of tables.

Also how do I direct the creation of a view or several views to use
a temporary, TEMP_TS, tablespace.  I see one can specify which
tablespace to create a table at, but not on the 'CREATE VIEW' command.

I have been asking lots of question lately and this newsgroup has been
tremendously responsive.  THANK YOU ALL, FOLKS!
--
****************************************************************************
Un Un Fu                                    Internet: un@gdstech.grumman.com
Disclaimer: I am solely responsible for what I am saying here!
****************************************************************************
-- 
****************************************************************************
Un Un Fu                                    Internet: un@gdstech.grumman.com
Disclaimer: I am solely responsible for what I am saying here!
****************************************************************************
Newsgroups: comp.databases.oracle
From: rhari@us.oracle.com
Subject: Re: Eating it RAW
Organization: Oracle Corporation, USA
Distribution: usa
Date: Tue, 10 Nov 1992 23:13:45 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 <BxGJw1.Kr1@well.sf.ca.us>, mharper@well.sf.ca.us (Michael J. Harper) writes:
> I am trying to store data into a LONG RAW column, and I am running into
> some difficulty.
> 
> The data I would like to store happens to be TIFF data.  Consequently, it
> is a minimum of 4K or so in size.  When I tried using HEXTORAW with an 8K
> string, I was told that my string was too long.  So, I divided the string
> into a bunch of 254-character strings all concatenated.  No parse error,
> but only the first 256 characters were stored anyway.  This gives me only
> 128 bytes of raw data, which isn't quite enough.
> 
> So, is there another way to issue an INSERT that will allow me to store up to
> the full length of my LONG RAW?  
> 
> Also, I noticed that when I fetch this column, the first byte seems to be 
> the row number in the query.  Does anyone know what this byte really means 
> and what it's doing at the beginning of my raw data?
> 
> Thanks.
> -- 
> Michael J. Harper
> mharper@well.sf.ca.us
-- 
I presume you are using version 6 of ORACLE.

The best way to handle raw data is thru OCI or Pro* languages.


Radhakrishna Hari
rhari@us.oracle.com
Newsgroups: comp.databases.oracle