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.
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center