Please help me in using CLOB in Forms6i

بتاريخ: 25 فبراير 200620 سنة

السلام عليكم..كنت أبحث عن طريقة للتعامل مع clob in oralce forms 6i لكي أستطيع تخزين نص طويل جدا (100 صفحة) و لقد وجدت هذا ال code في أحد المواقع..لكنني لم أستطع فهم بعض أجزائه..و هذا هو الcode و معه شرح الكاتب.
One solution can be as follows:
1- Define a VARCHAR2 text item in your form
2- provide a button next to the item.
3- The Button code will be used to display the entire CLOB field. The VARCHAR2 text item will display a SUBSTR of the CLOB field with ellipses (..) to show there is more data for this item.

4- you need to attach the following library to your form. ($ORACLE_HOME\TOOLS\DEV\DEM60\DEMOFORMS\d2kwutil.pll) to ensure that you can run windows API in your form trigger codes. Please ensure you remove reference to the PATH when prompted. The $ORACLE_HOME value can be obtained from your DBA or from the registry if you are in a Windows environment.

5-The code in the button will invoke the HOST command to invoke notepad as an editor for the CLOB field. Using the Windows API, you can get temporary directory information of the user and create a temporary file in the temporary directory to indirectly read from and write to the CLOB field.

6-You will also use Windows API to obtain signature of the file so that a time change to the file will be considered an update and you will have to update the database CLOB fields accordingly.

7-To display the CLOB field you may have a POST-QUERY trigger that takes a DBMS_LOB.SUBSTR (few hundred characters) of the CLOB field and concatenates the ellipses (if the value is more than 4,000 bytes long). You can get the length using the function dbms_lob.getlength(FIELD_NAME).

8-In your WHEN-BUTTON-PRESSED trigger for the button next to the field you may use the following code as a pointer and add your own business rules. However, your code should be as modular as possible. You should also make sure that you have proper error handling in your code, such as adequate EXCEPTION statements in your PL/SQL code.

##الcode هو الملف المرفق .
--الرجاء ممن يستطيع فهم الcode أن يخبرني كيف أستخدمه ..حيث أن هذه النقاط لم أتمكن من فهمها:
1- Temp_File_Name := Temp_File_Name||'Script'||File_No||'.txt';
ما هو file_no؟
2- WIN_API_UTILITY.DELETE_FILE(Temp_File_Name(1), FALSE);
ما هو TEMP_FILE_NAME(1)....??
3-ما هو RETURN_MS؟؟؟
ولكم جزيييييييييل الشكر.
my mail is [email protected]