Re: Cold Fusion and Bind Variables

2004-01-13 Thread Scott Behrens
Jared, Try this link. It still worked for me this morning. http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_oracle_databases.html Scott [EMAIL PROTECTED] 1/12/04 8:49:25 PM Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit

Re: Re: Little competition

2003-12-12 Thread Scott Behrens
Hey Richard, One of my desktop treasures is an autographed copy of Jonathan Lewis' book, Practical Oracle8i. The humorous, self-deprecating caption in the author's own hand: 'Never believe all you read.' Scott [EMAIL PROTECTED] 12/12/03 7:24:24 AM Hi Jonathan,SQL create tablespace

RE: DBV Cannot Load Module LIBDCE.A

2003-03-13 Thread Scott Behrens
Sam, I've never worked in a DCE environment, but here's a couple of things toverify: 1. If libdce.a is not installed in the first place, is your environment using DCE? I think this is an LPP (a separately licensed product) from IBM for AIX. Try the following from a unix prompt: $ lslpp -L

Re: Purely for your amusement

2003-02-27 Thread Scott Behrens
Thanks! I especially liked: TABLE...FULL OF 'WOE' That seems to be how the day is going for several of us. Scott [EMAIL PROTECTED] 2/27/03 1:23:55 PM And you thought your job was bad . . .(Yes, this IS a production job)-- snipped

Re: rootpre.sh

2003-02-11 Thread Scott Behrens
David, I haven't installed Oracle 8.1.7 or 9.2 to AIX 5.1 yet, but thanks to a data storage interrupt kernel panic on a 5.1 box, I do know that 'crash' has been replaced by 'kdb' for examining crash dumps. So, rootpre.sh is going to break on the line 'PKEXT_PATH='echo le | crash |

Re: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

2003-02-06 Thread Scott Behrens
Lisa, I have had TIMED_STATISTICS set to true on 5 different 8.1.7 databases (4 at 8.1.7.4 (64-bit), one at 8.1.7.0 (32-bit)) on 3 different servers for some timewith no perceived problems. These servers are either at AIX maintenance level 9 or 10. I have struggled with swap space

Re: Hotsos Clinic

2003-01-02 Thread Scott Behrens
Keith, I had the great good fortune to be able to attend the Hotsos Clinic in March, 2002 and then, in November, to attend Jonathan Lewis' seminar. Best investments in Oracle I ever made. Scott Behrens [EMAIL PROTECTED] 1/2/03 1:41:45 PM I have an opportunity to attend a Hotsos Clinic

Re: TNS-00510: Internal limit restriction exceeded

2002-10-04 Thread Scott Behrens
Funny you should mention... We had the same problem with an 8170 64bit db on AIX 4.3.3 yesterday at about 14:30. Paging space had become exhausted. In brief, I'm guessing the rash of memory leaks in 8170-8172 (or the temporary fix I did until I can patch to 8174) is the cause. Details