JDBC Paragraphs are not being considered while running the queries in Studio
(Doc ID 2797251.1)
Last updated on AUGUST 10, 2021
Applies to:Oracle Financial Services Crime and Compliance Management Studio - Version 8.0.8 and later
Information in this document applies to any platform.
User encountered below error message while running the jdbc paragraph
Steps to reproduce :
Step 1 : Login to Studio application
Step 2 : Execute JDBC paragraph
Step 3 : Check for the results and try for the below scenarios
Issue 1 : In UI are you able to see consistent permission for the users
Issue 2 : Go back option is working once the notebook is open - able to goback to notebooks ?
Issue 3 : Update role is working for users and create role or group is working fine? and its showing notebooks and pagination is proper ?
Expected result :
Paragraph must be executed without any issue and produce the results.
Actual result :
Paragraph executed with below error.
Issue Encountered :
The error message is Error Msg = ORA-00936: missing expression
Roles are modified recently.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document