Skip to Main Content
Forums

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!

PL/SQL Forms on Apex

dandaman184Nov 6 2013 — edited Nov 6 2013

I am trying to transition PL/SQL pages that use forms and complex logic to Apex. I know how to get them to display using PL/SQL Regions, and use dynamic actions to call Javascript code when they are clicked already. But our PL/SQL prints out a form and originally when you hit the "Submit" button it sets a hidden action field to tell the code what the user wants to do (update, search, delete, etc) based on the button they hit and then submits the form.

But Apex appears to be removing the form when I call the PL/SQL region, does anyone have any advice? I verified that it removes the form through Firebug by the way,

Comments

fac586 
SACH!N-Oracle wrote:
In my apex report, even after setting the 'maximum rows per page' value to 20, I'm able to see all the 29 rows.
I'm using Universal Theme - 42 with tab based navigation.
Apex version i'm using is apex 18.1.
Is this a bug or do i need to set any other attribute in 18.1 release ?

What do you mean by "apex report"? Always specify clearly and unambiguously exactly which APEX region or component type you are referring to.

SACH!N-Oracle

It's an interactive report region.

Thanks,

Sachin

fac586 
SACH!N-Oracle wrote:
It's an interactive report region.

Read the online help for the Maximum Rows Per Page property:

Maximum Rows Per Page
Enter the maximum number to display in the Rows Per Page selector.

It would appear that it doesn't do what you think it does. Are you confusing it with the Maximum Rows to Process property in the Performance section of the property sheet?

1 person found this helpful
SACH!N-Oracle
Answer

Yes i'm aware of that property.

I'm not sure whether it's an apex or my browser's (Mozilla) bug, the 'Maximum Rows Per Page' count, which i had given for my IR region (maximum 20 rows per page) was not reflecting.

Later when i changed a few other IR region attribute values it worked for me. I'll explain.

Earlier the IR region 'Heading' property was set as 'Fixed To: Page'

I changed it to 'Fixed To: Region' and also gave the 'Maximum Report Height' value.

After changing the above attribute values and reloading the IR report page, to my surprise i found that the 'Maximum Rows Per Page' property was working (only 20 rows were displayed).

Later i reverted the IR region 'Heading' property as 'Fixed To: Page' and reloaded the page, i found the 'Maximum Rows Per Page' property is working.

Someway the issue got resolved, but as i mentioned earlier, still I'm not sure whether it's an apex or my browser's (Mozilla) bug or some sort of cache issue.

Thanks,
Sachin

Marked as Answer by SACH!N-Oracle · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 4 2013
Added on Nov 6 2013
#apex-discussions
1 comment
270 views