i know how to use loops in vb, but not in plsql. please can you provide me with code that enables the uesr to enter a password just for 3 times, and then get access denied message. If it involves cursors, please explain it to me as i don't understand cursors so well. Thanx
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
loop
- Thread starter oakeyes
- Start date
DBAwhosaysNIE
MIS
If I were you I'd consider investing a copy of Oracle 8: PL/SQL Programming ($32 on amazon; Scott Urman/Oracle Press). Of eight Oracle Press books I own this is the only one I use on a regular basis. It also comes with a CD that has tons of sample code you can cut, paste and tweek to fit your needs.
mmontesano
Programmer
I may be missunderstanding your question. PL/SQL doesn't really support a direct user input/output interface. Oracle provides other tools for this (Developer 2000). Additionally, before any PL/SQL code executes, the user must have already logged on to the database. Could you give more context of what you are trying to accomplish?
monte
monte
- Status
Similar threads