APEX

Hi.
Newbie with a simple question I hope.!!
I've completed the 2 day tutorial examples provided by oracle, but I can't seem to get working the passing values between pages.

Here is what I have done.

I've created an interactive report page (page 2). In the source region, I have the following SQL Statement

select PUPIL_NAME,class
from T_PUPILS
where CLASS = 'P'
order by PUPIL_NAME

In the report attribute section of the page, I have created a column link on the PUPIL_NAME column.
In the column link section i have set the following

Target = Page in this Application
Page = 7 (This is the page I want to move to)
clear Cache = 7,CIR
Name = IR_PUPIL_NAME
Value = #PUPIL_NAME#

I have created page 7 as a report. In the region source of page 7 i have the following SQL

select PUPIL_NAME,
JOIN_DATE,
HOME_ROOM,
HOME_FLOOR,
HOME_TEACHER
RESULT
from T_PUPIL_INFO
where PUPIL_NAME = :IR_PUPIL_NAME;

When I run the application and move to page 2, I get a list of pupils and their class. When I select one of the pupil names, the application moves to page 7 , but instead of listing all the information for that pupil, it simply says no data found.

In the URL of page 7, I can see that the :IR_PUPIL_NAME has the value of the pupil I selected, but it doesn't seem to be using it in the SQL statement.

Any help would be appreciated.