Category Archives: xls4oracle

Added new page with Excel Reports

New page with excel reports added: Excel Reports Pls. try !!!

Posted in Applications development, Excel Reports, Excel tools, SQL, xls4OracleSQL | Comments Off on Added new page with Excel Reports

xls4OracleSQL is in use as Excel Reporting tool in a validated environment

The xls4Oracle is now in use as a reporting tool. New features in xls4OracleSQL, is enabling the build of Excel Reports, using xls4OracleSQL. The Excel files is store in a SharePoint folder, with restricted access. The ProtectData parameter enables protection of both sql … Continue reading

Posted in Excel Reports, Excel tools, SQL, xls4OracleSQL | Comments Off on xls4OracleSQL is in use as Excel Reporting tool in a validated environment

Duplicates in a Query

Here is a way to find out why you have two rows in a select, when you only expect one. In good database design you expect that a unique ID is giving you only one record. But many tables Oracle … Continue reading

Posted in Applications development, SQL, xls4OracleSQL | Comments Off on Duplicates in a Query

Oracle ODAC: NLS_LANG in registry

The Oracle ODAC (11.2.0.3.20) installation is creating an NLS_LANG entry in here: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG And that has no effeckt – it should be placed in an oracle_home – like: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\NLS_LANG The result of having the NLS_LANG in the wrong place is special … Continue reading

Posted in Applications development, Installation, News, SQL, xls4oracle | Comments Off on Oracle ODAC: NLS_LANG in registry

New features in xls4OracleSQL 5.0

The xls4OracleSQL 5.0is ready to be released soon and will include some new features: SmartFormat Clever formating of the SQL output. New parameter: MaxColWid enables control of how wide a column may be, before wrap is enabled. Heading width is … Continue reading

Posted in News, Revision History, SQL, xls4oracle | Comments Off on New features in xls4OracleSQL 5.0

New xls4OracleSQL tool released

The xls4OracleSQL tool enables distribution of reports. To enable this, some new fetures has been added: Password is protected and connected to the sql. Meaning: if the sql is changed, the password is being reset, and you have to enter the password … Continue reading

Posted in Applications development, News, SQL, xls4oracle | Comments Off on New xls4OracleSQL tool released

xls4Oracle tool – Release 4.0.4.133

Readme: 4.0.4.133 09-dec-2014: Fixed issue with many responsibilities(>99) Pls. upgrade to 4.0.4.133

Posted in News, Revision History, xls4oracle | Comments Off on xls4Oracle tool – Release 4.0.4.133

How to find which SQL has been executed from EXCEL using V$SQL

select * from v$sql where module = ‘EXCEL.EXE’

Posted in Developer Scripts, SQL, Uncategorized, xls4oracle | Comments Off on How to find which SQL has been executed from EXCEL using V$SQL

xls4Oracle tool – Release 4.0.4.131

Readme: 4.0.4.131 25-may-2014: sql: added clear buffer check: removed filedate check, because of DST issue sql: added multiline header formating Note: Revision 4.0.4.131 has an improtant fix for a bug in the sql function. The bug can result in wrong … Continue reading

Posted in News, Revision History, xls4oracle | Comments Off on xls4Oracle tool – Release 4.0.4.131

Load Stock Locators R12 template added

This template has been struggling – and today I realized what the problem was: There is a flag on the KFF “Stock Locators” “allow dynamic insert” – if unchecked – you get: “Can not create Locator”…  

Posted in Applications development, Dataload, Known Issues, News, R12, Revision History, Templates, Templates Development, xls4oracle | Comments Off on Load Stock Locators R12 template added