Hi:
In pl/sql, I want to add chr(10) into a string in every 70th position. The
string can be up to 2000 characters long. The follwoing code works. But is
there an even FASTER way to do this?
Thanks.
Guang
---
declare
pos number := 1;
len number;
buf varchar2(2000);
x varchar2(2100
Below is the code for myfunction1 in the package, It calls a bunch of other
functions, such as getBlastMatches, escapeGene, genes.gene2protein and
addItem.
Guang
---
type blastMatch is record (
geneName gene.name%type,
percent number
);
function myfunction1 (seqid in number,
what does myfunction1() do?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Messag
The first argumant (myID) is a variable that is different every time the
function gets called. The second argument is a hard code number (just as in
my orginal message). So I guess I could not use DETERMINISTIC here. I have
not heard of DETERMINISTIC before but I will take a look of this becuase it
Does myFunction1 often get called with the same arguments? In your example, the
second argument is never repeated, but in the real thing, would the same second
argument be likely to repeat? If myFunction1 gets the same arguments, will it always
return the same value? If so, then it is a deter
can you return multiple values from a modified version of myfunction(1) ?? If so, then
you can replace multiple calls by only one. And no, bulk binds is only within
dml/select statements.
Raj
Rajendra dot Jamadagni
Hi:
Oracle 8173 DB.
I have a package funtion, part of it is doing something like this:
utl_file.put_line(fpn, myFunction1(myID, 1));
utl_file.put_line(fpn, myFunction1(myID, 8));
utl_file.put_line(fpn, myFunction1(myID, 6));
utl_file.put_line(fpn, myFunction1(myID, 35));
utl_file.p
Would extproc_perl fit well enough, though, until 10g is here?
On Fri, 21 Nov 2003, Mladen Gogala wrote:
> PL/SQL is the fastest thing of them all when it comes to executing
> SQL commands, but there are things which simply aren't practical
> in 9.2 PL/SQL. Regular expression processing is one
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one of those things.
Fortunately, you can mix the two. Without DBI, perl scripts simply
woudn't be very useful. Of co
Guang,
Well you are almost there ... you need fifo structure namely a pl/sql array
1. create a local pl/sql array to store the delimiter (store the ascii value of the
delimiter to be safe) my_array (varchar2(5))
2. as you find a delimiter insert into the first position in the array and rep
Perl is a good tool for text processing. But our program is already written
in pl/sql long time ago and there are intensive db calls in this pl/sql
program. (text processing is only part of it). So I can not change that.
BTW I did a comparison study a while ago for some of our pl/sql packages
(spe
Hi Stephane:
Thanks for your good suggestion. I compared the method you suggested and the orginal
one and it indeed boosted the performance (in my simple test). However the ONLY
problem I am having is that by doing TRANSLATE, I lost the original delimits. The new
method (you suggested) correctl
Guang,
I agree with your analysis, looping on characters is not the faster you can do,
simply because there is a significant overhead (compared to C code for instance) in a
language such as PL/SQL - which might be perfectly acceptable in some circumstances,
much less so in very repetitive ta
I don't know about PL/SQL but here is how I would get separate words from a big string:
#!/usr/bin/perl -w
use strict;
my (@ARR);
while (<>) {
chomp;
@ARR = split(/[^0-9a-zA-Z_\.,<>]/);
foreach (@ARR) {
print "$_\n";
}
}
There is something called DBI and it can be used to
Hi:
In my pl/sql program, I want to process each "word" in a string. The
string is selected from a varchar2(300) column. The delimit that separates
the words is not necessary space character. The definition of the delimit
in this program is set as
1. Any character that is NOT AlphaNumerical (0-9,
I think
' begin
> mystorageArray.field_''i'' := 1;
> end; ';
will not recongize mystoragearray as a variable .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 11:49 AM
> Im on 8.1.7. Is it possible to do
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
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 y
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 number
Title: RE: is this a good practice...pl/sql question
Yes it is a good practice when required.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any
> Keeping aside all considerations about the loop, I see no problem
>here. The cursor variable is just short-hand notation for defining a
>table%ROWTYPE - you are not modifying some hidden Oracle internal state
>if this is what you are fearing. No 'mutating cursor', if I guess you
>correctly.
Steve McClure wrote:
>
> Allright I am making some changes to some pl/sql code that handles batch
> inserts into the database. I am making changes to correct an error where
> our clients are sending us data with invalid state information in their
> address fields. A constraint prohibits the inse
Title: RE: is this a good practice...pl/sql question
Steve,
Nothing wrong with setting xrec.state to null ... your developer is avoiding hard coding of NULL in the insert statement. In fact if this is working fine then only thing I'd try to change is bulk inserts instead of one b
Steve,
It may be "old fashion" code, but if it works within the time frame it needs
to run in, why spend time recoding? At any rate, I don't see a problem.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, September 17, 2003 4:05 PM
To: M
Allright I am making some changes to some pl/sql code that handles batch
inserts into the database. I am making changes to correct an error where
our clients are sending us data with invalid state information in their
address fields. A constraint prohibits the insert with records with invalid
sta
Tom - Thanks to you and everyone else for the great suggestions. He and I
are sitting down tomorrow to straighten this out. I was concerned that there
might be some PL/SQL oddity that I wasn't aware of (he is a pretty good
PL/SQL programmer). I appreciate your ruling that out.
Dennis Williams
DB
Dennis,
I'd guess that the developer did not try it correctly. Ask to see the code.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 21, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L
Tom - The developer reports that he tried this but i
Tom - The developer reports that he tried this but it didn't work. The third
position is still a space value. Thanks to everyone for the good replies.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 21, 2002 3:13 PM
To: '[EMAIL PROTECTED]
Dennis,
Try changing your insert statement to:
insert into JOBOFFERFACT_LOAD
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
PAIDPACKAGE
Geez, after re-reading my post, it seems that it
didn't make much sense to me, so to clarify...
I had a cursor in my procedure that took as an IN
param a varchar2 variable. The cursor failed to
return any rows because in my where clause I was
comparing a char field against a varchar2 variable.
um...just a thought but how about setting
marketingcode to char(3) in the PL/SQL code snippet.
I ran into this similar problem a couple days ago.
Had a var as varchar2 in PL/SQL but in the table it
was char. Changed my PL/SQL var to char, cursor in my
code worked with ltrim and rtrim functions
l: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Wednesday, August 21, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: PL/SQl question
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that T
Check the definition of table C. It sounds like it is defined as CHAR(3) instead of
VARCHAR2(3). I would also check the PL/SQL for using CHAR instead of VARCHAR2 for
storing the value -- the trim should have eliminated this problem if it was put in the
right place.
Kevin Kennedy
First Point
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.
PL/SQL snippets
<...snip...>
marketingcodeVARCHAR2(3);
<...snip...>
FILELOCATION :
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that TRIM is new, but I thought it needed additional parameters to
tell it what to trim.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To:
DENNIS WILLIAMS
touch.com>cc:
Sent by: Subject: PL/
Sounds like in the table the field c.marketcode is a char(3) instead of
varchar2(3).
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of
> I have a question for from one of my developers related to PL/SQL and how
> data is loaded.
>
> I have a field (marketcode) that is defined as VARCHAR2(3).
>
> I have a problem when I try to load the value of '20' into this field.
> All values with three characters work fine. The problem is
cc:
[EMAIL PROTECTED] Subject: Ang: RE: Pl/sql question - if
statement
[EMAIL PROTECTED] wrote:
> Yes but then it fails onthe word borttags_flagg, thi serrormessage :
>
>
> PLS-00103: Encountered the symbol "BORTTAGS_FLAGG" when expecting one of the
>following:
>
>. ( * @ % & = - + < / > at in mod not rem then
> <> or != or ~= >= <= <> and or like
>
> I
l 2002 18:48
An: Multiple recipients of list ORACLE-L
Betreff: Ang: RE: Pl/sql question - if statement
Yes but then it fails onthe word borttags_flagg, thi serrormessage :
PLS-00103: Encountered the symbol "BORTTAGS_FLAGG" when expecting one of the
following:
. ( * @ % & = - +
Yes but then it fails onthe word borttags_flagg, thi serrormessage :
PLS-00103: Encountered the symbol "BORTTAGS_FLAGG" when expecting one of the following:
. ( * @ % & = - + < / > at in mod not rem then
<> or != or ~= >= <= <> and or like
I reallydont see what the error is:
Roland
[EMAIL PROTECTED] Subject: Pl/sql question - if statement
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Pl/sql question - if
sta
anyone whom can tell me why this statement fails in a pl/sqll code:
I get this error message
PLS-00103: Encountered the symbol "||AvdNr||" when expecting one of the following:
. ( * @ % & = - + < / > at in mod not rem then
<> or != or ~= >= <= <> and or like
betwe
when i run this
pril 04, 2002 9:50 PM
> To: [EMAIL PROTECTED] (E-mail); [EMAIL PROTECTED] (E-mail);
> oralist@lists (E-mail)
> Subject: a PL/SQL question - how to catch errors without going
into
> exceptions block
>
> Dear gurus !
> I'm wondering whtether i can catch an SQL error (
ine
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 2:44 AM
To: Multiple recipients of list ORACLE-L
Subject: a PL/SQL question - how to catch errors without
going into except
Dear gu
inal Message-
> From: Andrey Bronfin
> Sent: Thu, April 04, 2002 9:50 PM
> To: [EMAIL PROTECTED] (E-mail); [EMAIL PROTECTED] (E-mail);
> oralist@lists (E-mail)
> Subject: a PL/SQL question - how to catch errors without going
into
> exceptions block
>
> D
; DBAndre
>
>
>
>
>
> > -Original Message-
> > From: Andrey Bronfin
> > Sent: Thu, April 04, 2002 9:50 PM
> > To: [EMAIL PROTECTED] (E-mail); [EMAIL PROTECTED] (E-mail);
> > oralist@lists (E-mail)
> > Subject: a PL/SQL question - how to catch
list@lists (E-mail)
> Subject: a PL/SQL question - how to catch errors without going into
> exceptions block
>
> Dear gurus !
> I'm wondering whtether i can catch an SQL error (from inside a PL/SQL
> proc) without jumping to the EXCEPTION block
> OR
> is there a wa
) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
> -Original Message-
> From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 04, 2002 11:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: a PL/SQL question - how to catch errors witho
many ways to do that ,
you can put begin .. end block around select .. inside while condition
i := 1;
while i < 10 loop
Begin
select the_name from the_table into myvar where the_id = 1;
Exception
when no data found then
null;
End ;
end loop;
or
> Sent: Thursday, April 04, 2002 1:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: a PL/SQL question - how to catch errors without going into
> except
>
> Dear gurus !
> I'm wondering whtether i can catch an SQL error (from inside a PL/SQL
> proc)
>
E-mail); [EMAIL PROTECTED] (E-mail);
> oralist@lists (E-mail)
> Subject: a PL/SQL question - how to catch errors without going into
> exceptions block
>
> Dear gurus !
> I'm wondering whtether i can catch an SQL error (from inside a PL/SQL
> proc) without jumping to
Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside a PL/SQL proc)
without jumping to the EXCEPTION block
OR
is there a way to jump back to the body of the proc from the EXCEPTION block
(i know that GOTO can not do it).
For example , assume i have users with IDs 1,2,5,6 in m
create a function getSoftwares(p_licence_id ) which returns varchar2
string of softwares and then simply run query on licence table
select licence_id , getSoftware(licenceid)
from licence ;
I hope you know what to write in getSoftwares .
-ak
- Original Message -
To: "Multiple recipi
Write a PL/SQL function which takes the licence_id as argument and returns a
varchar2(... what you deem sufficient, up to 32K).
In the function, loop on the appropriate table and concatenate.
When you run
select licence_id, my_ugly_func(licence_id) softwares
from ...
you more or less ge
You could use a user function. For example,
create or replace function lic_format (id in number) return varchar2
as
tmp varchar2(4000);
hold_tmp varchar2(50);
cursor c1 is
select name from software
where license_id = id;
begin
open c1;
loop
fetch c1 into hold_tmp;
exit when c1%notfound;
tmp := t
Hi all,
i have 2 tables software and licence. 1 licence can have many softwares.
softwares
name platform Licence_id
abc NT1
def WIN2K1
ghi all 2
i want to wri
eríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
"Thomas, Kevin"
anais.com> cc:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED
eïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
"Thomas, Kevin"
anais.com> cc:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED]
"Thomas, Kevin"
anais.com> cc:
Sent by: Subject: RE: Pl/sql question
[EMAIL PROTECTED]
2002.01.28 11:20
Please respond to
think it is more elegant solution
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
"Thomas, Kevin"
anais.com> cc:
Sent by: Subject:
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 28, 2002 14:05
>
> Oki thanks for info can you please show me an example with autonoumus
transactions? Please.
perhaps u could just go to http://technet.oracle.com and do some rese
Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
"Thomas, Kevin"
anais.com> cc:
Sent by: Subject: RE: Pl/sql question
Sent by: Subject: RE: Pl/sql question
[EMAIL PROTECTED]
2002.01.28 11:20
Please respond to
ORACLE-L
Hi Roland,
Best way to do this is just set some variables a
Subject: RE: Pl/sql question
Hi,
Not much experience with pl/sql but..
[EMAIL PROTECTED]@fatcity.com on 28-01-2002 09:40:20
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hallo,
Hi Roland,
Best way to do this is just set some variables at the start of your code:
l_proc_start := sysdate;
l_proc_name := 'proc_name';
begin
...commands...
exception
when then
l_proc_end := sysdate;
SELECT count(*)
INTO l_ins_count
FROM ;
>- pick out the name of the procedure thatis currently running,
check http://osi.oracle.com/~tkyte/who_called_me/index.html,
dbms_utility.get_call_stack, dbms_utility.get_error_stack
>-pick out the start_time of the procedure
discussed some days ago
>- pick outthe end_time of the procedure when i
Hallo,
anyone who canhelp me with this?
I have PL/sql procedure and if something goes wrong I would like the following things
to occur. Please help me with them
If some errors occur I want this to happen.
- pick out the name of the procedure thatis currently running,
-pick out the start_time
Linda" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Title: PL/SQL question
Thanks very much! My use of EXECUTE IMMEDIATE is passing
the parser.
Linda
-Original Message-From: Djordje Jankovic
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 15,
2001 2:03 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: PL
Title: PL/SQL question
Hi
Linda,
You
cannot put a variable instead of an object name (where by object here I
mean owner, table_name, column_name). You have few options:
-
generate a sql hat you would run, e.g. do select 'select
max('||v_column_name||') fro
Title: PL/SQL question
Can anyone can tell me how to use PL/SQL declared variables in a select statement where a . has to be between the owner and table name, and the owner and table name are variables, I'd be most appreciative. The answer is probably obvious... Feel free to point i
Spence To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: RE: pl/sql question
S
chase.comTo: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
Use DBMS_SQL or EXECUTE IMMEDIATE
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Ch
Can I somehow use a variable for the table name in a cursor select?
Here is the example:
--Declaration Section
sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_'
||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC';
--cursor for tmo daily source records
CURSOR cTMODaily IS
SELECT*
nt by: cc:
[EMAIL PROTECTED] Subject: PL/SQL Question after migrating
from
om7.3.4 to 8.1.7
07/27/2001
01:45 PM
Please respond
to
nt by: cc:
[EMAIL PROTECTED] Subject: PL/SQL Question after migrating
from
om
Deen,
If you want a table with the structure of a row in your uc9_correspondence, use THE
'%ROWTYPE'as follows:
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE
INDEX BY BINARY_INTEGER;
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Deen,
shouldn't the statement be:
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence.COLUMN_NAME%TYPE
INDEX BY BINARY_INTEGER;
??
The %TYPE in your PL/SQL is being applied to the table which, I think, is
not valid. A PL/SQL table is a one-column data type, indexed via the
BINAR
Hi,
I just migrated from 734 to 817, I used migration utility. Migration went fine. Some
of my package specification have become
invalid.
When I tried to recompile, I got the following error
30/41PLS-00206: %TYPE must be applied to a variable, column, field or
attribute, not to "UC
Thanks for your help!
This solved the problem.
Sonja
-Original Message-
Sent: Monday, June 25, 2001 3:27 PM
To: Multiple recipients of list ORACLE-L
Sonja,
Instance is easy enough. Either grant the person SELECT access to the
V_$INSTANCE view under the SYS account, or create another
Sonja,
Instance is easy enough. Either grant the person SELECT access to the
V_$INSTANCE view under the SYS account, or create another view owned by the
DBA that returns the same information.
By schema, do you mean the schema where the procedure exists, or of the
person executing the procedure?
Sonja ©ehoviæ <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Pl/SQL question
>Date: Mon, 25 Jun 2001 04:45:28 -0800
>
>List hi!
>Oracle 8.1.7 EE on AIX.
>One of our developers wrote a p
List hi!
Oracle 8.1.7 EE on AIX.
One of our developers wrote a procedure. Inside that procedure he wants to
know instance and schema, while executing that procedure.
Do you have any suggestions?
TIA,
Sonja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8
AIL PROTECTED]>
cc:
Subject: PL/SQL Question
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose of my procedure is to
Try
DBMS_LOCK.SLEEP (
seconds IN NUMBER);
Regards
Karthik Ramachandran
>>> [EMAIL PROTECTED] 05/11/01 11:20AM >>>
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
Hi:
use the procedure:
dbms_lock.sleep(seconds);
HTH
> --
> Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Gesendet: Freitag, 11. Mai 2001 17:20
> An: Multiple recipients of list ORACLE-L
> Betreff: PL/SQL Question
>
> I need to whip out a PL/SQL
dbms_lock.sleep(second in number);
>>> [EMAIL PROTECTED] 05/11/01 11:20AM >>>
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose of my procedure is to collect stats
[EMAIL PROTECTED] wrote:
> I am wondering if there is a similar
> function in PL/SQL similar as the Unix 'sleep' command.
Use dbms_lock.sleep -- it's pretty much like Unix sleep, but requires you to
grant execute on dbms_lock to whichever account needs it.
Bill
--
_
Dan,
While this does not work as is, but probably could be in
some fashion, you win the days raspberry for the most
obfuscated answer. :)
Jared
On Friday 11 May 2001 09:56, Dasko, Dan wrote:
> while trunc(sysdate, ss) = 30 loop
>
> I think this should do whatever's in the loop every minute on
while trunc(sysdate, ss) = 30 loop
I think this should do whatever's in the loop every minute on the 30 second
point.
-Original Message-
Sent: Friday, May 11, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
I need to whip out a PL/SQL procedure real quick today and have a quick
Dennis,
How about dbms_lock.sleep() ?
Jared
On Friday 11 May 2001 08:20, [EMAIL PROTECTED] wrote:
> I need to whip out a PL/SQL procedure real quick today and have a quick
> question for fellow-listers ( since today is Friday, hopefully I don't get
> RTFMed on this one :) )
> The purpose of m
There is indeed a "sleep", in dbms_lock, taking a single argument "seconds".
-Original Message-
Sent: Friday, May 11, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today
Use dbms_lock.sleep()
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opi
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose of my procedure is to collect stats from v$session_wait
periodically ( every second for example) and pump the data
Message-
Sent: Friday, April 06, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
Subject:PL/SQL-question
Hi,
I have imported a text-file into a table in the database. Now I find that
there are many bad things in some fields, for instance there is a ? instead
of the value 0
1 - 100 of 108 matches
Mail list logo