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
|
|
|
|
|