Hi All,
I have a requirement where i have to extract the file name which is stored in the database table which is as below:
DECLARE
V_SQL_File VARCHAR2(40);
BEGIN
SELECT CD_VAL_VARCHAR2 INTO V_SQL_File
FROM CD_VAL
WHERE CD_TYP = v_proc_cd_in
AND CD_CAT_TYP = v_proc_step_cd_in
AND CD_SUBCAT_TYP = 'FL_CHK';
@$EODSSQLFILE/V_SQL_File;
END;
/
in the above script V_SQL_File is not getting the value when put in like @$EODSSQLFILE/V_SQL_File
Please suggest how to use it.