Hi,
I am trying to do some authentification in a form and have run into a
problem. The user types the usename/password into a couple of fields and
presses the login button.
The button trigger PL/SQL looks like this :
DECLARE
uservar VARCHAR2(15) := '';
passvar VARCHAR2(15) := '';
BEGIN
/* grab the data */
uservar := :BLOCK10.USERNAME_BOX;
passvar := :BLOCK10.PASSWORD_BOX;
set role uservar identified by passvar;
/* if OK change context, etc... */
When I try compile I get the message :
Error 103 at line 9, column 6
Encountered the symbol "ROLE" when expecting one of the following:
transaction <a SQL statement>
Anyone know what the problem is? All hints greatly appreciated.
Thanks,
Mike.
--
_________________________________
There are only 10 types of people in the world -
those who understand binary, and those who don't.