declare
  Fil varchar2(150);
begin
  fil:='D:\accounts\';
 Host('Exp accsch/abc file='||fil||'Acc'||sysdate||'.dmp');
exit_form;
end;

Export done in WE8MSWIN1252 character set into and AL16UTF16 NCHAR character set
Export done in AR8MSWIN1256 character set into and WE8MSWIN1252 (Possibly convertsion set)

Host('Exp accsch/abc file='||fil||'Acc'||sysdate||'.dmp statistics=none'); ---to solve problem.

The above code is working properly.

orclx> declare
  2    Fil varchar2(150);
  3  begin
  4    fil:='D:\accounts\';
  5   Host('Exp accsch/abc file='||fil||'Acc'||sysdate||'.dmp');
  6  exit_form;
  7  end;
  8  /
 Host('Exp accsch/abc file='||fil||'Acc'||sysdate||'.dmp');
 *
ERROR at line 5:
ORA-06550: line 5, column 2:
PLS-00201: identifier 'HOST' must be declared
ORA-06550: line 5, column 2:
PL/SQL: Statement ignored
ORA-06550: line 6, column 1:
PLS-00201: identifier 'EXIT_FORM' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored


orclx>

Dear brother from where can I get the active user?
I am facing problem.....

I am using the complete statement as

declare
un varchar2 (20);
begin
select user into un from dual;
host ('exp' ||un||'/ xyz @XE file=d:\'||un||'.dmp');
end;


But I am unable to get any result....!!
Please help me..

"host" is a Forms internal procedure, you can't use it in SQL*Plus.

Please read How to use [code] tags and make your code easier to read.

"host" is a Forms internal procedure, you can't use it in SQL*Plus.

Please read How to use [code] tags and make your code easier to read.

Michel Cadot wrote on Fri, 03 May 2019 00:15

"host" is a Forms internal procedure, you can't use it in SQL*Plus.

Please read How to use [code] tags and make your code easier to read.

HOST is valid SQL*Plus command.
HOST is NOT a valid PL/SQL command which results from starting code with "DECLARE"

[oracle@localhost ~]$ sqlplus scott/tiger

SQL*Plus: Release 12.2.0.1.0 Production on Fri May 3 09:02:31 2019

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Last Successful login time: Fri Apr 19 2019 23:32:44 -04:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> host 'echo 123'
/bin/bash: echo 123: command not found

As Michel says host is a forms built-in that takes a string and runs it on the command line.
You need to take the string you are passing as the parameter to host and run that manually.

Also you don't need to select user from dual, you can just use user directly.

cookiemonster wrote on Fri, 03 May 2019 03:22

As Michel says host is a forms built-in that takes a string and runs it on the command line.
You need to take the string you are passing as the parameter to host and run that manually.

Also you don't need to select user from dual, you can just use user directly.

Thanks for your reply....!!
I have 4 database users and and i want the backup of active user on an oracle form with button.
I have trigger when button pressed.....!!!
I want that the backup should be of active user only...
For this purpose I am searching & asking for help....!!
hope you got my question....

M HANIF wrote on Fri, 03 May 2019 11:30

cookiemonster wrote on Fri, 03 May 2019 03:22

As Michel says host is a forms built-in that takes a string and runs it on the command line.
You need to take the string you are passing as the parameter to host and run that manually.

Also you don't need to select user from dual, you can just use user directly.

Thanks for your reply....!!
I have 4 database users and and i want the backup of active user on an oracle form with button.
I have trigger when button pressed.....!!!
I want that the backup should be of active user only...
For this purpose I am searching & asking for help....!!
hope you got my question....

The solution is not necessarily as simple & it appears you think it should be.
Is FORMS software running on the DB Server itself?
In order for the exp command to succeed, the USER password is required so how will be acquired & placed on the command line?
What security risk occurs by exposing the USER password to other folks?

You need to answer all 3 question before any specific solution is proposed or offered.

2. Password is static for and same for all users... it will be hard coded....
3. There is no security risk....my password is xyz for all my users....

3. There is no security risk....my password is xyz for all my users....

M HANIF wrote on Mon, 06 May 2019 09:34

3. There is no security risk....my password is xyz for all my users....

That is a security risk.

If you're going to live with it then all you need to do is debug your host command in the way we already described and fix it appropriately.

M HANIF wrote on Mon, 06 May 2019 09:34

3. There is no security risk....my password is xyz for all my users....

That is a security risk.

If you're going to live with it then all you need to do is debug your host command in the way we already described and fix it appropriately.

Assalam-o-Alaikum!
Dear experts...!
I want to backup my database using host exp command.
I have many database users with different tables etc.
I want to backup the data of current_user (active user) dynamically...!!
can any one help me...
I wrote the command as
host ('exp abc/xyz @xe file=d:\backup\backup.dmp');

1. Yes forms software is running on the same DB Server....

hi,
create your backup folder [i.e: 'c:\backup'],
on a PushButton [ WHEN-BUTTON-PRESSED] insert the following code

declare
  alrt         number;
  v_directory  varchar2(200) := 'c:\backup';
-------
  path          varchar2(100):='back_up'||to_char(sysdate,'dd-mm-yyyy-hh-mi-ss');
v_exp varchar2(200) := 'exp scott/tiger@orcl file = '
                       ||v_directory||'\'||path
                       ||'.dmp owner=scott grants=yes';  --for specify user use owner=user
-------
begin 
	host(v_exp);
if form_success then
	
set_alert_property('msg',alert_message_text,'Form success');
alrt:=show_alert('msg');
else
    message('there are errors ');
end if; 
end;

------
enjoy it
---------------------------------
Quote:

Executing imp command through a form

I'm sorry
however I still enjoy it

does get_application_property(password) actually return anything?
What exactly did you try in the host call?