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