09-20-03, 03:44 #1Registered User
- Join Date
- Sep 2003
How to pass parameters to expot utility via Oracle forms using host command
I want to export a particular schema among various schemas on forms 6i.
To achieve this, I am using the list of values (lov) on forms 6i for the selection of schema name. I attached this lov to a display item called (1).
On run time, I select the value (user name) from lov and then this selected value store in display item (1). Then I execute the button (export), inside this button following coding is written:
--trigger when button press
IF NOT Form_Success THEN
Message(' EXPORT TERMINATED SUCCESSFULLY WITH WARNINGS.');
ELSE Message('EXPORT TERMINATED SUCCESSFULLY WITHOUT WARNINGS.');
I am passing the name of schema which stores in the display item (1) to the batch file.
Export is invoke but not successful and show the error that “S1” IS INVALID USERNAME.
THE CODING OF BATCH FILE IS :
if not exist f:\export_schema mkdir F:\export_schema
if "%1" == "" goto usage
exp system/manager file=f:\export_schema\exp_schema.dmp
Could you please assist me in this regard that how to pass the user name/schema to the host command for exporting a particular schema, on forms 6i.
Furthermore I want to wrap a package via forms 6i, when I select the package with radio button, in order to secure the code. I am using host command on forms to do that but the problem is same as above, how should I pass the package name and owner name to the host command in order to wrap the package. I am using wrap utility.
I will be thankful to you.