Select statement from "v_filename_txt" inside cursor
661355Sep 24 2008 — edited Sep 24 2008Hi,
I've got a store procedure procedure that create parametric tables to upload from csv files. I have collect into v_filename_txt variable the parametric table name where I would like to make some select.
I have write the following code but I can't use a variable into a select statement :
select field
FROM TABLE '''||v_filename_txt||''' ;
Does anybody know how to include the precedent statement into a cursor to retrive recods ?
Paolo.