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
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
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
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
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,
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));
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
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
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)
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
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
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
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 of
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 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
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
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 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
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
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:
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 by one
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 insert
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.
I
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
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
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
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 when
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
:
Sent by: Subject: PL/SQl question
[EMAIL PROTECTED]
m
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
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 :=
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
: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 TRIM is new, but I thought it needed
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
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.
Dennis,
Try changing your insert statement to:
insert into JOBOFFERFACT_LOAD
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
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
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
an exponent (**) or != or ~= = = and or like
betwe
when i run
PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Pl/sql question - if
statement
: Pl/sql question - if statement
om
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
an exponent (**) or != or ~= = = and or like
I reallydont see what the error is:
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 (from inside a PL/SQL
proc) without jumping
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
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 the EXCEPTION block
OR
is there a way to jump back
: 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)
without jumping to the EXCEPTION block
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
) 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 without going
into ex
)
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 way to jump back to the body of the proc from the EXCEPTION
block
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
Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside
-
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
Dear gurus !
I'm wondering whtether i can catch
-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 gurus
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
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
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 :=
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
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
- 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 it
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 exception then
l_proc_end := sysdate;
SELECT count(*)
INTO l_ins_count
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,
:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED
[EMAIL PROTECTED]
anais.com cc:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED]
2002.01.28 11:20
Please respond to
ORACLE-L
Hi
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 at the start of your code:
l_proc_start
- 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 research
:
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 at the start
/
Thomas, Kevin
Kevin.Thomas@cal To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
anais.com cc:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED
http://www.itsystems.lv/gints/
Thomas, Kevin
Kevin.Thomas@cal To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
anais.com cc:
Sent by:Subject: RE: Pl/sql question
:
tes.com Subject: PL/SQL question
Sent
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 it out
Title: PL/SQL question
Hi
Linda,
You
cannot put a variable instead of an object name (where by object here I
meanowner, table_name, column_name). You have few options:
-
generate a sql hat you would run, e.g. do select 'select
max('||v_column_name||') from ' ||
v_owner
Title: PL/SQL question
Thanks very much!Myuse 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/SQL
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*
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,
:
[EMAIL PROTECTED] Subject: pl/sql question
om
Spence To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cspence@FuelS cc:
pot.com Subject: RE: pl/sql question
:
[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 ORACLE-L
Hi,
I just
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
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
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:
:
[EMAIL PROTECTED]Subject: PL/SQL Question after migrating
from
om7.3.4 to 8.1.7
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:
[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 procedure. Inside that procedure he wants to
know instance and schema
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
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
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
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 is
Dennis,
How about dbms_lock.sleep(seconds) ?
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
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
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
[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
--
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 from
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 procedure real quick today
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 :) )
The
:
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 collect stats from v$session_wait
periodically ( every second
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.
Can anyone give me a good example on a procedure that loops through a table and if
found a ? in some fields, replace it
update table
set dodgy_field = replace( dodgy_field, '?', '0' )
/
-Original Message-
Sent: 06 April 2001 09:45
To: Multiple recipients of list ORACLE-L
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
Another option is to create a table with a large varchar2 column and insert
the data row by row.
You can then spool a SELECT from that table to a file.
e.g.
create table hold_output
(mytext varchar2(4000)
tablespace ts_small;
-Original Message-
Sent: Tuesday, March 27, 2001 4:09 PM
To:
Hi ...
you can go for UTL FILE feature of Oracle PL/SQL, it is very handy while handling
large amount of data that DBMS_OUTPUT can't handle due to the buffer size constraints.
Cheers,
Bagchi.
On Wed, 28 March 2001, "Miller, Jay" wrote:
Another option is to create a table with a large
Hi,
This is my first attempt at writing a PL/SQL procedure. Everything works
fine, except I have a firly large table I am running against. I am trying to
display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to
100, apparently the maximum value, but it still isn't
Use the UTL_FILE package and write the results to a temporary file.
Eric
-Original Message-
Sent: Tuesday, March 27, 2001 4:09 PM
To: Multiple recipients of list ORACLE-L
Hi,
This is my first attempt at writing a PL/SQL procedure. Everything works
fine, except I have a firly
1 - 100 of 102 matches
Mail list logo
