Solved

testing stored procedure

Posted on 2006-10-20
3
220 Views
Last Modified: 2012-08-13
I've written a mysql procedure that I am trying to run/test in a query analyzer and obtain the return value. The client is aqua data studio on windows.

In my mind, the code would be something like (i'm new to mysql):

call proc_myproc(@return,1);
select @test;

The intention is that the contents of @test would be shown in the results pane. However, running this returns the error:

 W (1): 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 ';
select @test' at line 1

How can I run more than 1 command in a single request like this? Can I do it outside of a procedure or function? Both lines evaluate/run fine in isolation.
0
Comment
Question by:pat333
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 14

Accepted Solution

by:
racek earned 75 total points
ID: 17776391
start with

CREATE PROCEDURE myprc (OUT return int)
BEGIN
....
END

then
CALL ..

se: http://dev.mysql.com/doc/refman/5.1/en/create-procedure.html
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question