Toad World® Forums

executing stored proc syntax

declare @x numeric;

exec prse_f18_next_pred_no 1374, 1731, @x output;

select @x;

I’m trying to execute a stored proc as shown below. However, I am receiving a generic error msg. Can somebody pls tell me what I am doing wrong? thx in advance!

What is the error and what type of database are you connected to? If it is SQL server or Sybase, do not use ODBC conneciton type. Use our native connections.

Debbie

Dear Debbie,I have Mysql 5.5.15, and Toad for Data analysis 2.7. I have a simple automation script which contains connection to mysql, plus a sql scripts contains one line only: call my_proc()when I run the sql script at the editor it works fine, but with the automation it failed and gives me “Timestamp Message9/3/2011 3:31:51 PM Execution Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘D:\toad_script_files\sql_call_prcdr.sql’ at line 1”Please What would be the problem.