0

I wanna try this way of exporting data but toad won't recognize ORA_EXCEL as keyword any sugestion ??

BEGIN  
    ORA_EXCEL.new_document;  

    ORA_EXCEL.add_sheet('Employees');  
    ORA_EXCEL.query_to_sheet('select * from employees');  

    ORA_EXCEL.add_sheet('Departments');  
    ORA_EXCEL.query_to_sheet('select * from departments', FALSE);  

    ORA_EXCEL.add_sheet('Locations');  
    ORA_EXCEL.query_to_sheet('select * from locations');  

    -- EXPORT_DIR is an Oracle directory with at least  
    -- write permission  
    ORA_EXCEL.save_to_file('EXPORT_DIR', 'example.xlsx');  
END;

enter here is the original post of this way

Community
  • 1
  • 1
sam
  • 2,493
  • 6
  • 38
  • 73
  • did you install ora_excel package first of all? – Kirill Leontev Feb 09 '14 at 10:07
  • 1
    This package is not a standard Oracle package. Look [here](http://www.oraexcel.com/order) – Egor Skriptunoff Feb 09 '14 at 10:12
  • As Egor points out, ORA_EXCEL is a third party product, so it won't be recognised by a standard template. Oh, and it won't be called ORA_EXCEL for long: Oracle is *incredibly jealous* of its branding, and its lawyers come down on any third-party product with 'ORA' in the name. – APC Feb 09 '14 at 10:39
  • ummm okay thank u all i thought its free way.. anyway is there anyother free way to do it ?? please point me to some links – sam Feb 09 '14 at 11:40
  • I'm amazed someone's trying to sell that. There must be enough customers out there who don't bother looking at the free alternatives... – Jeffrey Kemp Feb 10 '14 at 03:46
  • @Jeffery same same here this first time see something like that 4 sale !! anyway still need away if someone can help... thanks :) – sam Feb 10 '14 at 05:56
  • @JeffreyKemp What are some free alternatives? – James Daily Mar 24 '15 at 19:53
  • Look at XLSX_BUILDER_PKG - https://github.com/mortenbra/alexandria-plsql-utils – Jeffrey Kemp Mar 25 '15 at 01:07

0 Answers0