Skip to Main Content

APEX

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!

Apex Custom Insert process for tabular form

Irha10Feb 2 2015 — edited Feb 4 2015

Apex 4.2

Oracle 11g R2

Hi, I am using tabular form but not sure about the custom process if using wizard to create a tabular form.

I have a tabular form based on the following.

select

"ROWID",

"F_ID

"M_DATE",

"RM_TYPE",

"TEXT1",

"TEXT2",

from "TEST_TAB"

WHERE F_ID= :P30_F_ID

I made a custom process as I need it.

BEGIN

   FOR i IN 1 .. apex_application.g_f01.COUNT   -- what value should i use here??? please!                     

   LOOP

  

         INSERT INTO TEST_TAB

                     (F_ID , M_DATE,RM_TYPE,TEXT1,TEXT2

                      )

              VALUES (apex_application.g_f01                      

                      );

    END LOOP;

END;

I does not work.

Thank you.

T

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2015
Added on Feb 2 2015
10 comments
2,011 views