1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Storing log in client UNIX machine

Discussion in 'SQL PL/SQL' started by man_expo, Sep 11, 2009.

  1. man_expo

    man_expo Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    I am calling a SQL script from a shell script. This SQL script in turn compiles and runs a procedure. I want the DBMS_OUTPUT statements in the procedure to be stored in my local UNIX machine in a file. UTL_FILE, if I am right, will create file in server side. What can I do to get logs in client machine? Some specific explanation with examples would be highly appreciated as I am relatively new to PL/SQL.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Files generated by calls to UTL_FILE from stored procedures always reside on the database server. They cannot be directly written to a client.

    You can always use ftp.