http://www.myoracleportal.com/ MyOraclePortal - Resource Library en-us Thu, 13 Mar 2008 10:19:49 GMT 1440 CPG-Nuke Dragonfly MyOraclePortal News http://backend.userland.com/rss http://www.myoracleportal.com/images/logo.gif http://www.myoracleportal.com/ http://www.myoracleportal.com/News/article/sid=152.html The PL/SQL FTP implementation code has been updated with a fix. Issue was identified with the PUT Operation for Binaries. No longer dropping 0 byte file. Please upgrade to the latest version 3.1.3 in the downloads area. Thank you. Thu, 13 Mar 2008 10:19:49 GMT http://www.myoracleportal.com/News/article/sid=151.html White Paper and discussion on the use of dynamic criteria submission and a variety of other useful features such pagination, dynamic sql, global temp table usage, associative arrays, refcursor in/out, etc. DynSQL Engine Discussion Tue, 30 Oct 2007 01:42:52 GMT http://www.myoracleportal.com/News/article/sid=150.html Posted a snippet in the forums regarding the use of Rank and how it gives you access to paging through data. Not exactly new to some, but I used to have code that used Oracle's cellprinting functionality which did the same thing. Was nice to find this information so that I could reuse that same functionality for custom queries outside of the standard htp command syntax. To see the details, head over to the forums in the Code area. Sun, 02 Sep 2007 03:37:02 GMT http://www.myoracleportal.com/News/article/sid=149.html Looking for a Single Sign On (SSO) solution for your Oracle Applications setup ? Look no further if you opted to build it on your own. I have posted notes and information in the Forum area. If you download it, and get it up and running... please stop back and provide some feedback on how it worked for you or did not work for you. I am certain others would gain from your experiences as well. Single Sign On (SSO) Without too much effort, it can be easily expanded to support Professional Forms as well as Discoverer (web edition). Mon, 18 Dec 2006 08:43:22 GMT http://www.myoracleportal.com/News/article/sid=148.html Hoping to try new approach to encourage viewer participation. I am going to start posting my new entries via the Forums. In doing this, I aim to provide the opportunity for some open dialog between users here. Click here to access forums. Sun, 17 Sep 2006 06:32:45 GMT http://www.myoracleportal.com/News/article/sid=147.html FTP_INTERFACE v.3.1.3 Local Remote operations LOB Remote operations Session Timeout Control automatically kills dead server connections Server Type identification RMDIR/MKDIR support for remote server LS/DIR commands to provide directory listing retrieval Oracle Applications integration Mainframe Compatible Binary/Ascii support Join the mailing list to keep up to date with new versions. MAIL_TOOLS v.3.0.0 File attachment supported Variable message length up to max size of CLOB Server validation CC and BCC supported Multiple destination addresses supported Formatted HTML Messages (I call it 'pretty' emails) Session Timeout Control automatically kills dead server connections Bonus :: File Dump utility included Join the mailing list to keep up to date with new versions. PLSQL, UTL_TCP, UTL_SMTP, utl_tcp, plsql, utl_smtp, email, ftp, binary, attachment 9iR2, 9.2.0.4, 8i, Oracle, oracle Sat, 09 Sep 2006 12:38:25 GMT http://www.myoracleportal.com/News/article/sid=146.html Somewhere on here is some code referring to executing host commands to the database server via PLSQL. It really works... but I was not happy with the security of the code in that you could in theory do whatever you want. Sounded very dangerous to me. I still have to gather everything together.. but I have it working solid now... with security built in to control the commands that can be executed. I will keep all posted to my progress as put a good doc together. Wed, 26 Jul 2006 19:26:24 GMT http://www.myoracleportal.com/News/article/sid=145.html A somewhat 'popular' download here is the Mail Tools package. This package supports sending emails with and without attachments (binary/ascii). One of things I have been meaning to do is leverage our Oracle Applications environment and build concurrent programs to run these mail routines. In a sense a wrapper call. To note, in the source code there are some references to some custom functions which you can either change to your own code or send me an email and request additional information on the specific call or code you are interested in. To test or use, just build an appropriate PLSQL code block or setup a concurrent executable and concurrent program in the application. If the latter, integrate into your request sets. There are four (4) different modules for emailing : Definitions SHORTMSG Means that it will only permit a short message entry of 240 characters or less. You can add html if you wish, just remember you are limited to 240 characters total. LONGMSG Means that you will need to prepare a message content file with only the body of the message in the file. Again, you can include HTML if you want formatting. The file is read into a CLOB from the filesystem, so the size of the message can be quite large. Remember, however, that Lotus Notes cannot handle emails that exceed 4 megabytes. 1. Email with no file attachments with SHORTMSG 2. Email with no file attachments with LONGMSG 3. Email with a file attachment with SHORTMSG 4. Email with a file attachment with LONGMSG Other Features 1. To, Cc, and Bcc support. 2. List of email addresses supported. Requires that they be separated by commas. 3. File attachments can be flat file or binary (zip, pdf, doc, etc) 4. Leverages existing /xfer interface directory structures Important Note Regarding Email Addresses * Only one FROM email address can be used with any given email * For TO/CC/BCC you can use multiple email addresses if seperated by a comma. You can list as many as you wish, however you are only limited to a total of 240 characters. Format for the FROM email address can be one of two ways, both will work : simple := someemailaddress@host.com friendly := "Oracle APPS <someemailaddress@host.com>" Notice that the double quotes are on the outside of value. Format for the remaining email address fields (TO/CC/BCC) can be one of two ways, both will work : simple := bchase@host.com friendly := "Barry Chase" <bchase@host.com> Notice that the double quotes are ONLY around the name of the addressee and not the entire email address value as we did with the FROM email address above. Sourcecode involved Wed, 26 Jul 2006 19:11:30 GMT http://www.myoracleportal.com/News/article/sid=144.html While out scanning the internet, I ran across an Oracle website with a variety of interesting features. If you have some free time, this might be just what you were looking for. Updatable External Tables Pie Charts in SQL*Plus Bar Graphs in SQL*Plus Hierarchical queries SQL Developer (formerly known as Raptor) by Oracle PL/PDF (Doc to PDF for PL/SQL environment) XML Publisher How ROWNUM can help tune a query PL/SQL Source Control Code in the Database Using PL/SQL Collection return a REF CURSOR Debugging PL/SQL with DBMS_DEBUG PLDOC, documenting your PL/SQL directly from the database Publishing PL/SQL Based Web Services Consuming Web Services from PL/SQL - Part II: A pure PL/SQL solution using UTL_HTTP (Oracle 9i or 10g) Enjoy ! Mon, 22 May 2006 17:35:04 GMT http://www.myoracleportal.com/News/article/sid=143.html Went to Thunder Over Louisville last night. It is the fireworks display that kicks off the Derby Festivities here in Kentucky. Over 800,000 people attended last night. Took about 2 hours to get home, working through the traffic and all. Parking was easy for us though. Where at work at, I am right down by the river. Just pulled into my parking garage. Easy. Only 15 minute walk, if that, from the action. Walked around for awhile, watching people mostly. Checked out the skateboard park for awhile. Saw a few people I knew from work also. Bought some Papa John's pizza for a quick dinner. Don't even ask about how much it cost to buy food and drink at something like this. Outrageous.... but all the same it was a good time. Found us a sweet spot to watch the show from. First time I was this close to be honest. Took my new camera (Fuji S5100) that I picked up on Ebay for an easy $132.00. All I can say is that I was able to get some incredible shots of the show. Check out the photo gallery here and the album called Thunder Over Louisville 2006. For more information on Thunder Over Louisville click here. Sun, 23 Apr 2006 16:07:03 GMT