ReportServer Forum

FRZ

Member

Registered: 2017-05-14

Calling Procedure

How to call stored procedure in MariaDB database? Try to execute query but error in SQL syntax reported.

Best regards,
Faizal Rezi

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Calling Procedure

Hi Faizal,

how did you try to call the stored procedure? what report are we talking about? Jasper, BIRT, dynamic list?
please also post the error stack.

Cheers,
Eduardo

FRZ

Member

Registered: 2017-05-14

Re: Calling Procedure

Hi Eduardo,

I create Dynamic List Report.
Query: CALL test_procedure()
Error:
Query could not be executed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CALL test_procedure()) wrappedQry) limitQry WHERE 0 = 1 /* user: 6 */ /* rep' at line 1 Query is: SELECT * FROM (SELECT * FROM (CALL test_procedure()) wrappedQry) limitQry WHERE 0 = 1 /* user: 6 */ /* report: 7504 */ /* token: 1b31126e-484c-4bc0-98f3-f8b14be9e2c2 */ /* currentuser: 6 */

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Calling Procedure

Hi FRZ,

take a look here: https://forum.reportserver.net/viewtopic.php?id=127 , #3 for this.

Regards,
Eduardo