469,602 Members | 1,984 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Use SET ROLE in Oracle Forms Builder

MEG
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.
Jul 19 '05 #1
1 7659
MEG <bu******@DROPTHIS.hotmail.com> wrote in message news:<Xn*****************************@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.

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.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by FuzzyBear | last post: by
reply views Thread by Rohit Dhawan | last post: by
4 posts views Thread by Corrado Valiente | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.