Error In Exec opa_ddl.grantConnectThroughPool(<username>) When Name Includes "-" (Doc ID 782846.1)

Last updated on MARCH 02, 2009

Applies to:

Oracle Clinical - Version: 4.5.0 to 4.5.3
This problem can occur on any platform.

Symptoms

You are upgrading Oracle Clinical (OC) from 4.5.0 to 4.5.3. During the user accounts migration, attempting to execute the following step in SQL*Plus the system presents the following error:

SQL> exec opa_ddl.grantConnectThroughPool('TEST_1-1');

BEGIN opa_ddl.grantConnectThroughPool('TEST_1-1'); END;

*
ERROR at line 1:
ORA-00922: missing or invalid option
ORA-06512: at "OPA.OPA_DDL", line 37
ORA-06512: at "OPA.OPA_DDL", line 448
ORA-06512: at line 1

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