DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: C code from developer reports

  1. #1
    Join Date
    May 2000
    Location
    Alex, Egypt
    Posts
    41
    I have a text file with a special format and I want Oracle reports to read this file as the base query, instead of the SQL statement.
    Is it possible to write a C code to parse the file then link this code with the query?
    This file is not fixed width, or delimited, it has a special format that need to be parsed.

    Thanks.
    Amir Magdy

  2. #2
    Join Date
    Oct 2000
    Posts
    123
    Do one thing:

    Write a package which mainly reading the flat file according to special format by using either TEXT_IO or UTL_FILE or other tools, and return the whole record set(return cursor).

    At last, when you create report, use REF sursor to generate report based on this returned cursor.

    Hope this will give you a hint.

    Take care

  3. #3
    Join Date
    May 2000
    Location
    Alex, Egypt
    Posts
    41
    Thanks for the suggestion, which is very usefull, It seems I will use it unless, someone,can tell me how to link Oracle reports, with C code, to extract the data, (just for performance issues)
    Amir Magdy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width