Unable to Execute Stored Procedure using ODBC connection (NetSuite)

Question

Hi All,

I need to execute Stored Procedure using ODBC connection (NetSuite). But, I'm getting below screen:

Can you please let me know how to execute stored procedure in Alteryx?

TIA

adam_rafael_18 · Answer

Hi,

Were you able to find a solution to this?

cvalteryx · Answer

Hey @TheOC ,

I saw the thread and still I get below error:

Even if I write EXEC <SP Name> in SQL editor. Can I know how can I view its result? Is it possible to use a 'pre SQL statement' without a Table/query? I get below error:

TheOC · Answer

hey @cvalteryx

I found this thread that might be some help by searching the error message on the community:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Stored-Procedures-are-not-Supported-for-this-type-of-connection/td-p/411025
it looks like you can use the 'pre SQL statement' to execute the stored procedure using the following:

exec your_stored_procedure

Hope this helps,
TheOC