Use SET ROLE in Oracle Forms Builder

From: MEG <burnunit_at_DROPTHIS.hotmail.com>
Date: Tue, 14 Oct 2003 18:27:20 GMT
Message-ID: <Xns94149D3B0E45Egililsmegovnsca_at_198.164.200.20>


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.
Received on Tue Oct 14 2003 - 20:27:20 CEST

Original text of this message