CLIENT_HOST issue [message #341339] |
Mon, 18 August 2008 07:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
I have the following Code in one of the push buttons
CLIENT_HOST('Net Send TestUser "Hello"',no_screen);
How will I know if it has been successfully executed or not?
I tried using
But it did not work.In 6i I was using Host command and it was working fine.I tried it in 10g but it always shows successfull.
Tested :
I tried sending a net send command to a user who is not logged on the network,It just stops at the client host command.I also put a message after the client host , but its not going past the client_host.
|
|
|
|
|
Re: CLIENT_HOST issue [message #341505 is a reply to message #341452] |
Tue, 19 August 2008 02:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi David,
With what I understood from your message I should create script file like a .bat file and in that file write the command for net send and then a command to create a temp file in the same folder. then from forms i should check for the existance of that temp file. right?
If I need to pass parameters to the net send command like
Declare
var varchar2(100);
Begin
var:= 'Net Send '||:block1.user1||' "Hello "';
CLIENT_HOST(var,no_screen);
End;
How in the above case will i write the script file?
|
|
|
|
Re: CLIENT_HOST issue [message #341512 is a reply to message #341510] |
Tue, 19 August 2008 02:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Quote: | Can't you write the parameters to file and pipe that file into the script that you write?
|
How to do that? can you suggest some links i can find out how i could do it?
|
|
|
Re: CLIENT_HOST issue [message #341579 is a reply to message #341512] |
Tue, 19 August 2008 07:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Allright..for everyone who has read this topic, I have found a solution to my problem.
I created a function
FUNCTION My_Host_Cmd(VAL varchar2)
RETURN BOOLEAN IS
BEGIN
client_host(val);
return TRUE;
EXCEPTION
WHEN OTHERS THEN
return FALSE;
END;
In place of the below code
var := 'cmd /c NET SEND '||:BLOCK1.USER_NAME||' " '||:BLOCK1.MESSAGE_SENT||' "';
CLIENT_HOST(var);
If Not Form_Success then
I am using
var := 'cmd /c NET SEND '||:BLOCK1.USER_NAME||' " '||:BLOCK1.MESSAGE_SENT||' "';
IF not My_Host_Cmd(var) then
This solves the problem.
|
|
|
Re: CLIENT_HOST issue [message #343474 is a reply to message #341579] |
Wed, 27 August 2008 06:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi David,
I am getting the below error msg if i try to send the net send message to a user who is not logged on the network.
I tried searching everywhere, Raised a TAR with Oracle also, still nothing... anyone have an idea?
-
Attachment: 3.JPG
(Size: 59.76KB, Downloaded 1488 times)
|
|
|
|
|
Re: CLIENT_HOST issue [message #345026 is a reply to message #344921] |
Tue, 02 September 2008 03:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Thanks David for your reply. I have solved the problem. The problem was in the webutil.pll file. I do not know what it was, but i just detached the pll file ,moved it to another location and recompiled it and again attached it back to the form. It worked .... No explanation.
Mudabbir
|
|
|
|