Results 1 to 3 of 3

Thread: exp

  1. #1
    Join Date
    May 2009

    Exclamation Unanswered: exp

    i have an application which is hard coded to run export when user logs into the system. The code is below, its failing to run the export because when i open command prompt DOS and i type exp or imp its saying opertation not found. The imp & exp utility only works when i type in the whole path
    e:\oracle\ora817\bin. This is when exp & imp run. So my question is how can i add this path in the below code so it can run when user logs in.

    if alert_button1 = al_button then
    host('exp '||connect_str||' file = c:\'||USER_NAME||'_'||FILE_NAME||' tables = ACTIVITY_PARAMETERS ;[/B][/B]

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL

    Cool Easy does it

    How about:

    host('e:\oracle\ora817\bin\exp '||connect_str||' file = c:\'||USER_NAME||'_'||FILE_NAME||' tables = ACTIVITY_PARAMETERS ;...
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    By the way, the host command is a sql command and can't be called from a PL/SQL block. However, you can do this with a java call.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts