How to fetch result of stored procedure ?

[sagarnikam123]

 

I am using Ubuntu 12.04, iReport-4.7, MySQL database, mysql-jdbc driver

I write stored procedure in MySQL

DELIMITER //CREATE PROCEDURE first()BEGINselect * from person where id in (11,22,33);END //DELIMITER;

which return id & name as fields & calling it from iReport

select id+1,name from (call first)

gives me syntax error,

 

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'call first)' at line 1

but when I run call first in query executor,no error

How should I get required field for further calculations ? Does this is possible in MS-SQL ?

 

[ernestoo]

Syntax is messed up in the post, can you see if you can remove the HTML docration or whatever is going on?

[djohnson53]

Fixed the posting problem.

[djohnson53]

Help with MySql Stored Procedures:

• You may find the Stored Procedures User Forum of use when working with stored procedures and functions.

• For answers to some commonly asked questions regarding stored routines in MySQL, see Section B.4, “MySQL 5.0 FAQ: Stored Procedures and Functions”.

• There are some restrictions on the use of stored routines. See Section E.1, “Restrictions on Stored Programs”.

• Binary logging for stored routines takes place as described in Section 18.6, “Binary Logging of Stored Programs”.

 

[djohnson53]

Hope this helps.

[djohnson53]

Not sure, but are you missing parens in the function call?

select id+1,name from (call first())