I'm trying to add a custom process to a tabular form for when I create a new row. But when I hit my button it comes back with the error:
ORA-01410: invalid ROWID
ORA-06510: PL/SQL: unhandled user-defined exception
/* Process execute when hitting the Custom Tabular Button */
FOR i in 1 .. apex_application.g_f01.count LOOP IF apex_application.g_f07 ( apex_application.g_f01(i) ) IS NOT NULL THEN :P38_VALREF := apex_application.g_f07 ( apex_application.g_f01(i) ); END IF; END LOOP;
The idea is when creating a new row I only have to enter one of the fields and when I hit my custom button it will run a process that will insert a new record into the table. But when I hit the custom button it gives me the above error.
Thanks in advance.
g_f01 has the rowid, g_f07 has a parcel id, which is a 6 digit number.
The idea is when adding to the table I only have to enter a parcel id, when I click submit it will run a process that automatically grabs the data for the other columns.
I see. I don't think you need a custom process for that. With some adjustments you can use the super LOV plugin from Skill Builders. Below you'll find a link to the plugin. Also I've added a blog post from Damien Antipa, who describes how he used the plugin to set tabular form items.
The plugin: - Item Plugin - SkillBuilders Super LOV
Post on how to tweek: APEX Plugin Super LOV for Tabular Form by Damien Antipa