Wow, I broke my brains over this for the last three days. I installed the apex listener as mentioned in the manual. It mentions you can use Java 6 Update 20 JDK or later. However, what they mean is that…
Author Archive for Richard Martens
Setting an apex-item from PL/SQL
by Richard Martens • • 0 Comments
Got it from Andy’s Blog: Within ApEx PL/SQL Processes, regions and items you can use the bind variable syntax (:PX_MY_ITEM) both to read and set the value of that item held in session state. Like so: :PX_MY_ITEM := ‘wibble’; l_my_local_variable…
update Oracle Linux without CSI
by Richard Martens • • 5 Comments
In my ongoing quest for freeware in combination with Oracle Apex I gave Oracle Unbreakable linux another try when I heard that you _are_ able to update/upgrade it using yum, without a support identifier. First we install Oracle Unbreakable Linux…
Unable to login or run an application after applying APEX 4.1.1 patch set?
by Richard Martens • • 1 Comment
Patrick Wolf blogged about this, but I’d like to have it available here as well: If you get the error Workspace “[workspace name]” is inactive. Contact your administrator. when you try to login into your workspace or when you run…
APEX listener startup/shutdown script
by Richard Martens • • 4 Comments
Watching our visitors and how they arrive on warp11.com I cam across this page: http://krisrice.blogspot.com/2010/12/listener-startupshutdown-script.html definately worthwile caching… here we go: Kris gives a script, which I altered a little bit. #!/bin/sh # # # chkconfig: 2345 80 05 #…
Mystery: Interactive Report broken for end-users!
by Richard Martens • • 0 Comments
taken from: http://stewstools.wordpress.com/2010/11/04/mystery-interactive-report-broken-for-end-users/ GREAT story :-) <COPY> A friend dropped me a line saying her Apex app’s Interactive Report wasn’t working for her users anymore and she asked if I knew what could cause it. She said it worked for…
Import Apex Application at command line
by Richard Martens • • 3 Comments
Recently (since 4.1 update) I’ve experienced issues when importing an application into an Apex environment. After a little bit of searching I found the way to do the import on the command-line. It is documented in the Apex documentation, but…
unique constraint violated WWV_FLOW_UNIQUE_MENU_OPT
by Richard Martens • • 0 Comments
Creating a new page in an application I’m writing for a customer APEX gave me an error against the WWV_FLOW_UNIQUE_MENU_OPT constraint, after I hit the finish button in the last step of the wizard.. Now, that’s strange, why would APEX break…
To V or not to V…
by Richard Martens • • 0 Comments
This is a one-on-one copy of an item blogged by Scott Splendolini <COPY> Earlier today, I tweeted the following: After this morning, I don’t think I will ever use the “v” function again. #orclapex I wanted to qualify what I…
UPDATE !: Oracle XE 11g R2 on CentOS 6
by Richard Martens • • 7 Comments
<EDIT sept 2, 2011> Today oracle released the definitive version of Oracle XE 11.2. I haven’t had the opportunity to test that version against my blogs, but I’ll do that shortly. stay tuned </EDIT> In addendum on my installation series…