Re: export table to csv

[Quoted] On Apr 6, 5:08 am, blumagic <riccardo.dibe..._at_gmail.com> wrote:
> Hi!My problem is this:
> 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

Post the code for this procedure; we can't tell you anything until you do.

David Fitzjarrell Received on Mon Apr 06 2009 - 14:38:39 CEST