export table to csv

From: blumagic <riccardo.dibella_at_gmail.com>
Date: Mon, 6 Apr 2009 03:08:01 -0700 (PDT)
Message-ID: <51260377-6327-4ea1-9e7a-298f65079e08_at_3g2000yqk.googlegroups.com>

Hi!My problem is this:
[Quoted] 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???????

Thanks to everybody.

Riccardo Received on Mon Apr 06 2009 - 12:08:01 CEST

Original text of this message