OraFAQ Forum: SQL & PL/SQL » assigning a filname to a variable and running the variable name from the prompt

Home » SQL & PL/SQL » SQL & PL/SQL » assigning a filname to a variable and running the variable name from the prompt

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

assigning a filname to a variable and running the variable name from the prompt [message #37951]

Fri, 08 March 2002 06:04

theak
Messages: 3
Registered: March 2002

Junior Member

cannot get this to work

i.e.
accept p_report prompt 'enter report to run: '
start 'c:sqlreport' || p_report

also (same as above
accept p_report prompt 'enter report to run: '
declare
v_report varchar2(50) := &p_report;
begin
v_report := 'c:sqlreport' || v_report;
@v_report;
end;

1st example outputs - cannot find file c:sqlreport.sql

2nd example - cannot find file v_report.sql

my question is - how do I assign a file name to a variable and running the script with
start variable.value
or
@variable.value

thanks in advance
theak

Report message to a moderator