APEX

Good Day Folks,

I'm trying to pass a search query "Text Field" from say page 1 to page 5. The user enters
the search criteria on Page 1 and Page 5 shows the results.

On page 1, I have an "after submit" computation like this
G_P1_SEARCH <= P1_SEARCH, where G_P1_SEARCH is an application level item and P1_SEARCH is a page 1 level text item.

On page 5 I have a Text Field, for debugging purposes, which is assigned the value of G_P1_SEARCH, and it works. But when I use G_P1_SEARCH in a query as follows

select "EMPNO",
"ENAME",
"JOB",
"MGR",
"HIREDATE",
"SAL",
"COMM",
"DEPTNO"
from "#OWNER#"."EMP"
where ename LIKE '%:G_P1_SEARCH%'

the query returns "no data found"

Any ideas on what I'm doing wrong ?

Thanks in advance
/Serge