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!

Oracle Apex Authorization is not working if we are using custom authentication sanity function

SharmaRishuJul 10 2018 — edited Jul 27 2018

Hi Expert ,

I have apex application which is launched from Oracle Fusion. Authentication is happening through jwt token. I am passing the jwt token from Oracle fusion to Oracle Apex and Authenticating the user. Now issue is i am not able use Authorization. I have created authorization and it is always failing. If i will create simple apex authentication , authorization is working. But if i am doing through custom authentication , authorization is not working. Please help me to fix this issue.

Kind Regards,

Harish Sharma

Comments

Trotty

Is it picking it up from your NLS preferences under Tools -> Preferences -> Database -> NLS

You can swap the length between CHAR and BYTE

Trotty

user12017111

Thanks. NLS preference under Tools -> Preferences -> Database -> NLS is set to BYTE.

So doesn't appear to be picking it from there.

thatJeffSmith-Oracle

Why would you want BYTES over CHAR?

With BYTES you risk not having columns 'wide' enough to store all of your data based on your characterset.

With CHAR you're guaranteed to always be able to fit that many characters in your column.

user12017111

Agree with your point, however we need it to be BYTE for following reasons:

BYTE is the default in Oracle and  our datamodel uses the default option.With CHAR columns all character columns could  become up to 4 times wider.

We are not worried about data not fitting in BYTE column as our application is designed with BYTE columns.

It would be a major re-testing exercise for us to test our application, which is already in production use at several customer sites.

thatJeffSmith-Oracle

I think we can get a 'fix' out to you, stay tuned.

Dermot ONeill-Oracle
Answer

HI,

If you email me I can provide a modified extension to use the BYTE unit in CHAR and VARCHAR2 columns.

My email address is my firstname.lastname@oracle.com

Regards,

Dermot ONeill

SQL Developer Team

Marked as Answer by user12017111 · Sep 27 2020
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 24 2018
Added on Jul 10 2018
2 comments
497 views