tag:blogger.com,1999:blog-6379904090858351676.comments2023-10-23T16:40:59.034+01:00Dancing and Wrestling with Oracle APEXDavid Njokuhttp://www.blogger.com/profile/11205924212052603994noreply@blogger.comBlogger92125tag:blogger.com,1999:blog-6379904090858351676.post-54310566642393564782020-08-10T17:53:51.724+01:002020-08-10T17:53:51.724+01:00Excellent post for the people who really need info...Excellent post for the people who really need information for this technology. <a href="https://infycletechnologies.com/oracle-training-in-chennai" rel="nofollow">oracle training in chennai</a>Devihttps://www.blogger.com/profile/03033114370184030018noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-87828693656569276212020-05-05T13:15:08.846+01:002020-05-05T13:15:08.846+01:00Wonderful Post..
SAP Training in Chennai
Java Trai...Wonderful Post..<br /><a href="http://www.traininginchennai.co.in/sap-training-in-chennai/" rel="nofollow">SAP Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/java-training-in-chennai/" rel="nofollow">Java Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/selenium-training-in-chennai/" rel="nofollow">Selenium Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/qtp-training-in-chennai/" rel="nofollow">QTP Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/hardware-networking-training-in-chennai/" rel="nofollow">Hardware and Networking Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/ccna-training-in-chennai/" rel="nofollow">CCNA Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/mcitp-training-in-chennai/" rel="nofollow">MCITP Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/oracle-training-in-chennai/" rel="nofollow">Oracle Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/php-training-in-chennai/" rel="nofollow">PHP Training in Chennai</a><br /><a href="http://www.traininginchennai.co.in/amazon-web-services-training-in-chennai/" rel="nofollow">AWS Training in Chennai</a>Rakshithahttps://www.blogger.com/profile/17983824605985724337noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-4237117608796102742020-05-05T13:14:54.691+01:002020-05-05T13:14:54.691+01:00Very nice psot..
SAP Training in Chennai
Java Trai...Very nice psot..<br /><a href="https://traininginchrompet.com/courses/sap-training" rel="nofollow">SAP Training in Chennai</a><br /><a href="https://traininginchrompet.com/courses/java-training" rel="nofollow">Java Training in Chennai</a><br /><a href="https://traininginchrompet.com/courses/software-testing-training" rel="nofollow">Software Testing Training in Chennai</a><br /><a href="https://traininginchrompet.com/training/ccnp-training/hardware-and-networking-training-in-chennai" rel="nofollow">Hardware and Networking Training in Chennai</a><br /><a href="https://traininginchrompet.com/training/data-warehousing-training/informatica-training-in-chennai" rel="nofollow">Informatica Training in Chennai</a><br /><a href="https://traininginchrompet.com/training/ccnp-training/ccna-training-in-chennai" rel="nofollow">CCNA Training in Chennai</a><br /><a href="https://traininginchrompet.com/courses/oracle-traning" rel="nofollow">Oracle Training in Chennai</a><br /><a href="https://traininginchrompet.com/courses/cloud-computing-training" rel="nofollow">Cloud Computing Training in Chennai</a><br /><a href="https://traininginchrompet.com/training/cloud-computing-training/microsoft-azure-training-in-chennai" rel="nofollow">Azure Training in Chennai</a><br /><a href="https://traininginchrompet.com/training/cloud-computing-training/amazon-web-services-training" rel="nofollow">AWS Training in Chennai</a>Rakshithahttps://www.blogger.com/profile/17983824605985724337noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-15194934754286851212020-05-05T13:14:38.621+01:002020-05-05T13:14:38.621+01:00Awesome Stuff
SAP Training in Chennai
Java Trainin...Awesome Stuff<br /><a href="https://iicttechnologies.com/sap-training-in-chennai.html" rel="nofollow">SAP Training in Chennai</a><br /><a href="https://iicttechnologies.com/java-training-in-chennai.html" rel="nofollow">Java Training in Chennai</a><br /><a href="https://iicttechnologies.com/qtp-training-in-chennai.html" rel="nofollow">QTP Training in Chennai</a><br /><a href="https://iicttechnologies.com/hardware-and-networking-training-in-chennai.html" rel="nofollow">Hardware and Networking Training in Chennai</a><br /><a href="https://iicttechnologies.com/sap-abap-training-in-chennai.html" rel="nofollow">SAP ABAP Training in Chennai</a><br /><a href="https://iicttechnologies.com/sap-fico-training-in-chennai.html" rel="nofollow">SAP FICO Training in Chennai</a><br /><a href="https://iicttechnologies.com/sap-sd-training-in-chennai.html" rel="nofollow">SAP SD Training in Chennai</a><br /><a href="https://iicttechnologies.com/sap-mm-training-in-chennai.html" rel="nofollow">SAP MM Training in Chennai</a><br /><a href="https://iicttechnologies.com/sap-pp-training-in-chennai.html" rel="nofollow">SAP PP Training in Chennai</a><br /><a href="https://iicttechnologies.com/amazon-web-services-training-in-chennai.html" rel="nofollow">AWS Training in Chennai</a>Rakshithahttps://www.blogger.com/profile/17983824605985724337noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-79149299564147245072019-01-30T12:58:46.134+00:002019-01-30T12:58:46.134+00:00Using Upper might have helped.
Seemingly
apex_au...Using Upper might have helped. <br />Seemingly <br />apex_authentication.login(<br /> p_username => :P9999_USERNAME,<br /> p_password => :P9999_PASSWORD )<br />does not care whether the username is written using capitals or not.<br /><br />But apex_util.is_login_password_valid does care.<br />Therefore I did the following and it worked as expected:<br /><br />apex_util.is_login(p_username => UPPER(:P9999_USERNAME),p_password => :P9999_PASSWORD))Nils Stritzelnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-78889150208616345652018-09-27T07:06:33.390+01:002018-09-27T07:06:33.390+01:00Thank You For Your Great Article!!
The Horns is a ...Thank You For Your Great Article!!<br /><a href="http://thehorns-shoreditch.co.uk/" rel="nofollow">The Horns</a> is a strip club in Shoreditch, London. We have beautiful and sexy dancers performing table dancing. Come and enjoy with the hottest strippers.Thehornsshoreditchhttps://www.blogger.com/profile/18438113231903678553noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-60945930497956268712018-09-26T12:00:44.537+01:002018-09-26T12:00:44.537+01:00Thank You For Your Great Article!!
Are you looking...Thank You For Your Great Article!!<br />Are you looking for a strip club and lap dancing venue in London? Enjoy the sexiest dancers and hottest strippers at <a href="http://www.browns-shoreditch.co.uk/" rel="nofollow"> Browns-Shoreditch.</a>browns shoreditchhttps://www.blogger.com/profile/14271648651180858080noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-20606103881373028612018-06-27T05:55:13.253+01:002018-06-27T05:55:13.253+01:00It's A Great Pleasure reading your Article. U...It's A Great Pleasure reading your Article. <a href="http://usmedicalresidency.com/" rel="nofollow"> USMLE </a> Thanks For Posting.Anonymoushttps://www.blogger.com/profile/18324358726725724128noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-57231637285212086212018-04-30T05:58:32.339+01:002018-04-30T05:58:32.339+01:00This is the first time I frequented your website p...This is the first time I frequented your website page and to this point?<br /><br /><br /><a href="https://www.svrtechnologies.com/Weblogic-training" rel="nofollow">Weblogic Application Server training</a>Anonymoushttps://www.blogger.com/profile/01712425100545589094noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-59747786300197233182018-04-07T20:28:24.731+01:002018-04-07T20:28:24.731+01:00Matthew Hejazi.
Also please make sure to allow exe...Matthew Hejazi.<br />Also please make sure to allow execute of your procedure to <br />Grant execute your procedure to APEX_PUBLIC and APEX_05XXX.<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-65916406496533471342018-04-07T20:21:54.765+01:002018-04-07T20:21:54.765+01:00You can email me with questions at mhejazi_76@yaho...You can email me with questions at mhejazi_76@yahoo.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-31317276773112451862018-04-07T20:21:01.046+01:002018-04-07T20:21:01.046+01:00From Matthew Hejazi (I hope this help others too.)...From Matthew Hejazi (I hope this help others too.) <br /><br />The following is how to setup procedure call from URL DB Procedure though APEX URL at runtime, if using Weblog.<br /><br />1) Before you begin make sure all the apex_ schemas are unlocked and without expiration.<br />2) Make sure all the passwords are the same and you can sqlplus to it.<br />3) Make sure is a strong password. In this example, I am using mytestpassword.<br />4) APEX uses ORDS built into apex.war file.<br />5) Figure out where the configuration most default.xml locate.<br />6) Cd to that dritory.<br />7) In my case /u02/software/listener<br />8) Ls -l<br />9) You should see apex.war<br />10) Create a file modify.properties<br />11) Put this inside – this will turn debug on too. So you can change it to ‘N’..<br />db.password=mytestpassword<br />debug.debugger=true<br />debug.printDebugToScreen=true<br />12) Save the file.<br />13) Cd ./apex the directory is under listener.<br />14) Backup the default.xml to default.xml.backup<br />15) Execute this at command line, java -jar apex.war set-properties modify.properties<br />16) Above execute will add encrypted password to default.xml.<br />17) You will see something like this if cat default.xml<br />18) apexdbprod.sandiego.edu<br />key="db.password">@05CCSFSFSFSFsDA49CEAA6XXXDDDDDGGSDFSFSFSFSFSFS900<br />19) Cd ./conf “/u02/software/listener/apex/conf”<br />20) Ls –l<br />21) Make sure the password in apex.xml is same as the one in default.xml.<br />22) In the DB find the function called APEX_050100.wwv_flow_epg_include_mod_local.<br />23) The above function is under apex_05xxxx.<br />24) In the function comment out “Return False;” and add your procedure or function.<br />'TEXXX.XXXX_My_happy_procedure'<br />25) If you are, confused at this point, google for the above function.<br />26) Every should work. So, URL will execute the procedure you added.<br />27) URL in APEX Application will look like this with LINK type.<br />28) 'TEXXX.XXXX_My_happy_procedure'?p_filename=#FILE_NAME#&p_full_path=#FULL_PATH#&p_to_path=#TO_LOC#&location=&P3_SYSTEM<br />29) If the above is not working also see this url<br />30) https://ora-00001.blogspot.com/2015/11/how-to-change-apex-public-user-password.html<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-52535924526691297242017-11-30T17:14:24.071+00:002017-11-30T17:14:24.071+00:00hi,
how to use this in lists or tabs
Thanks,
Mad...hi,<br />how to use this in lists or tabs <br /><br />Thanks,<br />MadhuMadhuhttps://www.blogger.com/profile/17257012339916499773noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-81819621779512390462017-07-05T07:43:23.312+01:002017-07-05T07:43:23.312+01:00I really appreciate the information shared above. ...I really appreciate the information shared above. It’s of great help. If someone wants to learn Online (Virtual) instructor lead live training in Oracle Application Express TECHNOLOGY, kindly <a href="http://www.maxmunus.com/contact" rel="nofollow"> Contact MaxMunus</a> <br />MaxMunus Offer World Class Virtual Instructor-led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 1,00,000 + training in India, USA, UK, Australia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.<br />For Demo Contact us.<br />Pratik Shekhar<br />MaxMunus<br />E-mail: pratik@maxmunus.com<br />Ph:(0) +91 9066268701<br /><a href="http://www.maxmunus.com" rel="nofollow">www.MaxMunus.com</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-32668599819295823822016-09-22T16:33:06.706+01:002016-09-22T16:33:06.706+01:00Hi there! Could we connect somehow to discuss data...Hi there! Could we connect somehow to discuss database options? Beginner trying to learn more, I am interested in your information. The Beginner https://www.blogger.com/profile/06353988840509876918noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-63724929778128700542013-10-23T08:10:05.948+01:002013-10-23T08:10:05.948+01:00Thanks for sharing your knowledge about oracle app...Thanks for sharing your knowledge about <a href="http://www.oracleconnections.com" rel="nofollow">oracle applications</a>Anonymoushttps://www.blogger.com/profile/12511713606636809918noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-69137829234857785382013-07-17T10:32:36.028+01:002013-07-17T10:32:36.028+01:00The major reason being that developers will have a...The major reason being that developers will have a lesser learning curve for migrating Oracle forms to .NET considering that features similarities between both the development platforms. <a href="http://www.softsol.com/modernization/oracle-forms" rel="nofollow"> Oracle forms migration </a>josephwilliamhttp://www.softsol.com/modernization/oracle-formsnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-91173989030998903022012-07-03T21:20:46.584+01:002012-07-03T21:20:46.584+01:00David,
I have implemented this procedure in apex a...David,<br />I have implemented this procedure in apex application but when I try to run the export I get an unauthorized access error. It runs fine from TOAD. I am pushing pages to blobs in table. I am sure if I set this as background job it would work too. It seems like a conflict with current appl.<br /><br />Thanks,<br />TomAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-29138523192396073742012-02-29T19:36:50.993+00:002012-02-29T19:36:50.993+00:00LOL...polygamy..
Had a great laugh.LOL...polygamy..<br />Had a great laugh.Pradeepnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-10806604577233190642012-02-29T19:31:57.149+00:002012-02-29T19:31:57.149+00:00David,
Great post and love your analogy. You make...David,<br /><br />Great post and love your analogy. You make techinical details easy to to understand.Unknownhttps://www.blogger.com/profile/03330109086348570771noreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-28831206085813988392012-01-03T14:56:40.603+00:002012-01-03T14:56:40.603+00:00Forms is a solid technology, but finding people wh...Forms is a solid technology, but finding people who specialize in it is going to be more difficult and more expensive as time goes on. I used to do Forms when I worked with EBS, but haven't touched it in 4 years and would only go back kicking and screaming. I think you hit the nail when you said the kids out of college relate it to betamax.Buzz Killingtonnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-34952844389645036702011-09-19T09:52:31.694+01:002011-09-19T09:52:31.694+01:00Hello bro! Awesome post, thanks for sharing this v...Hello bro! Awesome post, thanks for sharing this valuable article with us, such as exciting stuff available here!<br /><br /><br /><a href="http://freesampleforms.blogspot.com" rel="nofollow">Sample forms</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-19257582481187361732011-06-01T00:03:25.971+01:002011-06-01T00:03:25.971+01:00Entertaining read, but isnt this the same with any...Entertaining read, but isnt this the same with any upgrade?<br /><br />and who the hell is Katherine Hiegel?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-12300202279257494622010-12-09T11:44:07.818+00:002010-12-09T11:44:07.818+00:00Hi,
I have a query, may not be related to the top...Hi,<br /><br />I have a query, may not be related to the topic of this post.<br />I hope you help me out.<br />I used to apply all filter options like <, ,>= etc on date columns of the table browsed in interactive report. Recently due to some reasons all date columns got converted into varchar2 type(at database level) and now we cannot apply those filter options (<, ,>= ) on such columns. But sometimes it becomes necessary to apply these filters for comparison purpose. Is there any work around through which I can apply these filters options in such case. (please note these interactive reports are directly generated (through script) from database tables so I cannot apply “To_date” clause at database side). Is there any work around at apex level?Trapzznoreply@blogger.comtag:blogger.com,1999:blog-6379904090858351676.post-60438072511932559552010-07-15T23:02:35.017+01:002010-07-15T23:02:35.017+01:00Loved the post. Btw, Katherine doesn't need im...Loved the post. Btw, Katherine doesn't need implants. Hottest woman on the planet in my opinion.Carlnoreply@blogger.com