call stored procedure

Amruta29

The stored procedure is stored in the database to which I have access. But when I try to call the procedure i get an error.

Here is the syntax I am using

{call usp_Daily_Client_Performance_Report_Query(70)}

But I can copy select statement used to run the procedure and it works fine.

Can someone help?

bhanley

Are you using the same login credentials via the JDBC URL as you do when you log into the RDMS and run the Stored proc directly? Try supplying administrator credentials in BIRT initially to rule out a permissions issue and them work backward to increase the security to where it needs to be in production.