About
Hi, I’m Jorge Rimblas. Father, husband, photographer (more about this), Oraclenerd, Oracle ACE, Oracle APEX expert, coffee lover, car guy, gadget addict, etc…
I’m an APEX Technical Lead at DRW. I have worked with Oracle since 1995 and done eBusiness Suite implementations and customizations. Nowadays I specialize almost exclusively in Oracle APEX.
The views expressed here are my own and no one else’s including my employer, DRW. Of course, I may or may not agree with the comments made on my posts by other people.
Places you can find me
twitter.com/rimblas
YouTube Channel
JorgeRimblas.com
flickr
LinkedIn
Hi Jorge!!
My Name is Nilesh and we meet at Kscope16 recently in Chicago. During Open Mic night I asked you about sharing your application for Locking the Record Lock.
Kindly please send the details if you can.
I hope you remember.
Thanks,
Nilesh
Hi Nilesh, it’s coming soon, soon. ;-)
Hi Jorge !!!
Any Update to my request?
Thanks.
I’m an “aficionado” of your blog.
I known, there is the Apex forum for this questions, but I think is more efficient your answer…
It’s easy or difficult to use multitenancy with Apex? Do you can write about this kind of development ?
Many thanks for your help and for your blog.
Thanks for following! ;-)
It’s an interesting question. APEX itself is multi-tenant and of course you could write multi-tenant apps. The challenge is more on your data model and data control. But, if available, features like RAS (or VPD) can greatly help.
“The challenge is more on your data model ”
unfortunately …is not elementary my dear Watson…
I find this article for SQL Server: http://www.upsizing.co.uk/Art66_MultiTenantDesign_PrintLayout.htm
but I don’t know if I can translate the functions in an Oracle architecture.
I quick glance tells me you would NOT want to replicate that approach in Oracle, but it’s possible.
It would depend on your particular situation.
I recommend you post this question on the forums or even the apex.world slack channel. They are great resources, lots of exposure, and easier to go back and forth with questions.
Thank you Jorge,
I will try with apex.world.
I already posted in Apex forum, but no answer…
I have a question regarding passing values from one page to another page in apex based on button click. I have selected Redirect to URL option and it allows me to pass up to 10 item values. I need to send 5 more values to the other page. How can I do this?? I looked around but none seem to work. Any suggestions/help would be greatly appreciated.
I would argue that you rarely need to do something like this (I thinking never actually). Let the page submit. Branch to the new page (passing nothing). The new page can reference ALL the values from the previous page because they are in session state.
Now, to answer your questions, you can build the URL manually and add the params you need. for example: P1_ITEM1,P1_ITEM2,P1_ITEM3:&VALUE1.,&VALUE2.,&VALUE2.
Please use APEX forums for follow ups or slack channel found on apex.world.
Thanks!
Hi,
Jorge.
Thanks for your innovative blogs about apex.
I have a query that I used to apply inline CSS on page load to anything looks on the page and I got so much sucess in it.
But now, I need to apply inline CSS on a model page and due to not loading the model page just a pop up… my css could not run.
Kindly help me to run in line CSS on model page.
Thanks and Regrds,
Saim Ahmed.
You have 3 approaches:
1) Repeat the CSS on the modal, but that doesn’t scale well.
2) Place your inline CSS on the Theme Roller’s “Custom CSS” field. This will make it available to ALL pages.
30 Finally, place your CSS in a file (as a static file, workspace file, or web server file. It doesn’t matter). Go to Shared Components > User Interface Attributes > Edit your user interface. Scroll down and add the reference to your file in the Cascading Style Sheets field.
Hola Jorge
Hoy conocí su blog ye veo que comparte muy buenos tips.
¿Es possible añadir condiciones a los estatutos SQL de los reports IR o clasicos dinamicamente?
En el forms y Reports 6i yo lo hacia y me parecia muy versatile.
Gracias
Leticia Campos
Hi Jorge, Try the DA Client-side javascript condition “apex.item (this.triggeringElement) .isChanged ()”
– for Loose focus / Item / effected element:Triggering element is working fine
-for Lose focus / Region / effected element: Event Source is not working and condition is always false
// Any advice how to refer triggering element in condition when effected element is Event Source?
Thank you in advance for your help.
Vladimir
Hello Jorge,
I don’t think you remember me but we met at KScope 17
I am basically looking for this
https://community.oracle.com/message/15340383#15340383
and coincidentally I found the exact macth, unfortunately there is no link to download this application. Any help from you greatly appreciated.
https://apex.oracle.com/pls/apex/f?p=105473:3:::NO:::
Thank you
Swaroop
Hi, sorry but that’s not my app, although I suspect it may be Adria Png’s https://twitter.com/fuzziebrain