Jump to content
We've recently updated our Privacy Statement, available here ×

Read out parameter from a stored procedure


samhast

Recommended Posts

I have a mysql stored procedure:

CREATE PROCEDURE `vtigercrm`.`tester` (out aantal int(255))
BEGIN
*SQL QUERY*


set @aantal = FOUND_ROWS();
select @aantal as 'Aantal';
END

I call the stored procedure:

call tester(@aantal);

Is it possible to read the out parameter in ireport?

I can't display it at the moment. Is that possbile in ireport, to display the returned result from a stored procedure?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...