This discussion is archived
2 Replies Latest reply: Mar 8, 2013 7:43 AM by FrançoisDegrelle RSS

client_host in 11g forms

778090 Newbie
Currently Being Moderated
the following code was there in the form 6i
now i am working in 11g.

the code is not working in 11g.
could you advice regarding this


declare
lv_file_name varchar2(100);
lv_command varchar2(200);
begin
lv_file_name := substr(:parameter.image_path,instr(:parameter.image_path, '\', -1) + 1);

lv_command := 'copy ' || :parameter.image_path ||
' b:\temp\deposit\scanned_image\' || lv_file_name;

host(lv_command, no_screen);

if form_success then
p_message_alert('saved..');
else
p_message_alert('file copy process failed..');
end if;

end;
  • 1. Re: client_host in 11g forms
    HamidHelal Guru
    Currently Being Moderated
    user13272730 wrote:
    the following code was there in the form 6i
    now i am working in 11g.

    the code is not working in 11g.
    could you advice regarding this


    declare
    lv_file_name varchar2(100);
    lv_command varchar2(200);
    begin
    lv_file_name := substr(:parameter.image_path,instr(:parameter.image_path, '\', -1) + 1);

    lv_command := 'copy ' || :parameter.image_path ||
    ' b:\temp\deposit\scanned_image\' || lv_file_name;

    host(lv_command, no_screen);

    if form_success then
    p_message_alert('saved..');
    else
    p_message_alert('file copy process failed..');
    end if;

    end;
    Hi,
    at 11g you need to work with Webutil Client_To_AS features. Or UTL_FILE.
    Search this forum or google.com. you will get lot's of example.
    You can download webutil demo from http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/196249.zip

    Hope this helps

    Hamid
  • 2. Re: client_host in 11g forms
    FrançoisDegrelle Oracle ACE
    Currently Being Moderated
    Hello,

    Since the Web versions, you have to use the CLIENT_HOST() Webutil equivalent.

    Francois

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points