[Home] [Help]
587: PROCEDURE crt_txn_ind_pref
588: IS
589: CURSOR pref_csr IS
590: SELECT pre_name
591: FROM CTX_USER_PREFERENCES
592: WHERE PRE_NAME = 'TXN_IND_STORAGE_PREF';
593: l_pref_name CTX_USER_PREFERENCES.PRE_NAME%TYPE;
594: BEGIN
595: -- Drop storage preference if it exists.
589: CURSOR pref_csr IS
590: SELECT pre_name
591: FROM CTX_USER_PREFERENCES
592: WHERE PRE_NAME = 'TXN_IND_STORAGE_PREF';
593: l_pref_name CTX_USER_PREFERENCES.PRE_NAME%TYPE;
594: BEGIN
595: -- Drop storage preference if it exists.
596: OPEN pref_csr;
597: FETCH pref_csr INTO l_pref_name;