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 APRIL 07, 2010

Applies to:

LODESTAR EIP - Version: 04.53 - Release: 4.5
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms