Skip to Main Content

Calling A Page Process From Report Link

EEGAug 9 2013 — edited Aug 9 2013

Hello.

I am using Apex 4.2.1 on Oracle 11gR3 and mod_plsql.

I am trying to run a PLSQL after-submit page process when users click a SQL generated link in a classical type report.

For example, my classical report uses the query:

SELECT

E.*,

'<a id="rid" href="f?p=&APP_ID.:31:&SESSION.:ADDROW:::P31_ENAME,P31_MGR,P31_DEPTNO:'

|| E.ENAME

|| ','

|| TO_CHAR(E.MGR)

|| ','

|| TO_CHAR(E.DEPTNO)

|| '">'

|| 'Add New Row'

|| '</a>' AS ADD_ROW

FROM

EMP E

My page also has an after submit PLSQL process defined as:

declare

  v_empno     integer;

begin

  select nvl(max(empno), 0) + 1

    into v_empno

    from emp;

  insert into emp (empno,

                   ename,

                   mgr,

                   deptno)

           values (v_empno,

                   substr(:P31_ENAME,1,1) || '-' || to_char(v_empno),

                   to_number(:P31_MGR),

                   to_number(:P31_DEPTNO));

end;

This process has the condition "Request = Expression 1", where "Expression 1" = ADDROW.

I thought that if users click the "ADD_ROW" report link, then the report items ENAME, MGR, and DEPTNO would be passed to corresponding page items.  In addition, the above PLSQL process would be executed and add a new row to the EMP table.  The report then would then display the newly added row.

But when I click the report link, I see that my page items are, in fact, assigned the associated report values.  But the page process is never executed.

I have looked at both the Session State page and in Debug mode.  The processing simply never executes my page process.

Would anyone know why my page process is not being run?  And, how can I get the page process to run when users click the report link?  Indeed, what is the point of even having a REQUEST tage embedded in the url if it is not recognized bt other processes on the page?

In my apex.oracle.com workspace, I have created an example page in which all of this has been coded:

Workspace: EEG

Username: EGRUNHAUS@GMAIL.COM

Password: galaxy123 (all lowercase)

AppID: 27083 (Elie_Goodies)

Page 31 (Test Url Request Option)

I would much appreciate if someone could help me with this as I am puzzled why this is not working.

Thank you very much.

Elie

This post has been answered by Jorge Rimblas on Aug 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Sep 6 2013
Added on Aug 9 2013
3 comments
511 views