EBS Customizations (MOSC)

MOSC Banner

How to get file sitting in database server to application server

edited Jul 17, 2015 9:53PM in EBS Customizations (MOSC) 6 commentsAnswered ✓

Hello,

Using UTL_FILE package i created file which is sitting in the database server.

Now i want to access this file through a host program (shell script) launched from concurrent program.

The problem is, when shell is launched from concurrent program it is looking files/folder on application server (the reason behind concurrent program is running on application server) but i need to access the file which is on database server.

I need this file from database because the file need to be FTPed using the host program.

This can be achived by connecting database server from application server using scp command.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center