Database: Stored Procedure Not Showing in Database Import

Document created by thanh_n88 Employee on Apr 23, 2018Last modified by thanh_n88 Employee on May 21, 2018
Version 2Show Document
  • View in full screen mode

Scenario 1: Specifically for oracle databases, if you are using the database import function and your stored procedure is not showing up or the stored procedure is in a package and not showing up

Cause: A filter in the oracle driver filters the stored procedure from the list 

Solution: You can either add a parameter to the stored procedure (the stored procedure doesn't have to actually use the parameter) or use the program command shape to run the stored procedure instead

 

Scenarios 2: Your stored procedure shows up in the import wizard but you get the error, "No columns/parameters found for the procedure"

Cause: Your stored procedure does not have a parameter and a profile will not be created for stored procedures without parameters. Keep in mind, the database connector requires the response to be provided via a returned result set

SolutionYou can either add a parameter to the stored procedure (the stored procedure doesn't have to actually use the parameter) or use the program command shape to run the stored procedure instead

Attachments

    Outcomes