Enter your vote today! A new poll has been created for the VOUGlist group: If VOUG holds a two-day conference in Richmond this Fall, please select the ...
VOUGlist@yahoogroups....
Jun 5, 2003 12:57 pm
461
Enter your vote today! A new poll has been created for the VOUGlist group: Given that a two-day VOUG conference generally costs around $225 (plus travel and...
VOUGlist@yahoogroups....
Jun 5, 2003 12:58 pm
462
VOUG Membership - You've just received a couple messages regarding polls that have been created about our annual Fall conference. We've had a conference now...
i would like to ask if i can define a variable in the registry and use it in my forms. For example if i want to define registry variable caled my_path and save...
Yes, you can reference registry keys from forms. Use the built-in TOOL_ENV.GETVAR procedure. This lets you reference values of Oracle keys in the registry....
I am assuming that you need to access the registry variable from your Oracle Forms code, If so then you can Microsoft Windows Standard APIs to access registry ...
Ihtesham Uddin
ihtesham_u@...
Jun 16, 2003 2:35 pm
466
Hi All, I'm upgrading oracle client from 8.0.x to 9.0.1 is there any issue or any impact of this activity. Thanks and Regards Tarun...
Tarun Sharma
Sharma_Tarun@...
Jun 16, 2003 2:39 pm
467
VOUG Membership - As a follow-up to the poll we conducted over the last few weeks, below are the results as tabulated by Yahoo. These don't include the many...
After upgrading I cannot connect to a 7.3.4(hopefully going away next year) database with OEM or SQLPlus. Terry W. Copeland Database/Application Specialist ...
Terry Copeland
tcopeland@...
Jun 16, 2003 8:38 pm
469
Tarun, Hi. Other than Oracle moving the buttons around, making things a little more confusing and setting up the connection test for scott/tiger - an account...
Allen Shepard
ashepard@...
Jun 16, 2003 8:39 pm
470
oracle 7 is sql*net version 2, from 8 on up it is called net8... play with the trailing "." in your domain spec in your sql*net.ora or net8.ora.... ... From:...
ken kline
ken@...
Jun 17, 2003 2:07 am
471
I need help with the following query that I am trying to tweak the output on: select ety_entity, ety_name, prj_description, prj_off_office, prj_project_num, ...
Phillip Small
psmall57@...
Jun 24, 2003 6:17 pm
472
Phillip, I can't spend time at this point analyzing your query and table structure to determine exactly what you need, but just taking a brief look at the...
Mark C. Stock
mcstock@...
Jun 25, 2003 8:23 pm
473
At first glance I would try using a select distinct and get rid of the NVL function for performance. Instead of "and NVL(etyu_data,'N') = 'N'" use "and...
Frederick, Paul
paul.frederick@...
Jun 25, 2003 8:23 pm
474
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...