DBA Data[Home] [Help]

APPS.CN_CALC_FORMULAS_PVT dependencies on DBMS_LOB

Line 137: select dbms_lob.substr(sql_select)

133: END validate_name_flags;
134:
135: PROCEDURE check_planning_exp (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE) IS
136: CURSOR get_sql_select is
137: select dbms_lob.substr(sql_select)
138: from cn_calc_sql_exps
139: where calc_sql_exp_id = p_calc_sql_exp_id;
140:
141: l_sql varchar2(2000);