Is there a possibility of passing multiple parameters in the stored procedure query?

[santoshtheprofessional]

I tried something like this:

{call prc_JasperEmployeeData($P{LoggedInUserName} and $P{LoggedInFullName})}

{call prc_JasperEmployeeData($P{LoggedInUserName},$P{LoggedInFullName})} but it shows error.

 

Am I missing something? Please assist me.

[sthomas_3]

I have created below procedure :

CREATE OR REPLACE PROCEDURE prc_JasperEmployeeData(LoggedInUserName varchar2,LoggedInFullName varchar2, emp_cursor OUT sys_refcursor)
IS
BEGIN 
OPEN emp_cursor 
FOR SELECT username,fullname FROM jiuser where username =LoggedInUserName and fullname=LoggedInFullName;
END;
/

and from Jaspersoft studio called the procedure as below

{call emplist_proc($P{LoggedInUserName},$P{LoggedInFullName},$P{emp_cursor})}

 

This returns the value as expected. You may have manually create fields to get the values.