# SQl Nav 7.4.0.62 standard edition: can't see parameters

**URL:** <https://forums.toadworld.com/t/sql-nav-7-4-0-62-standard-edition-cant-see-parameters/41077>\
**Category:** SQL Navigator\
**Created:** [June 20, 2018, 9:07am UTC](https://forums.toadworld.com/t/sql-nav-7-4-0-62-standard-edition-cant-see-parameters/41077 "2018-06-20T09:07:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![amian](https://avatars.discourse-cdn.com/v4/letter/a/f1d935/32.png) [@amian](https://forums.toadworld.com/u/amian)\
**Post date:** [June 20, 2018, 9:07am UTC](https://forums.toadworld.com/t/sql-nav-7-4-0-62-standard-edition-cant-see-parameters/41077/1 "2018-06-20T09:07:28Z")

</div>

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

 ![1055.shows.gif](https://global.discourse-cdn.com/quest/original/2X/7/77e1a43b9e8175de78b72acc70cca8e149212ac3.gif)

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

 ![1055.noshow.gif](https://global.discourse-cdn.com/quest/original/2X/7/7d7fc85721f617ecd69270d8c99f69b80f17bb95.gif)

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](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.

---

<div class="post-metadata">

**Author:** ![amian](https://avatars.discourse-cdn.com/v4/letter/a/f1d935/32.png) [@amian](https://forums.toadworld.com/u/amian)\
**Post date:** [June 26, 2018, 9:52am UTC](https://forums.toadworld.com/t/sql-nav-7-4-0-62-standard-edition-cant-see-parameters/41077/2 "2018-06-26T09:52:05Z")

</div>

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
