All - I was on the OTN site this morning and some information they posted there caught my attention. Apparently Oracle is offering a special deal to shops...
Hi All, We have certain thoughts, dbms_job dbms_pipe ksh-call with &-ackground run Are there any other methods in Oracle to have multi-processing/parallel run...
kbutala@...
Jul 8, 2003 12:27 pm
476
Be careful with nulls! nvl(xxx,'N') = 'N' and xxx <> 'Y' are not equivalent: XXX nvl(xxx,'N') = 'N' xxx <> 'Y' ... 'Y' Y = N --> FALSE...
Mark C. Stock
mcstock@...
Jul 8, 2003 8:29 pm
477
Oracle 8.1.7 post install java.exe exception errors While installing Oracle 8.1.7 on Intel Celeron machine I faced same/similar bug that was hit on the Pentium...
The best way to run procedures parallely is using DBMS_JOB. Ihtesham...
Ihtesham Uddin
ihtesham_u@...
Jul 16, 2003 6:30 pm
479
How can I run areport from a PUSH BUTTON? I used the following code - after adding the report to my form module it gives an error saying that I did not give...
This might or might not help. I seem to recall this happening with one of the systems, I have worked on in the past. I had to reinstall a newer version of...
Michael Robison
mrrobison@...
Jul 16, 2003 6:36 pm
481
Hi, I am working on an application where we have to update a novell directory from oracle database. I want to use ssl to encrypt and decrypt the connection. I...
Jimmy Patel
jpatel@...
Jul 17, 2003 3:18 pm
482
You will have to do it as following: DECLARE repid REPORT_OBJECT; v_rep VARCHAR2(100); BEGIN repid := FIND_REPORT_OBJECT('report4'); ...
Ihtesham Uddin
ihtesham_u@...
Jul 21, 2003 2:46 pm
483
Hi, We are running Oracle 8.0.6 and would like to see if there is a way to export Oracle table data such that it can be imported into a Microsoft JET database....
Eklund, Chris
chris.eklund@...
Jul 28, 2003 3:32 pm
484
I'm not sure if there is a way to have Oracle do it from an internal process, but you can pull the information out directly from Oracle (from inside Access)...
Chris Hylton
cchylton@...
Jul 28, 2003 7:06 pm
485
Another suggestion - Oracle has a "Migration Workbench" product that I have used to go the other way - from Access to Oracle and again from SQL Server to...
Moody, Mark
moodymark@...
Jul 28, 2003 8:29 pm
486
Do you have Microsoft Access? Just create 'external links' to the oracle tables via the MS Access interface. Then create what I believe Access calls 'Create...
Mark C. Stock
mcstock@...
Jul 29, 2003 5:17 pm
487
All, If you need to query hierarchical data (the ORG structure in our application is a good example), you should read this article. If you didn't know...
Folks, My shop is in a Windows NT environment. Back in the day (Oracle 7) there was a way of signing into sqlplus by using an encrypted password. It looked...
bbuker@...
Jul 30, 2003 6:10 pm
489
+ Interjection by listserv moderator: + Matt posted a correction to his techtip earlier this morning + that recognized this as well. + + By the way, I'd like...
John Flack
johnf@...
Jul 30, 2003 6:10 pm
490
All, I'm doing a little research and wanted to open up a discussion on whether or not running java inside the database is a good idea or not. I know there ...
Dan Herrup
dherrup@...
Jul 31, 2003 5:38 pm
491
Hi, I have a machine which has oracle 8.1.6 client. I'm accessing a lot of oracle 8i and 8 databases from it. Now I'm planning to upgrade the client to 9.0.1...
Tarun Sharma
Sharma_Tarun@...
Jul 31, 2003 5:39 pm
492
The change in versions might affect how your applications work, they use different libraries, etc on the client side. I would test out how your apps work...
Michael Robison
mrrobison@...
Aug 4, 2003 1:36 pm
493
I just learned something that was (to me) very unexpected, and I'd like to share it with you. We are in the process of taking over a Portal instance (v....
Hi Folks! I have some problem while installing the Oracle9i Databse server on MAC OS X system. Database has been installed perfectly, the problem I'm getting...
Hariom K. Verma
hariomkverma@...
Aug 6, 2003 9:00 pm
495
You don't necessarily have to upgrade the client. I have several client versions connecting to 9i databases. The the version 7 clients are the only ones I'm...
Brett Ogletree
bretto97@...
Aug 6, 2003 9:00 pm
496
HI, I thought I had my backups in order till Monday morning(Aug,4th). We have an imaging server on a Compaq Prolient server with two drive cages running MS SQL...
Allen Shepard
ashepard@...
Aug 6, 2003 9:00 pm
497
Presizing the files to a "max" value + growth room before they are filled with tables and data is almost always a time saver. Many systems extend a file by a...
Dr. Robert Young
rcyoung@...
Aug 11, 2003 2:54 pm
498
+ Interjection by listserv moderator: + Multiple replies to this posting, below... ... From: "Mark C. Stock" <mcstock@...> As a broad principle, most...
Under the category of "I don't know why it does that, must be a bug": For too long I've put up with SQL*Plus on windows randomly dropping characters on wide...
We're trying to install a working well-tested application that runs on 8.1.7 in a 9.2 database. Everything imports and compiles properly, but some of the...
John Flack
johnf@...
Aug 14, 2003 2:20 pm
501
Mark, This is incredibly useful. Thanks for sharing. Munit...
M A
mafework123@...
Aug 14, 2003 2:20 pm
502
I did a presentation for MAOP on combining html and sql. If anybody wants the presentation email me. I really enjoyed it. Orest Roman Swystun email address -...
When we've gotten this sort of error on our Unix and Linux systems, it has usually meant that one or more of the kernal parameters is not set to Oracle's...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
