My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.