Hi,
I am dynamically creating a HREF link in my Apex report using SQL. this links invokes an Ajax Process on the same page.
The process is an on Demand Ajax Call back that calls a Stored Proc.
All seems to work as expected, with one small issue, A blank page is displayed once the process is called, the process page does not return back to the page it was called from. Can someone let me know where i am going wrong.
This is the Query i use to create a dynamic HREF via my Report SQL ...Notice the <a href...> syntax. The name of the process flow is CALL_PROCESS_FLOW
select "RUN_ID",
"JOB_NAME",
"JOB_START_DATE",
"JOB_END_DATE",
'
Ajax' SP1
from "#OWNER#"."VW_JOB_CONTROL"
where job_name='CLN_INPATIENT_FCE'
I have tried getting rid of the colons after the name of the process flow. I have also tried the same with and without the # at the end. However it still returns the same error.
Can some one help. I know its something small but i just can seem to figure it out.