Use SET ROLE in Oracle Forms Builder

[MEG]

Hi,

I am trying to do some authentificatio n 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.USERNA ME_BOX;
passvar := :BLOCK10.PASSWO RD_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.

[Pete's]

MEG <bu******@DROPT HIS.hotmail.com > wrote in message news:<Xn******* *************** *******@198.164 .200.20>...

Hi,

I am trying to do some authentificatio n 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.USERNA ME_BOX;
passvar := :BLOCK10.PASSWO RD_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.

If I remember correctly, you can not issue a set role directly in
Oracle Forms as you have coded it. For Forms, Oracle has provided a
function to do this. If I recall correctly, it is 'set_role'. Try
checking out the help on this.

HTH,
Pete's

The opinions I may have stated here are mine and not that of my
employer. Use any advice given at your own risk.