DBA Data[Home] [Help]

APPS.QA_CHAR_INDEXES_PKG dependencies on DBMS_LOB

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

641:
642: -- Bug 4086800. A CLOB value cannot be fetched directly
643: -- into a VARCHAR2 variable prior to 9i. Hence the below
644: -- cursor needs to be modified to be compatible across
645: -- database versions. Used the dbms_lob package routines
646: -- for varchar2 conversions. kabalakr.
647:
648: CURSOR c IS
649: SELECT dbms_lob.substr(text, dbms_lob.getlength(text), 1)

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

645: -- database versions. Used the dbms_lob package routines
646: -- for varchar2 conversions. kabalakr.
647:
648: CURSOR c IS
649: SELECT dbms_lob.substr(text, dbms_lob.getlength(text), 1)
650: FROM qa_char_indexes
651: WHERE char_id = p_char_id AND enabled_flag = 1;
652:
653: BEGIN