Re: Cursor output to CSV


"Helge" <hmoulding@xxxxxxxxx> wrote in message
news:1150052064.006706.80650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
: Mladen Gogala wrote:
: > Maybe, if you provided us with some more details, we would be
: > able to give you some more information.
:
: OK. I have a number of Crystal Reports in my application that use
: PLSQL procedures as data sources. Each PLSQL procedure has a ref
: cursor as output, and that's used by Crystal Reports to generate a
: pretty output. These reports are generated "on demand."
:
: At the same time I need to be able to push the same information that
: is in the reports to other servers in various departments. This has to
: happen at predefined times, e.g. every day, once a week, on the last
: day of each month, etc. A database connection is not an option, which
: is why I have to write a flat file.
:
: Clearly the same procedures that generate the Crystal Reports should
: generate the data for the csv files. So what I need to be able to write
: is
: something like:
:
: create or replace procedure report1(rc out refcur_pkg.rc) is
: ...
: create or replace procedure report2(rc out refcur_pkg.rc) is
: ...
: create or replace push_reports is
: rc ref cursor;
: begin
: report1(rc);
: output_csv(rc);
: close rc;
: report2(rc);
: output_csv(rc);
: close rc;
: end;
:
: If I have to write output_csv in some other language than PLSQL, that's
:
: not a problem, but I need to know where to read up on the Oracle API
: that supports this.
:

does the output have to be csv?

does it have to have column headings?

++ mcs


.

Relevant Pages

  • Re: Cursor output to CSV
    ... I have a number of Crystal Reports in my application that use ... PLSQL procedures as data sources. ... is why I have to write a flat file. ... rc ref cursor; ...
    (comp.databases.oracle.server)
  • Re: Standard Method for Importing/Exporting to DB
    ... but there is the possibility that the databases may be ... and also exporting to CSV files. ... everything from DTS packages to Crystal Reports are used. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Which newsgroup / forum ....
    ... "al jones" wrote in message ... chances are open is some sort of method. ... All output I ever did to a printer was from crystal reports. ... Otherwise I think I'd write the stuff to a flat file. ...
    (microsoft.public.dotnet.languages.vb)
  • Standard Method for Importing/Exporting to DB
    ... but there is the possibility that the databases may be ... and also exporting to CSV files. ... everything from DTS packages to Crystal Reports are used. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Crystal Reports and COBOL
    ... it is a database field defined as a blob...I can't do that ... using CSV files? ... >>Anyone out here use Crystal Reports? ... >>The data being passed to CR is currently a standard CSV file and I am ...
    (comp.lang.cobol)