Re: Trivia question - not of any practical use.

I don't get that when running on W2K. Are you executing a login.sql or glogin.sql script first? How are you invoking your temp.sql? Using the @ on the command line or redirecting input or typing it in directly? What version of sqlplus? I tried it with 8.1.6. Marc Perkowitz - Original

Re: No Nulls? (was: Warehouse design: snowflake vs star schem

nd screens to suppress displaying these dummy values. Or you'll have to explain to the HR manager why all of the employees appear to be terminated! A null value meansthere ismissing data. It is not clear that 01/01/4000represents missing data or incorrectly entered data. Leave me my nulls! Marc

Re: No Nulls? (was: Warehouse design: snowflake vs star schem

ckage-level variable that can be used globally. That way you can avoid usinghard-coded values. You could also use this approach with languagesthat are usingembedded SQL or ODBC/JDBC. Alternatively, you could use a construct within the language like Java's final static constants. Marc Perkowitz --

Re: deploy forms on web

then in the correct directory and it will work automatically. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 30, 2002 12:08 AM So i dont have to do anything with my original .fmb compiled in .fmx for icon, but how does forms server

Re: deploy forms on web

Also be sure you have gif files set up. You can't display icon files in the browser so you must convert any icons to gif files and store them in the appropriate directory. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July

Re: SQLLDR73 from a Win 2000 Machine

, you might try changing the properties on the SQLLDR73 executable by right-clicking and then setting compatibility to NT. I've had to do this on an installation program for another product, but haven't run into that requirement on any Oracle product yet. Marc Perkowitz Senior Consultant TWJ

Re: data cleansing question

, will be different with zeroes versus nulls. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 5:43 PM For those of you who have had

Re: No DBAs needed on AS400

. The AS400 was designed to be pretty much a hands-off system. Just plug it in and let it run. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 9:33 AM It's been a while since I

Re: Differences between Oracle JDBC thin and thick drivers

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network

Re: Question about Forms Version

Perhaps you're referring to Developer/2000? If so, that name was first usedwith Forms 4.5. I believe it was also used for Forms 5.0, but dropped after that. Marc PerkowitzSenior ConsultantTWJ Consulting, LLP - Original Message - From: JoJo Zawawi To: Multiple

Re: Forms6i (6.0.8 ?) on Motif Mode

think there is a licensing issue too. You may need to license iAS to get 6i Motif on Unix. If you still want or need to proceed, let me know and I'll see if I can dig up my notes from that project and send them to you. Regards, Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866

Re: White space compression in Oracle

Title: White space compression in Oracle Bjørn, Aren't those semantics all host language based? I haven't been working on Pro-X languages for a while, but I seem to recall that there were language options (switches, directives)on how the comparisons were done. Also, you could easily move the

Re: Date format element rule change

Doesn't work in 8i. (8.1.6 to be specific). SQL ALTER SESSION SET NLS_DATE_FORMAT = 'Mon (MM) DD, '; ERROR: ORA-01816: month may only be specified once Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I am posting this for a co-worker. Anyone seen this before? Seems like there should be an easy answer to this. It's Oracle 8.1.7 on Redhat Linux. Thanks, Marc Perkowitz I am receiving the following Oracle error from a PL/SQL procedure when it attempts to execute a line of code like

SOLVED: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Tom, At first, he said, no, he had checked that, but (as we know often happens), he rechecked and saw that a higher level calling procedure was set at the smaller size. So your suggestion did lead to the solution. Thanks! Marc Perkowitz - Original Message - To: [EMAIL PROTECTED] Cc

Re: Forms and Reports Server 6i minus iAS

your supportability. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 19, 2001 12:05 PM Is it possible to install Forms and Reports Server

Re: Java in the database

, but that's the way it really works. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 26, 2001 9:50 AM :-) Wait 2 weeks and I will tell you how is it running up to 500 people. Oracle and BEA who have a nice little Java

Re: Duhvelopers and DB-ehs?

fun!!? (Though I'm happy to say I was never on another project that intense again!) Marc Perkowitz. - Original Message - From: Don Granaman To: Multiple recipients of list ORACLE-L Sent: Friday, August 31, 2001 8:26 PM Subject: Re: Duhvelopers and DB-ehs

Re: Migrating IMS to Oracle

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: ops-shd

If you are not running it already, be aware that Forms 5 is quite buggy. It would be much better to stay on 4.5 or go to 6 or 6i. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L

Re: GMT

As I usually do on timezone issues, I'm putting in my .02. Keep in mind that you will need to switch between EDT and EST yourself. There's nothing for this yet, though I heard rumors of something in 9i. Anyone heard of anything new with timezones and 9i? Marc Perkowitz Senior Consultant TWJ

Re: OT Bears

Keep in mind that many many animals only still exist at all because of zoos. And unfortunately that will continue to be more and more true in the future. I much prefer my animals wild as well, but I'd rather see them then not see them at all. Marc Perkowitz. - Original Message

Re: Enforced Costraints (sic) ??

authorities (such as state driver license bureaux) and commercial organizations. I applaud the intent of the SSA, by seriously doubt that this can be accomplished. Its use is very much embedded in US society today. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L

Re: Order by for varchar ???

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network

Re: what to put in place of null

I believe the empty string is not guaranteed to be the same as a null in the future -- perhaps new ANSI standards? It's much safer to cast the null using to_char, to_date, etc. as suggested earlier. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com

Re: Need a Help

I worked with 7.3.2 on a Compaq (Dec) Alpha environment a few years ago and we were using Forms 4.5 (32 bit Dev 1.2) and eventually we upgraded to Forms 5. Both worked, but Forms 5 was a buggy release and if you have to stay with 7.3.2, I'd recommend staying away from Forms 5. Marc Perkowitz

Re: Your views on Quest - Shareplex

that was planned to be part of 9i. I haven't read enough on 9i to see if it made it in there or not. Perhaps someone else knows about this. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L

Re: forms 4.5 error against oracle 8i db...

a way to run an 8i database in Oracle 7 compatibility mode where the rowids are formatted the old way, but I'm not familiar with that. Patching 4.5 or upgrading to 6i is the better approach. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original

Re: 8.1.7. and OAS / iAS versions confusion

9i iAS == 8i OAS. Oracle renamed 8i 1.0 to 9i 1.0. Version numbers are consistent. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001

Re: function to get GMT time

r the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: function to get GMT time

difference was less than usual, but now the difference is consistent. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 20

Re: function to get GMT time

nd some countries do not have DST) and by year. The NEW_TIME is just a simplistic function that subtracts or adds hours. Also, there's a very limited number of timezones supported (mainly US plus GMT). Marc Perkowitz - Original Message - To: "Multiple recipients of list ORACLE-

Re: meeting of list participants working in DC area

startling his other guests. Of course, he was a bit of a cut-up and could have been just joking with us. Marc Perkowitz - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, March 30, 2001 3:50 PM Alex, this is the 21st century (I think)