Home » SQL & PL/SQL » SQL & PL/SQL » How to incorporatet file that will be written to AS using DS package (Oracle,10g,Unix)
How to incorporatet file that will be written to AS using DS package [message #296317] Fri, 25 January 2008 13:56 Go to next message
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 #296321 is a reply to message #296317] Fri, 25 January 2008 14:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, there is no way unless you use an NFS mounted file system on DS.

Regards
Michel
Re: How to incorporatet file that will be written to AS using DS package [message #296331 is a reply to message #296321] Fri, 25 January 2008 17:08 Go to previous messageGo to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
I was trying to explore more information on:
NFS mounted file system on DS

in google but not able to get proper one,
can you depict some link/info for the same ?
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 Go to previous message
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
Previous Topic: Eliminate duplicate emails in String
Next Topic: Oracle Sample Schema's?
Goto Forum:
  


Current Time: Tue Nov 05 14:11:47 CST 2024