tag:blogger.com,1999:blog-207884012024-03-13T19:04:05.128+01:00daust_de :: Oracle XE / APEXAnonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.comBlogger113125tag:blogger.com,1999:blog-20788401.post-47369564679916723632016-10-12T20:16:00.004+02:002016-10-12T20:16:55.912+02:00Presenting at KScope can change your lifeBack in 2008 I was invited by <a href="http://spendolini.blogspot.de/" target="_blank">Scott Spendolini</a> to speak about my experiences with <a href="http://daust.blogspot.de/2008/06/my-presentation-at-odtug-kaleidoscope.html" target="_blank">Oracle APEX at the German telecom shops</a> at the KScope conference in New Orleans.<br />
<br />
<b><span style="font-size: large;">It was a truly great experience. </span></b><br />
<br />
At that time the system I had built was one of the larger deployments of Oracle APEX known in the community serving 6.000 users in the 800 telecom shops in Germany with 400.000 hits per day on the system.<br />
<br />
Not only could I showcase what I had built with Oracle APEX 2.2 but I could even get more connected with the Oracle APEX community. It was awesome.<br />
<br />
I had the chance to meet many people from the Oracle forums in person, like Scott Spendolini, Patrick Wolf, Dimitri Gielis, Roel Hartman, Karen Cannell, Anton Nielsen, John Scott but also many people from the APEX team itself like Mike Hichwa, Joel Kallman, Carl Backstrom, David Peake, Scott Spadafore and many others.<br />
<br />
On this conference you will certainly meet the most members of the APEX team itself. It is a great opportunity to get in touch with the people in person ... this just makes a HUGE difference. So whenever you might need support later on ... your name will be known and people understand that you contribute just as well. It makes a difference !<br />
<br />
From that time on in 2008 I got hooked and got more and more involved in the community. Each project became an opportunity to research yet another interesting topic for the next conference.<br />
<br />
And I presented each year (I missed Long Beach ... what a bummer :( ) until now ... and I will submit again this week ... because the deadline is coming close ( 14.10.2016 ) !!!<br />
<br />
This conference sets itself apart not only by the extremely high class content but also by the social activities, there is soo much going on. They always select really nice locations, everybody is relaxed and has so much fun. The APEX presentations are typically well attended ... even more than from the other tracks.<br />
<br />
<b>I can only encourage you to submit your presentation since the deadline is coming up soon: 14.10.2016 !!!</b><br />
<br />
In order to submit a really compelling presentation, please read up these posts for guidance:<br />
<ul>
<li><a href="http://spendolini.blogspot.com/2013/11/presentation-advice.html">http://spendolini.blogspot.com/2013/11/presentation-advice.html</a></li>
<li><a href="http://www.odtug.com/p/bl/et/blogid=1&blogaid=497">http://www.odtug.com/p/bl/et/blogid=1&blogaid=497</a></li>
<li><a href="https://www.linkedin.com/pulse/20140630141618-4832037-how-to-get-your-conference-abstract-accepted">https://www.linkedin.com/pulse/20140630141618-4832037-how-to-get-your-conference-abstract-accepted</a></li>
<li><a href="http://www.pythian.com/blog/concrete-advice-for-abstract-writers/">http://www.pythian.com/blog/concrete-advice-for-abstract-writers/</a></li>
<li><a href="https://chadthompson.me/2012/12/how-to-submit-winning-presentations/">https://chadthompson.me/2012/12/how-to-submit-winning-presentations/</a></li>
</ul>
<div>
And remember ... we need presenters on all levels: beginners, intermediates and experts. </div>
<div>
<br /></div>
<div>
Hope to see you in San Antonio at <a href="http://kscope17.com/" target="_blank">KScope 2017 </a>!!!</div>
<div>
<br /></div>
<div>
Cheers, </div>
<div>
~Dietmar. </div>
<div>
<br /></div>
<div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-71517913610816033772016-04-28T19:30:00.000+02:002016-04-28T19:30:38.636+02:00Slides and demo script from my APEX command line scripting talk at APEX Connect 2016 in BerlinHi everybody,<br />
<br />
I just came back from the <a href="https://apex.doag.org/de/home/" target="_blank">DOAG APEX Connect 2016 conference in Berlin</a> ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure. This time we felt a little pinkish ;)<br />
<br />
As promised, you can <a href="http://www.opal-consulting.de/downloads/presentations/2016-04-APEX-Connect/Oracle-APEX-Scripting-101/" target="_blank">download the slides and the demo script (as is) from my site</a>. They are in German, but I will give the talk in June at KScope 2016 in Chicago in English just as well.<br />
<br />
Instructions are included.<br />
<br />
See you at KScope in Chicago, #letswreckthistogether .<br />
<br />
Cheers and enyoy!<br />
<div>
~Dietmar. </div>
<div>
<br /></div>
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-21411157585961241202016-04-28T19:25:00.001+02:002016-04-28T19:25:46.648+02:00Slides and demo script from my ORDS talk at APEX Connect 2016 in BerlinHi everybody,<br />
<br />
I just came back from the <a href="https://apex.doag.org/de/home/" target="_blank">DOAG APEX Connect 2016 conference in Berlin</a> ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure. This time we felt a little bit pink ;)<br />
<br />
As promised, you can <a href="http://www.opal-consulting.de/downloads/presentations/2016-04-APEX-Connect/Oracle-ORDS-Quickstart-fuer-Entwickler/" target="_blank">download the slides and the demo script (as is) from my site</a>.<br />
<br />
Instructions are included.<br />
<br />
See you at KScope in Chicago, #letswreckthistogether .<br />
<br />
Cheers and enyoy!<br />
<div>
~Dietmar. </div>
<div>
<br /></div>
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-19066456969203247242016-03-10T08:23:00.001+01:002016-03-10T08:23:59.386+01:00Slides and demo script from my ORDS talk at apex.world 2016 in RotterdamHi everybody,<br />
<br />
I just came back from the <a href="https://www.ogh.nl/page.aspx?event=293&lang=en" target="_blank">apex.world conference in Rotterdam</a> ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure.<br />
<br />
As promised, you can <a href="http://www.opal-consulting.de/downloads/presentations/2016-03-05-APEX-World-Rotterdam/2016-03-05-APEX-World-Rotterdam.zip" target="_blank">download the slides and the demo script (as is) from my site</a>.<br />
<br />
Instructions are included.<br />
<br />
See you at APEX Connect in Berlin or KScope in Chicago, #letswreckthistogether .<br />
<br />
Cheers and enyoy!<br />
<div>
~Dietmar. </div>
<div>
<br /></div>
<br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-76387483447866275882016-02-12T14:57:00.000+01:002016-02-12T14:57:02.081+01:00Folien zum Webinar REST mit ORDSOracle hat zusammen mit der DOAG das Webinar "<a href="https://apex.oracle.com/pls/apex/f?p=75474:1" target="_blank">Modern Application Development</a>" organisiert, darin habe ich auch ein Webinar (auf deutsch) zum Thema "Oracle als REST-Service mit ORDS – So geht‘s" beigesteuert.<br />
<br />
<a href="http://www.opal-consulting.de/blog/2016-01-ords-modern-application-development-webinar-video-v3.pdf" target="_blank">Die Folien dazu findet Ihr hier.</a><br />
<br />
Viele Grüße,<br />
~Dietmar. Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-9629155186503336912015-11-18T12:41:00.000+01:002015-11-18T12:41:08.284+01:00Presentation slides for my presentation at DOAG 2015 - Apache - ORDS Setup for Production EnvironmentsHi guys,<br />
<br />
here you can find the slide, the config files and installation steps for my presentation at the DOAG conference in Nürnberg on 18.11.2015:<br />
<br />
<a href="http://www.opal-consulting.de/downloads/presentations/2015-11-DOAG-ORDS-Setup/" target="_blank">http://www.opal-consulting.de/downloads/presentations/2015-11-DOAG-ORDS-Setup/</a><br />
<br />
Enjoy!<br />
<br />
Cheers,<br />
~Dietmar.<br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com2tag:blogger.com,1999:blog-20788401.post-54000705250110388672015-09-30T21:48:00.000+02:002015-09-30T21:49:17.110+02:00DOAG Conference Presentation Summary FinishedHi guys,<br />
<br />
today was the deadline for uploading the four-page abstract / summary of my presentation at the German Oracle conference in Nürnberg:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvlYyhlBnW1pHF6z0VTwkpbbctjYGE0_uEqWH4eqmqzpG50hr_t6lFP-wyl3nRodsXsQWbXDbcai9rkHKVIJHEjoQhyphenhyphenA6x4PpaB3H3MrrI7er_TUZNezGW4GONgUk09cBq0Gei/s1600/Vortrag_Details.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvlYyhlBnW1pHF6z0VTwkpbbctjYGE0_uEqWH4eqmqzpG50hr_t6lFP-wyl3nRodsXsQWbXDbcai9rkHKVIJHEjoQhyphenhyphenA6x4PpaB3H3MrrI7er_TUZNezGW4GONgUk09cBq0Gei/s400/Vortrag_Details.png" width="400" /></a></div>
<br />
<br />
If you still have to upload yours, hurry up ... only a few hours left ;).<br />
<br />
<a href="http://www.opal-consulting.de/downloads/presentations/2015-11-DOAG-ORDS-Setup/2015-11-19-D.Aust-DEV-Apache-ORDS-Quickstart-Manuskript.pdf" target="_blank">You can have a look here (it is German though ;). </a><br />
<br />
See you in Nürnberg in November.<br />
<br />
Cheers,<br />
~Dietmar.<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-61580411859356331732015-09-17T07:30:00.004+02:002015-09-17T07:34:21.637+02:00My Nomination for the Oracle Database Developer Choice Awards<div class="_209g _2vxa" data-block="true" data-offset-key="6m95h-0-0" data-reactid=".18.1.0.1.0.0.$editor1.0.0.$6m95h" style="background-color: white; direction: ltr; position: relative;">
<span style="color: #373e4d; font-family: helvetica, arial, sans-serif;"><span style="font-size: 14px; white-space: pre-wrap;">Actually this came as a wonderful surprise ... I have been nominated for the Oracle Database Developer Choice Awards: </span></span>
</div>
<div class="_209g _2vxa" data-block="true" data-offset-key="38kah-0-0" data-reactid=".18.1.0.1.0.0.$editor1.0.0.$38kah" style="background-color: white; color: #373e4d; direction: ltr; font-family: helvetica, arial, sans-serif; font-size: 14px; position: relative; white-space: pre-wrap;">
<a href="https://community.oracle.com/community/database/awards/ords-voting">https://community.oracle.com/community/database/awards/ords-voting</a> .
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhQDMcxQmUI9qsPCKbWLQyjBrKGrwDBrqCFxTPtQeNlVKlg4k3m7DcFPB9n0bDweAMGJGIBCP3slp9hjuOiO5paXDJ2tueQkr1653spmaf4yPPqEljOWZLwj-z1hA0ZbQPgHrO/s1600/Dietmar_Aust.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhQDMcxQmUI9qsPCKbWLQyjBrKGrwDBrqCFxTPtQeNlVKlg4k3m7DcFPB9n0bDweAMGJGIBCP3slp9hjuOiO5paXDJ2tueQkr1653spmaf4yPPqEljOWZLwj-z1hA0ZbQPgHrO/s1600/Dietmar_Aust.png" /></a></div>
<div class="_209g _2vxa" data-block="true" data-offset-key="ekou1-0-0" data-reactid=".18.1.0.1.0.0.$editor1.0.0.$ekou1" style="background-color: white; direction: ltr; position: relative;">
<span style="color: #373e4d; font-family: helvetica, arial, sans-serif;"><span style="font-size: 14px; white-space: pre-wrap;">
I have basically devoted my entire work life to build solutions based on Oracle technology ... and you can build some pretty cool stuff with it.
I have always enjoyed building software that makes a difference ... and even more so share to what I have learned and support and inspire others to do the same.
The people in the Oracle community are simply amazing and I have made a lot of friends there.
If you have an account for the Oracle Technology Network (OTN) I would appreciate your vote !
And if you don't feel like voting for me ... vote anyway in all the different categories ... because the Oracle community deserves the attention.
Thanks,
~Dietmar. </span></span></div>
Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-62672338419676857962015-09-15T19:48:00.001+02:002015-09-15T19:48:31.643+02:00Presentation slides for my ORDS talk at KScope 2015Hi guys,<br />
<br />
in June I gave a talk at the ODTUG KScope conference regarding the optimal setup of Oracle ORDS for Oracle Application Express: <span style="background-color: #eef1f6; color: #777777; font-family: 'Open Sans', Arial, sans-serif; font-size: 16px; font-weight: bold; line-height: 19px;">Setting Up the Oracle APEX Listener (Now ORDS) for Production Environments</span><br />
<br />
You can access the slides certainly through the ODTUG site. They have even recorded the presentation and made it available to their members.<br />
<br />
This seems to be a good investment for $99 per year for a paid membership, because now you also have access to the other content from the ODTUG conferences. I am not affiliated with ODTUG but all I can say is that the KScope conference is the best place for an Oracle developer to learn and connect with the best folks in the industry.<br />
<br />
For everybody else who is not (yet) an ODTUG member you can download my slides and the config file here: <a href="http://www.opal-consulting.de/downloads/presentations/2015-06-ODTUG-KScope-ORDS-in-production/">http://www.opal-consulting.de/downloads/presentations/2015-06-ODTUG-KScope-ORDS-in-production/</a><br />
<br />
Cheers and all the best,<br />
~Dietmar.<br />
<br />
P.S.: The configuration is based on the version 3.0.0 of ORDS. You should definitely move to 3.0.1 which is currently available.<br />
<br />
But on the other hand I was once again thrown of by another problem with version 3.0.1 running the schema creation scripts for the ORDS schema users (ords_metadata and ords_public_user) .<br />
<br />
Thus I have come to the conclusion it is best to do it step by step, the database users have to be created first. You can extract the installation scripts from the ords.war just as well:<br />
- http://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#CHDDIFEC<br />
- http://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#CHDFJHEA<br />
<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com3tag:blogger.com,1999:blog-20788401.post-22034551722274501852015-06-10T18:30:00.003+02:002015-06-10T18:30:37.964+02:00APEX Connect Presentation and Download of the sample applicationHi guys,<br />
<br />
I have just finished my presentation on the smaller new features of Oracle Application Express 5.0 here at the APEX Connect conference in Düsseldorf ... it was a blast :).<br />
<br />
You can download the slides and the sample application here:<br />
<br />
<div>
<ul>
<li><a href="http://www.opal-consulting.de/downloads/presentations/2015-06-DOAG-APEX-Connect/APEX5-New-Features.pdf" target="_blank">APEX 5 New Features - auch die Kleinen verdienen Beachtung!</a></li>
<li><a href="http://www.opal-consulting.de/downloads/presentations/2015-06-DOAG-APEX-Connect/Sample%20Application.zip" target="_blank">Sample Application</a></li>
</ul>
</div>
<div>
Cheers, </div>
<div>
~Dietmar. </div>
<div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-64196598916951871262015-04-20T16:38:00.003+02:002015-04-20T16:38:45.145+02:00APEX Summer School 2015 - Online WebinareIm Rahmen der APEX Summer School 2015 ( Twitter Handle: #apexsummer2015 ) werden wir <a href="https://apex.oracle.com/pls/apex/f?p=74314:1:::" target="_blank">9 kostenlose Webinare</a> zum Thema APEX 5 mit den Experten aus dem deutschsprachigen Raum durchführen:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgODzxdSjil1Ihvz6Lw4Q9cIdbsNu9PCq-JZYl-lir22rSSpRI6dUG5Isw8yJvJkPF63jhOenJTkdiHyINPkDC52euK7ofKJVnINjpfBj1iu_vEddM0ArWBOHe5ek2Q11X3zeHn/s1600/Bildschirmfoto+2015-04-20+um+16.33.15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgODzxdSjil1Ihvz6Lw4Q9cIdbsNu9PCq-JZYl-lir22rSSpRI6dUG5Isw8yJvJkPF63jhOenJTkdiHyINPkDC52euK7ofKJVnINjpfBj1iu_vEddM0ArWBOHe5ek2Q11X3zeHn/s1600/Bildschirmfoto+2015-04-20+um+16.33.15.png" height="250" width="320" /></a></div>
<br />
<br />
Vielen Dank an <a href="https://twitter.com/cczarski" target="_blank">Carsten Czarski</a> für die Einladung und Organisation! Nicht zuletzt auch vielen Dank für die klasse Homepage des Webinars, alles 100% APEX 5 out-of-the-box! Ein einfaches und dennoch wirkungsvolles Beispiel dafür, was standardmäßig mit APEX 5 möglich ist:<br />
<br />
<a href="http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html" target="_blank">APEX 5 </a>ist seit letzter Woche produktiv verfügbar und kann <a href="http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html" target="_blank">hier zum heruntergeladen werden</a>.<br />
<br />
Es gibt noch weitere APEX Veranstaltungen, schaut doch mal rein.<br />
<br />
Es wird ein heißer APEX - Sommer ;).<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcGG7KF5CsXZ2_ZKLzzP-EGnv2jaOU4XDCNlhnRv6UyJu9Nc9HmKfuG4_YR61XbCWu92MsVhoZtVp1mFmbgrlSIj8wR4NoXd5m5Kzq3N2-2oQWcnC-BFguMv0gHJeFiQJeLFhs/s1600/apexsummer2015.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcGG7KF5CsXZ2_ZKLzzP-EGnv2jaOU4XDCNlhnRv6UyJu9Nc9HmKfuG4_YR61XbCWu92MsVhoZtVp1mFmbgrlSIj8wR4NoXd5m5Kzq3N2-2oQWcnC-BFguMv0gHJeFiQJeLFhs/s1600/apexsummer2015.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Viel Vergnügen,<br />
~Dietmar.<br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-76451575369556742792015-03-30T11:05:00.001+02:002015-03-30T11:05:46.840+02:00Slides from my presentation at APEX World 2015 in RotterdamHi guys,<br />
<br />
I had a great time at <a href="https://www.ogh.nl/page.aspx?lang=en&event=241" target="_blank">APEX World in Rotterdam</a>, it was a wonderful event. I could meet up with my friends and learn a few new tricks, too :).<br />
<br />
<a href="http://www.opal-consulting.de/downloads/presentations/2015-03-25-APEX-World-Rotterdam/2015-03-25-APEX-World-APEX-5.0-NF.pdf" target="_blank">Here are the slides from my presentation</a> about the many smaller new features of Oracle APEX 5.0. And I could only cram like half of the good stuff that I found into this 45 min. session.<br />
<br />
About 70 people attended the session and I sure hope they will use some of the features I presented.<br />
<br />
Once I clean up my demo application, I will make it available, too. <br />
<br />
Cheers,<br />
~Dietmar.<br />
Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-72441809455133204712014-05-01T21:05:00.003+02:002014-05-01T21:05:47.411+02:00Professional support offering for the JasperReportsIntegration toolkit officially announcedYou are using the free tool <a href="http://www.opal-consulting.de/tools/jasper_integration" target="_blank"><strong>JasperReportsIntegration</strong></a> from Opal Consulting and you might be struggling with setting it up and integrating it into you own APEX applications?<br />
<br />
Now you have somebody to talk to!<br />
<br />
Already several years ago I have built this software for my own reporting needs in a project for a client of mine. <br />
<br />
Then I wrapped it up, documented it and gave it to the incredible and wonderful Oracle APEX community to help them with their reporting needs as well.<br />
<br />
As time went by it would become more difficult for me to make the free time to answer the different questions, keep developing the software and adding new features.<br />
<br />
In order to move the free tool forward but also because some people requested a professional support offering, I have finally created one.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.opal-consulting.de/site/products/" target="_blank"> <img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji5LMhupbvDx7eQXTsFGVynUL4MxU_eZJEIeRPfCFkkd4I61UJutZOdkVwkEsR442W9osBFRZhjcKEHCti6i1BAZVUPQeDt3mvdi5IED2SraDzn9T2qB4quasKp0PK8CjPFYqD/s1600/Snap+2014-05-01+at+21.00.06.png" height="204" width="320" /></a></div>
<br />
You will get:<br />
<ul>
<li>Priority email support,</li>
<li>can schedule support calls via Skype</li>
<li>and can participate in the monthly (1 hour) conference call to ask all kinds of questions</li>
</ul>
If you are interested, you will find more details here: <a href="http://www.opal-consulting.de/site/products/" target="_blank">http://www.opal-consulting.de/site/products/</a><br />
<br />
So, this is your chance to contribute back and help me to further support the APEX community.<br />
<br />
Also, when enough people have signed up for this support offering, I will create a professional version with thrilling advanced features, so that it will be able to use the same APEX integration as the BI Publisher, i.e. using report queries and report templates (not based on RTF but on JRXML).<br />
<br />
Hope you find it interesting.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.opal-consulting.de/site/products/" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" target="_blank"></a><a href="http://www.opal-consulting.de/site/products/" target="_blank"><img alt="http://www.opal-consulting.de/site/products/" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwkB1OnUIHd3woiOHC0Tdhs4AAnGf_LJdDc2XbymefjR4s4GPjdMUvNeyGym_cerzpAaQehEBaVBXAnzRmKusUraJwVFXDhiOmAlhX7OT_L8TrWeoA2J7TKUdWzx6YdVmnk244/s1600/Snap+2014-05-01+at+21.02.38.png" height="205" width="400" /></a></div>
<br />
Let me know what you think.<br />
<br />
Regards,<br />
~Dietmar. Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com3tag:blogger.com,1999:blog-20788401.post-47989159475237960032014-04-27T14:41:00.000+02:002014-04-27T14:41:07.501+02:00APEX 4.2 Best Practices Training am 26.05-28.05.2014<div style="font-family: Arial; font-size: 12pt;">
<span style="font-weight: bold;"></span>
<br />
<table border="0" cellpadding="2" cellspacing="2" style="text-align: left; width: 550px;">
<tbody>
<tr>
<td style="vertical-align: top;">Wußten Sie schon, daß in APEX 4.2 alleine <span style="font-weight: bold;">130 neue Features</span> implementiert
wurden, die uns Entwickler SOFORT produktiver werden lassen und das
Leben erleichern? <br />
<br />
Auch wird jedes Release von APEX <span style="font-weight: bold;">immer
sicherer</span>, es kommen immer wieder neue Security Features hinzu.<br />
<br />
Das alles hilft uns jedoch nur, wenn wir diese Features überhaupt <span style="font-weight: bold;">kennen und optimal einsetzen!</span><br />
<br />
Seit 2006 bauen wir <span style="font-weight: bold;">jeden Tag</span> <span style="font-weight: bold;"></span>Applikationen mit APEX für unsere
Kunden, ja genau - an jedem Tag! Na ja, vielleicht nicht am Wochende
für unsere Kunden ... dann aber für die APEX Community ;). <br />
<br />
Mobile Endgeräte, HTML 5, mehr Dynamik mit JQuery und Dynamic Actions,
einbruchssichere Applikationen und REST Webservices werden immer
wichtigere Themen, die man als Entwickler einfach kennen sollte. <br />
<br />
In unseren Kursen haben wir schon <span style="font-weight: bold;">über
200 APEX-Fans</span> die besten Herangehensweisen, Tipps und Tricks
beigebracht. Durch die Hands-On Übungen vertiefen wir diese und Sie
können diese sofort einsetzen ... oder Sie schlagen sie nach ... wenn
Sie sie später brauchen ;). <span style="font-weight: bold;">Aber auf
jeden Fall wissen Sie nach dem Kurs, was möglich ist!</span><br />
<br />
Wir beide (Denes und Dietmar) haben schon alles mit APEX ausprobiert
und auch schon alle Fehler gemacht! <span style="font-weight: bold;">Nehmen
Sie die Abkürzung</span> und lernen Sie gleich, was sich immer wieder
bewährt hat ... <span style="font-weight: bold;">weil es funktioniert!</span>
<br />
<br />
Mit jedem Release gibt es neue Features und auch wir passen unser
Vorgehen immer wieder an - <span style="font-weight: bold;">weil es
sich einfach lohnt!</span><br />
<br />
<br />
Wenn Sie Ihre Kenntnisse in der APEX Entwicklung auf das nächste Niveau
bringen wollen, dann melden Sie sich am besten gleich an:<br />
<ol>
<li>Klicken Sie auf den Link "Anmeldung zum Kurs".</li>
<li>Tragen Sie Ihre Anmeldedaten ein und klicken Sie auf den
Button "Anmelden".</li>
<li>Sie bekommen sofort eine Bestätigungs-Email zugeschickt. <br />
</li>
<li>Sobald Sie in der Email auf den Link zur Bestätigung
klicken, haben Sie Ihren Platz gesichert und sind auf jeden Fall dabei!<br />
</li>
</ol>
<a href="http://www.opal-consulting.de/apex/f?p=107:8:0::NO:7:P8_CLS_ID:921" target="_blank"> Anmeldung zum Kurs </a> <br />
<br />
<span style="font-weight: bold;">P.S.</span>: Wir haben es sogar,
geschafft, <span style="font-weight: bold;">Carsten
Czarski</span> für unseren Kurs zu gewinnen! Wir werden mit ihm mobile
Applikationen bauen und er wird uns seinen <span style="font-weight: bold;">Geolocation Showcase</span> im
Detail zeigen, die Packaged Application, die er für das APEX Team
entwickelt hat und die mit APEX 4.2.5 weltweit ausgeliefert wird, sehr
cool!<br />
<br />
<span style="font-weight: bold;">P.P.S.</span>: Die vollständige
Agenda und weitere Infos zum Kurs gibt es <big><a href="http://www.opal-consulting.de/apex/f?p=107:7:0::NO:7:P7_CLS_ID:921">online
in der Kursbeschreibung</a></big>. </td>
</tr>
</tbody>
</table>
<span style="font-weight: bold;"><br />
<br />
</span></div>
Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-81803892249227588042014-04-15T00:38:00.000+02:002014-04-15T00:38:33.026+02:00JasperReportsIntegration - Full path requirement and workaroundI have just posted an answer to a question that seems like a bug in the JasperReportsIntegration toolkit, that you have to use absolute paths for referencing images or subreports, which is typically a bad thing.<br />
<br />
Don't know exactly why it doesn't work, but there is a workaround for that: <a href="http://www.opal-consulting.de/site/jasperreportsintegration-full-path-requirement-and-workaround/">http://www.opal-consulting.de/site/jasperreportsintegration-full-path-requirement-and-workaround/</a><br />
<br />
Hope that helps,<br />
~Dietmar.<br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com3tag:blogger.com,1999:blog-20788401.post-1773581064623720162014-04-14T23:50:00.002+02:002014-04-14T23:50:50.172+02:00First blogpost at my own hosted wordpress instanceI have been blogging at <a href="http://daust.blogspot.com/" target="_blank">daust.blogspot.com</a> for quite some years now ... and many people have rather preferred wordpress to blogspot, I can now understand why :).<br />
<br />
It is quite flexible and easy to use and there are tons of themes available ... really cool ones.<br />
<br />
The main decision to host my own wordpress instance was in the end motivated by different means. I have created two products and they needed a platform to be presented:
<br />
<ul>
<li><a href="http://www.opal-consulting.de/site/products/opal-xp/" target="_blank" title="OPAL:XP">OPAL:XP</a></li>
<li><a href="http://www.opal-consulting.de/site/products/opal-xe/" target="_blank" title="OPAL:XE">OPAL:XE</a></li>
</ul>
First I wanted to buy a new theme from themeforest and build an APEX theme for that ... but this is a lot of work.<br />
<br />
I then decided to host my content using wordpress since I have already bought a new theme: <a href="http://www.kriesi.at/themedemo/?theme=enfold" target="_blank">http://www.kriesi.at/themedemo/?theme=enfold</a><br />
<br />
And this one has a really easy setup procedure for wordpress and comes with a ton of effects and wizards, cool page designer, etc.<br />
<br />
Hopefully this will get mit motivated to post more frequently ... we will see ;).<br />
<br />
Cheers,<br />
~Dietmar.
Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-85683226911697165962014-02-12T23:58:00.000+01:002014-02-12T23:58:02.969+01:00Oracle APEX Listener - support for Apache TomcatThe <a href="http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html?ssSourceSiteId=otnpt" target="_blank">Oracle APEX listener</a> is one possible gateway to run Oracle Application Express besides the Oracle http server (OHS), the embedded pl/sql gateway (which is the http server included in the Oracle database as part of the XML DB) and other open source alternatives.<br />
<br />
Being implemented as a J2EE application it needs a servlet container to be deployed in. Finally, due to popular customer demands, the Apache Tomcat servlet container is (again) supported. Many customers are using it already for quite a while and I personally had hardly any issues with that.<br />
<br />
When you look at the APEX listener 2.0 installation guide you will find a section on <a href="http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25066/install.htm#CHDGAIAJ" target="_blank">deploying to tomcat</a>. There they talk about Apache Tomcat 7 but it seems like <a href="http://krisrice.blogspot.de/2013/11/apex-listener-supported-app-servers.html" target="_blank">version 6 is also supported</a>, I have found the information on Kris Rices blog, he is the development manager of the APEX listener. <br />
<br />
This is not really NEW news ;), but I personally had not seen this information before.<br />
<br />
Cheers and enjoy,<br />
~Dietmar. <br />
<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com1tag:blogger.com,1999:blog-20788401.post-52941888258121727422013-11-21T16:41:00.000+01:002013-11-21T16:42:10.126+01:00Upgrading the JasperReports libraries to 5.2.0Would you like to upgrade your existing <a href="http://www.opal-consulting.de/tools/jasper_integration" target="_blank">JasperReportsIntegration</a> with the 5.2.0 libraries of JasperReports?<br />
<br />
As of now this already seems to be not the most current version, JasperReports has already moved on to 5.5.0. But since I have already created the 5.2.0 package a while ago, I might just post the instructions here. The 5.5.0 version will follow.<br />
<br />
Here you go ...<br />
<br />
This is an updated version of the original instructions found here: <a href="http://daust.blogspot.de/2013/01/upgrading-jasperreports-libraries-to-501.html">http://daust.blogspot.de/2013/01/upgrading-jasperreports-libraries-to-501.html</a><br />
<br />
<h3>
</h3>
<h3>
Step 1: Download the libary files for 5.2.0</h3>
<br />
You can download the files <a href="http://www.opal-consulting.de/downloads/free_tools/JasperReportsLibraries/5.2.0/" target="_blank">here</a>:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsuBth7ET5MqR_0hr3lZAJfvjQ96Ha3a68GTS-L6EcRipb6fQneUMx_8UK71lnzVwncU_mcbmAkCSrhmdqCerjwPr3Gxpwnkl4nKpUmD5EYhyphenhyphencdUmoDnlnBZ3WmE9Tpc849opx/s1600/2013-11-21+16_39_33-Index+of+_downloads_free_tools_JasperReportsLibraries_5.2.0.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="97" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsuBth7ET5MqR_0hr3lZAJfvjQ96Ha3a68GTS-L6EcRipb6fQneUMx_8UK71lnzVwncU_mcbmAkCSrhmdqCerjwPr3Gxpwnkl4nKpUmD5EYhyphenhyphencdUmoDnlnBZ3WmE9Tpc849opx/s320/2013-11-21+16_39_33-Index+of+_downloads_free_tools_JasperReportsLibraries_5.2.0.png" width="320" /></a></div>
<br />
<h3>
</h3>
<h3>
Step 2: Shutdown the Apache Tomcat J2EE server</h3>
<h3>
</h3>
<h3>
Step 3: Remove the existing JasperReportsLibraries from your existing installation</h3>
<br />
Typically, after you have installed your previous version of the <a href="http://www.opal-consulting.de/tools/jasper_integration" target="_blank">JasperReportsIntegration</a> toolkit on your Apache Tomcat J2EE server, the files will be located in the directory <span style="font-family: "Courier New",Courier,monospace;">$CATALINA_HOME/webapps/JasperReportsIntegration/WEB-INF/lib</span>, for example version 4.7.0 of JasperReports, where <span style="font-family: "Courier New",Courier,monospace;">$CATALINA_HOME</span> represents the path to your installation of Tomcat.<br />
<br />
Then you would have to remove these libraries first. In this directory you should find two files for removal: <span style="font-family: "Courier New",Courier,monospace;">_jasper-reports-delete-libs-4.7.0.sh</span> and <span style="font-family: "Courier New",Courier,monospace;">_jasper-reports-delete-libs-4.7.0.cmd</span>, for *nix or Windows respectively. For *nix systems you would have to make it executable, though, e.g.: <span style="font-family: "Courier New",Courier,monospace;">chmod u+x _jasper-reports-delete-libs-4.7.0.sh</span> . Then you can call it and it will remove all files for version 4.7.0. But it will <b>NOT </b>remove the file for the JasperReportsIntegration <b>and all other libraries which YOU might have placed there deliberately</b>.<br />
<br />
You can always find the required removal scripts here: <a href="http://www.opal-consulting.de/downloads/free_tools/JasperReportsLibraries/" target="_blank">http://www.opal-consulting.de/downloads/free_tools/JasperReportsLibraries/ .</a><br />
<br />
Whenever I release another package, the removal scripts for that package will be shipped as well. <br />
<br />
<h3>
Step 4: Install the new 5.2.0 libraries</h3>
<br />
Now you can just copy the new libraries from <span style="font-family: "Courier New",Courier,monospace;">JasperReportsLibraries-5.2.0.zip</span> into <span style="font-family: "Courier New",Courier,monospace;">$CATALINA_HOME/webapps/JasperReportsIntegration/WEB-INF/lib.</span><br />
<h3>
</h3>
<h3>
Step 5: Start the Apache Tomcat J2EE server again</h3>
<br />
Now you system should be upgraded to the most current JasperReports 5.2.0 !<br />
<br />
Just drop me a note when you need updated libraries for a later JasperReports version, etc. I have scripts in place to create a new package of the libraries.<br />
<br />
Here you can find the notes from my upgrade (4.5.0 => 4.8.0) on Linux to illustrate the process, I hope it makes sense:<br />
<br />
<pre class="brush: sql">**
** download the libraries from:
** http://www.opal-consulting.de/downloads/free_tools/JasperReportsLibraries/4.8.0/JasperReportsLibraries-4.8.0.zip
** to /home/jasper/JasperReportsLibraries
cd /home/jasper
mkdir JasperReportsLibraries
** unzip them
cd JasperReportsLibraries
unzip JasperReportsLibraries-4.8.0.zip -d JasperReportsLibraries-4.8.0
** stop tomcat server
/home/jasper/tomcat/bin/shutdown.sh
** remove libraries of current jasper reports release
cd /home/jasper/tomcat/webapps/JasperReportsIntegration/WEB-INF/lib
chmod +x _jasper-reports-delete-libs-4.5.0.sh
dos2unix _jasper-reports-delete-libs-4.5.0.sh
./_jasper-reports-delete-libs-4.5.0.sh
** copy libraries of the new release to the WEB-INF/lib directory
cp /home/jasper/JasperReportsLibraries/JasperReportsLibraries-4.8.0/* /home/jasper/tomcat/webapps/JasperReportsIntegration/WEB-INF/lib
** restart tomcat
/home/jasper/tomcat/bin/startup.sh
</pre>
Cheers,<br />
~Dietmar.<br />
<div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com9tag:blogger.com,1999:blog-20788401.post-23141530827668539632013-09-23T19:20:00.001+02:002013-09-23T19:20:36.758+02:00Oracle APEX 4.2 New Features und Tipps aus der Praxis - Neuer Kurs am 11.11.2013In diesem November werden <a href="http://deneskubicek.blogspot.de/" target="_blank">Denes Kubicek</a> und ich wieder einen Kurs zu Oracle APEX in Bensheim abhalten:<br />
<br />
<h3>
<a href="http://www.opal-consulting.de/apex/f?p=107:7:0::NO::P7_CLS_ID:861" target="_blank">Oracle APEX 4.2 New Features und Tipps aus der Praxis</a></h3>
<br />
Wir werden diesmal viel über den APEX Listener, Einsatz von jQuery und über Restful Web Services reden und natürlich, praktisch üben. <br /><br />Darüber hinaus gehen wir auch das Thema Mobile Development an und geben einen Überlick über die 100+ neuen Features, die sich auch in diesem Release wieder geändert haben. Mir gefällt besonders, dass durch diese vielen kleinen Verbesserungen die Transparenz in der Applikationsentwicklung nochmals erhöht wurde. <br /><br />Gerade die Packaged Applications liefern viele gute Beispiele, wie häufig verwendete Design Patterns in der Praxis moderner umgesetzt werden können. <br /><br />Dieser <a href="http://www.opal-consulting.de/apex/f?p=107:7:0::NO::P7_CLS_ID:861" target="_blank">Link</a> informiert Sie über alle weiteren Details zum Kurs. <br /><br />Viele Grüße,<br />~Dietmar. <br /><br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-77683461037925520582013-05-22T21:41:00.001+02:002013-05-22T21:41:19.753+02:00DOAG 2013 Development in Bonn am 19. Juni<div class="separator" style="clear: both; text-align: center;">
<a href="http://development.doag.org/" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDocxbuMCMv7Ei54aJ-Nz-zwUhFM9NIrKb4JgrS-RzcGUT7K6SP73oK7cqiyNaWfF55CYXxwUF7dkZvGrezRaP3M9WfQq1H2CRAHkAoCytVozLimQ33s4ag1KN7tIvL1jFocoH/s1600/2013-Devel-Banner_468x60.jpg" /></a></div>
<br />
Am 19.Juni 2013 findet die nächste DOAG Development Konferenz in Bonn statt, diesmal mit dem Thema:<br />
<h3>
„Agile and Beyond – Projektmanagement in der Oracle-Softwareentwicklung“</h3>
Das Motto der zweiten Auflage der Community Konferenz steht fest: Die effektive Durchführung von Softwareprojekten steht thematisch im Zentrum der Konferenz für Entwickler, Softwarearchitekten und Projektleiter.<br />
<br />
Gerade Oracle APEX eignet sich hervorragend für die agile Durchführung von Softwareprojekten, ich habe damit seit Jahren hervorragende Ergebnisse erzielt. Mit Oracle APEX kann man in extrem kurzen Iterationszyklen von 1-4 Wochen sehr beachtliche Funktionalitäten implementieren. Gerade die Lieferung von Funktionalitäten in kurzen Abständen hilft, das Vertrauen der Fachseiten zu gewinnen. Dennoch gibt es einige Fallstricke zu beachten, damit auch alles rund läuft ;).<br />
<br />
Weitere Informationen zur Konferenz <a href="http://development.doag.org/" target="_blank">finden Sie hier</a>. <br />
<br />
Bitte beachten: der Frühbucher-Rabatt endet heute!<br />
<br />
Viele Grüße,<br />
~Dietmar. Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-30928978621491485162013-05-22T13:07:00.000+02:002013-05-22T16:58:15.513+02:00How to locate all interactive reports in my application?Today my client decided to remove the email functionality from all interactive reports in their APEX application.<br />
<br />
I could step through all the pages of my application and check whether there are any interactive reports used. This very manual approach can take some time and I can make mistakes by overlooking some of the interactive reports to modify. <br />
<br />
A different approach would be to use the (officially supported) data dictionary views in APEX. Using this simple sql query I can find all interactive reports in all pages of my application (having the id 20120618):<br />
<pre class="brush: sql">select workspace
, application_id
, application_name
, page_id
, region_name
, download_formats
from apex_application_page_ir
where application_id=20120618
order by page_id;
</pre>
This will show all interactive reports which are used in my application:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy0gZdnYTP1H-2DfanSEzGTsl6WNLst0xy4YPnz1xDB89j7swmuAPdGhnRdQaI8B2WiGARY7fUqj5Vl8MKriWiP4L3jddAci9COGkWhMj9BviFD7rV_GrdcnpLgixGi8rDb33y/s1600/2013-05-22+10_45_29-Oracle+SQL+Developer+_+it4fm_rwht__1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="81" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy0gZdnYTP1H-2DfanSEzGTsl6WNLst0xy4YPnz1xDB89j7swmuAPdGhnRdQaI8B2WiGARY7fUqj5Vl8MKriWiP4L3jddAci9COGkWhMj9BviFD7rV_GrdcnpLgixGi8rDb33y/s400/2013-05-22+10_45_29-Oracle+SQL+Developer+_+it4fm_rwht__1.png" width="400" /></a></div>
<br />
We can even look for all interactive reports that need to be fixed by specifically looking for all reports where the download format email is enabled:<br />
<pre class="brush: sql">select workspace
, application_id
, application_name
, page_id
, region_name
, download_formats
from apex_application_page_ir
where application_id=20120618
and instr(download_formats, 'EMAIL') > 0
order by page_id;</pre>
These data dictionary views contain a wealth of information about your application. This is a real strength of Oracle Application Express, due to its nature being driven by a metadata repository.<br />
<br />
Thus from a quality management perspective you could use the following query to make sure, all interactive reports are configured the same way, i.e. having flashback disabled, using the same display position for pagination (Top and Bottom-Left) and showing the dropdown list for selecting the rows per page:<br />
<pre class="brush: sql">select workspace
, application_id
, application_name
, page_id
, region_name
, pagination_display_position
, show_rows_per_page
, show_flashback
from apex_application_page_ir
where application_id=20120618
and ( pagination_display_position <> 'Top and Bottom - Left'
or show_rows_per_page = 'No'
or show_flashback = 'Yes' )
order by page_id;</pre>
Here is the result:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4ui_0t6XMMQeRPnMYe3xzPnhRLozEnWnRounmtuhE0fUcDCCZ4U7O5nfYrOX_JUIr_mvZLvYe3jIuHVnIwaMf1fcQScnfm0wXa04LVkI46MO9Q3VVSqSEmdXNst0FjbklsVu2/s1600/2013-05-22+10_58_36-Oracle+SQL+Developer+_+it4fm_rwht__1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="56" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4ui_0t6XMMQeRPnMYe3xzPnhRLozEnWnRounmtuhE0fUcDCCZ4U7O5nfYrOX_JUIr_mvZLvYe3jIuHVnIwaMf1fcQScnfm0wXa04LVkI46MO9Q3VVSqSEmdXNst0FjbklsVu2/s400/2013-05-22+10_58_36-Oracle+SQL+Developer+_+it4fm_rwht__1.png" width="400" /></a></div>
<br />
But how do we find the appropriate views? The APEX data dictionary contains information about all available data dictionary views and all of their columns.<br />
<br />
Typicall I use the following query to find all information about interactive reports, all related views contain _IR_ in the view name:<br />
<pre class="brush: sql">select *
from apex_dictionary
where apex_view_name like '%IR%'</pre>
This will show us all view including their respective columns:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ-DYRYbe72_uzoI46aE-oDooD5T9KHT3ObmGgQnAPphFeybbBVVE0NcwoCj7DQqGhFcrpEtQL4Kc2dFbtAvGj-IdALmME1EDIky7TWvgi-AfHNkJ__vmFleO5DzbxG4rROM6C/s1600/2013-05-22+11_01_43-Oracle+SQL+Developer+_+it4fm_rwht__1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="78" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ-DYRYbe72_uzoI46aE-oDooD5T9KHT3ObmGgQnAPphFeybbBVVE0NcwoCj7DQqGhFcrpEtQL4Kc2dFbtAvGj-IdALmME1EDIky7TWvgi-AfHNkJ__vmFleO5DzbxG4rROM6C/s400/2013-05-22+11_01_43-Oracle+SQL+Developer+_+it4fm_rwht__1.png" width="400" /></a></div>
<br />
If we want to display the view only without their columns we can add the filter for the <span style="font-family: "Courier New",Courier,monospace;">column_id 0</span>, in there the APEX team added the overall description of the view itself:<br />
<pre class="brush: sql">select *
from apex_dictionary
where apex_view_name like '%IR%'
and column_id=0; </pre>
Now, we get only the view names including their description:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7smZ-9YiTC4ffVUBfdJcQkV_Fb3knaHzAbxti8Z36cTtR56Xcp6u4v1MUdu_4DjEjLHl_CiXvaloD4Q_mgq4DxI896MiEF0woBbd20LIWoF5FV7Z3qNGS9V-9E7s8yiIUvhpW/s1600/2013-05-22+11_05_45-Oracle+SQL+Developer+_+it4fm_rwht__1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="60" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7smZ-9YiTC4ffVUBfdJcQkV_Fb3knaHzAbxti8Z36cTtR56Xcp6u4v1MUdu_4DjEjLHl_CiXvaloD4Q_mgq4DxI896MiEF0woBbd20LIWoF5FV7Z3qNGS9V-9E7s8yiIUvhpW/s400/2013-05-22+11_05_45-Oracle+SQL+Developer+_+it4fm_rwht__1.png" width="400" /></a></div>
<br />
Regards,<br />
~Dietmar. <br />
<br />Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-20582467977683136902013-04-27T11:36:00.000+02:002013-04-27T11:36:07.294+02:00Oracle Application Express 4.2.2 Patch releasedJust yesterday, the most recent APEX patch set has been released. It is <span class="revnumber">Release 4.2.2.00.11. The full version just as well as the patch set to apply to a 4.2.0 or 4.2.1 instance <a href="http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html" target="_blank">can be downloaded from here</a>.</span><br />
<span class="revnumber"><br /></span>
<span class="revnumber">The full details can be found on <a href="http://joelkallman.blogspot.de/2013/04/oracle-application-express-422-now.html" target="_blank">Joel's Blog</a>. </span><br />
<span class="revnumber"><br /></span>
<span class="revnumber">Nevertheless I will have a good look at the <a href="http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-422-patch-set-notes-1940408.html#CHDFABBF" target="_blank">release notes</a>, because they contain quite some important notes, which you should be aware of before upgrading. Especially, there were some changes made to the templates. So it is wise to upgrade your existing 4.2.0 / 4.2.1 instance with the patch set directly. If you export/import a 4.2.1 APEX application into a 4.2.2 instance, you cannot leverage the changes immediately, you would have to install the new theme and switch it then. </span><br />
<span class="revnumber"><br /></span>
<span class="revnumber">I will try to look at these issues in more detail ...</span><br />
<span class="revnumber"><br /></span>
<span class="revnumber">Cheers, </span><br />
<span class="revnumber">~Dietmar. </span>Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0tag:blogger.com,1999:blog-20788401.post-62113337630163180782013-04-22T21:48:00.000+02:002013-04-22T21:48:22.022+02:00Join me at ODTUG's Expert Panel - Oracle Application Express<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">In May, I will take part in one of <a href="http://www.odtug.com/online-education" target="_blank">ODTUG's webinars</a>:</span><br />
<br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span style="color: #074666;"><strong>Tuesday, May 14, 2013 12:00 PM - 1:00 PM EDT</strong></span></span><br />
<br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">
</span><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><em><strong>ODTUG's Expert Panel - Oracle Application Express</strong></em><br /><span style="font-size: 13px;"><strong> </strong></span></span><br />
<span style="font-size: small;"><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span><strong>Panelists: Dietmar Aust</strong> (Opal Consulting), <strong>Roel Hartman</strong> (APEX Evangelists ), <strong>Dan McGhan</strong> (Enkitec)<br /><strong>Moderator: Patrick Cimolini</strong> (Patrick International APEX Consulting) </span></span></span><br />
<br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">
</span><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">This is a live interactive panel similar to the ACE Lunch and Learn
panels held at Kscope. This innovative webinar is modeled after a
call-in radio talk show. You will be able to chat a question to our
organizer and if it is accepted you will have the option to verbally ask
the question to our panel. Please be sure to have the proper equipment
(headset and a quiet office) so that our panelists can clearly
understand your question. You’ll also be able to participate in the
discussion with the panel while they answer your question. </span><br />
<br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">
</span><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">The following are some potential topics, but audience participation will shape the scope of the panel: </span><br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">
</span><ul>
<li><span style="font-size: small;"><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span>What skill sets does an APEX team need? </span></span></span></li>
<li><span style="font-size: small;"><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span>What options are available for producing printed reports from APEX?</span></span></span></li>
<li><span style="font-size: small;"><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span>Moving away from Forms/Reports to APEX </span></span></span></li>
<li><span style="font-size: small;"><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span>Interactive Reports - THE killer feature of APEX </span></span></span></li>
<li><span style="font-size: small;"><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span>Developer Productivity - negotiate
and tweak the requirements with the customers in order to use standard
APEX components to implement them = unparalleled productivity</span></span></span></li>
<li><span style="font-size: small;"><span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span>Real-world showcases (APEX can handle application complexity just as well as a high load serving many users)</span></span></span></li>
</ul>
<br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">Personally, I like ODTUG a lot, it is a friendly and very competent place to be, I always enjoy the conference.</span><br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">The panel will be held for 90minutes, so there will be a lot of time asking questions :). </span><br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">You can register for the webinar <a href="https://www3.gotomeeting.com/register/909624086" target="_blank">here</a>. </span><br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">Cheers, </span><br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;">~Dietmar. </span><br />
<span style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><br /></span>Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com2tag:blogger.com,1999:blog-20788401.post-57815024990160063212013-04-18T17:13:00.001+02:002013-04-19T10:29:40.565+02:00How to make your browser save your passwordTypically and for good security reasons the password manager from either Firefox or any other browser will not prompt you to save the password for the login screen of the APEX workspace or any of your own APEX applications.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXV25dGKlYbhe2dVKMiRthIEm9QqgX8xvGCbKzFbUR_bvJy7JuAJDdJLdgzeTMJh-ovFwsrSfbM1ekj1C4tFKwkiEk3Um8D9NNJv0CxmfmiJLbnetV7ZVGFIIolxjx59lmW0in/s1600/2013-04-18+16_33_48-Application+Express+Login.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXV25dGKlYbhe2dVKMiRthIEm9QqgX8xvGCbKzFbUR_bvJy7JuAJDdJLdgzeTMJh-ovFwsrSfbM1ekj1C4tFKwkiEk3Um8D9NNJv0CxmfmiJLbnetV7ZVGFIIolxjx59lmW0in/s320/2013-04-18+16_33_48-Application+Express+Login.png" width="320" /></a></div>
<br />
<br />
Why? The APEX team implemented the login page with the HTML attribute autocomplete=off:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5Bm06kLGXGVxKMhZPiBl6J6KDL8-vLNV0EoVK7yW29PE0uVLXsWEz3yjhM_I4EELahR4ZYDfBWDJJ9gKVcBwnKcLokdSXZzePPDKa9uJ8FqDFu2IuV37E-m-uZczGtCqjURDo/s1600/2013-04-18+16_36_33-Quelltext+von_+http___localhost_8081_apex_f_p=4550_1_6127695668784_____&p_lang=e.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="12" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5Bm06kLGXGVxKMhZPiBl6J6KDL8-vLNV0EoVK7yW29PE0uVLXsWEz3yjhM_I4EELahR4ZYDfBWDJJ9gKVcBwnKcLokdSXZzePPDKa9uJ8FqDFu2IuV37E-m-uZczGtCqjURDo/s640/2013-04-18+16_36_33-Quelltext+von_+http___localhost_8081_apex_f_p=4550_1_6127695668784_____&p_lang=e.png" width="640" /></a></div>
<br />
For a development environment I find this behaviour kind of annoying, especially when the APEX builder session times out frequently and you have to login to your workspace multiple times during the day.<br />
<br />
Thus I have looked around and found a javascript routine which removes the autocomplete=off attribute from the form.<br />
<br />
Just right-click on this link and save it as a bookmark: <a href="javascript:(function(){var%20ca,cea,cs,df,dfe,i,j,x,y;function%20n(i,what){return%20i+"%20"+what+((i==1)?"":"s")}ca=cea=cs=0;df=document.forms;for(i=0;i<df.length;++i){x=df[i];dfe=x.elements;if(x.onsubmit){x.onsubmit="";++cs;}if(x.attributes["autocomplete"]){x.attributes["autocomplete"].value="on";++ca;}for(j=0;j<dfe.length;++j){y=dfe[j];if(y.attributes["autocomplete"]){y.attributes["autocomplete"].value="on";++cea;}}}alert("Removed%20autocomplete=off%20from%20"+n(ca,"form")+"%20and%20from%20"+n(cea,"form%20element")+",%20and%20removed%20onsubmit%20from%20"+n(cs,"form")+".%20After%20you%20type%20your%20password%20and%20submit%20the%20form,%20the%20browser%20will%20offer%20to%20remember%20your%20password.")})();">Force browser to save the password</a><br />
I have found it <a href="http://www.werockyourweb.com/force-firefox-save-password" target="_blank">here</a>, but it is explained on many other websites as well.<br />
<br />
Once you click on your bookmark you will see the following message: <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRPIDPKAnexGFSJe0hr4PHia_QH0qpnGtXKLelzlLgWlFx_-an5bJSwsH724a2eL8w8CQ4opQZ_QfLzYk_-ru3KaDWrZ8q6f_I0Gpt_EA0P948K2FM3C2S6Sy_qIU0LZNIMchb/s1600/2013-04-18+17_06_19-Application+Express+Login.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRPIDPKAnexGFSJe0hr4PHia_QH0qpnGtXKLelzlLgWlFx_-an5bJSwsH724a2eL8w8CQ4opQZ_QfLzYk_-ru3KaDWrZ8q6f_I0Gpt_EA0P948K2FM3C2S6Sy_qIU0LZNIMchb/s320/2013-04-18+17_06_19-Application+Express+Login.png" width="320" /></a></div>
<br />
<br />
If you continue to log into APEX you will get the typical message where you can save the password now:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5Z4tVxT_17PtDYOrFnSKgs8HjMRlAvaAuYUl3YxKbnOnyZ4yhUfL0Pf5oNe3OgGXems-4tlafHVaOpuSdGIg4UqVlvihLykH_VX84tpuHdbBBDUOWB2SxUp3wKF9WJvZ4A5GN/s1600/2013-04-19+10_28_28-Oracle+Application+Express.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="218" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5Z4tVxT_17PtDYOrFnSKgs8HjMRlAvaAuYUl3YxKbnOnyZ4yhUfL0Pf5oNe3OgGXems-4tlafHVaOpuSdGIg4UqVlvihLykH_VX84tpuHdbBBDUOWB2SxUp3wKF9WJvZ4A5GN/s320/2013-04-19+10_28_28-Oracle+Application+Express.png" width="320" /></a></div>
<br />
<br />
It is good practice to use a password for your password manager in Firefox, too. <a href="https://support.mozilla.org/en-US/kb/use-master-password-protect-stored-logins" target="_blank">Here are the steps to enable it</a>. <br />
<br />
Cheers and enjoy,<br />
~Dietmar.<br />
<br />
<br />
Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com1tag:blogger.com,1999:blog-20788401.post-85149523541378363642013-03-04T07:56:00.000+01:002013-03-04T07:58:24.257+01:00APEX Training 15.04. - 17.04.2013Wie jedes Jahr in den letzten sechs Jahren, veranstalten wir (<a href="http://deneskubicek.blogspot.de/" target="_blank">Denes Kubicek</a> und ich) unser <br />
<br />
<h4>
<a href="http://www.opal-consulting.de/apex/f?p=107:7:::NO:7:P7_CLS_ID:821" target="_blank"><i>Oracle APEX: Knowhow aus der Praxis</i></a></h4>
<h3>
</h3>
Training in Bensheim an der Bergstrasse.
Wir werden unsere bisherigen Themen überarbeiten und einige neue Themen hinzufügen.
So werde ich auch folgende neue Themen in das Programm der Schulung
aufnehmen:<br />
<br />
- jQuery (Beispiele und Übungen)<br />
- APEX Collections<br />
- Erstellung von komplexen Forms<br />
- APEX und Mehrsprachigkeit<br />
<br />
Wir haben dieses Mal einen ganz speziellen Gast zu der Schulung eingeladen - <a href="http://rokitta.blogspot.de/">Christian Rokitta</a>
aus den Niederlanden. Er ist ein Experte in Sachen Layoutgestalltung
und Mobile Applikationen. Die Teilnehmer der Schulung werden sich
gemeinsam für eins dieser Themen entscheiden und Christian wird es
vortragen.<br />
<br />
Unser Highlight sind auf jeden Fall die
abendlichen Q & A Session, in denen die Teilnehmer die
Gelegenheit bekommen ihre eigenen Projekte vorzustellen und ihre
konkrete Probleme mit uns zu diskutieren.<br />
<br />
Die Anmeldung zur Schulung finden Sie <a href="http://www.opal-consulting.de/apex/f?p=107:7:::NO:7:P7_CLS_ID:821" target="new">hier</a>.<br />
<br />
<br />
Viele Grüße,<br />
~Dietmar. Anonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.com0