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
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-fo...
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
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:
Hi,
Were you able to find a solution to this?