Hi Divya,
you have to use dynamicsql for calling the function . First step
select the function name into a variable say ls_fn_name from the table func
.Then create a dynamic statement
'Select' || ls_fn_name || ' from dual ' and cpature the return value into
another variable . If u
Hi,
I have this DB FILE PARALLEL WRITE as the top event (right after
SQL*NET,rdbms.,pmon smon) and according to the documentation this
has to do with my DBWR but no mention is done on how to solve this.
Is this purely another indication of poor disk performance or should I be
looking
we are experiencing ora-03116 error (invalid
buffer length)
How can we solve this . ? Urgent please .
Thank you . Any Ýdea please ?
bunyamin
Title: analyze partitioned indexes
Hi,
I want to write a procedure that analyzes all my indexes. But I'm not sure whether my source code will also analyze partitioned indexes. What I'm doing is:
delete from admin.tb_index_stats
where index_owner = '1';
commit;
FOR
Hi Jack and List,
we have the same situation. Our DB (mainly OLTP) was built with
db_block_size 8k and ext2 filesystem (Linux) has 4k block size. AFAIK 4k is
max block size for ext2. Do you think it's worth to rebuild the DB with 4k
block in order to adjust it to ext2's block size? I know it's
Hi Deepak,
Can you elaborate what is consistent gets
-
Eric,
here's a high level from my understanding on this
issue:
Buffer gets {also called Logical IO's}
These happen as oracle scans blocks of data in the
buffercache(in-mem scans). Many people believe that
since these are
Helmut, have you tried your code, that would be the best way to see if
it works(hint: partitioned indexes work pretty much like normal indexes,
in that you can analyze the table and the indexes will be analyzed also,
including partitioned tables/indexes).
joe
Daiminger, Helmut wrote:
Hi,
Dpb,
within PL/SQL you can:
-- declare a variable to store the result from the function
func_res number;
-- within the PL/SQL block, call the function and store the result:
func_res := calc_radius(5);
-- or, you can
select calc_radius(5) into func_res from dual;
You do NOT need to
Hi,
We have implemented a form that emails reports. The user has to enter his
email address.
However, we are finding that a lot of users are entering incorrect and
invalid email addresses.
Obviously, we can do nothing if they enter an incorrect (but syntactically
correct) email address.
What
Try to connect with complete connect string (tnsname + names_default_domain
from sqlnet.ora)
regards
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 23. Oktober 2001
Hi all,
I've got a little question, which i can't find simply on metalink.
I've got one user with a not know password and i want to temporary change
it;s password.
I know it is possible to save the hex-key in dba_users.
But how can i change it back to that hex-key?
I need temporary this user
If it is an html form, you may want to consider implementing the code as
JavaScript. This is how it was done at the last company I worked for. This
way, the addresses are validated long before they get to the db. This was
also the case for credit card numbers. Also, this moved the processing off
Quite tricky this one...I would imagine there will be a few combinations for
valid email addresses, you could try looking at the World Wide Web
Consortium page www.w3.org, or some similar site for the standards
documents.
HTH
Kev.
hit any user to continue
__
Kevin Thomas
We're setting up a development box that will have a number of instances on
it. We won't need any backup, since we can easily re-create the databases
from testing instances.
I'm planning on implementing the disk storage as RAID0 - a single logical
volume stripped across all the drives (6), with
save the key
then to set it back
alter user username idenfified by values 'HEX KEY HERE';
joe
[EMAIL PROTECTED] 10/24/01 10:10AM
Hi all,I've got a little question, which i can't find
simply on metalink.I've got one user with a not know password and i want to
temporary changeit;s
Hi Marco,
Following select will generate a alter user with old password. After
generating SQL you can change password of a user. With the generated SQL ypu
can set password bak to original one.
SELECT 'alter user ' || username ||
' identified ' ||
It's just
ALTER USER username IDENTIFIED BY VALUES 'hex-key-whatever';
Substituting the username and password value from dba_users as appropriate.
There are scripts that save it in a file with the commands to switch it back,
but it's easy enough to do manually.
Simon Anderson
Hi all,
I need to use utl_file on a Unix server to process DOS format(CRLF) files.
can I sepcify to utl_file waht the record delimiter is...or do I need to
convert the files to Unix format before utl_file will read them correctly?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Hi,
how can I retrieve the hostname from within PL/SQL ?
TIA
Stefan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Hi
The definition is found in RFC 2822 Internet Message Format
(ftp://ftp.isi.edu/in-notes/rfc2822.txt)
Oweson Flynn wrote:
Hi,
We have implemented a form that emails reports. The user has to enter his
email address.
However, we are finding that a lot of users are entering incorrect and
Leng,
If you dont use a catalog with rman you wouldn't be able to store scripts
to make automated backups and restore. Also that means that all the
information about your backups will be stored in the control file of the
target database, if you loose your controlfiles will loose all the
Hi,
I guess what you want is more heading towards dynamic sql:
Start with a PL/SQL block like this:
DECLARE
v_funcName VARCHAR2(50);
v_statement VARCHAR2(255);
BEGIN
SELECT function_name INTO v_funcName
FROM function
WHERE function_name;
v_statement := 'SELECT ' ||
Include it n your select statement
select emp||','||name||','||sal from emp;
This would return
10,MILLS,9
Here using comma as a delimiter
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
809-565-3121
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL
You can not specify the record delimiter with UTL_FILE.
You can use UTL_FILE.GET_LINE to read records terminated with LF. LF will
not be included in the return string.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of
If you want a definitive answer, this is it:
http://RFC.net/rfc2822.html
My suggestion would be that you don't actually allow all
valid forms of addressing. The code to check that would
be rather large to say the least, and the testing routine
for it would not be too trivial either.
Jared
Does utl_file not just read the file a line at a time and then it is upto
you to programmatically divide the data up into it's chunks using substr
etc.
Kev.
hit any user to continue
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs
The script below will generate a script that can be used to restore the
userid to its original state.
select 'alter user ' || username || ' identified by values ''' ||
password || || ' default tablespace '
|| default_tablespace ||' temporary tablespace ' || temporary_tablespace ||
' ;'
from
select host_name from v$instance;
Jared
On Wednesday 24 October 2001 07:55, Stefan Jahnke wrote:
Hi,
how can I retrieve the hostname from within PL/SQL ?
TIA
Stefan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City
Title: RE: providing 24*7 database ---
I
couldn't verifythat the non-partitioned indexes become unusable after
exchanging the partition for the normal table. In the sample I posted
Isnipped the output of the queries on USER_INDEXES and USER_PART_INDEXES,
but my tests showed that they remain
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 9:15 AM
Hi,
We have implemented a form that emails reports. The user has to enter his
email address.
However, we are finding that a lot of users are entering
Hi everyone -
I need some help. We have an application running on 8.0.5 on NT. My
programmer tells me that she should be able to add columns to a table simply
by changing the sql loader control file definition of the input. I have
looked through the documentation and tried several tests, but
Hi,
is there a smart way to generate IDs in chunks?
getting an ID with nextval is perfectly ok most of the time, but sometimes
the application would need to generate a pool of IDs and keep them for later
use
as I can't manipulate the currval of the sequence, I wander what the best
solution
Are the 'db file scattered read' and 'db file
sequential read' waits directly related to the readtim
values in v$filestat?
For every 1/100th sec of v$filestat.readtim, should I
see corresponding wait time reported for the 'db file
scattered read' or 'db file sequential read'?
If this is the
Is there a way to detect if a transaction is currently being rolled back?
ie. If it fails part way thru or is cancelled by the user?
Thanks in advance,
John
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
this is documented in Kevin Loney's 7.3 edition of the DBA Handbook
(look for become_another_user.sql)
--- [EMAIL PROTECTED] wrote:
Hi all,
I've got a little question, which i can't find simply on metalink.
I've got one user with a not know password and i want to temporary
change
it;s
Why not have the sequence increment by 20 (or something to your liking) and
then in the application use the number from the sequence and the 19 numbers
the sequence will skip.
-Original Message-
Sent: Wednesday, October 24, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L
Hi,
is
We have HP server with NT 4.0 installed. This server dedicate for ORACLE
use. The ORACLE version is 8.1.5 (no patch installed). we found the
performance NOT really good. I turn on the performance monitor and found
the memory page fault and memory pages/sec are very high while SQL
statement
John
My initial tests indicated that not all tables which had any DMLs were
getting into the'stale category'. I checked the ratioA/B
where:
A is the sum of inserts+deletes+updates from user_tab_modifications
B is num_rows from user_tables (or user_tab_partitions).
I observed that if this
On my NT Quad Development box I have 9x2 Raid 1 for OS/Oracle Files.
Then Raid 0+1 for the 6 drives for data. It isn't perfect, but works good.
If you do raid 0 with 6 drives, make sure you look into a good stripe size
so you actually use the girth. Otherwise 0+1,1+0 may be a better option.
We are trying to recover a database to another server.
The backup was a hot backup. The files are all copied to the new server,
along with the archive log that was created a few seconds after the hot
backup was run. We bring the database up and apply the archive log and
Oracle says recovery
Seemed fine when I tried it (and thanks for the idea!). The trick
with the indexes is that the ones on the partitioned table have to be local,
which was in the scripts provided, and the 'exchange partition' had to say
'including indexes', which was not. Adding 'including indexes' made this
Tony,
If the partitioned indexes have a locality of global (not local), then they
become invalid after activity on the underlying table partitions.
Does Narender say whether his indexes are global or local?
Cherie Machler
- Original Message -
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 18:33
Why not have the sequence increment by 20 (or something to your liking)
and
then in the application use the number from the sequence and the 19
numbers
the sequence will skip.
Lisa,
No and no. Loader loads rows into tables. If you ask nicely,
it will clean out the table completely before it does that. That's all
it does. And it does it pretty well.
It does not let users redefine tables.
And it does not do selective update and delete based on the
incoming data file.
Title: RE: Please help! Recover a database on another server
sometimes the error message is a little strange...
when it comes back 'media recovery complete' you can usually just do a 'alter database open;' command and not worry about resetting the logs. If you backed up the controlfiles,
Ron,
Make sure you have atleast applied the archive logs between
Archive old log sequence number before start of hot backup and
Archive current log sequence number after end of hot backup.
It may not need all of them but you need the last one for incomplete
recovery..
Mohammed Ahsanuddin
You might ask your programmer to read the manual. However, the first might
be a nice enhancement but it's not currently available.
As for the second, SQL*Loader either inserts into an empty table or appends
to a table with existing data. It doesn't do an implicit update. However,
if your
use the girth -- I'd love to pretend that I knew what this means but
someone might call me on it. What does it mean? Each drive is 36G.
Christopher
Title: RE: to find who is waiting for lock
DBA_WAITERS
A table which gives information about sessions holding the lock and sessions waiting to lock the same object.
rgds
amar
-Original Message-
From: Tatireddy, Shrinivas (MED, Keane)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Here's a kludged-together work-around. After you do your rare pool
requests, drop the sequence and recreate it starting at MAX(ID)+1. There
is no easier way to reset the sequence number.
Here is a script I use all the time to run jobs for other users. It saves the current
password, sets the password to temp, connects to user, and sets it back to original
setting. Now you are logged in as the new user but their password was only changed
for less than a second. The script
Ron,
The backup was a hot backup. The files are all copied to the
new server,
along with the archive log that was created a few seconds
after the hot
backup was run. We bring the database up and apply the
archive log and
Oracle says recovery complete. We then do an alter database
Try ' recover database until time '2000/10/24 12:00:00' using backup
controlfile;'
That should eliminate this problem.
Regards,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 12:40 PM
We are trying to recover a
what documentation has your programmer been reading?
as far as I know you can't add a column on the fly through a sqlloader
control file, nor will oracle do an update to existing data.
I'm not an expert, but I've never been able to do that
--- YTTRI Lisa [EMAIL PROTECTED] wrote:
Hi everyone
Oracle 8.1.7.1 on HPUX 11
I have a table that I have just indexed every column. This has improved the
query performance however, its going to slow down the load. Thing that has
me confused is that I tried this as an IOT and it actually hurt performance.
This table is joined to another table
the key is when did you create the backup controlfile?
Try using a backup controlfile as opposed to a copy of the controlfile.
yes, there is a difference.
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
We are trying to recover a database to another server.
The backup was a hot backup. The
That's it folks. We can all go home.
Rachel says I'm not an expert.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, October 24, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L
what documentation has your programmer been reading?
as far as I
Come work for this R D Company in beautiful Coastal Maine that is search
of an ERP Oracle DBA to join it's I.T. staff.
This company is near the ocean, mountains, forrests, lakes, and trails in a
very low cost of living area.
If you love high tech challenges but you're looking for a more
natural
SQL declare
2 w_a number := 0;
3 w_b number:= 0;
4 w_c char(10) := null;
5 w_d number := 0;
6 cursor v_c_t is
7 select a,c,b from civ_test;
8 begin
9 for v_c_t_row in v_c_t loop
10 :w_d := w_d + 1;
11 :w_a := 0;
12 :w_c := null:
13 :w_b := 0;
14 :w_a := select c
I've been trying to track down the source of high
'direct path read' and 'direct path write' waits. It
appears the waits are related to locally managed
temporary tablespaces. However, I'm puzzled by what
is reported in v$tempstat.
SQL select FILE#, READTIM, WRITETIM, AVGIOTIM,
Title: RE: Code to Validate email addresses
I'd like to make a suggestion for a different approach. I'm thinking of something like a reverse check of the address. Check out this web service (http://beta2.eraserver.net/webservices/mxchecker/) that accepts an email address for validation. It
Title: RE: providing 24*7 database ---
Narender hasn't replied yet. But the sample I sent only uses local indexes since there is only one partition. I did see that Jim Conboy pointed out that I missed the 'including indexes' option.
Tony
-Original Message-
From: [EMAIL PROTECTED]
Do you need a space when declaring the variable, w_b number := 0?
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L
SQL declare
2 w_a number := 0;
3 w_b number:= 0;
4 w_c char(10) := null;
5 w_d number
Remove the colons from the assignment statements.
SQL declare
2 w_a number := 0;
3 w_b number:= 0;
4 w_c char(10) := null;
5 w_d number := 0;
6 cursor v_c_t is
7 select a,c,b from civ_test;
8 begin
9 for v_c_t_row in v_c_t loop
10 w_d := w_d + 1;
11 w_a := 0;
12
change :w_b to w_b, :w_c to w_c and so on. you do not need to user :(colon) to assign
values
Rakesh
[EMAIL PROTECTED] 10/24/01 02:31PM
SQL declare
2 w_a number := 0;
3 w_b number:= 0;
4 w_c char(10) := null;
5 w_d number := 0;
6 cursor v_c_t is
7 select a,c,b from
Hi,
I installed 815 client and server on NT 4.0. When I
use svrmgrl to connect to the database, I got 12560
protocol adapter error. I already commented out all
the entries in sqlnet.ora file.
What should I do ??? Thank you!
Janet
__
Do You
Title: FW: ADO.NET and Oracle 8.1.6
(p.s. tday6 - please ignore my previous message, I hit the send button too quickly.)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Are the ODBC driver and SQL*Plus using the same tnsnames.ora file?
Yes, as far as I can
Can anyone tell me what is difference between :
select count(*) ... from ..
select count(0) ...
select coun (1) ...
select count(2) ...
Thanks.
_
Get your FREE download of MSN Explorer at
Binay,
from what i understand, these type of block reads
relate to read consistancy .. meaning that if oracle
wants to read block x but it finds that it is dirty ,
it reads from the rollback segments to give you the
point in time snapshot as it existed at the time when
you had first started the
why does he need a backup control file? this appears
to be a straightforward case of moving databases(i
mean restoring to a new host). does not look like they
have done structural changes or things like that.
ron do you use rman? if not then someone earlier
suggested taking the datafiles off
i think count(*) gives count of all columns .. where
as count(col1) gives count for col1 ignoring nulls in
col1
Deepak
--- aaa aaa [EMAIL PROTECTED] wrote:
Can anyone tell me what is difference between :
select count(*) ... from ..
select count(0) ...
select coun (1) ...
aaa aaa,
( if that's your real name :)
Considering that your page faults are very high, take a look
at the sizes of db_block_buffers, db_block_size, and shared_pool_size
for starters.
512 Meg of RAM isn't exactly an overabundance, but will perform
especially badly if you've allocated all of it
The control file was backed up the same time the data files were backed up.
The control file from the backup
is what we are using.
Ron
-Original Message-
Sent: Wednesday, October 24, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
the key is when did you create the backup
Are you sure, if you don't state 'using backup controlfile' it will use the
control file you usd to startup the database.
Just a thot,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 3:46 PM
The control file was
Title: RE: analyze partitioned indexes
-Original Message-
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
I want to write a procedure that analyzes all my indexes. But I'm not sure whether my source code will also analyze partitioned indexes.
...
- with the command analyze
If you have a Raid 0 of 6 drives and set a strip size to be 16K, then the
girth (or commonly referred to as stripe width) is 16k x 6 or 96K, if you
write less than 96K you will only use some of the drives. With a write-back
caching controller it can hold writes to speed transactions but also to
Thanks to all for reconfirming this for me. I had never heard of SQL Loader
doing these things, but couldn't quite convince the programmer.
What I have since found out is that once upon a time, a consultant came in
and set up the job that loads their data - and left without documenting it.
Lo
Title: RE: protocol adapter error ???
-Original Message-
From: Janet Linsy [mailto:[EMAIL PROTECTED]]
I installed 815 client and server on NT 4.0. When I
use svrmgrl to connect to the database, I got 12560
protocol adapter error. I already commented out all
the entries in
try to recreate a control file!!!
@lex
Lic. Alexander Ordóñez Arroyo
Caja Costarricense del Seguro Social
Soporte Técnico - División de Informática
Telefono: 295-2004, San
Aren't they the same? If I restore the control file from the backup. There
was no control file on the server
before I did the restore.
Ron
-Original Message-
Sent: Wednesday, October 24, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L
Are you sure, if you don't state 'using
If you analyze all of the partitions in an index (one partition at a time)
is the performance of the the end result the same as it would be if you
just analyzed the entire index at one time (not partition by partition).
Thanks,
Cherie
Thanks. Now all I have to do is coach our SA past the HP auto-config.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
Hi, all
I have a table that has a column with BLOB data type.
When I do a select I got:
SP2-0678: Column or attribute type can not be
displayed by SQL*Plus
And I don't know how the data got inserted there.
Could anyone let me know how to insert and display
BLOB contents. Thank you!
Andrea
it depends on how you created the control file that was on the backup.
If you just copied the control file from disk, that would explain your
problem.
If you did a alter system backup controlfile to file and then
backed that one up and moved it to the other server and then did a
recover
Andrea -
That's a standard message when you perform a select * against a table with
a BLOB column, or explicitly select the BLOB column via SQL*Plus. You say
that you don't know how data got into the table - are you sure that data
is actually in the BLOB column? You can use the
Hi
My redo log group# is 5,6,7.If I want to add more redo log group then Can I
add group#9?
As far I know there will be not impact on Database but let me know group
view please.
Thanks
-Seema
_
Get your FREE download of MSN
Title: RE: BLOB ???
Look at the documentation for the Supplied PL/SQL Package Reference... Read the information about DBMS_LOB... That should get you started...
Tim
-Original Message-
From: Andrea Oracle [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 5:16 PM
To:
Title: RE: Weirdness
First off... Did you place a separate index on every column or one index that included every column? Second, either of those is methods is probably overkill... The real questions you have to ask are...
Have you determined the execution plan of the statement yet?
What was
We need to communicate inside a team made of DBAs that support different
database platforms: oracle, sql*server, Sybase, adabase (Am I wrong that
sql*server and sybase terminology is pretty much the same?). There are some
terminology differences between different databases (to start with the
Hi,
If you open up task Manager on the server, and swap to the performance tab,
how much physical memory is shown as available?
While you're on that tab, how much total physical memory does Task Manager
report?
As per Jared's question, what do the following 2 queries show?
select * from v$sga;
especially if you are restoring to a new server then
typically i would issue rman -- restore controlfile
which would get the backup from tape
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
Aren't they the same? If I restore the control file
from the backup. There
was no control file on the
The script included will produce the following output. The key for you
would be to watch the #Of Undo Blks Used column. If it's incrementing
the updates, etc. are in progress. If it's decreasing, the transaction is
being rolled back.
Hope this helps.
Wed Oct 24
page1
Seema,
so long as you dont drop the current log you are
fine:)
adding logs will have zero impact in terms of db
impact or availabilty. One of the things you could do
is immediately take a backup of your control file just
in case;
Deepak
--- Seema Singh [EMAIL PROTECTED] wrote:
Hi
My redo
Thank you for answer. How about count(0)?
From: Deepak Thapliyal [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: [Q] what difference between count(0), count(1) and count(*)
Date: Wed, 24 Oct 2001 11:41:11 -0800
i think
http://certcities.com/editorial/columns/story.asp?EditorialsID=23
-
http://www.google.com/search?as_q=num=100btnG=Google+Searchas_epq=oracle+vs.+sql+serveras_oq=as_eq=lr=as_qdr=allas_occt=anyas_dt=ias_sitesearch=safe=off
ORACLE-L Digest -- Volume 2001, Number 296
--
As I understand it, count(*) counts all rows. Anything other than * is treated as
an expression and it returns the number of rows where that expression evaluates to not
null. So what Deepak said below about count(col1) giving the count of non-null
instances of col1 is correct. That also
List,
Bit of an inappropriate question to the Oracle List.
Does anybody know the SQL Server (Transact SQL) equivalent
of the LPAD function.
Regards
Suhen
For interest, 9i introduces the SQL Loader merge command which combines
update and insert.
So if they were reading 9i doco then they might have been partly right.
Refer to Jonathan Gennick's article from Oracle Magazine - available online
at
We had a situation like this - we wanted to get a large batch of sequences at
once with one trip to the database. We used a stored procedure that took an
argument how many do you want - and it used an execute immedate select nextval
into an array and passed the array back.
On Wed, 24 Oct
1 - 100 of 102 matches
Mail list logo
