Schemaname on package?

[unihamburg]

Hi there

I create a package (or standalone proc/func) as follows:
"CREATE OR REPLACE PACKAGE [SchemaName].[pck_Name] ..."

But the schemaname disappears and remains only [pck_Name], after I execute it and from object browser open it:
"CREATE OR REPLACE PACKAGE [pck_Name] ..."

Can anyone explain to me, why?

thanks

 

[Claus Pedersen]

You can create objects in two ways:
When logged on the the current schema, you can write "create package tester as ..."
When logged on as another schema, you can write "create package mySchema.tester as ..."

When PL/SQL Developer opens a package via the browser, it opens a package that belongs to the current schema, and there is no need to prefix it with schema name, as it belongs to the current schema.

This is the way PL/SQL Developer is designed. You can always see the schema name for the package in the window title.

If you change schema in PL/SQL Developer, and try to compile a package on another schema, you will get the warning "This object is owned by a different user. Continue compilation anyway?"