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!

How do you automatically initialise collections?

carl0021Nov 22 2021

With the scenario below, the FOR LOOP will fail (... collection initialisation ...) if there are no records to delete.
What is the best way to deal with this without changing the delete-bulk collect statement?
... apart from wrapping the for loop in an exception block...

CREATE TABLE t_emp(id NUMBER, fname VARCHAR2(50));
DECLARE
TYPE t_emp IS TABLE OF employee%ROWTYPE;
c_emp t_emp;
BEGIN
DELETE FROM emp
RETURNING id, fname BULK COLLECT INTO c_emp;
FOR i IN 1..c_emp.COUNT LOOP
dbms_output.put_line (' rows found');
END LOOP;
END;

Thanks

This post has been answered by User_H3J7U on Nov 22 2021
Jump to Answer

Comments

Rajagopalan-Oracle
Answer

Java JNLP is not certified / supported to work with Forms 10g --->
Forms 11.1.2.2 client and Java Web Start, JNLP (Doc ID 2081779.1)
Running the Oracle Forms applet via Java Web Start and/or JNLP is ** NOT ** supported in Forms 11.1.2.2. However, Web Start and/or JNLP is supported from Oracle Forms version 12.2.1.
More details about the 12.2.1 forms client deployment options can be found in Document:2066505.1

Marked as Answer by Suresh Sangaran-Oracle · Sep 27 2022
User_WPTHP

Thank you for your comments Sir.
I try to run my form in Java web start through JNLP File its works fine my form is running successfully but the report is not running, when on internet explorer i run my form and report both working fine but in JNLP File only forms work.

Jiju Mathew

I try to run my form in Java web start through JNLP File its works fine my form is running successfully but the report is not running, when on internet explorer i run my form and report both working fine but in JNLP File only forms work.

I also facing same issue. please help me.

1 - 3

Post Details

Added on Nov 22 2021
8 comments
109 views