OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » SSO (Oracle IDS 10g,Windows Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SSO [message #399860]

Fri, 24 April 2009 05:13

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

Hi All !
Iam logging into my form using the username and password set using SSO in oracle application server..

I have set certain fields to be enabled or disabled based on condition in button click on my forms..

The coding i used in button click is ..

 DECLARE
	authenticated_username varchar2(20);
begin
 
 authenticated_username := Get_Application_Property(sso_userid);
 	  
go_block('pim_emplpersonalinfo');
 
 if authenticated_username 'admin1' then 
 
 set_item_property('PIM_contactdetails.pincode1',enabled,property_off);
 set_item_property('PIM_contactdetails.phoneno2',enabled,property_off);
 set_item_property('PIM_contactdetails.division',enabled,property_off);
 set_item_property('PIM_contactdetails.section',enabled,property_off);
 set_item_property('PIM_contactdetails.pan_no',enabled,property_off);
 set_item_property('PIM_contactdetails.bank_accountno',enabled,property_off);
 set_item_property('PIM_contactdetails.mobileno2',enabled,property_off);
 set_item_property('PIM_contactdetails.PUSH_BUTTON154',visible,property_off);
 
end if;
end;

After logging in as admin1, when i click this button iam getting

FRM-40735 when button pressed unhandled exception ORA-01403

Actually iam not retrieving records .. while designing, i have set the enabled property to yes for all the fields of my form.. so when an user logs in using the id admin1, those fields must be enabled when the if condition in above code doesnt satisfy right? But this is not happening ..

If i run my form individually without using the SSO, everything is working fine..

Pls help !

regards

varosh

[Updated on: Fri, 24 April 2009 05:37]

Report message to a moderator

Re: SSO [message #399867 is a reply to message #399860]

Fri, 24 April 2009 05:44

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

The syntax of your set_item_properties is wrong.

Report message to a moderator

Re: SSO [message #399873 is a reply to message #399867]

Fri, 24 April 2009 05:55

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

DECLARE
	authenticated_username varchar2(20);
begin
 
 authenticated_username := Get_Application_Property(sso_userid);
 	  
go_block('pim_emplpersonalinfo');
 
 if authenticated_username<>'admin1' then 
 
 set_item_property('PIM_contactdetails.pincode1',enabled,property_off);
 set_item_property('PIM_contactdetails.phoneno2',enabled,property_off);
 set_item_property('PIM_contactdetails.division',enabled,property_off);
 set_item_property('PIM_contactdetails.section',enabled,property_off);
 set_item_property('PIM_contactdetails.pan_no',enabled,property_off);
 set_item_property('PIM_contactdetails.bank_accountno',enabled,property_off);
 set_item_property('PIM_contactdetails.mobileno2',enabled,property_off);
 set_item_property('PIM_contactdetails.PUSH_BUTTON154',visible,property_off);
 
end if;
end;

But this if condition works for me correctly..

where am going wrong ?

my issue is when the login is admin1, these fields must be enabled which i have set by default during form design

regards
varosh

Report message to a moderator

Re: SSO [message #399876 is a reply to message #399860]

Fri, 24 April 2009 06:03

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Hmmm.

Seems property_off compiles, I assumed it wouldn't. But I would change it to property_false - which is what the documentation says you should use.

Are you sure Get_Application_Property returns the username in lower case? Use a message to display the value.

Report message to a moderator

Re: SSO [message #400181 is a reply to message #399876]

Sun, 26 April 2009 23:40

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

Hi !

Thanks for your reply !

you are right ! Due Case Sensitive issue, i got that problem ..

Now its solved ..

Thanks a lot !

Regards
varosh

Report message to a moderator

Previous Topic:	Creating text file from Forms 6i
Next Topic:	Populating the data in respective excel columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:21:13 CDT 2024