1

I'm connecting to a new Oracle database with Toad.

If a create a procedure like:

create or replace procedure MyProc...

After I compile it, the name automatically is changed to

 SchemaName.MyProc

This doesn't happen in other Oracle databases where I'm doing the same test.

Is that a database configuration?

Thanks!

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Yuki NET
  • 11
  • 2
  • Definitely not a database setting - this will be a setting in TOAD somewhere – Connor McDonald Jan 20 '23 at 01:34
  • Are you sure the name is `SchemaName.MyProc` and not `MyProc` in schema `SchemaName.MyProc`? A literal dot in a procedure name is poor style. – Bohemian Jan 20 '23 at 05:14
  • Each procedure (function, table, index etc.) belongs to exactly one schema. Regardless of the fact if you see it or not. If you are in the schema `myschema`, then `objectname` and `myschema.objectname` are semantically equivalent. What you see in IDE as procedure definition is generated by the IDE and have a chance to be adjusted to include the schema or not. At least in db https://stackoverflow.com/questions/6782278/generating-ddl-script-for-object-without-schema-name-baked-in-using-dbms-metadat – astentx Jan 20 '23 at 05:52

1 Answers1

3

If you open TOAD settings, you'll find it here:

  1. Editor - Open/save
  2. Object loading
  3. if set to "Always include", you'll see owner name (SCOTT in my example)
  4. if you set it to "Never include", owner name isn't visible any more

enter image description here

Littlefoot
  • 131,892
  • 15
  • 35
  • 57