Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is the alternative for 'for loop' ?

kalyan vedagiriJul 7 2021 — edited Jul 7 2021

i want to update the table by using a decrementor and row id as below.
my_line_count := 0;
select count(*) into my_line_count from emp where empno = in_empno
For line_rec in ( select rowid from emp where empno = in_empno order by countline desc)
loop
update emp set countline = my_line_count where ROWID = line_rec.ROWID;
my_line_count = my_line_count -1;
end loop;
This procedure will be called for suppose 314 times, by another procedure( based on count in emp table i:e for each row);

Before data is like
select countline from emp where empno = in_empno ;
countline
1
1
1
1
1
-- so on

Expected result
select countline from emp where empno = in_empno ; (For exapmle there are 314 rows)
countline
314
313
312
311
.
.
.
3
2
1

Is there any way to perform above logic without loop?

Comments

Hi Penny,

This is a known issue.  Please connect with me directly for the fix.

Thank you,

Sherry

Hasnur Ramadhan

Hi Sherry,

Error in .ore.odm.chk.dbver() : DB version 19.0 is not supported

---

How to connect with you directly to get the fix?

Currently I am doing a POC using ORE Oracle 19c for a prospective customer.

TIA.

Hasnur R.

Hasnur Ramadhan

Solved with Oracle R Distribution 3.6.1, and re-download OML for R library 1.5.1 (the latest one, dated August 24, 2020).

Sherry Lamonica-Oracle

Thank you for the update, Hasnur. Oracle R Distribution 3.6.1 is now available.  Refer to this blog post for details and a pointer to installation instructions with Oracle Machine Learning for R 1.5.1, which contains the fix for the OREdm bug discussed in this thread.

Sherry

1 - 4

Post Details

Added on Jul 7 2021
9 comments
1,436 views