| Guestbook |
 |
We wish to thank you for stopping by and invite you to sign or view our guestbook.
| Host Services |
|
250 gigabytes with Terrabytes of bandwidth for as little as 7.50 a month.
| User Info |
|
Welcome Anonymous
Membership:
 Latest: ganeshsusarla
 New Today: 0
 New Yesterday: 0
 Overall: 527
 People Online:
 Members: 0
 Visitors: 2
 Total: 2
Who Is Where: Visitors:01: News
02: Downloads
Staff Online:No staff members are online!
| Main Menu |
|
 Main Menu
| Visitor Counter |
|
Thank you for visiting MyOraclePortal and we welcome any contributions you may have. Your participation is encouraged in our open exchange of ideas.
| Top10 Downloads |
|
| Search Google |
|
| MyOraclePortal |
|
Copy and paste the text below to insert the button displayed above on your site. Thanks for your support!
| Button Links |
|
| Hot Questions |
|
| Recently Updated |
|
| ORA-APPS-DBA |
|
|
News
 |
FTP and SMTP utilities using UTL_TCP |
 |
|
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
|
|
Encouraging use of Forums |
|
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.
|
Posted by nimda7080 on Sunday, September 17, 2006 (06:32:45) (594 reads)
  | Score: 0
|
|
FTP INTERFACE Source updated with fix.. |
|
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.
|
|
Dynamic SQL Engine Whitepaper |
|
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
|
Posted by bsc7080mqc on Tuesday, October 30, 2007 (01:42:52) (601 reads)
comments? | | Score: 0
|
|
Use of Rank features and Pagination Example |
|
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.
|
Posted by bsc7080mqc on Sunday, September 02, 2007 (03:37:02) (726 reads)
comments? | | Score: 0
|
|
Oracle Single Sign On (SSO) :: Custom Solution |
|
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).
Note: ** Critical Bug Fix **
If you have previously downloaded the SSO solution here, please download again due to a security hole that I just corrected.
** Update **
Updated subdomain parsing logic in sourcecode. Not a mandatory download, but recommended. See forums for details and to also download the modified sourcecode.
|
Posted by bsc7080mqc on Monday, December 18, 2006 (08:43:22) (1869 reads)
comments? | | Score: 0
|
|
HOST Command execution via PLSQL... update soon |
|
|
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.
|
Posted by bsc7080mqc on Wednesday, July 26, 2006 (19:26:24) (1688 reads)
comments? | | Score: 0
|
|
Concurrent Manager Wrapper Routines for Mail Tools |
|
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
|
|
Collection of various interesting articles |
|
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.
Enjoy !
|
Posted by nimda7080 on Monday, May 22, 2006 (17:35:04) (1158 reads)
comments? | | Score: 0
|
|
Thunder Over Louisville |
|
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.
|
|
Create a Temporary Work table |
|
Occassionally you may run into a situation which requires you to capture some test information while your process is running. You could always create a standardized log table just for your process and log items to it. You could even build one specific to your process. However, often it would be nice if there was already something there that you could easily use any time.
What I might suggest is the creation of a temporary log table. This tale would have a key identifier on it to separate your items from other individuals/processes logging to the table. Also it would have some date, number, character, blob, clob fields to pass data into.
In your stored proc, you would have code to insert data into the table as your process runs. Then you could simply review the table when things are completed. I would recommend cleaning up your data from the temporary table when you are done analyzing the data.
Read on....
|
|
HANDY ONE-LINERS FOR AWK |
|
See SED also, which is often a companion to AWK.
HANDY ONE-LINERS FOR AWK 22 July 2003
compiled by Eric Pement version 0.22
Latest version of this file is usually at:
http://www.student.northpark.edu/pemente/awk/awk1line.txt
Most of my experience comes from version of GNU awk (gawk) compiled for Win32. Note in particular that DJGPP compilations permit the awk script to follow Unix quoting syntax '/like/ {"this"}'.
However, the user must know that single quotes under DOS/Windows do not protect the redirection arrows ( ) nor do they protect pipes (|). Both are special symbols for the DOS/CMD command shell and their special meaning is ignored only if they are placed within "double quotes."
Likewise, DOS/Win users must remember that the percent sign (%) is used to mark DOS/Win environment variables, so it must be doubled (%%) to yield a single percent sign visible to awk.
If I am sure that a script will NOT need to be quoted in Unix, DOS, or CMD, then I normally omit the quote marks. If an example is peculiar to GNU awk, the command 'gawk' will be used.
Please notify me if you find errors or new commands to add to this list (total length under 65 characters). I usually try to put the shortest script first.
|
|
Multi-threading in Unix using shell scripts |
|
Multi-threading can be accomplished at many levels
- Separate stages that run parallel to each other, in Concurrent Manager request sets
- Using DBMS_JOB.SUBMIT at the database level
- Compiled Pro*C files (Oracle does this with PYUGEN for example)
- Unix background processes
- Scripting language such as Perl
- Java
- JSP
- etc
However, in the wise words of someone else I know, sometimes the simpliest answer achieves the desired goal. Shell Scripts, when you get down to it, are pretty simple. No real complex logic in most cases.
Read On...
|
|
Mail Tools Updated to v.3.0.0 |
|
|
Updated the mail tools utility online here so that it now handles variable message lengths instead of limiting to 32k as previous versions did.
Check out the downloads area to download the package header and body. Click here.
|
|
Methods to improve performance of SQL and/or PLSQL |
|
Well, somewhere on here I know I have mentioned it already. However I feel compelled to say a little something on it again for those passing by.
Occassionally you run into a process that you are running and it simply takes too long or at least longer than you expected. For any process that I build for what I believe will be a long running process, my goal is to get it down under an hour at least. Anything less than that is always a plus. Sometimes no matter what you do, you can't get a less than your desired goals. So what to do ?
Somethings you can look at (not necessarily in this order either) :
- Indexes (e.g. bitmap vs. b-tree vs. function)
- Query optimization
- Generate Statistics by analyzing tables
- Optimizer Hints
- Bulk Collect and ForAll processing
- Multi-threading into processing chunks
- Analyze timings
Briefly we can review these things. My goal is not to provide a tutorial on what these are specifically. Mainly, instead, provide some information that can help remind you of some things that you can research on your own. With that said, if you are a newbie to Oracle, then this may not help you much.
|
Disclaimer
Welcome to the MyOraclePortal.com site. Please review the following terms and conditions concerning your use of this site. By accessing, using or downloading materials from this site you agree to follow and be bound by these terms and conditions.
This site may contain links to sites controlled by parties other than MyOraclePortal.com. MyOraclePortal.com, is not responsible for and does not endorse or accept any responsibility over the contents or use of these sites.
WARRANTIES AND DISCLAIMERS : THE INFORMATION, SOFTWARE, PRODUCTS AND SERVICES CONTAINED ON THIS SITE MAY BE OUT OF DATE OR INCLUDE OMMISSIONS, INACCURACIES OR OTHER ERRORS. ALL INFORMATION, SOFTWARE, PRODUCTS AND SERVICES ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. IN NO EVENT SHALL MyOraclePortal.com BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES, OR DAMAGES FOR LOSS OF PROFITS, REVENUE, DATA OR USE, INCURRED BY YOU OR ANY THIRD PARTY, ARISING FROM YOUR USE OF THIS WEB SITE OR ANY OTHER LINKED SITE.
MyOraclePortal.com RESERVES THE RIGHT TO MAKE CHANGES OR UPDATES TO THIS SITE OR THE PRODUCTS OR PROGRAMS DESCRIBED IN THIS SITE AT ANY TIME WITHOUT NOTICE.
Trademark Information
ORACLE and other Oracle Products and Services Trademark are trademarks of ORACLE CORPORATION, Redwood Shores, CA.
Any other commercial products specifically mentioned or indirectly referenced are the trademarks of their respective organizations. MyOraclePortal.com is not affiliated with or endorsed by Oracle Corporation.
Purpose and Intent of Internet Presence
Furthermore, it is to be understood that MyOraclePortal.com was created and is maintained as a source of information related to the Oracle database and related applications. It is open to the public, and membership is optional. There are no membership fees, nor is there any intention to establish a paid member site.
Our goal is to encourage open exchange of ideas between Oracle related Professionals with MyOraclePortal.com as a viable medium for that purpose. Related domains associated to MyOraclePortal.com are MyOraclePortal.net and MyOraclePortal.org.
If you have further questions, please contact MyOraclePortal.com via site feedback.
|
1: FTP Interface v.3.1.3
