OraFAQ Forum: Forms » Create folder in oracle app server 10g

Home » Developer & Programmer » Forms » Create folder in oracle app server 10g (Oracle form 10g , linux server )

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

Create folder in oracle app server 10g [message #631256]

Sun, 11 January 2015 20:15

nguyennhatdlu
Messages: 5
Registered: January 2015
Location: Viet Nam

Junior Member

I want to create a folder or directory in app server when I click button in oracle form . I have test some command ex :HOST or webutil_Host.Host . But it dont action Sad

. Pls help . Have i configure any thing else in app server ? Thanks and waiting ....
CODE : WEBUTIL_HOST.HOST('mkdir -p '||'/u01/app/oracle/perp/tmp/nhat1');

Report message to a moderator

Re: Create folder in oracle app server 10g [message #631678 is a reply to message #631256]

Sat, 17 January 2015 00:09

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

i am not able to understand exactly what do you want to do, but may be below written code would help you, please find the attachment i have added.

TO CREATE FOLDER

--When_button_pressed
DECLARE
	V_PATH VARCHAR2(1000);

	BEGIN
V_PATH:='MKDIR '||:B1.DRIVE||:B1.FOLDER;

--HOST( 'cmd /c start ' || v_path , screen); 
HOST( 'cmd /c start ' || v_path,no_screen); 
:B1.MSG:='FOLDER CREATED';
END;

TO OPEN FOLDER

DECLARE
	V_PATH VARCHAR2(1000);

	BEGIN
V_PATH:='START '||:B1.DRIVE||:B1.FOLDER;
--HOST( 'cmd /c start ' || v_path , screen); 
HOST( 'cmd /c start ' || v_path,no_screen); 
END;

Attachment: CREATEOPENFOLDER.fmb
(Size: 52.00KB, Downloaded 1413 times)

Report message to a moderator

Re: Create folder in oracle app server 10g [message #631794 is a reply to message #631678]

Mon, 19 January 2015 19:23

nguyennhatdlu
Messages: 5
Registered: January 2015
Location: Viet Nam

Junior Member

Thanks your reply Smile

.But maybe not understand for me Smile

.I want to create folder in app server linux .
.I compiled and test your attachment file and I don't see the result . I have to setup another in client or server ?

Report message to a moderator

Re: Create folder in oracle app server 10g [message #631851 is a reply to message #631794]

Tue, 20 January 2015 23:00

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

the solution i provided is for windows os, i cant say it will work on linux or not, but you could take hint through my reply. Smile

Report message to a moderator

Re: Create folder in oracle app server 10g [message #631919 is a reply to message #631851]

Wed, 21 January 2015 21:22

nguyennhatdlu
Messages: 5
Registered: January 2015
Location: Viet Nam

Junior Member

Thanks U so much Smile

I tested many case But it dont create a folder Sad

.So i posted problem in here Smile

If u have another ideas,pls tell me Smile

One more time i want to say thanks to U Smile

Have a nice day Smile

Report message to a moderator

Previous Topic:	[FORMS10g] : Get Windows logged User?
Next Topic:	import excel Data By column using oracle 6i form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 20:57:20 CDT 2024