Chances are that what you are going to need is a three step process. Step one is to write the CLOB to a temporary file. Step two is to print that file. Step...
John Flack
johnf@...
Apr 1, 2003 5:48 pm
428
You have to go through 8i first.. Dave Freyer ATIMS Applications ... From: Prescribed@... [mailto:Prescribed@...] Sent: Friday, March 21, 2003 3:44 PM ...
David, It can be done, but it is messy! My requirement was to take the data from a pre-formated text report and load certain data from it into Oracle. The...
Gary Turnbull
turnbulg@...
Apr 1, 2003 5:49 pm
430
Look into Oracle Import/Export compatiblity chart. You need to know if you are migrating up to 9.0.1 or 9.2.0.1 or other such versions, all of them are...
Michael Robison
mrrobison@...
Apr 1, 2003 5:49 pm
431
Here is an OutPutClobToFile procedure and also one that outputs to the screen (OutPutClobToScreen). ... CREATE OR REPLACE PROCEDURE OutPutClobToFile(p_location...
Patricia Perlingeiro
plperlingeiro@...
Apr 1, 2003 5:49 pm
432
Hello, You can do couple of things, depending on situations. Oracle Forms (Developer 6i ) has TEXT IO api's to handle texts to Oracle data base or text from...
David, Are you doing client/server or web forms? In client server (not available after 6i), use the get_file_name() and read_image_file() built-ins, and the...
Mark C. Stock
mcstock@...
Apr 1, 2003 5:49 pm
434
Hi everyone, I have a simple problem which I hope someone can help me on. I am writing an inventory report for distributed documents. One of the column items...
Prescribed@...
Apr 8, 2003 2:04 pm
435
If we take an Oracle seeded .wft file and make customizations through workflow builder (ver 2.0.3.8.3) and save to a flat file we lose the header info. Is...
Don't rely on Oracle to handle your implicit conversions as it has in the past. We recently upgraded our producton database to 8i. Our stored procedures...
Melissa Reed
MReed@...
Apr 8, 2003 2:06 pm
437
Does anyone have any experience with using OID along with Active Directory? Can Active Directory be used without OID and allow network users be authenticated ...
Anderson, Dennis H.
dhanderson@...
Apr 15, 2003 7:48 pm
438
Unfortunately I still am supporting a 7.3.4 database. I recently installed Oracle 9.2 and can no longer connect to this database using SQLPlus or the ...
Terry Copeland
tcopeland@...
Apr 15, 2003 7:49 pm
439
Hi, Maybe someone knows about this error. Im trying to export a 7.2 database. I made sure system has all the requird privileges such as exp_full_Database,...
Prescribed@...
Apr 15, 2003 7:49 pm
440
+ Interjection by listserv moderator: + Lots and lots of replies to this posting, below... ... From: "Mark C. Stock" <mcstock@...> If the column should...
We've had a lot of problems with conflicting versions of Oracle databases and export utilities. The only surefire way to get the job done is to export with...
John Flack
johnf@...
Apr 22, 2003 12:24 pm
442
It sounds like you might be using a new version of export, which is trying to execute a SQL statement with options that are not supported in 7.2. Make sure...
Mark C. Stock
mcstock@...
Apr 22, 2003 12:24 pm
443
If anyone has experience on source control software and how to automatically keep the integrity of the code, please post your solutions or e-mail me direct....
Does anyone out there have experience using SQL*Loader to load data from a flat (text) file to a DB2 database table using the Oracle DB2 Gateway? If so, can...
Fred.M.Ridgway@...
May 16, 2003 2:42 pm
445
A serious security flaw in the Oracle RDBMS affecting versions 7.3.x through 9i Release 2 has been identified. Information has been released under Oracle...
Steve Long
slong@...
May 16, 2003 2:54 pm
446
Hi, I have a question regarding this. I know that the documentation says that you can't jump a major revision when importing. In my case the database is so...
Prescribed@...
May 16, 2003 3:10 pm
447
Hello, the below script is what I am trying to run to create a table populating it with data from another database table on a different server. Does anyone...
Phillip Small
psmall57@...
May 17, 2003 1:26 am
448
This buffer overflow error is very common across all the software products & hackers use that area to play his/her own code. There is a good description @ ...
Agarwala, Rajib
rajib_agarwala@...
May 17, 2003 1:26 am
449
Hello, I'm getting "ORA-0020 MAXIMUM NUMBER OF PROCESSES (200) EXCEEDED" after a few days of a database running. My environment - Windows 2000 running Oracle...
Joe Jankowski
jankowski@...
May 17, 2003 1:26 am
450
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "Joseph F. Cross" <jcross@...> I suggest...
Have you considered ClearCase? It's available for both Windows and Unix, depending on where you want to store your source. It allows multiple projects to be...
Melissa Reed
MReed@...
May 17, 2003 1:26 am
452
Phillip, What you are tryuing to do is possible and I have done it many times. What you need to do is test your dblink to make sure it is working first. I...
Anderson, Dennis H.
dhanderson@...
May 19, 2003 8:57 pm
453
Hi All, I'm writing a procedure to load a table from several other tables. Each table has some millions of records. In my procedure I'm using two queries: One>...
Tarun Sharma
Sharma_Tarun@...
May 20, 2003 1:57 pm
454
+ Interjection by listserv moderator: + Some helpful replies to this posting, below... ... From: "John Flack" <johnf@...> Dennis - You've got that right...
Tarun, Try this. Steve ... CURSOR lilly_worker1_cur(p_load_date DATE) IS SELECT a.pernr global_id ,max(a.aedtm) create_date ,b.user_id user_id ,max(a.begda)...
Steve Long
slong@...
May 21, 2003 7:22 pm
456
Hello, I am assigned to install Oracle 9i release 3 database server on RedHat Linux 7.3. Anyone who has an eperience with this? Where can I find installation...
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.
