Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ORA-44004: invalid qualified SQL name #1211

Open
DiegoMi opened this issue May 19, 2022 · 2 comments
Open

ORA-44004: invalid qualified SQL name #1211

DiegoMi opened this issue May 19, 2022 · 2 comments
Assignees

Comments

@DiegoMi
Copy link

DiegoMi commented May 19, 2022

Hello,
we are getting this error whenever we try to run tests from a schema which has a name starting with a number.
We have created a package PKG1 on a schema with name 01234567A (these names are only as example). We have created a test package PKG1_TEST in that schema too.
When we try to execute ut.run(); we get this output:

ORA-06512: at "SYS.DBMS_ASSERT", line 315
ORA-06512: at "UTP3.UT_UTILS", line 899
ORA-06512: at "UTP3.UT_ANNOTATION_MANAGER", line 73
ORA-06512: at "UTP3.UT_ANNOTATION_MANAGER", line 188
ORA-06512: at "UTP3.UT_ANNOTATION_MANAGER", line 314
ORA-06512: at "UTP3.UT_SUITE_MANAGER", line 432
ORA-06512: at "UTP3.UT_SUITE_MANAGER", line 455
ORA-06512: at "UTP3.UT_SUITE_MANAGER", line 552
ORA-06512: at "UTP3.UT_RUNNER", line 139

ORA-44004: invalid qualified SQL name

If we try another schema, let's say X0123456A, tests run fine.

Our version of utplsql is 3.1.12, installed in its own schema utp3, and oracle version is Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production.

Thanks for your help.

@jgebal
Copy link
Member

jgebal commented May 19, 2022

So your schema names are actually created as quoted identifiers.
You cannot do
select * from 12345ABC.SOME_TABLE;
You have to do:
select * from "12345ABC".SOME_TABLE;

Currenyly utPLSQL does not support quoted identifiers.

As a workaround, you could try this:

alter session set current_schema=12345ABC;
ut.run('test_pkg1');

@jgebal jgebal self-assigned this May 24, 2022
@jgebal
Copy link
Member

jgebal commented May 24, 2022

@DiegoMi
Does that work for you?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants