This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Not able to access Oracle stored procedure list from the Pre and Post SQL Statement feature in the Input Tool.
Alteryx Designer, Server
To get the Oracle stored procedure list in the Pre and Post SQL Statement feature, the Designer runs the following query:
SELECT OBJECT_NAME FROM USER_PROCEDURES WHERE OBJECT_TYPE = 'PROCEDURE'
Because the Designer queries USER_PROCEDURES, you will need to use the Oracle User that owns the stored procedure in the Input Tool Oracle connection in order to see the list or be granted rights to read from USER_PROCEDURES. Please consult with your DBA for grants..
The stored procedure list is just for convenience. You can type in the stored procedure directly into the SQL Editor tab of the Pre and Post SQL Statement window. We use "CALL" to execute stored procedures with no semi-colon.