I have run into a problem where when I go to run a procedure it does not show parameters:
Procedures are listed alphabetically, any procedure with name starting from OR, I am unable to see the parameters when I go to run the procedure.
Example:
Take this code:
PROCEDURE dummy2
(year IN number)
IS
-- Purpose: Briefly explain the functionality of the procedure
-- MODIFICATION HISTORY
-- Person Date Comments
BEGIN
null;
END;
So I hit F9 or the run arrow and it will bring me to the run screen and this will show 1 parameter year where I can type a number
same code but change the name to something after OR:
PROCEDURE organisation
(year IN number)
IS
-- Purpose: Briefly explain the functionality of the procedure
-- MODIFICATION HISTORY
-- Person Date Comments
BEGIN
null;
END;
When I go to the run screen, I don't see any parameters
I thought this was because of number of procedures, but it is not.
Example:
Procedure names(I have over 500 procedures):
dummy2
login
oie_login
organisation
wave
oie_login shows parameters, but organization and everything after does not.
So I create another procedure oie_organ:
dummy2
login
oie_login
oie_organ
organisation
wave
It is still organisation where it will start to not show procedures, I can add any number (I added 10),
same code as above, only the procedure name is different:
dummy2
login
oie_login
oie_organ
oq1
oq2
oq3
oq4
oq5
oq6
oq7
oq8
oq9
oq10
organisation
wave
oq10 shows parameters, organisation and every procedure after doesn't.
We have 2 people on 7.4 and it happens on both.
This does not happen on SQL 6.5 or 7.2, All procedures if they have a parameter will show a parameter.
I tired searching for this issue, but I was not able to find anything, maybe I am wording this incorrectly.
Any help with this would be greatly appreciated,
Thank you.
EDIT: I found this: https://support.quest.com/sql-navigator-for-oracle/kb/230745/when-executing-procedure-not-seeing-input-parameters
But I can't view that article, but my issue is not with all procedures.