Home » Developer & Programmer » Forms » can anybody help me out...
can anybody help me out... [message #82267] Wed, 14 May 2003 05:47 Go to next message
suhail..
Messages: 1
Registered: May 2003
Junior Member
Hi all,

how can i create user-name and password if suppose i want to enter into a .fmx(runtime)form.

thanx

Mubeen.
Re: can anybody help me out... [message #82272 is a reply to message #82267] Wed, 14 May 2003 22:28 Go to previous messageGo to next message
amit zhankar
Messages: 31
Registered: March 2003
Member
Hi ,

Check Get_application_property function in forms whuich will give username,passwaord and hosdt string in the runtime.

amit zhankar
Re: can anybody help me out... [message #82294 is a reply to message #82267] Thu, 15 May 2003 09:54 Go to previous messageGo to next message
BEB
Messages: 1
Registered: May 2003
Junior Member
Send me your email address and I will send you the entire form to accomplish this.
Re: can anybody help me out... [message #82304 is a reply to message #82272] Fri, 16 May 2003 02:00 Go to previous messageGo to next message
BIRENDER KUMAR
Messages: 18
Registered: May 2003
Junior Member
Inorder to execute sql ddl commands use
FORMS_DDL buit-in.
This is a very powerfull buit-in.

use this code:

BEGIN
Forms_DDL('create user x identified by x');
IF NOT Form_Success THEN
Message ('user Creation Failed');
ELSE
Message ('user Created');
END IF;
END;

If u wish to create n no of user thru form
use :text_item in place of x

Note :You should have sufficent previlages to create user.

If not working e-contact me.
Re: can anybody help me out. [message #84350 is a reply to message #82304] Sun, 07 March 2004 01:05 Go to previous message
fouzia
Messages: 3
Registered: February 2002
Junior Member
I use this command to create user in forms
it work perfectly but when I add this command
'DEFAULT tablespace dat temporary tablespace ts_temp'
the user is not created
please help me
Previous Topic: using text_io
Next Topic: Query Problem
Goto Forum:
  


Current Time: Fri Apr 26 02:09:06 CDT 2024