بسم الله الرحمن الرحيم

اخواني الاعزاء ما اهمية استخدام SRW.REFERENCE في التقارير ويا ريت اعطائي مثال توضيحي اذا ممكن .

يا اخوان الرجااااء مساعدتي في معرفة اهمية استخدام SRW.REFERENCE في التقارير لان الموضوع هام جدا
بالنسبة لي .

وينكم يا شبااااااااااااااااااااااااااااب ....

لا احد يعرف .................................................... ؟؟؟؟؟

Alsalam alikom ,
You can use the help of the oracle reports it gives also good examples

انا لم استخدم هذا الامر من قبل .. ولكن بدلا من الانتظار

SRW.REFERENCE built-in procedureThis procedure adds the referenced object to the PL/SQL construct's dependency list. This causes Reports Builder to determine the object's value just before firing the PL/SQL construct. This is useful when you want to ensure that a column value passed to a user exit is the most recently computed or fetched value.

Syntax

SRW.REFERENCE (:object CHAR|DATE|NUMBER);

Parameters
Description

:object Is the Reports Builder parameter or column whose value needs to be ascertained before the construct fires.


Restrictions
The colon is required before the object name.

SRW.REFERENCE is unnecessary when the object is already referenced in the current PL/SQL construct.

Example
Suppose you want to pass the temperature and pressure values to a user exit called SUPERHEAT. Suppose, also, that if the temperature is too low, you want to raise a customized error message.   To do so, you could write the following formula:


FUNCTION EXIT RETURN BOOLEAN IS 
BEGIN 
 if :temp > 0 then  
 SRW.REFERENCE (:temp); -- unnecessary reference
 SRW.REFERENCE (:pressure);
 SRW.USER_EXIT('superheat temp pressure'); 
else SRW.MESSAGE(1000, 'Temperature is below normal. 
 Is machine off?');
raise SRW.PROGRAM_ABORT;
end if;
RETURN(TRUE);
END; 

تفاصيل أكثر
من هنــــــــــــــــــا