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!

'RUNTOFILE' using dblink or remotely

Discussion in 'Oracle Forms and Reports' started by sreyas, Jan 7, 2015.

  1. sreyas

    sreyas Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi

    I have created a PSQUERY with same name on different databases with different criteria.So suppose if i run psquery 'X' in database 'A'the result will give 8 and if i run psquery 'X' in database 'B' the result will give 100.

    Using 'RUNTOFILE' command i am able to get the result of database A into a file.But how to get the result of database B into a file using 'runtofile' command?

    Please give me sample peoplecode for this.

    Note: Dblink is created but not getting how to use it in 'RUNTOFILE' command.

    Please help

    Thanks
    PS