antonscheffer / as_xlsx Goto Github PK
View Code? Open in Web Editor NEWas_xlsx: generate an Excel xlsx file from an Oracle database. Or read data from a xlsx. Works on Oracle 11.2, but also on 23c Free
License: MIT License
as_xlsx: generate an Excel xlsx file from an Oracle database. Or read data from a xlsx. Works on Oracle 11.2, but also on 23c Free
License: MIT License
I run the package in Oracle 11g and found the error at line 2853 "Column ambiguously defined" and don't know how to fix it.
Line 2853 in b21c048
Hi Anton
First of all, thanks for creating this tool. I think that it's ease of use is really making it perfect.
I would like to ask you about the use case I have.
We use Excel to present data in a nice visual form.
The data lives in worksheets: Sheet1, Sheet2, Sheet3 and is a ump of data from specific SQL queries.
The sheets with raw data are hidden and another sheet is used to visualize the data.
What I was aiming at is to:
The problem that I am facing at the moment is that I can't really find a PL/SQL Excel generator that would allow me to do this.
Our tool that we are using is reaching end of life and I need to find a decent & simple replacement for it.
Would it be difficult to extend the package you have now to work with an existing Excel Workbook instead of populating a blank one each time?
Thanks
Hi @antonscheffer,
Thanks for this great package!
Having this error compiling the package body in Oracle Database 23c Free:
Compilation errors for PACKAGE BODY AS_XLSX
Error: PL/SQL: ORA-00932: expression is of data type BLOB, which is incompatible with expected data type -
Line: 2401
Text: select ora_hash( p_img ) into l_hash from dual;
Error: PL/SQL: SQL Statement ignored
Line: 2401
Text: select ora_hash( p_img ) into l_hash from dual;
Database info:
OCI: version 12.1 (21.13.0.0.0)
Oracle Database 23c Free Release 23.0.0.0.0
Compilation works on previous releases.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.