SQL & PL/SQL

Hi!

My problem is
i have created a procedure to export a sql table to csv file using
dynamic sql and the package dbms_sql. It works eith the tables defined
on my database but it doesn't work with the view that are referred to
table defined in other databases. The procedure doesn't work with this
instruction:

DBMS_SQL.parse (cus_3, 'SELECT * FROM ' || p_view_name,
DBMS_SQL.NATIVE);
The procedure reads the view, insert the values in the table created
but when i pass the function htp.p it doesn't show anything and it
doesn't open the csv file. This problem doesn't exist if i pass in the
parameter of the procedure a table.

Why it reads the tables but not the view?


Regards
Sandeep