My Oracle Support Banner

When Configuring Data Access for a Database View an Error Occurs, Error (0x90430001): ExecuteReaderException: ORA-00936: missing expression (Doc ID 1078517.1)

Last updated on JULY 27, 2022

Applies to:

Oracle Utilities Energy Information Platform - Version 04.53 and later
Information in this document applies to any platform.

Symptoms

When configuring Data Access for a Group or User in EIP Security, an error occurs when trying to edit access for a custom view.

Error (0x90430001): ExecuteReaderException: ORA-00936: missing expression



Example

An error occurs when configuring Groups/Users > Data Access for a View (e.g. TESTEXUPLOADALLOCVW).

Steps :

  1. In EIP Security > Data Sources "PWRLINE" > Data Access
  2. Choose the custom view TESTEXUPLOADALLOCVW from 'Tables' and select 'Add' to 'Direct Tables'.
  3. Go to Groups and select a group to edit
  4. Choose "Data Access" for the group
  5. Choose the data source and view, then click Edit next to Data Privileges
  6. Choose "Test Access" or try to make changes to access (SQL editor, etc).
  7. Error will be displayed, Error (0x90430001): ExecuteReaderException: ORA-00936: missing expression

Cause

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
Symptoms
Cause
Solution


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