Code Assistant with parameter lists

hbar

Member²
I've been seeing a weird thing for a while now, but today it hosed me, so I'm registering my complaint. :D

I have a package with several procedures. When I begin entering the parameters to a function, the code assistant messes up 2 things: first, it gives me the parameters out of sequence. Second, it does not show me all the parameters. The function is not overloaded, and the missing parameters do not have default values or anything tricky like that. It happens on procedures as well as functions, but it does not happen with all my procs/fns, and it's not isolated to this one package.

Has anybody else seen this?
 
I think this may be an Oracle issue. What happens if you use the DESCRIBE command in SQL*Plus at the same time that this fails in PL/SQL Developer?
 
Stupid Oracle. SQL*Plus showed the same thing. On a whim made a small change, recompiled, changed back, and recompiled again, and the problem went away.

grrrr
 
Back
Top