Toad World® Forums

AUTHID clausule and code explorer problems


#1

Hi!

I have 2 more things with pl/sql editor.

So, when you have authid clausule in package aspecyfication, code explorer does not lists variables and types list.
The other thing is that ctrl+space does not work for variables declared in spec. (of course when you have authid clausule).
Watch attachement, there are two almost identical packages, one of them has AUTHID DEFINER clausule. Check this things, i wrote about.

Regards Piter


#2

I can’t attach files!!! File is uploades succesfully, afther POST i can’t see it…
Then paste ddls:
CREATE OR REPLACE
PACKAGE test AUTHID DEFINER
IS

subtype Tparams is all_tables%rowtype;
a constant number:=1;

END TEST; – Package spec
/

CREATE OR REPLACE
PACKAGE BODY test
IS

procedure start1(x in Tparams) is
begin
null;
end;

END TEST;
/

CREATE OR REPLACE
PACKAGE test_
IS

subtype Tparams is all_tables%rowtype;
a constant number:=1;

END TEST_; – Package spec
/

CREATE OR REPLACE
PACKAGE BODY test_
IS

procedure start1(x in Tparams) is
begin
null;
end;

END TEST_;
/


#3

attachement ,Once again

:wink: atachements works now

Message was edited by: piortek
test_ddl.zip (357 Bytes)


#4

Thanks Piter, I’ll check this out this morning…

Jaime


#5

Thanks for the script Piter… made it easy to see your first issue!!
I’ll log an enhancement request to have the Code explorer show this information.

I found that the Ctrl + Space works if you do it twice… the first one ads a space and the second one launches the lookup That’s a bit quirky!!
I’ll get this checked out too.

Thanks for your feedback…
Jaime


#6

Hi Jaime!
Nice you found another thing with ctrl+space, i had mistake i had to write ctrl+click, not ctrl+space !!!
So when ctrl+click don’t work for variables in spec, when AUTHID clausule is included.