My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Clinical - Version 4.5.1 to 4.5.3 [Release 4.5.1 to 4.5.3]
Information in this document applies to any platform.
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


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.