Category Archives: APEX

Oracle Apex RESTful Services…

Posted on 12. May 2014 by vogler

To use RESTful Oracle Apex Services following grant has to be done: alter user grant connect through apex_rest_public_user;

Posted in APEX | Comments Off on Oracle Apex RESTful Services…

Export Oracle APEX Applications of Workspace

Posted on 11. May 2014 by vogler

How to export all applications of an Oracle APEX Workspace: export CLASSPATH=.:/app/oracle/product/11.2.0/dbhome_1/jdbc/lib/ojdbc5.jar:/app/apex/utilities java oracle.apex.APEXExport -db localhost:1521:ORCL -user system -password -workspaceid 2097002597188478 /app/apex ==> Oracle APEX Installation-Directory

Posted in APEX | Comments Off on Export Oracle APEX Applications of Workspace

Oracle Apex Blob as Download-Link…

Posted on 21. March 2014 by vogler

First of all you have to select the blob column like this: select project_id, mimetype, filename, dbms_lob.getlength(“OUTPUT”) AS output from TR_PROJECT t order by uploadts desc If not you will get an error message. AS Number/Date Format use  a string … Continue reading →

Posted in APEX | Comments Off on Oracle Apex Blob as Download-Link…

WinCC OA on Raspberry Pi…

Posted on 28. November 2013 by vogler

works great! Photovoltaik-Power: http://rocworks.no-ip.org:8080/apex/f?p=102 Meter-Values: http://rocworks.no-ip.org:8080/apex/f?p=102:8

Posted in APEX, WinCC OA | Comments Off on WinCC OA on Raspberry Pi…

SmartHome Power Monitoring with WinCC OA and Oracle/APEX…

Posted on 11. November 2013 by vogler

Power Monitoring http://rocworks.no-ip.org:8080/apex/f?p=100 The system also controls my hot water boiler heater

Posted in Allgemein, APEX, Oracle, WinCC OA | Comments Off on SmartHome Power Monitoring with WinCC OA and Oracle/APEX…

SmartHome Architecture…

Posted on 10. June 2013 by vogler

SmartHome…. high availability architecture… but just for fun and to play with some technologies. The system is also able to run on a single system like the “Scada Local” system, and this is just an old Lenovo Netbook with 2GB RAM… … Continue reading →

Posted in APEX, Oracle, Virtualization, WinCC OA | Comments Off on SmartHome Architecture…

WinCC OA APEX jQuery mobile smartphone demo…

Posted on 13. March 2013 by vogler

Apex-Mobile-Demo Simple mobile smartphone demo build with Oracle APEX connected to WinCC OA (www.etm.at). It tooks me about 3h… and i had NO experience with APEX! The map does not work on (my) android smartphone… maybe a known bug: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-42-known-issues-1863578.html Connectivity … Continue reading →

Posted in Allgemein, APEX, Oracle, WinCC OA | Comments Off on WinCC OA APEX jQuery mobile smartphone demo…

Oracle and APEX meets WinCC OA…

Posted on 13. March 2013 by vogler

With a “few lines” of code Oracle is able to fetch WinCC OA values over XMLRPC webservice – current and history values (WinCC OA RDB-Manager is not needed). WinCC OA values can be queried with “natural” Oracle SQL Statements select … Continue reading →

Posted in Allgemein, APEX, Oracle, WinCC OA | Comments Off on Oracle and APEX meets WinCC OA…