How to incorporatet file that will be written to AS using DS package [message #296317] |
Fri, 25 January 2008 13:56 |
tapaskmanna
Messages: 98 Registered: January 2007 Location: Cyprus,Nicosia
|
Member |
|
|
Application Server (AS)
Database Server (DS)
I have written Package in DS and calling that Package in AS using shell script.
As i am using UTL_File to write the data into File that will write file in DS.
Is there any way using PL/SQL that can be written in AS?
If not then how to incorporate this so that file will be written to AS using DS package ?
|
|
|
|
|
Re: How to incorporatet file that will be written to AS using DS package [message #296334 is a reply to message #296317] |
Fri, 25 January 2008 20:01 |
rleishman
Messages: 3728 Registered: October 2005 Location: Melbourne, Australia
|
Senior Member |
|
|
tapaskmanna wrote on Sat, 26 January 2008 06:56 |
I have written Package in DS and calling that Package in AS using shell script.
|
Unless Unix Shells have leapt forward whilst I wasn't watching, they cannot call PL/SQL packages directly. They need to run a client that has database connectivity like SQL*Plus, Perl, Java, Pro*C, etc.
Instead of using UTL_FILE, use a pipelined function to push the data into a Nested Table, and then perform a SELECT statement on the nested table from your client tool to then push the results to a file.
Lookup PIPELINED FUNCTIONS in the doco.
Ross Leishman
|
|
|