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.
Per visualizzare gli articoli della Knowledge Base di livello avanzato, è necessario aver effettuato l'accesso e disporre di un contratto di manutenzione in essere.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center