Why does some package or procedure names in the Schema Browser | Source Tab have double-quotes around its name and others do not have it?
If a package or procedure was created with double-quotes around its name, the Schema Browser will show it just like that. If a package or procedure was created without the double-quotes around the name, then the Schema Browser will also not show any double-quotes around the name. Placing double-quotes around the name also preserves the format of the name i.e. capitalized or non-capitalized.
The source code names below are displayed in the Schema Browser just like how the create script is run.
1)
CREATE OR REPLACE PROCEDURE MAUI."dbms_output_test" (var IN NUMBER)
IS
BEGIN
DBMS_OUTPUT.put_line ('Customer number is ' || var);
END "dbms_output_test";
/
2)
CREATE OR REPLACE PROCEDURE MAUI.dbms_output_test (var IN NUMBER)
IS
BEGIN
DBMS_OUTPUT.put_line ('Customer number is ' || var);
END dbms_output_test;
/
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center