We are using Oracle Forms 10g Release 1 at one of my client place.

At this client place, today my team came across one problem!

A report was running for all the item code except when they pass item code ‘RPKKH-25X118″-PB’ as parameter,

After r&d I came to conclusion that to pass any value which contain special characters or blank space, we need to surround the value being passed with extra single quotes.

DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(1000);
rep_status VARCHAR2(100);
v_cond VARCHAR2(100) := ””||’WHERE STATUS IS NULL’||””;
BEGIN
repid := FIND_REPORT_OBJECT(’itminput’);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,’HTML’);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
……..
……
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,
‘p_item_code=”’||’RPKKH-25X118″-PB’||””);
………