Unable to Execute Stored Procedure using ODBC connection (NetSuite)

[cvalteryx]

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

[TheOC]

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

[cvalteryx]

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:

[adam_rafael_18]

Hi, 

Were you able to find a solution to this?