Toad World® Forums

SQl Nav 7.4.0.62 standard edition: can't see parameters


#1

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.


#2

The article I had linked in the edit had the answer.

My co-worker was able to see the article which I did not have access to:

  • Title
    When executing procedure, not seeing input parameters

  • Description
    When executing a procedure, it is not showing the input parameters for the procedure. It brings up the window where they would be entered, but there are no parameters listed.

  • Resolution
    WORKAROUND:

  1. Close all sessions.

  2. Open login window and change status of “Enable using DBA view”, so it is disabled.

  3. Connect and execute procedure.

STATUS:
Waiting for a fix to be implemented in a future release of SQL Navigator.

  • Defect ID
    SQLNAV-2208