Skip to Main Content

SQL & PL/SQL

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!

"ORA-20401:Reject By Dbsec" error in PL/SQL but not in SQLPLUS

User_WX2XFApr 27 2021

The problem is:
When we execute 'create table' in PL/SQL , the filedname with double quotes(") and this filedname ends with 'USER', then error message "ORA-20401:Reject By Dbsec" is displayed .
p1.pngbut if the fieldname is not ends with 'USER' or delete double quotes of fieldname, then SQL can be executed successful!
However, it is strange : All of uppon SQL statement s can be executed in SQLPLUS!
p2.pngKey Words: Error only in PL/SQL in some conditions
filedname with double quotes
fieldname ends with 'USER'( no ends, like 'ABCUSER01' is alway OK)

Comments
Post Details
Added on Apr 27 2021
11 comments
586 views