Re: export table to csv

From: ddf <>
Date: Mon, 6 Apr 2009 05:38:39 -0700 (PDT)
Message-ID: <>

[Quoted] On Apr 6, 5:08 am, blumagic <> 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,
> 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

Original text of this message