Title: RE: Guild of DBAs
Bill...
If you get to... So do I.
-Original Message-
From: Thater, William
To: Multiple recipients of list ORACLE-L
Sent: 8/29/2003 4:59 PM
Subject: RE: Guild of DBAs
Arup Nanda scribbled on the wall in glitter crayon:
> And how do you suppose you wo
Title: Message
Oracle officially "desupported" the package in 8i;
but then included (by mistake?) in 9i. In 8i, however, you could pester your
friendly neuighborhood Support Analyst to give you the package. You could try
from 9i sources, too; but not sure if they work.
Arup
- Origina
David,
Could you post the few lines before and after the line the package
comiplation is failing.
Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 6:39 PM
> I am getting this error from these packages. In one databa
In
using developer on Unix - do you have to use XWindows or an XWindows emulator
like Hummingbird or is it character based tool. How does it perform versus
Windows version? What about security holes with XWindows?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PRO
>kidding aside, this does sound like a good idea. an independent group of
>professionals.
And if you are looking for an independent group of 'Oracle' professionals,
you always have the IOUG. Granted, we have our share of Developers (!) but
then all good DBAs probably were Developers at some point
I am getting this error from these packages. In one database they create
just fine (8.1.7.0.0) and the other database they error out (8.1.7.1.0)
does anybody have an idea?
SQL> @p_autoaud_api.pck
CREATE PACKAGE BODY p_autoaud_api
*
ERROR at line 1:
ORA-06553: PLS-103: Encountered the symbol ""
IT is time to take this thread to the OT list.
"Mladen Gogala" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/29/2003 03:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE
I am getting this error from these packages. In one database they create
just fine (8.1.7.0.0) and the other database they error out (8.1.7.1.0)
does anybody have an idea?
SQL> @p_autoaud_api.pck
CREATE PACKAGE BODY p_autoaud_api
*
ERROR at line 1:
ORA-06553: PLS-103: Encountered the symbol ""
Please take this to the OT list.
"Thater, William" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/29/2003 02:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Guild of D
this is from metalink
HOW TO FIND THE SESSION HOLDING A A LIBRARY CACHE LOCK
--
Common situations:
* a DML operation that is hanging because the table which is accessed is
currently
undergoing changes (ALTER TABLE). This may take quite a long
How about a secret handshake and a good hazing?
--
Mladen Gogala
Oracle DBA
-Original Message-
Nanda
Sent: Friday, August 29, 2003 5:15 PM
To: Multiple recipients of list ORACLE-L
And how do you suppose you would conduct the intiation to this "Guild"? A
touch of your scepter on the
Title: Message
I was
trying to come up with a sensible explanation for DAMBLA (DBA version of NAMBLA)
but I couldn't. Can
someone help me out here?
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTEC
Arup Nanda scribbled on the wall in glitter crayon:
> And how do you suppose you would conduct the intiation to this
> "Guild"? A touch of your scepter on the shoulders? A hard knock on
> the head? Being asked to hold on the TAR call for a dozen ORA-600
> errors? Or negotiating with a bunch of de
Experience: case doesn't matter on PC's for loading files (icons, whatever), calling other forms, etc.
It does matter on unix, so it's a good idea to standardize on names so that the case of the
object in the forms actually matches the case of the object as stored on disk.
Jared
[EMAIL
One small correction is that the Berkeley book you're describing is by
Leffer and others (Bach wrote the AT&T one).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for sch
Then suggested names should closely
follow:
Guild of Oracle Professionals (GOP,
or GOOP, depending on how you feel about it)
Current Organization for the Working
Finestkind Learned Oracle Professionals (COWFLOP; esp. big in Maine and
Montana)
Institute for the National Advancement
of the Guild of
Title: Message
It’s not in 8.1.5
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John
Kanagaraj
Sent: Friday, August 29, 2003 3:20
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: get s
Title: RE: Congratulations Arup (DBA of the Year)
JBOD - Just A Bunch Of DBAs.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have f
Title: Message
Ok, so it was too good to
be true
the suggestion to run
namesctl dump_tnsnames
on the client and expecting a fresh copy of tnsnames to
be installed (on the clients machine) is NOT
supported.
I searched on metalink, alot of people have the same
problem " a 0 byte
alification.
>
> OK so when do we start?;-)
>
> kidding aside, this does sound like a good idea. an
> independent group of professionals.
>
> --
An independent array or redundant professionals
;-)
Sorry I couldn't resist
Have a good holiday all!
--
Please see the official ORACLE-L FAQ: htt
And how do you suppose you would conduct the intiation to this "Guild"? A
touch of your scepter on the shoulders? A hard knock on the head? Being
asked to hold on the TAR call for a dozen ORA-600 errors? Or negotiating
with a bunch of developers for using bind variable?
Arup,
Wannabe founding memb
Title: Message
NT -
uppercase/lowercase no problems. UNIX - got problem!
NT -
Bill wants to use "\" just to spite UNIX; UNIX - Used "/" right from the
beginning
NT -
Has a lot of GUI goodies that developers may want to use/call. UNIX - Likes the
command line, so doesn't support that many GU
DENNIS WILLIAMS scribbled on the wall in glitter crayon:
> Bill - Oh yeah, you'd be a founding member for sure. A history of
> participation on this list would surely be all the necessary
> qualification.
OK so when do we start?;-)
kidding aside, this does sound like a good idea. an independe
"Design and Implementation of the [UNIX || 4.x BSD] Operating System" by
[Bach || McCusic et all]
Should both have excellent overviews of shared memory, semaphores, and why
they're useful. If you want even more nitty gritty, pick up a decent book
on pthreads programming and you'll also learn abou
Ron and all;Sorry took me so long to replay ... I got the flu :(
Anyways thanks so much for the reply. I went back and read more about TAF, I still am expecting to finish my selet call count on a 32 million row table even if I kill an instance with srvctl command.
Here is where I am at now. Thanks
Title: Message
With
Developer6i it worked like a charm. That is, at least, what I was told by
developers on my previous job.
They
were porting the application system called PULSE from Dev 2000 R1.6 -> Dev 6i
on AIX 5.2. Windows
PC
were heavily used by people who were doing the porting wor
Title: RE: using developer under Unix versus on PC and then ftp code to Unix
Pros/Cons/Ideas/Experience?
Bill - Oh yeah, you'd be a founding member for sure. A history of
participation on this list would surely be all the necessary qualification.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, August 29, 2003 3:05 PM
To: Multiple rec
Title: Message
Need
to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all
platforms 8.0.6+ I understand.
John KanagarajDB Soft IncPhone: 408-970-7002
(W)Disappointment is inevitable, but Discouragement is
optional!** The opinions and facts contained in this message a
Title: RE: get sid (session id) and serial#?
Go ahead, install the package, no problems. It is a better interface to enable/disable trace anyways.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expre
Raj,
The comments in dbmssupp.sql suggest that this object needs to be installed
only when requested by Oracle supportI was just curious why our
databases did not have this object... :-).
Thanks
Murali.
DENNIS WILLIAMS scribbled on the wall in glitter crayon:
> Stephen
>
>To copy from Alcoholics Anonymous, I'm Dennis and I'm a DBA.
>
>I've been promoting an idea of a "Guild of Oracle DBAs". Nobody
> would be allowed to call themselves an Oracle DBA without our
> permission. An organiza
a senior dba who can train others and help developers is far more valuable to an
organization than one who cant or wont.
also pays better too.
>
> From: [EMAIL PROTECTED]
> Date: 2003/08/29 Fri PM 03:54:27 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: The Co
Hi All,
I am using below code to send mail to Lotus Notes. It works fine except
when I receive a mail message the time stamp is correct. However when
I open the mail message the time stamp in the header is 4 hours off. It
must have something to do with
utl_smtp.write_data(connection, header
Title: RE: The Coming Job Boom
Steve, although it has been years for some of us - we were once the DBA in the diapers so remember to be gentle. I forgot just today.
-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 29, 2003 3:39 PM
To: Multiple rec
Stephen,
I was using CHAR for the LONG column the error is actually on the
field in the file FOLLOWING the LONG column... I was getting a message
that the data was too large. So I did the following and it seems to be
working, although I can't get it to work via direct path this way:
I changed
its kinda slick. i have large tables. if i use the nested table with the cast
function, I can use an index.
ill keep it in mind.
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3748097f.5471527%40newshost.us.oracle.com&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe
Title: RE: get sid (session id) and serial#?
[EMAIL PROTECTED]> sys
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Aug 29 14:42:11 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
14:42:15 SQL> desc dbms_support
FUNCTION MYSID RETURNS NUMBER
FUNCTION PACKAGE_VERSION
This method works; I have some code using it.
The only problem, it could be slow (on large tables), because index on
will not help.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Chelur, Jayadas {PBSG}
Sent: Friday, August 29, 2003 10:45 AM
To: Multiple recipients of list OR
> I was wondering how one performed CPA though...
I think some old geezer steered his monstous Cadillac fingers into a
wrong turn on the keyboard highway. :-)
Peeking over the downhill side of life brings new perspective and I see
that we're not getting older, we're just getting wiser. In "The
Raj,
Which version of db are you on? This is not available on 9.2.0.3
Murali.
"Jamadagni,
Stephen
To copy from Alcoholics Anonymous, I'm Dennis and I'm a DBA.
I've been promoting an idea of a "Guild of Oracle DBAs". Nobody would be
allowed to call themselves an Oracle DBA without our permission. An
organization where the Sargent of Arms is more than a ceremonial post.
Dennis Wi
We don't like nobody and we're taking over, using our strange and wonderful
mutant powers if necessary. That and a 10g install on RedHat 10.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original M
So, this begs the question (still the newbie here), how many DBAs would
you say there were?
Oh, and when can you say, I'm a DBA?
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
> -Original Message-
> From: Tim Gorman [mailto:[EMAI
Title: RE: get sid (session id) and serial#?
use the function dbms_support.mysid if it is available on your version.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictl
Title: Message
http://www.business2.com/articles/mag/0,1640,51816,00.html
-Original Message-
From: April Wells
[mailto:[EMAIL PROTECTED]
Sent: Friday, August
29, 2003 1:40 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: The Coming Job Boom
Oh it's okay...
Title: Message
What
about those mutants?
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Friday, August 29, 2003 1:44
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
How to keep "root" out?
Nope. It's against the law of evolution. SA has to work
Title: Message
How do
you take a systemdump, level 10 of an 80 years old person? Restart would be
nice, something like
alter
joe.schmoe set age=20; Isn't that exactly what the guy named Ponce de Leon was
looking for in FL?
Self
check. I was about to start about voting practices in FL, first
Title: RE: How can I measure my DB performance.
I thought that would be for a bad database. Of course you need to throw the server out of a 20th floor window or higher to hit terminal velocity.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-O
Title: Message
Oh it's okay... Paula lives in Florida... she has to
be more tolerant of "old people in their monstrous Cadillacs,
driving
40 mph in the passing lane"... and
snowbirds
and bad humor...
=)
I was wondering how one performed CPA
though...
April Wells Oracle DBA/Oracl
I'm getting the following response back from okinit.
okinit: Password incorrect
okinit: Decrypt integrity check failed.
The password is correct. Has anybody seen this? I have some indication, a paper from
U. of Mich. that this is due to corruption of the keytab file. But kinit continues to
Nope. These are fresh installs dedicated to nothing except proving RAC.
I'd like to open a TAR on this, but running RH9 won't get us very far.
Thanks,
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
> -
I subscribe to theories of Arthur Dent and Ford Prefect: Don't Panic and
always have a towel.
--
Mladen Gogala
Oracle DBA
-Original Message-
Jesse, Rich
Sent: Friday, August 29, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L
Sounds similar to the economic theories of Harry S.
Title: Message
Yeah,
I really was on a tangent. Actually I was thinking of making a move in my
career to something related to the healthcare industry. I mean analysis is
analysis, diagnostics is diagnostics. With a few manuals and a
certification exam I think I could be just as good as if
Title: Message
CPR,
not CPA.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Mladen GogalaSent: Friday, August 29, 2003 2:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
The Coming Job Boom
Pa
Rachel,
I do not claim to be a guru, but I do happen to have Jonathan's book
here.
The first thing is what field type are you using for this memo field?
The book says you should use CHAR for VARCHAR2, CHAR, LONG and other
related.
What error are you getting?
Can you post the lines from the ctl
Picked up the text of the article on another listserv...
This appears in the latest edition of Business 2.0: (its subscription, so
Ive included the entire article inline rather than a link):
The Coming Job Boom
Forget those grim unemployment numbers. Demographic forces are about to put
a squeeze
Title: Message
Paula,
does that mean that the DBA of the future will have to learn how to perform CPA
and
do a
therapeutic massage? I have problems with surgery, except if done on
damagement.
We'll
have to speak louder and be more tolerant to old people in their monstrous
Cadillacs, drivi
> related the method of milking a nanny goat who has mastitis
> (yes, carefully
> and gently for starters, watch the horns...) :-)
Is this going to be a session at Hotsos or OracleWorld? ;)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Anderson, Brian
INET: [EMAI
Mladen Gogala scribbled on the wall in glitter crayon:
> On the other hand, one might say that if users aren't complaining,
> the speed is adequate.
one might say if they do complain, "gee works fine for me, sorry but if i
can't reproduce the problem i can't fix it.";-)
--
Bill "Shrek" Thater
by any chance do you have an Oracle 7, or 8 instance (or even listener) running on
that second machine? I think I've seen something similar to this when we had the
wrong libraries linked to the database on one of the nodes.
Nick
-Original Message-
Sent: Friday, August 29, 2003 10:39
Title: RE: The Coming Job Boom
That's nice but what if the companies outsource overseas in response to this concern - hmmm. Still on the up-side they won't be able to do this in all cases and so overall there will likely be a positive demand for DBA skills in relation to the "ageing" of our N
You can also use speed the acceleration as a criteria. A good database
should accelerate
with the acceleration of 30ft/sec square (= 9.81 m/sec square for ISO types)
but only once.
On the other hand, one might say that if users aren't complaining, the speed
is adequate.
--
Mladen Gogala
Oracle DBA
Title: Message
Nope.
It's against the law of evolution. SA has to work hard evolve to become a
DBA. The regular, unevolved specimens
of
systemadministraticus vulgaris would be bored to death on this list. It's
about the survival of the fittest, remember?
--Mladen GogalaOracle DBA
Hey all,
We're testing the useability of 9iRAC. Our test hardware is a 2-node Intel
RedHat9 "cluster" (AS2.1 won't recognize our hardware) with OCFS on a shared
SCSI drive, setup using the "How to Build a $1000 RAC" from www.bradmark.com
Following the "Step-By-Step Installation of 9.2.0.4 RAC on
Hmmm,
I only managed 9/10.
Pete
-Original Message-
Sent: 29 August 2003 18:19
To: Multiple recipients of list ORACLE-L
My score :
10/10 "Your liver is safe" =)
What worries me most is that I named the majority of the serial killers but
didn't recognise any coders. Maybe I'm in the wro
yes. Tried that too. Get the same error. And I'm using Oracle's data
provider for .NET.
Kevin
-Original Message-
Sent: Friday, August 29, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
I haven't had a chance to work with this senerio much but it seems to look
like it would work
Well, unlike BogoMips, which is just kind a mostly meaningless number the
kernel generates on boot, a TPC benchmark is a measurement of the
performance of a specific database on a specific platform - not the measure
of your database. The database is provided to you, and you're very limited
as to
My score :
10/10 "Your liver is safe" =)
What worries me most is that I named the majority of the serial killers but
didn't recognise any coders. Maybe I'm in the wrong job.
regards,
Mike
-Original Message-
Sent: 29 August 2003 16:34
To: Multiple recipients of list ORACLE-L
This we
There was a 3rd party utility called DBTools4, you can search for that on
the 'net but it's a little old. It submits SQL as 1 session, then logs in
twice at the same time, submits the same SQL, etc. and builds up the
pressure... Good for load testing but I wouldn't do that against a
production sys
no i need it in several placse and i dont want to run it over and over again. Im
passing it around.
>
> From: "Charu Joshi" <[EMAIL PROTECTED]>
> Date: 2003/08/29 Fri AM 11:54:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: how to do a variable in-list of num
i figured it out. here
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3748097f.5471527%40newshost.us.oracle.com&rnum=1&prev=/groups%3Fq%3Doracle%2Bcast%2Bpl%252Fsql%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den
>
> From: "Charu Joshi" <[EMAIL PROTECTED]>
> Date: 2003/08/29 Fri PM 12:09
http://www.tpc.org
>
>Jake
> Compare to what? Another database? To what its
>performance should be?
>
>Dennis Williams
>DBA, 80%OCP, 100% DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Thursday, August 28, 2003 6:59 PM
>To: Multiple recipients of list ORACLE-L
>
Nuala
I think many of us are struggling to understand the new Web/Internet/Java
world. Many times the Java program is hosted by an application server. I
don't think that is essential though. There are many different application
servers, so you might ask around. Popular ones are Oracle9i AS, Webl
Sounds similar to the economic theories of Harry S. Dent, Jr. -- it's all
based on birth-rate.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
> -Original Message-
> From: Grabowy, Chris [mailto:[EM
I haven't had a chance to work with this senerio much but it seems to look
like it would work, have you
tried to pass the value to a stored procedure then have the stored procedure
insert into the table?
I haven't had much experience with ODP but the MS Oracle Provider is really
buggy with para
This week a game was brought to the attention of the Round-Up which
perfectly sums up the image crisis besieging IT.
Can you tell which of these mugshots are programmers and which are serial
killers?
http://www.malevole.com/mv/misc/killerquiz/
It's actually quite difficult (not to mention scar
We
assume the SA don't know much about Oracle. But if some one is
particularly interested in
getting into the database, he might be on this list as
well learning all our defense mechanisms. :)
Or
doesn't have to be subscribed to it since this list is mirrored other places and
google is his
Hi Dennis,
I'm not too sure what you are asking so I will give you a brief overview of
the set up;
The oracle server (version 8.1.7.4) (running on windows2000)
The java process is running on this server.
Users connect to the java process via Radio Data Terminals.(RDT's)
The java process then hand
Good point. Also, SYS becomes AUDITable in 9i, which should help an
after-the-fact whodunnit, especially if the hostname (or IP) is properly
captured. It's not prevention (I still don't think that's possible if the
user has root access), but it can provide a good trail of bread crumbs to
follow b
Roger
I have never received this error (or didn't read the log closely enough).
I think I heard somewhere that is how RMAN handles blocks that are updated
while it is reading them. I do remember that RMAN's method of handling this
is different from hot backups.
One thing you might consider
I know that there are several sql loader gurus on this list. I'm having
a problem loading data from a third party vendor. into what is
basically a LONG column
The file is ASCII, tab delimited. The specs on the input data say that
this particular column is a "memo" field (the originating datab
Jin
You have received several good replies. One question I have for you is
whether you simply want to do this once (like to create a test database), or
continuously (to create a standby database)?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message--
Jake
Compare to what? Another database? To what its performance should be?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 28, 2003 6:59 PM
To: Multiple recipients of list ORACLE-L
Is there a standard query I can run
Sorry, I totally misunderstood the question. Gotta improve my
grasping. (but how?)
Regards,
Charu.
-Original Message-
Sent: Friday, August 29, 2003 8:29 PM
To: [EMAIL PROTECTED]
Hi,
Can you not use the query that fetches the numbers to be part of
the 'inlist' directly in the insert sta
A stupid suggestion :
insert into tab2
select col1
from tab1
where col2 in (select you use to build your inlist);
>
>I need to do an insert select of the form
>
>insert into tab2
>select col1
>from tab1
>where col2 in (inlist of numbers);
>
>I do not know how many values will be in my inlist
>at
Title: RE: how to do a variable in-list of numbers?
The reason is there is a bug (which is never going to get fixed) which won't recognize a pl/sql type. The type that you want to use in CAST or TABLE must be a SQL type. And only way you will create a SQL type is using create TYPE command whic
RE: Congratulations Arup (DBA of the Year)
> hmmm... award to Mogens maybe for writing 'You Don't Need RAC' paper
> I think his next paper will 'You don't need Grid Computing' ...
I certainly hope it won't be "You don't need Oracle" or something similar ;)
Tanel.
--
Please see the official O
Title: ODP.NET and LONG RAW
Help!
I am having trouble loading a JPEG image into Oracle via ODP.NET. I am getting the ORA-00932: Inconsistent datatypes error message when attempting to load the image into a LONG RAW column.
If this wan't an Oracle Apps table, I would use a BLOB column inste
Hi,
Can you not use the query that fetches the numbers to be part of
the 'inlist' directly in the insert statement itself?
insert into tab2
select col1
from tab1
where col2 in (select num from .);
If you want to reuse the same 'inlist' for the rest of the
session, you could use temp tables.
Title: ODP.NET and LONG RAW
Help!
I am having trouble loading a JPEG image into Oracle via ODP.NET. I am getting the ORA-00932: Inconsistent datatypes error message when attempting to load the image into a LONG RAW column.
If this wan't an Oracle Apps table, I would use a BLOB column inste
Naula
Are these Java processes being hosted by an application server or do they
just connect directly to your Oracle database?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, August 29, 2003 4:49 AM
To: Multiple recipients of l
Ruth,
Just to be clear you are pre-compiling(not compiling) under 9.0.2.3 and
compiling with same C compiler then linking with new 9.0.2.3 libraties. OS
is the same.
Obviously the contents of sqlca.sqlcode memory location is getting stomped
on as 1093480496 is garbage. I would not think the s
SELECT
FROM
WHEREINSTR(','',' ,
','',' ) > 0;
(1). Concatenate Commas at BOTH ENDS of the string containing
different code values. e.g. If the string is
'101,102,554,336,678,301,201,199' , the concatenate commas
on both ends to make it ',101,102,
Title: RE: how to do a variable in-list of numbers?
http://tinyurl.com/llg8
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts
Hi,
I want to install oracle client on Red Hat Linux release 8.0 (Psyche).Which
version would be good for that in 9i. What is the basic configuration
required for that machine?
thx
-seema
_
Get MSN 8 and enjoy automatic e-mail virus
figured it out, but dont know why.
i have to explicitly create a type in the database. I cant use a pl/sql table made on
the fly.
must be the seperate sql and pl/sql parsers.
thanks anyway.
>
> From: <[EMAIL PROTECTED]>
> Date: 2003/08/29 Fri AM 10:31:37 EDT
> To: Multiple recipients of list
Oops, so right.
The author of the SANS book is Pete Finnigan.
Jared
On Fri, 2003-08-29 at 00:49, Pete Sharman wrote:
> Much as I would like to claim credit, that's the wrong Pete you have
> there. :)
>
>
> Pete
>
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Ha
GROUP BY does not necessarily guarantee a sort.
eg. you still need an ORDER BY
On Fri, 2003-08-29 at 07:59, Mercadante, Thomas F wrote:
> Mike,
>
> Add a GROUP BY command:
>
> select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
> from EMP
> group by (rpad(employee_id,6,' ')) ||';'|| ssn
>
>
2003 06:44:40
>
>I have problem to use "distinct" with Function on
>select statement. Can anyone give me a hint?
>
>Thanks.
>
>SQL> select distinct (rpad(employee_id,6,' '))
>||';'||
>ssn from EMP
> 2 order by employee_id;
>select distinct (rpad(employee_id,6,' ')) ||';'||
>ssn
>from EMP
>
1 - 100 of 143 matches
Mail list logo
