XPost: comp.databases.oracle.misc, comp.database.oracle   
   From: burnunit@DROPTHIS.hotmail.com   
      
   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    
      
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)