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>
BEGIN
/* grab the data */
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