APEX

Hi all,

  I am using apex 5.0,

I have an classic report the columns are

No               Code     Type       Id          Name

10               111        Ban        100        AAA

10               111        Ban        101        BBB

12               112        Cal         1001      XXX

14               177        Mum       2911      XYZ

I Have created On Demand - Run this process when required by AJAX

Parameters for below query is from the above report

Declare

Cursor C1 is

Select No, Code, Type, Id, Name from test

where No = apex_application.g_x01

Code = apex_application.g_x02

Type = apex_application.g_x03

Begin

.......

end;

My problem is when i pass No = apex_application.g_x01 its working.

if i pass other parameter by like code, type using apex_application.g_x02,  and apex_application.g_x03 it is not displaying any row.

it is not accepting the value of g_x02 and g_x03.

How to pass multiple parameter

Thanks in advance