mithilaupadhya_1 Posted October 11, 2018 Share Posted October 11, 2018 I HAVE TRIED USING DIRECT QUERY BY DEFINING PARAMETER IN REPORT AS COLLECTION AND USED "WHERE v_name $X{IN, columnName, paramName}". THIS WORKS FINE. BUT FOR A STORED PROCEDURE THIS CANT BE USED . I HAVE ALSO CONVERTED COLLECTION TO STRING AND USED IN PROCEDURE BUT MULTISELECT VALUES WONT REFLECT.I NEED TO PASS THESE VALUES FROM JASPER SERVER REPORT TO ORACLE STORED PROCEDURE ALONG WITH IN CLAUSE. EX : INSIDE A STORED PROCEDURE I NEED TO USE A QUERY : SELECT * FROM DEPARTMENTS WHERE ID IN ('A','B','C') WHERE A,B,C ARE SELECTED VALUES IN MULTISELCT LIST OF REPORT Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now