If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Applications & Tools > How to pass parameters to expot utility via Oracle forms using host command

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-20-03, 02:44
stranger stranger is offline
Registered User
 
Join Date: Sep 2003
Location: india
Posts: 1
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:

The code:

--trigger when button press

BEGIN

HOST('F:\EXP_SCHEMA_F.BAT 1');


IF NOT Form_Success THEN
Message(' EXPORT TERMINATED SUCCESSFULLY WITH WARNINGS.');
ELSE Message('EXPORT TERMINATED SUCCESSFULLY WITHOUT WARNINGS.');
End if;
END;




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 :

@echo off
if not exist f:\export_schema mkdir F:\export_schema
del/q f:\export_schema\*

set owner=%1

if "%1" == "" goto usage

exp system/manager file=f:\export_schema\exp_schema.dmp
owner=%owner%

goto end

:end

set owner=




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.

Yours Sincerely,

Faraz
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On