Hi,
I got a very strange problem (9.2 on Linux Red Had,
9iAS).
I have a package which works fine, I added a new
procedure in that package, if the procedure's name
starts with order_, (the pkg has some procedure starts
with order) the pkg compiles, and app runs fine. if I
rename it something
How does the app calls this procedure?
-Original Message-
Sent: Thursday, June 12, 2003 5:26 PM
To: Multiple recipients of list ORACLE-L
Hi,
I got a very strange problem (9.2 on Linux Red Had,
9iAS).
I have a package which works fine, I added a new
procedure in that package
Title: "Take Care of your DBAs"
I'm curious if anyone has run into
this error before or can provide somethings I can look into to
resolve.
system:
SAP HR
Oracle 8.1.7.4.1
M$ 4.0 svc pack 6a
On Sunday, I applied some NT patches
to the OS and rebooted the server.
The last one was security
Title: Strange problem with charactersets
Hi list,
I have a strange problem with charctersets, character display.
I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. On clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. Now I've installed a Windows 2000
Title: Strange problem with charactersets
Unfortunately the only solution is to recreate the
database in German character set.
Oracle is very strict in this respect. Database
character set once chosen can not
be changed.
- Original Message -
From:
[EMAIL PROTECTED
Title: Strange problem with charactersets
Execute the following query:
select substr(parameter,1,30),substr(value,1,30) from
sys.v_$nls_parameters order by 1;
This way you will know the database`s nls settings. If
the client has the same settings as the database, there will be no character
://www.inplan.de
-Ursprüngliche Nachricht-Von: Szecsy Tamas
[mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 15. Mai 2002
14:58An: [EMAIL PROTECTED]; Schoen VolkerBetreff: RE:
Strange problem with charactersets
Execute the following query:
select
substr(parameter,1,30
Tufar
[mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 15. Mai 2002
16:03An: Multiple recipients of list ORACLE-LBetreff:
Re: Strange problem with charactersets
Unfortunately the only solution is to recreate
the database in German character set.
Oracle is very strict in this respect
Title: Strange problem with charactersets
From Oracle 8i and up you do not have to recreate
the database, you just have to issue an alter command and reload the data.
Unfortunately this would not help Volker any
further.
Tamas
Szecsy
-Original Message-From: Nicolai Tufar
-
vsid Von: Nicolai Tufar [mailto:[EMAIL PROTECTED]]
vsid Gesendet: Mittwoch, 15. Mai 2002 16:03
vsid An: Multiple recipients of list ORACLE-L
vsid Betreff: Re: Strange problem with charactersets
vsid Unfortunately the only solution is to recreate the database in German
vsid character set.
vsid
I created a procedure to remove up to 2.4 million records out of a 13+ million record
table with bulk binds and forall. Figured that would be the fastest way. While doing
this delete, other processes were accessing the table, but not the rows that were
being deleted. Things went fine.
Check for any trace files reporting some errors in bdump directory.
Dropping indexes on the table might help if there is any reporting
errors/locks in any trace file.
Waleed
-Original Message-
Sent: Monday, February 25, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
I created
Rick,
Your process is waiting (check v$session_wait) or it is consuming CPU. If it is
consuming CPU, it is probably doing some work of the rollback. If you think that the
process is hanging check v$session and report to us the event it is waiting on.
Anjo.
[EMAIL PROTECTED] wrote:
I
Rick
If you are waiting on rollback, this script (written by Steve Adams) will
help you find out how long the rollback will take.
set serveroutput on
set feedback off
prompt
prompt Looking for transactions that are rolling back ...
prompt
declare
cursor tx is
select
s.username,
Greetings fellow DBAs:
I just dealt with a problem I personally haven't run into before
and thought that members of this list might be interested in
reviewing:
User-A owns all of a set of objects on Database
Primary-DB including tables Table-1 through Table-100.
User-B also exists
Hi,
I have noticed this strange error with two different database: 8i and 9i.
We have a cgi that worked well under 8i but not under 9i.
The problem was here :
If MyString = '' Then
Return xxx
End If ;
It never went in. I tried the following :
If 'string' = 'string' Then
-- never
: 1 1 ??? Strange problem
[EMAIL PROTECTED]
om
Hi ,
ONLINE is a reserved word. It should not be used as a column name. I
think it is bug.
rukmini
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2001 3:51 AM
All, I got a problem with v$recover_file. Somehow the
query
Andrea,
From Metalink, the column is defined in uppercase:
SQL select online from v$recover_file;
select online from v$recover_file
*
ERROR at line 1:
ORA-00936: missing expression
SQL select ONLINE from v$recover_file;
no rows selected
Also, online is a reserved word and that is why
All, I got a problem with v$recover_file. Somehow the
query failed if selecting is on ONLINE column.
SQL desc v$recover_file;
Name Null?Type
-
---
FILE# NUMBER
ONLINE
Hi all,
I installed Oracle8.1.6 on a SunOS 5.6 box. That box
already had 815 and 817 installed. When I'm in 816
Oracle_HOME/bin, sqlplus works fine but when I do
svrmgrl which does exist, I got this:
ld.so.1: svrmgrl: fatal: relocation error: file
svrmgrl: symbol kghla42_: referenced symbol
You might need to change LD_LIBRARY_PATH=$ORACLE_HOME/lib
Regards,
Waleed
-Original Message-
Sent: Tuesday, June 19, 2001 5:36 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I installed Oracle8.1.6 on a SunOS 5.6 box. That box
already had 815 and 817 installed. When I'm in
Check your path statements and other environment setting on the Sun box.
If you already had the old software installed, you probably are still using
those for the old path.
When you are in the 8.1.6 ORACLE_HOME/bin directory its finding the binary
file for that version of oracle but its fining
Hi
Just check all of your paths. You might be trying to use files from the
other version libs or some similar issue.
Peter
At 01:35 PM 19/06/2001 -0800, you wrote:
Hi all,
I installed Oracle8.1.6 on a SunOS 5.6 box. That box
already had 815 and 817 installed. When I'm in 816
Hey Kirti!
Congrats on your accomplishment of Tuning book. Must have been a gratifying
experience.
Keep the good work up!
-Rahul Dandekar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul Dandekar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
When using sqlplus to do the select you are most probably using the privileges
that have been assigned to you in a role. Privileges assigned to
a user through a role are not used (or applied) inside PL/SQL blocks (procedures/functions).
You need to have the appropriate privilege explicitly
hi gurus,
I am able to select from every hting from v$session at command line.
but when i write in procedure it fails why.
SQL select osuser from v$session where username = 'IMAGE_INDEX' and rownum
= 1;
OSUSER
--
MLOBO
this is ok...
CREATE OR
Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: Narender Akula [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 7:16 PM
To: Multiple recipients of list ORACLE-L
Subject: strange problem
hi gurus,
I am able to select from
hi gurus,
I am able to select from every hting from v$session at command line.
but when i write in procedure it fails why.
SQL select osuser from v$session where username = 'IMAGE_INDEX' and rownum
= 1;
OSUSER
--
MLOBO
this is ok...
CREATE OR REPLACE PROCEDURE
hi pat...
thanks for info.
I granted explicit previleges to user,
narender
-Original Message-
Sent: Tuesday, May 15, 2001 2:50 PM
To: Multiple recipients of list ORACLE-L
hi gurus,
I am able to select from every hting from v$session at command line.
but when i write in
30 matches
Mail list logo