VOUG Membership - The transition of VOUG's listserv to Yahoo Groups that I mentioned in my message last week is now complete. I'm very excited about having us...
+ Interjection by listserv moderator: + Please respond directly to Betsy at elraines@... + if you are interested in helping with this (please...
Elizabeth Raines
elraines@...
Feb 19, 2002 11:02 pm
8
When stopping IFS using IFSSTOP.bat, it would seem that we also have to restart the oraias services (including the HTTP server). This is not good since the...
Clinton Rudd
therudd@...
Feb 19, 2002 11:02 pm
9
We are trying to upgrade from SUNLink SNA 9.1 to a current SNA stack that is supported by Oracle for the DRDA Gateway. Does anyone know of SNA software that...
Michael Riley
mriley@...
Feb 19, 2002 11:20 pm
10
This won't give you real time viewing of your code unfortunately. Output from this command only occurs after the procedure is finished. Also, if you exceed...
Himes, Pam M
PAM.M.HIMES@...
Feb 19, 2002 11:44 pm
11
In 8i you could you autonomous transactions to write to a debug table -- this would be more 'real-time', but i do remember some strange side-affects when...
Mark C. Stock
mcstock@...
Feb 20, 2002 12:50 am
12
When in doubt, take the easy way out. Create a JOB_STATUS table that could have 3 columns: JOBNAME, STATUS, STATUS_TIME. At intervals within your job, you...
Peat, David
David.Peat@...
Feb 20, 2002 1:32 pm
13
If you're using Oracle9i, you can use autonomous transaction to make writing to the job_status table easy. Otherwise, a commit to the job_status table affects...
David Medinets
medined@...
Feb 20, 2002 2:42 pm
14
What about the good old-fashioned DBMS_APPLICATION_INFO package? You can use the package to log certain actions within your code. Then you can query...
Ralph Jones
RJones@...
Feb 21, 2002 10:59 am
15
This may be elementary but I need help with the DELETE command. If I want to select rows from one table based on matching columns in another table I could use...
Fred.M.Ridgway@...
Feb 21, 2002 4:49 pm
16
Is there a way to search an Oracle database, or at least a table for ASCII characters? We seem to have some rogue data in some of our tables that is creating...
Kristen Reale
kreale@...
Feb 22, 2002 4:11 pm
17
+ Interjection by listserv moderator: + Lots of helpful replies to this posting, below... ... From: "Richard Quintin" <quintinr@...> Delete from TableA...
Virginia Oracle User'...
vouglist@...
Feb 22, 2002 4:13 pm
18
IF x is a number for an ascii character and the_string is your string or column then use something like WHERE instr(the_string,chr(x))) > 0 the following...
KennethDavid Kline, III
ken@...
Feb 22, 2002 7:56 pm
19
There is an ASCII function which is like CHR(10) as an example. Suppose you could search fields with the "LIKE" using the CHR function....
Himes, Pam M
PAM.M.HIMES@...
Feb 22, 2002 7:56 pm
20
very good suggestion. V$SESSION will indicate what is currently running, but V$SQLAREA would only indicate what was running when statements are parsed, which...
Mark C. Stock
mcstock@...
Feb 25, 2002 5:10 am
21
I've created the following function: CREATE OR REPLACE FUNCTION squeeze_partnumber( inp_part_number IN VARCHAR2 ) RETURN VARCHAR2 DETERMINISTIC AUTHID...
David Medinets
medined@...
Mar 6, 2002 1:36 pm
22
Hi all, ... Plan Table ... Plan Table ... Sql: select /*+ ordered */ ... From pvcatalog pvcat, stfdescm Cf, pvtechvw V, stockm s Where ( ...
Sri Harsha
harshaskm@...
Mar 6, 2002 1:36 pm
23
For whatever reason, the AUTHID CURRENT_USER clause in the function definition caused the error when the index was created. I'm hoping this is a bug because I...
David Medinets
medined@...
Mar 6, 2002 2:48 pm
24
I am running Oracle 8i on Windows NT. I wanted to check for corrupt blocks in a data file, so I ran DBVERIFY. The following message was returned: "Specified...
Barbara Samlok
b.samlok@...
Mar 6, 2002 2:51 pm
25
1. Have the all the tables in the query been analyzed to either compute or estimate statistics? If not, the Cost Based Optimizer won't have accurate...
mjfierst@...
Mar 6, 2002 2:51 pm
26
My guess is that AUTHID CURRENT_USER makes the function dependent on state information (who is the current user) and therefore cannot be deterministic and...
Henry R. Miller
hmiller@...
Mar 6, 2002 5:48 pm
27
Hi David, Repect the order on those parameter: 1. AUTHID CURRENT_USER 2. DETERMINISTIC 3. PARALLEL_ENABLE So try this: CREATE OR REPLACE FUNCTION...
Regis Biassala
regis.biassala@...
Mar 6, 2002 5:48 pm
28
I'm new to this but, when you use functions (TRIM) on the columns aren't the indexs not used....
rspaeth2001@...
Mar 6, 2002 5:50 pm
29
Actually, I just ran some simple tests, and it doesn't appear that using the TRIM function is enough to prevent using an index. But in general, you are right:...
mjfierst@...
Mar 6, 2002 9:59 pm
30
According to the Oracle Utilities Manual under DBVERIFY parameters: BLOCKSIZE BLOCKSIZE is required only if the file to be verified has a non-2kb block size....
Mark C. Stock
mcstock@...
Mar 6, 2002 9:59 pm
31
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "Kalpesh Jani" <janik29@...> Hi Barbara, Run this...
Hi David, Repect the order on those parameter: 1. AUTHID CURRENT_USER 2. DETERMINISTIC 3. PARALLEL_ENABLE So try this: CREATE OR REPLACE FUNCTION...
Regis Biassala
regis.biassala@...
Mar 7, 2002 6:02 am
33
I haven't studied your query extensively, but the first thing that strikes me is that it has a lot of ORs and function calls, both of which can disable ...
John Flack
johnf@...
Mar 7, 2002 7:44 am
34
+ Interjection by listserv moderator: + Several helpful replies to this posting come + to similar conclusions, below... ... From: "O'Neill, Sean"...
Virginia Oracle User'...
VOUGlist@yahoogroups....
Mar 7, 2002 7:47 am
35
I think I can see a valid reason for the CREATE FUNCTION to succeed, but for the CREATE INDEX to fail -- it would have to do with different scopes of the ...
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.
