How to call an external program
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to call an external program

  1. #1
    Join Date
    Mar 2001
    Posts
    188

    Exclamation

    Hi gurus
    i have a simple question. Can i call an external program from an PL/SQL procedure.
    If yes. How can i make this. Can you give me a small example and which packages must be installed.

    our system runs under linux with the oracle enterprice edition 8.1.7.

    Thanks

    Regards
    Thomas Schmidt

    [Edited by tomate on 04-06-2001 at 02:14 AM]

  2. #2
    Join Date
    Mar 2001
    Posts
    5

    Wink running external programme

    use HOST Command:

    PROCEDURE HOST
    (system_command_string VARCHAR2);
    PROCEDURE HOST
    (system_command_string VARCHAR2,
    screen_action NUMBER);

    Built-in Type unrestricted procedure
    Enter Query Mode yes

    Parameters

    system_command_ string Specifies the system command you want to pass to your particular operating system.

    screen_actio Specifies one of the following constants:

    no parameter Specifies that Form Builder will:

    n clear the screen

    n prompt the operator to return from the command

    NO_PROMPT Specifies that Form Builder will:

    n clear the screen (does not prompt the operator to return from the command)

    NO_SCREEN Specifies that Form Builder will:

    n not clear the screen

    n not prompt the operator to return from the system command

    (The HOST command should not send output to the screen when using the NO_SCREEN parameter.)

    Note: Thescreen_action parameter is only relevant to applications running in character mode, where the output of the Host command is displayed in the same window as the form. In GUI applications, the output of the Host command is displayed in a separate window.

    Take Care.
    Bye
    Yogesh Bhardwaj

  3. #3
    Join Date
    Mar 2001
    Posts
    188
    Can You tell me how the procedure is named that i implement this procedure host into the database.

  4. #4
    Join Date
    Apr 2001
    Posts
    3

    Hi,

    Do you want to call the PL/SQL Procedure from Oracle Application ?

    If yes then,

    go into the o/s and write the procedure in a file with .sql extension and then move the file to application specified directory under sql or you can even store the procedure as a stored procedure and call it in oracle application.

    for doing so,

    Navigate to Application Developer Responsibility and then enter in to Concurrent Program Menu and then into Create Executables form

    in that if u are using stored procedure,

    select the execution method as stored procedure and then tell the procedure to be called.

    and then attach this executable file to Concurrent program. and then call the concurrent program as a report or process.

    if you are aware about concurrent programs pls let me know so that I can proceed further.

    rgds,
    suren

Posting Permissions

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



Click Here to Expand Forum to Full Width