digitalwise
asked on
Oracle APEX Report Parameters
I have a call to report built in Oracle's Application Express (APEX).
The URL is XXXXX/f?p=700:265&p_cust_id=99999
This is my query for the report:
SELECT
XXX.CUST_ID,
CCC.CVAR
FROM
XXX INNER JOIN CCC CCC ON (CCC .CUST_ID=XXX.CUST_ID)
WHERE
(
CCC.ATTRIBUTE_TY IN ( 'SBM_VOUCHER_CD' )
AND (CCC.OUTER_JOIN = 'N')
AND
CCC.CVAR Is Not Null
)
AND
XXX.CUST_ID = :p_cust_id
This is the result when the page runs:
The URL is XXXXX/f?p=700:265&p_cust_id=99999
This is my query for the report:
SELECT
XXX.CUST_ID,
CCC.CVAR
FROM
XXX INNER JOIN CCC CCC ON (CCC .CUST_ID=XXX.CUST_ID)
WHERE
(
CCC.ATTRIBUTE_TY IN ( 'SBM_VOUCHER_CD' )
AND (CCC.OUTER_JOIN = 'N')
AND
CCC.CVAR Is Not Null
)
AND
XXX.CUST_ID = :p_cust_id
This is the result when the page runs:
Failed to parse target procedure f: SIGNATURE (parameter names) MISMATCH VARIABLES IN FORM NOT IN PROCEDURE: P_CUST_ID NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM:
Any ideas what I need to change on the query end? I can't change the parameters that are passed.
Do you have p_cust_id defined as an item for your report page or as a global item?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.