You are viewing limited content. For full access, please sign in.

Question

Question

Stored Procedure Not Showing up in Dropdown

asked on May 20, 2014

I've created a stored procedure on a database and in Forms have added the database as a datasource. I can query the table in the database, I can query any Stored Procedures which already existed, but I cannot use a stored procedure I just created.  In the Data Sources it shows stored procedure I created but it is not available via the dropdown in forms.  It is called "sp_AllApprovers" in the screenshot below. Do I need to do something to refresh the options available in the dropdown or is something missing in my stored procedure that is required for it to show up in the dropdown?

 

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on May 20, 2014

Does the same issue occur if you use a different web browser? There was a similar issue where Forms wouldn't detect any new tables added to an already configured data source. Please make sure to apply the latest Forms patch (must be on 9.1.1 already) from KB 1013483 and see if the issue still occurs.

0 0
replied on May 20, 2014

It was an issue with IE.  I switched over to Chrome and it is working fine now.  I will try to get us upgraded from 9.1 to 9.1.1 when I get a chance.  Thanks for the help.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.