Category Archives: APEX

Oracle Apex RESTful Services…

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

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…

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…

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…

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…

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…

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…

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…