Dave,
during a 'db file sequential read', an index is _not_ accessed sequentially.
An index is not a sequential structure, so reading from an index in order
will cause multiple seeks on the index itself. And we're talking single user
here
regards,
Hans
Reply-To: [EMAIL PROTECTED]
To:
Hi List ,
Can you help me please ,
What are the database parameters that i have to increase or modify in
order to increase the speed of my ddl
statments ,i have a statment that delete a table with 4 record but it
takes about nine hours to accomplish !!!
Is their any parameters on
use bind variable
-Original Message-
Sent: 09 October 2003 16:29
To: Multiple recipients of list ORACLE-L
Hi List ,
Can you help me please ,
What are the database parameters that i have to increase or modify in
order to increase the speed of my ddl
statments ,i have a statment
Steve,
If you are patient, I guess that something like
where dump(problem_column) like '%target hex%'
should more or less answer your question.
HTH
SF
- --- Original Message --- -
From: Steve Main [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL
Hans,
Your statement is true except in the case of a fast full-index scan.
But that's not my point. What I'm trying to say is:
1. In scenarios where response time is important, for example when you
want to obtain the first n rows of a query result as quickly as
possible, then access time
Isn't this true when the query is a parallel query, i.e. when you're
doing a parallel index range scan using a partitioned index? In such
case, reading the index is the producer operation, and using the rowid
to retrieve the row from the table is the consumer operation, and the
data flow
Yes, exactly Stephane -
Non-printable characters like this are a proper pest in our environment, to
the extent that I have exception reports running every night looking for
them (cannot trust the users...).
I have a small PL/SQL piece of code used to detect these things, if anyone
wants it.
Peter, i would be interested in that.
can u mail it to me ?
Jp.
09-10-2003 18:29:33, Robson, Peter [EMAIL PROTECTED] wrote:
I have a small PL/SQL piece of code used to detect these things, if anyone
wants it.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem
Peter, i would be interested in that.
can you mail it to me ?
Dias Costa
Robson, Peter wrote:
Yes, exactly Stephane -
Non-printable characters like this are a proper pest in our environment, to
the extent that I have exception reports running every night looking for
them (cannot trust the
Hi,
What is volume of ur table, and 4 records that u want to delete is what
% of total records.
One thing that u can try is introduce index hint in delete statement. The
optimal solution can be find out only if know exact statement and volume of
tables and indexes.
Also can u check the size
At the risk of being dragged off and strung up (and keeping it brief as I am
very busy), I really thought it was quite good. Maybe it is the change is
as good as a rest syndrome.
Quite intuitive and fairly easy to get dramatic performance gains by
parameter tweaking and runstats (equiv. of
Connor, you're the best!
On 2003.10.08 21:09, Connor McDonald wrote:
Cary, you're intention is good, but you need to take
the more effective (Dirty Harry) approach:
Customer: It's Slow
Me: What is?
Customer: The application. Make it fast.
Me: Maybe I can make it fast, maybe I can't. You've
got
Hi ,
In Oracle Apps why concurrent manager and report
server
should be indatabase tier when other
application servers
are in application tier.?
Thx
- Original Message -
the striped array. However, this does not improve access time. If you
have your tables and indexes on the same striped array, necessarily the
two I/O's have to be done sequentially, incurring two times access time
at a minimum. However, if you separate the
Hi
Can You please give an example on using bund varables ..
THANKS
I don't use snapshots, but have used EMC BCV's in the past and now use
IBM's Flashcopy for backups. I backup 1TB db in ~20 mins using
Flashcopy. Then I take it off to tape, i.e. filesystems monted on a TSM
Backup server, hence no resources needed from the production server :).
hth,
Gene
Walid
TRUNCATE
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 09, 2003 3:29 AM
To: Multiple recipients of list ORACLE-L
Hi List ,
Can you help me please ,
What are the database parameters that i have to
do they mean the ora -03113 end of file communication error(number may be off)? Alot
of stuff causes that error.
that is a very vague response on their part.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/10/08 Wed PM 11:34:24 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
FYI...
Oracle extended the desupport date for 8i by a year, end of error correction
support is now 31-dec-2004.
They posted that end of ECS for 9i Rel 2 will be 31-dec-2005, I am doubtful
about that, only 1 year lag time between two terminal releases?
Patrice.
--
Please see the official
Bob,
I do the following:
First, alter all tables turning monitoring on: alter table {table name}
monitoring;
Monitoring says:
Specify MONITORING if you want Oracle to collect modification statistics on
table. These statistics are estimates of the number of rows affected by DML
statements over
Title: RE: RE: Cary's Book - new topic
This comment coming from Mladen means something ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any
Oracle documentation discusses multiplexing control files, data files, redo log files
across multiple volumes in a RAID array. How do you handle this if your using shared
storage? Where you just have one or a few logical volumes.
has anyone developed a backup plan for this?
--
Please see
Not sure why you would necessarily want the reports server on the
database tier... Concurrent managers wake up periodically (like 60 or 90
seconds), query their tables to see if there are any jobs to run... run them if
there are and then go back to sleep. If they are all on the same tier,
But what !?
Wedding bells?
Mike
-Original Message-
Sent: 09 October 2003 12:59
To: Multiple recipients of list ORACLE-L
This comment coming from Mladen means something ...
Raj
Rajendra dot
does monitoring have any real overhead in a high transaction system?
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/10/09 Thu AM 08:59:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: how to keep statistics up to date for CBO
Bob,
I do the
Gene,
What happens when you need to perform a
recovery from the Flashcopy backup?
Is Flashcopy done while the database is open
or closed?
If the database is open, then I assume that
you would need to perform an incomplete recovery?
Just curious. I am in the middle
of setting up new
Agreed. By the way, since my original posting, this error has occurred
several more times.
Yes, it is a catch-all error that sounds a lot like an ORA-3113. Since
they using the Oracle thin JDBC driver, which talks directly to the
listener, Net8 isn't involved. If the server is shut down or
Lee?
-Original Message-
Walid Alkaakati
Sent: Thursday, October 09, 2003 4:29 AM
To: Multiple recipients of list ORACLE-L
Hi List ,
Can you help me please ,
What are the database parameters that i have to increase or modify in
order to increase the speed of my ddl
statments ,i have
never mind found it, d
Boivin, Patrice J wrote:
FYI...
Oracle extended the desupport date for 8i by a year, end of error correction
support is now 31-dec-2004.
They posted that end of ECS for 9i Rel 2 will be 31-dec-2005, I am doubtful
about that, only 1 year lag time between two
Patrice, where did you find that, i'm not having much luck under
desupport notices.
joe
Boivin, Patrice J wrote:
FYI...
Oracle extended the desupport date for 8i by a year, end of error correction
support is now 31-dec-2004.
They posted that end of ECS for 9i Rel 2 will be 31-dec-2005, I am
Title: RE: SAME and separating disk and index tablespaces
Maybe we have been lucky. But we use the SAME methodology. We have removed a considerable amount of human effort in regards to layout of datafiles and disk layout. And based on the stats that I have seen from the Storage team/SA's, we
Thank you very much Tom. That gives me an excellent starting point. I'll
begin to implement this in a devel environment and get a feel for it.
Thanks again!
bob
-Original Message-
Sent: Thursday, October 09, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L
Bob,
I do the
Gaja Krishna Vaidyanatha scribbled on the wall in glitter crayon:
Hi Hans/Vikas,
I tend to agree that the old draconian rule that thou
shalt always separate indexes from tables may not
apply any more. We used to apply that principle in the
past when the number of available spindles was
Yes Im on Windows xp the script names and dir structure should be the
same though...
Here is buildall.sql
buildall.sql
spool \build.log
SET TERMOUT OFF
SET ECHO OFF
connect internal
@@build_db.sql
@C:\oracle\ora81\RDBMS\admin\catalog.sql
Patrice
Oracle's goal is to create a major release every 18 months, and someone
figured out they historically have been pretty much on track. So then
desupport intervals should theoretically be about 18 months apart. My guess
is that 8i is very popular among large clients so its desupport is
No
-Original Message-
Sent: 09 October 2003 14:15
To: Multiple recipients of list ORACLE-L
Lee?
-Original Message-
Walid Alkaakati
Sent: Thursday, October 09, 2003 4:29 AM
To: Multiple recipients of list ORACLE-L
Hi List ,
Can you help me please ,
What are the
Title: RE: SAME and separating disk and index tablespaces
All,
Is
there a way to clear a TEMP tablespace defined as Temporary? We had a
couple of long-running jobs that have totally clogged up the TEMP
tablespace (54 Gig worth) and it doesn't seem to be releasing the space. I
know a db
You can try with the _db_perf_silver_bullet=42, which is the
straightforward approach, or you can be a backward hick like me
and trace your session with 10046, see what events are you waiting for
and adjust your application, OS and instance parameters to really solve
the problem.
On Thu,
You should try with RHN or Red Carpet. They work just fine.
On Wed, 2003-10-08 at 18:19, [EMAIL PROTECTED] wrote:
Microsoft issued this critical update on the 3rd, which I found out about,
when I did a Windows Update from my IE.
Thanks April,
Joe,
Look at Doc IDs 250629.1 148054.1 - the extension is for some platforms only
Regards
-Original Message-
Sent: 09 October 2003 14:29
To: Multiple recipients of list ORACLE-L
Patrice, where did you find that, i'm not having much luck under
desupport notices.
joe
Boivin,
My Headlines screen, KnowledgeBase section, top two items (I got two copies
because I have two CSIs ? not sure).
Or, note 148054.1
Patrice
-Original Message-
Sent: Thursday, October 09, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Patrice, where did you find that, i'm not
Lee - Interesting you were using IBM Flashcopy and you had problems.
I am using FlashCopy v2 and have not seen any problems. Can you enlighten
me what I should look out for?
Thanks,
Gene [EMAIL PROTECTED] 10/09/03 06:44AM
At the risk of being dragged off and strung up (and keeping it
Tom - I can do either a cold or hot backup. It is all scripted.
I prefer cold backups. IBM did try to sell us TDP for Oracle, get this, to
open the db on the backup server to back it up using RMAN. The files on
the backup server are just that files, no need for Oracle utilities to back them
Title: RE: SAME and separating disk and index tablespaces
Good stuff. Plus, watch this:
If saving dozens of hours of labor cost
actually does cost a full 5% performance penalty on access time, and if reads
from disk account for 10% of total response time for a given user action, then
Hey Tom,
I'm in the same boat.
Have you looked over some of the red papers
at www.storage.ibm.com/ess???
If not, check this one out...
Storage Management for SAP and Oracle8i on
SUN SOLARIS Split Mirror Backup/Recovery with IBM's ESS.
Granted its for Solaris, but I would think
the
Title: Avoiding full table scan
Hi All,
I wish to avoid a full tablescan on the following data
V. Zanen
Zanen
Van Zanen
...
...
...
Lot's more data
Select * from table where upper(name) like '%ZANEN%'
I could create a function based index on upper(name) but this does not take care
Title: RE: how to keep statistics up to date for CBO
Tom,
why would you want to collect table/index stats separately? Any reason? I prefer cascade=true with mine.
Raj
Rajendra dot Jamadagni at nospamespn dot
Title: RE: how to keep statistics up to date for CBO
Raj,
Of
course you are correct. I didn't see the "cascade" option until just
recently. And I'm a bit lazy. And it's currently working just
fine.
Need
any other lazy-a**ed excuses? :)
Tom Mercadante Oracle Certified Professional
Hi
A.F.A.I.K the space is free for use by new queries. Oracle just does not
release the extents to save resources on extent management.
Just that your monitoring scripts keep yelling 100% used :-)
Jack
-Original Message-
Sent: Thursday, October 09, 2003 4:14 PM
To: Multiple
Title: RE: how to keep statistics up to date for CBO
Likewise all my options are shaken .. not stirred
.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly
If it is a TABLESPACE TEMPORARY, query on v$SORT_SEGMENT to
get the current size of the sort segment.
Then issue an ALTER TABLESPACE tablespacename DEFAULT
STORAGE (PCTINCREASE 0).
Re-query V$SORT_SEGMENT and the segment would have been released.
If there were current users in the
segment, you
I was tempted to point to the /*+ _try_harder */ hint (revealed by Jonathan
Lewis at this year's IOUG), but that won't be available until Oracle 10.
Until then we have to use the old methods of identifying where the time is
spent and figure out what can be done to eliminate as much of it as
Which oracle version is your buildall.sql for? I just queried my 9i db and
got this:
SQL select TABLESPACE_NAME from dba_tablespaces;
TABLESPACE_NAME
--
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB
Where is Undo tablespace part in your
I don't think it's accurate to say that NET8 isn't involved when
you're talking directly to the listener =8-) More correctly
you are eliminating the NET8 client DLL's...but you could still
have the connections dropping due to transient network failures.
I have a particular problem with CISCO
One reason to collect index stats separately would be if you use estimate
for the collection of the table statistics. In that case I collect the
index stats separately with a compute. Index statistics collection is fast
enough to always go for exact statistics rather than sampling.
At 08:44 AM
Title: RE: how to keep statistics up to date for CBO
So Wolfgang,
in that case, should _wait_ till table stats (which are probably estimate) are complete to perform index stats (which you recommend compute) or can that happen in parallel.
Raj
Tom,
What type of temporary? Dictionery managed or LMT.
If dictionary managed then 2 solutions.
a)make it offline and online again during offpeak period.
2)Make it permanent tablespace to avoid this situation.
If LMT based (temp_datafiles) then check v$sort_usage instead of header
table.
If
Walid,
It's unlikely that a database parameter will provide the solution to
your problem.
Trace the DELETE if you can (DBMS_SUPPORT.START_TRACE_IN_SESSION), to
see what's taking so long. Odds are that your DELETE is poorly optimized
SQL that's simply doing more work than it needs to be doing.
We are trying to load 23Gb's of raster images into our 9.2.0.2/Rac
Database, using ESRI's SDE GIS package,
and as usual there is a big rush to load the data.
If we try to load 14 images at one time, we run out of undo space
(datafile is currently 2 Gb). I could simply add another
datafile and
Does the table you are deleting has any child table(s)? If yes, then are the
foreign keys in the child table(s) indexed?
Guang
-Original Message-
Wolfgang Breitling
Sent: Thursday, October 09, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
I was tempted to point to the /*+
It's because of the SGA_MAX_SIZE parameter, which is, of course, rounded
so that the SGA can be aligned to the page boundary.
On Wed, 2003-10-08 at 19:59, [EMAIL PROTECTED] wrote:
Mladen ,is all this
documented anywhere or is it all very common knowledge ? I can't believe
that all you expert
Undo cannot be turned off because without commit/rollback capability,
RDBMS can no longer manage resources and cannot observe ACID properties.
What you can do is to load files as BFILE type, which, essentially,
means that you are copying them to file system and just recording the
pathname into
Hi, list. Ya, I'm still alive and kickin'.
We have this small database that's running a weird
vendor application. (We get all the gems.) It's on
Solaris 5.8, Oracle 8.1.7.2
The database suddenly went from kicking out 50 meg
redo logs 2 or 3 times a day to churning them out
every 15 minutes.
I don't see any reason why that couldn't happen concurrently. The table and
its indexes are different physical segments.
At 09:59 AM 10/9/2003, you wrote:
So Wolfgang,
in that case, should _wait_ till table stats (which are probably estimate)
are complete to perform index stats (which you
Title: RE: SAME and separating disk and index tablespaces
Hi:
I had
this situation last month and I finally bounced the db.
"drop tablespace temp INCLUDING
CONTENTS" might work if you want to wait long
enough. I tried this and the db just hang for 30 min before I killed it. My temp
ts
Title: RE: Redos gone crazy--a job for audit?
log miner should give you what you want ... why not? On last friday something happened and in our database which usually averages about 100x100M archive logs, it started throwing 41 files between 2pm-3pm, 248 between 3pm-4pm, 95 between 4pm-5pm.
I think you are right Jack. With a Temporary Temp tablespace, there is
nothing I can do to lower the HWM. And I don;t really think it's full -
just the HWM shows it filled up.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, October 09, 2003 11:19 AM
To:
Paul,
Not true. It has no effect on privileges. If
you can't access the table normally using alter session won't change
that.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Paul Drake
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 2003
Here is a query that will help you find the biggest consumer of
redo blocks:
select sid, value
from
(select s.sid,s.value
from v$sesstat s, v$statname n
where s.statistic#=n.statistic# and
n.name='redo blocks written'
order by value);
However, 50MB redo
That only affects how Oracle finds objects. If for instance you would have to access
dba_users normally as sys.dba_users then using the alter session command means you can
drop the 'sys.' portion thereof. It has no affect on your priviledges. Down side is
that if you then want to reference
It should have been redo entries, not redo blocks written.
The only guy writing redo blocks is LGWR, so the previous query would
always give a hume amount for SID=4 and 0 for everybody else.
On Thu, 2003-10-09 at 13:09, Barbara Baker wrote:
Hi, list. Ya, I'm still alive and kickin'.
We have
Just a quick thought, are any tablespaces left in Hot Backup Mode?
Rich
-Original Message-
Barbara Baker
Sent: Thursday, October 09, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
Hi, list. Ya, I'm still alive and kickin'.
We have this small database that's running a weird
None that I've noticed the database in question is processing something like 1B
transactions per day.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, October 09, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
does monitoring have any
Title: Avoiding full table scan
Jack,
In a recent copy of SELECT magazine there is a discussion
in defense of full table scans. I believe you might find it VERY
interesting. Although I was aware of some of what the author spoke he put
it in a vein that makes extreme sense.
Dick
Thanks for the response, unfortunately the application requires the
data
to be stored in the database, loading the files as BFILE type and then
using
DBMS_LOB.READ is not possible.
Darren
-Original Message-
Sent: Thursday, October 09, 2003 10:10 AM
To: Multiple recipients of list
List,
How can I user comma ' in my update statement?
update tablea set fielda =' james'ste Camp 'first,'sec' '
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
David and list,
Some points to keep in mind in our discussion:
* Throughput can be measured both by IOPS and MB./sec,
it depends on the application, whether it is purely
transactional or is just hauling loads of data.
Access time normally is a function of the number of
I/O operations the disk
I have a problem with the new procedure based roles,
Secure Application Roles.
The following is taken from an example in ASKTOM.
Basically, I'm trying to setup a role that is
enabled or not by a procedure. The original code from Tom:
[EMAIL PROTECTED] l
1 create or replace procedure
It's in the documentation. Start with the concepts manual, then SQL*Plus
manual and SQL reference. I'm sure that you'll run across the answer
because that's where I have found the answer to the very same question.
On Thu, 2003-10-09 at 13:59, Hamid Alavi wrote:
List,
How can I user comma '
Do you have the database in backup mode?
Waleed
-Original Message-
Sent: Thursday, October 09, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
Hi, list. Ya, I'm still alive and kickin'.
We have this small database that's running a weird
vendor application. (We get all the
Here's URL that shows how.
http://www.akadia.com/services/ssh_connect_tunnels.html
I've tried it, works well.
Jared
Richard Ji [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/08/2003 08:44 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL
Maybe you should try with DBMS_SESSION.SET_ROLE?
On Thu, 2003-10-09 at 11:09, Nuno Souto wrote:
I have a problem with the new procedure based roles,
Secure Application Roles.
The following is taken from an example in ASKTOM.
Basically, I'm trying to setup a role that is
enabled or not by a
Mark,
I didn't fully understand you're earlier post, but now it seems that
the sqlunldr.pl script in the PDBA toolkit may do what you want.
http://www.oreilly.com/catalog/oracleperl/pdbatoolkit/
It will dump blobs to hex in a sqlldr compatible file, along with
the control and parameters script
Do you mean a single quote? like this?:
SQL update tablea set fielda = ' james''ste Camp ''first,''sec'' ';
1 row updated.
SQL select * from tablea;
FIELDA
james'ste Camp 'first,'sec'
1 row
Im on 8.1.7. Is it possible to do something like this? Im getting errors:
create or replace procedure myproc is
TYPE myRecord is RECORD (
field_1 number,
field_2 number);
TYPE storageArray IS TABLE OF myRecord
INDEX BY BINARY_INTEGER;
myStorageArray storageArray;
i
Well, that was an excellent idea.
But sadly, that's not it.
(We actually don't use hot backups, but I checked just
in case someone mucked with it. No dice.)
Thanks.
Barb
--- Khedr, Waleed [EMAIL PROTECTED] wrote:
Do you have the database in backup mode?
Waleed
-Original Message-
Title: Message
I was
told by our Oracle Rep it is the number of users using the front-end
application. If you have 10 specific users using the application, then a
10-user license must be purchased.
-Original Message-From: AK
[mailto:[EMAIL PROTECTED] Sent: Thursday, October
Strange... works fine here (same environment 9.2.0.1 on Win2K server):
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 9 13:43:23 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the
It worked for me 9.2.0.2 Solaris 2.8
But I'm surprised since I always thought that roles are disabled in stored
procs.
Even it worked for me but it's still disabled in the stored proc after the
execute immediate.
Waleed
-Original Message-
Sent: Thursday, October 09, 2003 11:09 AM
To:
Barb,
Every time I have run into this situation, I have used the following
approach and it has always worked. I've never validated it in all cases,
so take it with a grain of salt.
Redo is generated by block changes. Find the session that is generating
the most # of block changes
Just curious ,
If Ibuy named user licence and use some
application to connect using same user (Just like any app server with
connection pooling ) does the cost multiply to no of
user_connecting_to_app_server or no_of_users_actually_connected to
database( mean schemas) ??
-ak
-
Under the senario rely on v$sort_usage view.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 09 Oct 2003 09:24:24 -0800
I think you are right Jack. With a Temporary Temp tablespace, there is
nothing I can do to lower the HWM. And
Sample the top sessions from v$sesstat for statname 'redo size' (statistic#
115 in my database)
Then joining to v$sql should give you the sql that generates that redo.
Waleed
-Original Message-
Sent: Thursday, October 09, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Well,
You can track the sql which is doing DML while redo being generated. Look at
v$sqlarea or v$sql.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 09 Oct 2003 09:09:24 -0800
Hi, list. Ya, I'm still alive and kickin'.
We have this
Nope. Tried with that one as well,
same result.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
Maybe you should try with DBMS_SESSION.SET_ROLE?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno Souto
INET: [EMAIL PROTECTED]
Fat City Network
Sure... there you go!
SQL create role new_role identified by password;
Role created.
SQL
1 create or replace procedure turn_on_role
2 authid current_user
3 as
4 begin
5 execute immediate
6 'set role new_role';
7* end;
SQL /
Procedure created.
SQL set role
You should be getting errors, because PL/SQL inside execute immediate
knows nothing about mystorageArray (or i for that matter) declared
in your stored procedure.
Probably, you could get by using package variables (and referring to
them properly: package_name.var_name, specifically inside your
Title: RE: interesting dynamic pl/sql question
Ryan,
what errors are you getting?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can
I assume you mean quote
update tablea set fielda =' james'ste Camp 'first,'sec' '
update tablea set fielda =' james''ste Camp ''first,''sec'' ';
Just use 2 single quotes
1 - 100 of 119 matches
Mail list logo
