+ Interjection by listserv moderator: + Oops, I noticed that I never posted these responses from + awhile back - sorry about that!! ... From: "Blizard, Robert"...
Hi Guys and Gals. I've just created a Weakly Typed ref_cursor function in Oracle Reports 6i. I am unable to see how to reference these on the layout. Clicking...
Hi all, I am currently assisting in the migration of our database from SQL Server 2000 to Oracle 9i. My question is: is there any way to migrate the stored...
I have a PL/SQL routine that opens a REF CURSOR defined as a public variable in a package using a SELECT I constructed for dynamic SQL. I loop through the...
John Flack
johnf@...
Jan 23, 2003 8:39 pm
358
During my original 9iAS Infrastructure installation (back in late December), I kept receiving the following pop-up message during the Infrastructure ...
Edward Girard
Edward_Girard@...
Jan 28, 2003 6:41 pm
359
+ Interjection by listserv moderator: + Definitely a clear consensus in the responses to + this posting, below... ... From: "Russell Hertzberg"...
+ Interjection by listserv moderator: + Excellent response by the membership to this posting, below... ... From: Leslie Tierstein <ltierstein@...> John...
Edward, It _is_ possible to change the hostname (and domain) that your 9iAS installation responds to, but it is NOT a trivial undertaking. I have successfully...
Matt Fierst
mjfierst@...
Jan 28, 2003 9:23 pm
362
I have a developer who wants to insert up to 2000 records into an Oracle table at one time. By this I mean that he doesn't want to half to issue individual...
Anderson, Dennis H.
dhanderson@...
Jan 29, 2003 12:28 pm
363
VOUG Membership - As you probably know, VOUG meets in the Fall of every year. Many folks have asked if it would be possible to hold a meeting in the Spring as...
+ Interjection by listserv moderator: + Some helpful replies to this posting below. + Anyone with good experience using VB against Oracle may + want to add...
I agree with Phillip Small, SQL*LOADER is the way to go and do it all at once. Processing would have to be done after the files are loaded into the table. If...
bbuker@...
Feb 3, 2003 7:32 pm
366
Well one way is using Pro C/C++ and declaring a host variable record structure with each element being an array of say 2000. #define MAX_BATCH_SIZE 2000 static...
Bob Barrett
bbarrett@...
Feb 3, 2003 7:32 pm
367
it has been just a little while since i've done VB/Oracle interfaces, but if I recall properly, this is the way it should work for you (hopefully my VB...
Mark C. Stock
mcstock@...
Feb 4, 2003 6:39 pm
368
It is time to upgrade our client's 8.1.5 database running under Windows NT 4.0 Server Service Pack 6. Looks like we have three choices: 8.1.7.4 9.0.2 or 9.2...
John Flack
johnf@...
Feb 7, 2003 12:18 am
369
Does anyone know anything about 3G Technology? Will it work with Oracle 8i or 9i database? We have a customer experimenting with a 3G connection to our Oracle...
Greg Shockey
gshockey@...
Feb 7, 2003 12:19 am
370
have not had in problems on 9.2.0.2.1 on same platform as you, however there is a little bit of a learning curve as default tablespace are now locally managed...
ken kline
ken@...
Feb 7, 2003 3:40 pm
371
I haven't upgraded any of our databases to 9i - yet - so can't comment on that version. We have found 8.1.7.4 to be very stable on our AIX servers. Some...
Blizard, Robert
robert.blizard@...
Feb 7, 2003 3:41 pm
372
John, You may want to go to at least 9.0.2 , you will soon be in the same boat with 8.1.7.4 as you were with 8.1.5 . Look up the support matrix on Oracle's...
Terry Gould
tgould@...
Feb 7, 2003 4:54 pm
373
John, I did experience some problems with updatable views in 9.0.2 -- some views which 8.1.7 considered updatable were not considered updatable in 9.0.2, but ...
Mark C. Stock
mcstock@...
Feb 7, 2003 10:56 pm
374
+ Interjection by listserv moderator: + An excellent response to the post, with a good bit of + helpful info to those running Oracle on NT/2000... You should...
Michael Robison
mrrobison@...
Feb 7, 2003 11:53 pm
375
Thank you all for your responses - it's always great to hear from those who have already been through the mill that you are about to enter. I recommended that...
John Flack
johnf@...
Feb 11, 2003 7:51 pm
376
Hello.. I was wondering if anyone is running Oracle databases on a Hitachi 9500 series SAN box? We are looking to get rid of our Netapps Box which has HORRIBLE...
Noelle Stimely
nstimely@...
Feb 17, 2003 1:43 pm
377
Hi All Is there is any way to get a random number using select statement ? any hint can help . thanks...
ahmad abusaleh
ahmadabusaleh@...
Feb 17, 2003 1:43 pm
378
Noelle, One thing to consider when purchasing a Storage Area Network (SAN) is the personnel that will be managing the Storage. If you have people in-house...
G Dixon
gdixon@...
Feb 18, 2003 1:34 pm
379
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: Vaibhav Dani <vdani@...> Hi ! This function should...
Hi, I am also intersted in random number selection. I cannot find the DBMS_RANDOM package on my Oracle 8.1.7, however. How can I install this package? Thanks...
Yrd. Doc. Dr. Kemal T...
kturhan@...
Feb 19, 2003 3:03 pm
381
Hi, I am having a problem where web.show document will not bring up a browser when I make a call from a web enabled 6i form. When I click the button, nothing...
Hunter Stair
hunter.stair@...
Feb 19, 2003 4:48 pm
382
Does anyone know how to install gnumake for use with Oracle 11i? The readme and install files are generic and rather confusing. I am attempting to install the...
Simon Gorton
simongorton@...
Feb 19, 2003 6:55 pm
383
Hi Everybody, I have a situation where I need to process 10 M to 20 M rows in a Data Warehouse environment in a process cycle. There are two steps such as...