Skip to Main Content
Forums

Oracle Forms

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!

Unable to connect forms to DB user

user8786417Apr 24 2014 — edited Apr 25 2014

Hi,

I am new to forms, and during the connect stage (during the wizard) i entered my username/password and the database name but get REP-501 error, i use the same credentials to make the connection via sql plus and it works fine.

Any ideas?

Many thanks in advance.

Rgds,

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 May 23 2014
Added on Apr 24 2014
#connection, #forms, #moved-from-devops, #sql
7 comments
3,063 views