Oracle migration script issue with Callback URL value as NULL

[CrowleyRajapakse]

Description:

In oracle empty strings '' are considered same as null. Therefore, when executing following query, UPDATE IDN_OAUTH_CONSUMER_APPS SET CALLBACK_URL='' WHERE CALLBACK_URL IS NULL / It doesn't change anything, the value remains null. Therefore, users can't update the keys in application keys page since callback value is "null" still in migrated apps.

ref: https://stackoverflow.com/questions/49678159/insert-empty-string-in-oracle

[HiranyaKavishani]

@shilmyhasan Could you please close the issue if this is solved ?

[shilmyhasan]

@HiranyaKavishani This particular query is available only when migrating from 3.1.0. I will check on this during 3.1.0 to 4.1.0 migration.

[shilmyhasan]

Hi Team,

The issue is resolved.

Thanks