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

0

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.

santoshtheprofessional's picture
Joined: May 14 2018 - 9:45pm
Last seen: 1 day 18 hours ago

1 Answer:

0

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.

sthomas_3's picture
5008
Joined: Dec 15 2014 - 2:56pm
Last seen: 1 day 2 hours ago
Feedback