Michael Virnstein
Member
1. If i use F5 to explain a sql from a plsql program (package, function, procedure, trigger, ...), the program is not owned by the connected user and tables in the sql are not fully qualified (missing schema name), the explain window gives me an ORA-00942 table or view does not exists.
This results in
a. the pl/sql-variables are not converted to host variables
b. the into clause is not commented out
I would expect PL/SQL-Developer to be smart enough to add the schema name of the program if it is missing in the sql.
2. this problem is similar to 1.
if i hold the ctrl-key and i click on a table/package/function/procedure name in an sql, the according window is opened. This does not work, if i click on such a name in a plsql program, that is not owned by the connected user and the schema name is missing.
I also would expect PL/SQL-Developer to be smart enough to add the schema name of the plsql program, if it is missing for the table/package/function/procedure that i click.
This results in
a. the pl/sql-variables are not converted to host variables
b. the into clause is not commented out
I would expect PL/SQL-Developer to be smart enough to add the schema name of the program if it is missing in the sql.
2. this problem is similar to 1.
if i hold the ctrl-key and i click on a table/package/function/procedure name in an sql, the according window is opened. This does not work, if i click on such a name in a plsql program, that is not owned by the connected user and the schema name is missing.
I also would expect PL/SQL-Developer to be smart enough to add the schema name of the plsql program, if it is missing for the table/package/function/procedure that i click.
