Procedure does not exist error

[Luc]

When rightclicking on a procedure and select to test or describe this procedure we get the following error : Procedure "XXX" within package YYY does not exist.

This is not the case for all packages.

Tested in both PL/SQL versions 6.0.3.893 and 6.0.4.906

Worked fine in version 5.0.3.527

 

[KovacsTamas]

Try to recompile invalid objects.
Is it ok?

 

[Luc]

Object is not invalid ( and we already tried to recompile already )

We tried to access the same object with both PL/SQL version 5 and version 6. V5 works fine, V6 doesn't ...

 

[Marco Kalter]

Can you send me this package?

 

[Luc]

Marco,

Did some further testing and found the cause of the error : if the function or procedure is between " then we get the error.

If we create a package like this :

CREATE OR REPLACE PACKAGE "STG_XXX" AS
PROCEDURE "STG_TRUNCATE_TABLES" ;
END "STG_XXX";

then we get the error while testing or describing. If we create the same package as :

CREATE OR REPLACE PACKAGE "STG_XXX" AS
PROCEDURE STG_TRUNCATE_TABLES ;
END "STG_XXX";

( so we remove the " for the procedure name ) then we can test/describe without any error. This seems a bug in PL/SQL version 6 to me ...

Regards,

Luc

 

[Marco Kalter]

Thanks, we'll fix it.