to compile it. IN this case, the package is locked
until the execution is complete.
Good Luck!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, September 05, 2002 5:58 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I have couple of questions, 817 on NT
Janet,
The last place where I worked, we had to split a big package into smaller
ones since we hit a # of lines limit (undocumented!).
Prakash
-Original Message-
Sent: Thursday, September 05, 2002 5:58 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I have couple of questions
-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: couple of questions ???
Date: Fri, 06 Sep 2002 11:58:29 -0800
Janet,
The last place where I worked, we had to split a big package into smaller
ones since we hit a # of lines limit (undocumented
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:couple of questions ???
Hi all,
I have couple of questions, 817 on NT.
1. There is an invalid SP, my collegue did a Show
Errors in SQL Plus, it shows the error; but I did
Check for Remote DB Link and connection to that DB if any.
Check for the LOCKS.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 05, 2002 02:58 PM
Hi all,
I have couple of questions, 817 on NT.
1. There is an invalid SP
of list ORACLE-L [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: Loughmiller, Greg [EMAIL PROTECTED]
From: Loughmiller, Greg [EMAIL PROTECTED]
Subject: RE: a couple of questions
X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman
Mime-Version: 1.0
Content
I haven't been following this thread, but I saw the phrase database
independent and couldn't help chiming in...
For the past couple years, whenever someone mentioned database
independence as justification for certain decisions, I suggest that they
stick with MySQL and save themselves the
database indepdent...
oh dear...You're doomed :-)
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
and here they want to be database independent
sigh. it's for a content management system
--- Toepke, Kevin M [EMAIL PROTECTED]
wrote:
I agree, it looks messy and confusing... However,
As an additional side note to the 64 bit phase of this thread...
Solaris 9 is 64 bit by default. So the statement made by an individual (a
field engineer) if anyone has plans on moving to a Solaris 9 environment,
one will need to use the 64 bit Oracle version. I'm not totally convinced
of that
no, I do have SOME input -- we'll be hiring a consultant DBA on this,
at least to get it up and running. I have some control over who we
hire. I'm going to make sure I get someone who is willing and able to
say NO.
And I refuse to mention the ANY datatype :)
Rachel
--- Connor McDonald [EMAIL
Rachel,
I have talked to some very talented SQL Server DBA's that have used sql_variant data
types. They all agreed that this data type is not worth the time. They would get
unexplainable results. It is not so much a database issue but rather it is a coding
and understanding of the data
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/17/2002 12:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: a couple of questions
Rachel,
This variant datatype
Title: RE: a couple of questions
Nope. Been happening for years. Where ignorance is bliss 'tis folly to be wise. Thomas Gray (1716-1771)
Damagement likes to be happy.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message
Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but
first: has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?
second (and this one confuses me a bit)... I've been
Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far,
but not much mileage on either. The one thing that came up is that you must
be careful because you seem to get 32-bit Oracle by default. Someone on this
list suggested running file oracle.
Oracle does have user-defined
Rachel,
First question - Not a Clue. I'm on windoze. ;o)
Second Question - SQL_Variant datatype -I'll find out more about this. I have never
used it.
A data type that stores values of various SQL Server-supported data types, except
text, ntext, image, timestamp, and sql_variant.
Rachel,
1. Don't know
2.
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/
a88876/adfnstyp.htm#434671 may not be the exact thing but you just might be
closer ...
Also, Oracle *automatically* does implicit conversion ... but I think your
developers are asking for
Rachel -
We were running 64-bit Oracle here for a while, but I decided against
it. I knew that we weren't going to need the features that the 64bit
version would buy us. That, coupled with the fact that the 64 bit
versions of the software are usually the *last* to be patched, kept me
on the
Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: a couple of questions
Okay, I'm working on what feels like 30 new projects all at once and
I
WILL be RTFM'ing as soon as I can get more
A variant data type column in the database? What would be the domain of such a
column? Does such a column not beg for data which should be placed in other columns
to be stored in it? Oh what fun when someone stores 1234 or worse 1.2E4 both as a
number and string.
Perhaps I'm to staid in
Dennis,
I'm not sure your referring to the message I posted a couple of weeks ago,
but the labeling on the CD's from Oracle can be deceiving. Each CD pack ships
with both the 32 and 64 bit versions of Oracle, one of which is labeled with the
bit value). Make sure you've got the right one.
Rachel
Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
thinks its what SQL server would call a variant data type.
Follow this link for more info
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to
c.htm
Kevin
The Any types provide
Kevin,
Looks messy to me, and damned confusing to boot.
Dick Goulet
The more you overtake the pluming the easier it is to stop up the drain.
Scotty of Star Trek, Search for Spock.
Reply Separator
Author: Toepke; Kevin M [EMAIL PROTECTED]
Date:
:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: a couple of questions
Rachel
Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
thinks its what SQL server would call a variant data type.
Follow
I agree, it looks messy and confusing... However, I found an example that
makes it a little easier to understand.
http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:3099475696866,%7Banydata%7D
My guess it was implemented for 2 reasons
1)
How do u get 32 bit by default? The 32bit and 64bit Oracle came as
separate CDs. Am I missing something?
Richard
-Original Message-
Sent: Wednesday, July 17, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so
Much better explanation especially with the examples. BUT, do I smell a
potential manure pile here?
Dick Goulet
Reply Separator
Author: Toepke; Kevin M [EMAIL PROTECTED]
Date: 7/17/2002 1:53 PM
I agree, it looks messy and confusing... However, I
Some times I get a thin CD pack which only has 32bit.
I will have to ask Oracle to ship me the 64bit version.
-Original Message-
Sent: Wednesday, July 17, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
Dennis,
I'm not sure your referring to the message I posted a couple of
Rachel,
This variant datatype sounds a lot like the union data structure from
C language, which closely resembled a struct (i.e. record) but all of
the fields overlap the same memory address. In other words, it was a
mechanism for type re-casting. In the grand tradition of robust programming
No problem running 64bit Oracle on 64bit Solaris so far.
But 64 bit has it's own set of bugs from 32 bit. I am
sure you will test it before deployment. :)
Richard Ji
-Original Message-
Sent: Wednesday, July 17, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L
Okay, I'm working
and here they want to be database independent
sigh. it's for a content management system
--- Toepke, Kevin M [EMAIL PROTECTED] wrote:
I agree, it looks messy and confusing... However, I found an example
that
makes it a little easier to understand.
. But using it in SQL queries ain't the prettiest thing.
HTH,
- Kirti
-Original Message-
From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: a couple of questions
I'm going to try very hard to unremember (G) anything about ANY just
so I can tell them they can't get there from here.
Rachel
--- Tim Gorman [EMAIL PROTECTED] wrote:
Rachel,
This variant datatype sounds a lot like the union data structure
from
C language, which closely resembled a struct
Richard - I can't answer how we got 32 bit Oracle on Solaris by default.
Currently my sys admin is handling installs. I think he had only one version
and its' bitness wasn't labeled.
One day someone on this list asked how to tell whether the version
installed was 32 or 64 bit. Several other
/2002 12:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: a couple of questions
Rachel,
This variant datatype sounds a lot like the union data structure from
C language, which closely resembled
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:Re: a couple of questions
Not so with what you're describing. Sounds like a feature which is ripe
for
all kinds of abuse. I can just imagine entire tables populated with
columns
/17/2002 12:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: a couple of questions
Rachel,
This variant datatype sounds a lot like the union data structure
from
C language, which
On Thu, 22 Mar 2001,Donald Bricker scribbled on the wall in glitter crayon:
-Is anyone running Oracle 8.1.6 on Solaris 8? Any problems? Anything to be aware of?
yup, no problems so far. however this is not a large database nor mission
critical. YMMV.;-)
--
Bill Thater
Also for those who have Oracle certification how much database experience
(Oracle in particular) did you have before you obtained certification?
What do you recommend for experience before attempting certification?
OCP and Good Oracle DBA are not one of the same things. There might
be people
True, but it probably looks good on a resume!
-Original Message-
Dandekar
Sent: Thursday, March 22, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
Also for those who have Oracle certification how much database experience
(Oracle in particular) did you have before you obtained
Someone coming into where I work with only their OCP as their claim to fame will
most likely not get an interview whereas someone with a number of years Oracle
experience will. We were pretty badly burned in the recent past by someone who
had their OCP as their sole claim to fame. This
Title: RE: Re[2]: Couple of questions
Gosh I keep mine hush-hush. It is at the very bottom of my resume... Yes I have it but so what? I didn't claim to know a whole lot about backup and recovery until a couple of months ago when I actually had resources and time to PRACTICE.
Yes, Gene, you
I'd even give latitude to someone who might not know everything, but who has a basic
understanding and will logically and carefully research a problem as opposed to
hacking away at it until he/she figures it out.
[EMAIL PROTECTED] 03/22/01 12:13PM
Gosh I keep mine hush-hush. It is at the
I could benefit from being able to "add" a new, homebrew SQL function into the
database.
I assume that it is possible; which might be incorrect.
Can someone point me any documention that explains how I could add my own SQL function
into the db?
I assume that some already has a PL/SQL function
44 matches
Mail list logo
