Unable to Change Mode of Self parameter using P/L SQL Developer

[dshort_mn]

MEMBER FUNCTION GetTag(SELF IN OUT NOCOPY TmpDataObj
,pStrTag IN VARCHAR2)
RETURN NUMBER,

This is the correct syntax for changing the mode of the Self variable in oracle and will compile fin on another tool ( toad ) but will throw an error when attemped in pl/sql developer. the error it it throws is PLS-00382 expression is of wrong type. I was wondering why?

 

[Marco Kalter]

Can you check if you have enabled the "Safe compilation" option (Tools > Preferences > Program Window). If it is enabled, disable it and try again.

 

[gad]

Hello Marco,
I'm having the same trouble. I saw your answer to this question and did as you recommended.
It did solve the problem, but I would like to maintain the 'Safe compilation' flag.
Can you fix this?

TIA,
gad

 

[Marco Kalter]

Yes, we'll fix this.

 

[jlathion]

Hello Marco,

I am facing the same issue even by using version 11.0.2. 1766. When will it be fixed ?

Thanks.

 

[BRi-17]

Hello Marco,

we have a similar issue by using Pldev version 15.0.3.2058 (64 bit).

We have package functions with overloading as follows:

CREATE PACKAGE BODY ...
FUNCTION fnc_get_tab_comp_desc(p_dckt pkg_pfp_api.TY_PFP_VTABLES) RETURN VARCHAR2 IS
BEGIN
RETURN pkg_pfp_vtables.fnc_get_tab_comp_desc(p_dckt => p_dckt);
END fnc_get_tab_comp_desc;

FUNCTION fnc_get_tab_comp_desc(p_tab_name_or_alias VARCHAR2) RETURN VARCHAR2 IS
BEGIN
RETURN pkg_pfp_vtables.fnc_get_tab_comp_desc(p_tab_name_or_alias => p_tab_name_or_alias);
END fnc_get_tab_comp_desc;

... and get PLS-00386 in Program Window during compilation.

In command window compilation works fine and also when we deactive checkbox "safe compilation" in program window.

Could you please fix it?

Regards, Berit

 

[Marco Kalter]

We'll check it out. This seems like an issue with the "Safe compilation" option, so the only workaround at the moment is to disable it.