| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why this update is not working , can't I use nvl function in
--0__=85256984006BEAF88f9e8a93df938690918c85256984006BEAF8
Content-type: text/plain; charset=us-ascii
Try this way,
set max_capacity = (select nvl(max (col1),0.0) from <table2>
hope this helps.
best regards,
prasad
"Koivu, Lisa" <lkoivu_at_qode.com> on 10/26/2000 03:10:54 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
cc: (bcc: Prasada R Gunda/HLIFE)
Subject: RE: Why this update is not working , can't I use
nvl function in
Veera, I don't believe you can't have a select statement in an NVL. As
long
as you are in a procedure and aren't stuck to straight SQL, execute your
select into a variable and NVL that variable.
sorry.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
Sent: Thursday, October 26, 2000 2:53 PM
To: Multiple recipients of list ORACLE-L
update st
Hi Guys,
Can anybody tell me why this update is failing , can't I use nvl
function in update while
loop thru?, please also see the errors at the end.
DECLARE
v_min_unique_num int; v_max_unique_num int; v_increment int;
v_increment := 10000;
v_min_unique_num = 1;
v_max_unique_num = 100;
while (v_min_unique_num <= v_max_unique_num) loop
update <table1>
set max_capacity = nvl( (select max (col1) from <table2>
where <table2>.col1 = <table1.col1 and
<table1.col1 in (select col1 from <table3>
where col2 = 33)), 0.0)
where <table1>.col1 between v_min_unique_num and (v_min_unique_num +
v_increment);
v_min_unique_num := v_min_unique_num + v_increment + 1;
end loop;
end;
/
PLS-00103: Encountered the symbol "SELECT" when expecting one of the
following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
ORA-06550: line 78, column 31: PLS-00103: Encountered the symbol "," when expecting one of the following:
Veera
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Veera Prasad
INET: vprasad_at_olf.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--0__=85256984006BEAF88f9e8a93df938690918c85256984006BEAF8
Content-type: text/html;
name="att1.htm"
Content-Disposition: attachment; filename="att1.htm" Content-transfer-encoding: base64 Content-Description: Internet HTML
PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgTkFNRT0iR2VuZXJhdG9yIiBDT05URU5U PSJNUyBFeGNoYW5nZSBTZXJ2ZXIgdmVyc2lvbiA1LjUuMjY1MC4xMiI+DQo8VElUTEU+UkU6IFdo eSB0aGlzIHVwZGF0ZSBpcyBub3Qgd29ya2luZyAsIGNhbid0IEkgdXNlIG52bCBmdW5jdGlvbiBp biB1cGRhdGUgc3QgPC9USVRMRT4NCjwvSEVBRD4NCjxCT0RZPg0KDQo8UD48Rk9OVCBTSVpFPTI+ VmVlcmEsIEkgZG9uJ3QgYmVsaWV2ZSB5b3UgY2FuJ3QgaGF2ZSBhIHNlbGVjdCBzdGF0ZW1lbnQg aW4gYW4gTlZMLiZuYnNwOyBBcyBsb25nIGFzIHlvdSBhcmUgaW4gYSBwcm9jZWR1cmUgYW5kIGFy ZW4ndCBzdHVjayB0byBzdHJhaWdodCBTUUwsIGV4ZWN1dGUgeW91ciBzZWxlY3QgaW50byBhIHZh cmlhYmxlIGFuZCBOVkwgdGhhdCB2YXJpYWJsZS48L0ZPTlQ+PC9QPg0KDQo8UD48Rk9OVCBTSVpF PTI+c29ycnkuPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+TGlzYSBSdXRsYW5kIEtv aXZ1PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5PcmFjbGUgRGF0YWJhc2UgQWRtaW5pc3RyYXRv cjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+UW9kZS5jb208L0ZPTlQ+DQo8QlI+PEZPTlQgU0la RT0yPjQ4NTAgTm9ydGggU3RhdGUgUm9hZCA3PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5TdWl0 ZSBHMTA0PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5Gb3J0IExhdWRlcmRhbGUsIEZMJm5ic3A7 IDMzMzE5PC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+VjogOTU0LjQ4NC4zMTkxLCB4 MTc0PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5GOiA5NTQuNDg0LjI5MzMgPC9GT05UPg0KPEJS PjxGT05UIFNJWkU9Mj5DOiA5NTQuNjU4LjU4NDk8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPjxB IEhSRUY9Imh0dHA6Ly93d3cucW9kZS5jb20iIFRBUkdFVD0iX2JsYW5rIj5odHRwOi8vd3d3LnFv ZGUuY29tPC9BPjwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yPiZxdW90O1RoZSBpbmZv cm1hdGlvbiBjb250YWluZWQgaGVyZWluIGRvZXMgbm90IGV4cHJlc3MgdGhlIG9waW5pb24gb3Ig cG9zaXRpb24gb2YgUW9kZS5jb20gYW5kIGNhbm5vdCBiZSBhdHRyaWJ1dGVkIHRvIG9yIG1hZGUg YmluZGluZyB1cG9uIFFvZGUuY29tLiZxdW90OzwvRk9OVD48L1A+DQo8QlI+DQoNCjxQPjxGT05U IFNJWkU9Mj4tLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpF PTI+RnJvbTogVmVlcmEgUHJhc2FkIFs8QSBIUkVGPSJtYWlsdG86dnByYXNhZEBvbGYuY29tIj5t YWlsdG86dnByYXNhZEBvbGYuY29tPC9BPl08L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPlNlbnQ6 IFRodXJzZGF5LCBPY3RvYmVyIDI2LCAyMDAwIDI6NTMgUE08L0ZPTlQ+DQo8QlI+PEZPTlQgU0la RT0yPlRvOiBNdWx0aXBsZSByZWNpcGllbnRzIG9mIGxpc3QgT1JBQ0xFLUw8L0ZPTlQ+DQo8QlI+ PEZPTlQgU0laRT0yPlN1YmplY3Q6IFdoeSB0aGlzIHVwZGF0ZSBpcyBub3Qgd29ya2luZyAsIGNh bid0IEkgdXNlIG52bCBmdW5jdGlvbiBpbjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+dXBkYXRl IHN0IDwvRk9OVD4NCjwvUD4NCjxCUj4NCg0KPFA+PEZPTlQgU0laRT0yPkhpIEd1eXMsPC9GT05U Pg0KPEJSPjxGT05UIFNJWkU9Mj5DYW4gYW55Ym9keSB0ZWxsIG1lIHdoeSB0aGlzIHVwZGF0ZSBp cyBmYWlsaW5nICwgY2FuJ3QgSSB1c2UgbnZsPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5mdW5j dGlvbiBpbiB1cGRhdGUgd2hpbGU8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPmxvb3AgdGhydT8s IHBsZWFzZSBhbHNvIHNlZSB0aGUgZXJyb3JzIGF0IHRoZSBlbmQuPC9GT05UPg0KPC9QPg0KDQo8 UD48Rk9OVCBTSVpFPTI+REVDTEFSRTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+dl9taW5fdW5p cXVlX251bSBpbnQ7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj52X21heF91bmlxdWVfbnVtIGlu dDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPnZfaW5jcmVtZW50IGludDs8L0ZPTlQ+DQo8QlI+ PEZPTlQgU0laRT0yPmJlZ2luPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mbmJzcDsmbmJzcDsg dl9pbmNyZW1lbnQgOj0gMTAwMDA7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj52X21pbl91bmlx dWVfbnVtID0gMTs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPnZfbWF4X3VuaXF1ZV9udW0gPSAx MDA7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mbmJzcDt3aGlsZSAodl9taW5fdW5pcXVlX251 bSAmbHQ7PSB2X21heF91bmlxdWVfbnVtKSBsb29wPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj51 cGRhdGUmbmJzcDsmbmJzcDsgJmx0O3RhYmxlMSZndDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0y PnNldCZuYnNwOyBtYXhfY2FwYWNpdHkgPSBudmwoIChzZWxlY3QmbmJzcDsgbWF4IChjb2wxKSBm cm9tICZsdDt0YWJsZTImZ3Q7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mbmJzcDsmbmJzcDsg d2hlcmUmbmJzcDsgJmx0O3RhYmxlMiZndDsuY29sMSA9ICZsdDt0YWJsZTEuY29sMSZuYnNwOyBh bmQ8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZuYnNwOyZuYnNwOyZuYnNwOyAmbHQ7dGFibGUx LmNvbDEgaW4gKHNlbGVjdCBjb2wxIGZyb20gJmx0O3RhYmxlMyZndDs8L0ZPTlQ+DQo8QlI+PEZP TlQgU0laRT0yPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyB3aGVyZSBjb2wyID0gMzMp KSwgMC4wKTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+d2hlcmUgJmx0O3RhYmxlMSZndDsuY29s MSBiZXR3ZWVuIHZfbWluX3VuaXF1ZV9udW0gYW5kICh2X21pbl91bmlxdWVfbnVtICs8L0ZPTlQ+ DQo8QlI+PEZPTlQgU0laRT0yPnZfaW5jcmVtZW50KTs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0y PiZuYnNwOyB2X21pbl91bmlxdWVfbnVtIDo9IHZfbWluX3VuaXF1ZV9udW0gKyB2X2luY3JlbWVu dCArIDE7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mbmJzcDtlbmQgbG9vcDs8L0ZPTlQ+DQo8 QlI+PEZPTlQgU0laRT0yPmVuZDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPi88L0ZPTlQ+DQo8 L1A+DQoNCjxQPjxGT05UIFNJWkU9Mj5QTFMtMDAxMDM6IEVuY291bnRlcmVkIHRoZSBzeW1ib2wg JnF1b3Q7U0VMRUNUJnF1b3Q7IHdoZW4gZXhwZWN0aW5nIG9uZSBvZiB0aGU8L0ZPTlQ+DQo8QlI+ PEZPTlQgU0laRT0yPmZvbGxvd2luZzo8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiggLSArIG1v ZCBub3QgbnVsbCBvdGhlcnMgJmx0O2FuIGlkZW50aWZpZXImZ3Q7PC9GT05UPg0KPEJSPjxGT05U IFNJWkU9Mj4mbHQ7YSBkb3VibGUtcXVvdGVkIGRlbGltaXRlZC1pZGVudGlmaWVyJmd0OyAmbHQ7 YSBiaW5kIHZhcmlhYmxlJmd0OyBhdmc8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPmNvdW50IGN1 cnJlbnQgZXhpc3RzIG1heCBtaW4gcHJpb3Igc3FsIHN0ZGRldiBzdW0gdmFyaWFuY2U8L0ZPTlQ+ DQo8QlI+PEZPTlQgU0laRT0yPmV4ZWN1dGUgZm9yYWxsIHRpbWUgdGltZXN0YW1wIGludGVydmFs IGRhdGU8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZsdDthIHN0cmluZyBsaXRlcmFsIHdpdGgg Y2hhcmFjdGVyIHNldCBzcGVjaWZpY2F0aW9uJmd0OzwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+ Jmx0O2EgbnVtYmVyJmd0OyAmbHQ7YSBzaW5nbGUtcXVvdGVkIFNRTCBzdHJpbmcmZ3Q7PC9GT05U Pg0KPEJSPjxGT05UIFNJWkU9Mj5PUkEtMDY1NTA6IGxpbmUgNzgsIGNvbHVtbiAzMTo8L0ZPTlQ+ DQo8QlI+PEZPTlQgU0laRT0yPlBMUy0wMDEwMzogRW5jb3VudGVyZWQgdGhlIHN5bWJvbCAmcXVv dDssJnF1b3Q7IHdoZW4gZXhwZWN0aW5nIG9uZSBvZiB0aGU8L0ZPTlQ+DQo8QlI+PEZPTlQgU0la RT0yPmZvbGxvd2luZzo8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPjsgcmV0dXJuIHJldHVybmlu ZyBhbmQgb3I8L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9Mj5WZWVyYTwvRk9OVD4NCjwv UD4NCg0KPFA+PEZPTlQgU0laRT0yPi0tIDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+UGxlYXNl IHNlZSB0aGUgb2ZmaWNpYWwgT1JBQ0xFLUwgRkFROiA8QSBIUkVGPSJodHRwOi8vd3d3Lm9yYWZh cS5jb20iIFRBUkdFVD0iX2JsYW5rIj5odHRwOi8vd3d3Lm9yYWZhcS5jb208L0E+PC9GT05UPg0K PEJSPjxGT05UIFNJWkU9Mj4tLSA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPkF1dGhvcjogVmVl cmEgUHJhc2FkPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mbmJzcDsgSU5FVDogdnByYXNhZEBv bGYuY29tPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+RmF0IENpdHkgTmV0d29yayBT ZXJ2aWNlcyZuYnNwOyZuYnNwOyZuYnNwOyAtLSAoODU4KSA1MzgtNTA1MSZuYnNwOyBGQVg6ICg4 NTgpIDUzOC01MDUxPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5TYW4gRGllZ28sIENhbGlmb3Ju aWEmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgLS0gUHVibGljIElu dGVybmV0IGFjY2VzcyAvIE1haWxpbmcgTGlzdHM8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPi0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5UbyBSRU1PVkUgeW91cnNlbGYgZnJv bSB0aGlzIG1haWxpbmcgbGlzdCwgc2VuZCBhbiBFLU1haWwgbWVzc2FnZTwvRk9OVD4NCjxCUj48 Rk9OVCBTSVpFPTI+dG86IExpc3RHdXJ1QGZhdGNpdHkuY29tIChub3RlIEVYQUNUIHNwZWxsaW5n IG9mICdMaXN0R3VydScpIGFuZCBpbjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+dGhlIG1lc3Nh Z2UgQk9EWSwgaW5jbHVkZSBhIGxpbmUgY29udGFpbmluZzogVU5TVUIgT1JBQ0xFLUw8L0ZPTlQ+ DQo8QlI+PEZPTlQgU0laRT0yPihvciB0aGUgbmFtZSBvZiBtYWlsaW5nIGxpc3QgeW91IHdhbnQg dG8gYmUgcmVtb3ZlZCBmcm9tKS4mbmJzcDsgWW91IG1heTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpF PTI+YWxzbyBzZW5kIHRoZSBIRUxQIGNvbW1hbmQgZm9yIG90aGVyIGluZm9ybWF0aW9uIChsaWtl IHN1YnNjcmliaW5nKS48L0ZPTlQ+DQo8L1A+DQoNCjwvQk9EWT4NCjwvSFRNTD4=
--0__=85256984006BEAF88f9e8a93df938690918c85256984006BEAF8--
From: "Gabriel Galanternik" <ggalanterni_at_tesis-oys.com.ar>
Date: Thu, 26 Oct 2000 16:37:30 -0300
Subject: RE: Upgrade 8.0.4 to 8.1.x
The MUST part means:
Designer 2.1.2 AND Designer 6.0/6.i when generates web modules, generates
packages which exceeds
maximum package lenght, so I get "program too large" error...
nice thing, ouch!
And Support won't fix this thing neither previous nor next versions of
designer, so, I must upgrade db
Thanks a lot
Gabriel
Gabriel Galanternik
Tesis OyS
Well must is a strong word. You never really have to upgrade Oracle unless you find a bug that Oracle does not already have a fix for. I still have one database here running 7.3.3 and just got rid of a 7.3.4 one.
I do believe though that to use Des2k 6i you need Oracle 8i. But you could just install another version of Oracle for that.
However, just last night I did the upgrade to 8.0.4 to 8.1.6 along with an major OS upgrade. No problems. It's not to complicated when its a supported upgrade which this is.
-----Original Message-----
Sent: Thursday, October 26, 2000 7:47 AM
To: Multiple recipients of list ORACLE-L
Just two questions:
- I've been doing almost everything but never a DBA. Now Oracle Support
tells me I MUST upgrade my 8.0.4 database to a 8.1.x
It's over NT. Is as easy as it sounds? what should I care?
The database is not running any application. No users executing
anything, just some developers, some Oracle Education Trainers'
doing the labs, etc.
In the box I have the database and some tools, I mean,
Dev2k 1.3, 2.1.2, 6.0; Des2k 1.3, 2.1.2, 6.0; an Owas 3.0; a WEBDB;
and some setups uses in curses of Oracle Education.
I can have the db down for a while but I can't lose it...
Any suggestion? besides "Perform a voodoo dance" as Dr. Nikolay
Kumanov recomended recently?
- As you could see I'd like to join a list more developers oriented
Anyone heard about one?
From: "Michael Ray" <Michael.Ray_at_trw.com>
Date: Thu, 26 Oct 2000 12:44:33 -0700
Subject: Re: listener wont connect any more sessions and wontstop/start
Received on Thu Oct 26 2000 - 14:39:25 CDT
 |
 |