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.


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


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