Home » Developer & Programmer » Forms » SSO (Oracle IDS 10g,Windows Xp)
SSO [message #399860] Fri, 24 April 2009 05:13 Go to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 12415
Registered: September 2008
Location: Rainy Manchester
Senior Member
The syntax of your set_item_properties is wrong.

Re: SSO [message #399873 is a reply to message #399867] Fri, 24 April 2009 05:55 Go to previous messageGo to next message
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
Re: SSO [message #399876 is a reply to message #399860] Fri, 24 April 2009 06:03 Go to previous messageGo to next message
cookiemonster
Messages: 12415
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.
Re: SSO [message #400181 is a reply to message #399876] Sun, 26 April 2009 23:40 Go to previous message
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
Previous Topic: Creating text file from Forms 6i
Next Topic: Populating the data in respective excel columns
Goto Forum:
  


Current Time: Thu Dec 08 00:27:49 CST 2016

Total time taken to generate the page: 0.17646 seconds