SQL stored procedure
I am trying to run a SQL stored procedure within Workbench and continually get an error stating "Input string was not in a correct format". The input string is as follows:
EXEC Media_DeliverSearch_Update @StartDate='10/1/2016', @EndDate='10/16/2016'
Any ideas on the proper syntax for calling a stored procedure with date inputs for parameters?
Thanks.
Comments
-
Errors you get in workbench for ODBC connections should be the errors returned from the database, not workbench, so you'd probably want to consult your ODBC driver docs or database docs for specifics.
It could be something like:
exec procedure_name (startdate,enddate);
or
call schema.procedure_name (startdate,enddate);
or
something entirely different, depending on how the sytem is set up.
Domo's workbench squad is very helpful also. You can reach them through the helpdesk line.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@mattdonovan, did @AS's reply help you out?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive