Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

access the variable value in .sql file

curious_mindNov 24 2020

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.

This post has been answered by Billy Verreynne on Nov 26 2020
Jump to Answer
Comments
Post Details
Added on Nov 24 2020
13 comments
1,810 views