When executing a Function in the database, whilst connected with a Proxy user, if there is a table in the database with the same name as the Oracle schema name, the error 'ORA-6550' appears.
If this table doesn't exist, there is no error.
=========================
Steps to replicate:
1. Create a proxy user:
CREATE USER PROXY_USER IDENTIFIED BY PASSWORD ;
ALTER USER EXISTING_USER GRANT CONNECT THROUGH PROXY_USER ;
Then check if the user proxy has been successfully created.
select * from proxy_users;
2. Log into SQL Navigator by PROXY_USER in the following way:
USERNAME => PROXY_USER[EXISTING_USER]
password => password_PROXY_USER
3. Create a function:
CREATE OR REPLACE
FUNCTION f_function
RETURN VARCHAR2 IS
BEGIN
RETURN 'OK';
END;
/
4. Create a table with the same name as the schema name (it can be the most basic table)
5. Once that table is made, execute the f_function with the proxy user and the issue will appear.
6. Drop the table with the same name as the schema and when you execute the Function again, it works.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center