Apex ORA-44004: invalid qualified SQL name error



5 hours spent trying to debug this.  I am starting of in the wonderful world of Apex and need a custom login.


So I read the books, watched the Youtube clips, all of which did not really cover Apex 4.1, but hey there can not be that much difference.

Well there is!!!!!!!!!

The code for the login I will post separately but just to let you know where you need to add the function name and in what format.

My function is in a package ans is called pkg_auth.authenticate.

And here is where you put it.

Shared components –> Authentication Schemes

Choose the authentication method in place and change to below



Note the place it is held and the format.

You place it in the Authentication Function Name and as you can see it is call pkg_auth.authenticate.

You will see many references that would indicate that you need to enter

return pkg_auth.authenticate

return pkg_auth.authenticate;

or pkg_auth.authenticate;

You do not


Good luck with any development












3 Comments on “Apex ORA-44004: invalid qualified SQL name error”

  1. Naveen says:

    Thanks , this worked for me

  2. dana says:

    Thank you a lot!!!!!!!!!! Your post helped me very much!! I spent a lot of time also trying to configure the custom authentication!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s