I have a stored procedure that runs a query which includes calling another stored procedure and putting the results in an temp table.
When I run it on the server it runs fine (takes about 1.5 minutes), returns about 100k results. I can call it from a php file on the same server as mydbr it loads fine.
When I try to run it in myDBR it immediately returns all of the columns with no results. I have tried using the refresh feature and it never returns any results.
Is there anything else I should try?
Edit: sorry didn't realize I was under the Installation section