Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate Unique Hash Key in PL/SQL

faoileanFeb 9 2009 — edited Feb 12 2009
I have a document that i want to send to certain customers. What I've decided to do is send the customer a link to the document that will be stored locally on our server. Obviously for security reasons i don't want to simply send the sequential doc ID allowing customers to change the query string to get other information.

What would be the best way in pl/sql to generate a unique hash key to include in the url? The key would have to be both unique and not easily edited by customers to view other documents.

Any help would be much appreciated.

Faoilean.
This post has been answered by BluShadow on Feb 9 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2009
Added on Feb 9 2009
8 comments
1,893 views