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!

Getting error: Schema did not match. If the table schema is altered on the target database.

User_2XXOFOct 10 2022

Hi we are trying to execute sql statement to connect oracle db(SELECT GRANTEE FROM sys.DBA_ROLE_PRIVS where GRANTEE='XDB' and rownum < 2 ORDER BY GRANTEE or SELECT * FROM DBA_SYS_PRIVS ORDER BY GRANTEE) from jdbc using Servicenow but getting below error: and null output
image.pngimage.png
but i was able to get the output with the below sql statement(SELECT * FROM sys.DBA_USERS ORDER BY USERNAME).
image.pngMay i know what this the first error we are getting is it to fix from servicenow or access issue with db.
Thanks

Comments
Post Details
Added on Oct 10 2022
1 comment
370 views