I have a Oracle statement like this and works in DTS:
Select f1
From t1
Where f2=123
However, I need to replace 123 with variable v_f3. I try to declare the variable like this:
variable v_f3 number;
begin
SELECT f4
INTO :v_f3
FROM t2
WHERE ...;
end;
Select f1
From t1
Where f2=v_f3
The above statement won't work in SQL DTS data pump task. I am using ODBC driver for Oracle connection.
Thanks a lot.
Select f1
From t1
Where f2=123
However, I need to replace 123 with variable v_f3. I try to declare the variable like this:
variable v_f3 number;
begin
SELECT f4
INTO :v_f3
FROM t2
WHERE ...;
end;
Select f1
From t1
Where f2=v_f3
The above statement won't work in SQL DTS data pump task. I am using ODBC driver for Oracle connection.
Thanks a lot.