DBA Data[Home] [Help]

APPS.QA_CHAR_INDEXES_PKG dependencies on DBMS_LOB

Line 826: -- database versions. Used the dbms_lob package routines

822:
823: -- Bug 4086800. A CLOB value cannot be fetched directly
824: -- into a VARCHAR2 variable prior to 9i. Hence the below
825: -- cursor needs to be modified to be compatible across
826: -- database versions. Used the dbms_lob package routines
827: -- for varchar2 conversions. kabalakr.
828:
829: CURSOR c IS
830: SELECT dbms_lob.substr(text, dbms_lob.getlength(text), 1)

Line 830: SELECT dbms_lob.substr(text, dbms_lob.getlength(text), 1)

826: -- database versions. Used the dbms_lob package routines
827: -- for varchar2 conversions. kabalakr.
828:
829: CURSOR c IS
830: SELECT dbms_lob.substr(text, dbms_lob.getlength(text), 1)
831: FROM qa_char_indexes
832: WHERE char_id = p_char_id AND enabled_flag = 1;
833:
834: BEGIN