Home » SQL & PL/SQL » SQL & PL/SQL » Copy os file using pl/sql with different users credential (merged 6)
Copy os file using pl/sql with different users credential (merged 6) [message #414329] Tue, 21 July 2009 12:03 Go to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Hi,

I wanted to copy files from one to location to another location using sql/plus. The caller of this procedure wont be having write privilege on the folder the file is being copied to.

So i wanted to create a procedure that will use internally a privileged users credential to copy this file.How can i accomplish this using pl/sql or in any other way that can be incorporated to plsql

Looking forward to your supporting..


Regards,
uns Smile
Re: Copy os file using pl/sql with different users credential [message #414332 is a reply to message #414329] Tue, 21 July 2009 12:08 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>I wanted to copy files from one to location to another location using sql/plus
>How can i accomplish this using pl/sql or in any other way that can be incorporated to plsql

PL/SQL not equal sqlplus.
Why do you want to use Oracle to do an Operating System function?

Why not use correct tool for the job; COPY?
Re: Copy os file using pl/sql with different users credential [message #414334 is a reply to message #414329] Tue, 21 July 2009 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not repeat your question but answer BlackSwan's ones.

Is this SQL*Plus or PL/SQL?

Regards
Michel
Re: Copy os file using pl/sql with different users credential (merged) [message #414335 is a reply to message #414329] Tue, 21 July 2009 12:28 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>I wanted to copy files from one to location to another location
What assurance is there that "oracle" user will have OS permissions to both source & destination folders & files?
Realize this task is only valid for files resident on DB server system.
Re: Copy os file using pl/sql with different users credential (merged 4) [message #414352 is a reply to message #414329] Tue, 21 July 2009 13:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
STOP repeating your question twice per hour.

Regards
Michel
Re: Copy os file using pl/sql with different users credential (merged 5) [message #414355 is a reply to message #414329] Tue, 21 July 2009 13:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Correction

STOP SPAMMING THE FORUM WITH THE SAME QUESTION EVERY QUARTER OF HOUR.

Regards
Michel

[Updated on: Tue, 21 July 2009 13:46]

Report message to a moderator

Re: Copy os file using pl/sql with different users credential (merged 5) [message #414766 is a reply to message #414355] Thu, 23 July 2009 07:39 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
I am really sorry all. I was not posting it again and gain. Every time i tried to post my screen was not showing any progress at all becuase of some issues so iwas under the impression that it was not getting posted at last gave up and decided to post it next day but only when i tried to login the other day i realized my account is blocked and something has gone worng.
Re: Copy os file using pl/sql with different users credential [message #414769 is a reply to message #414332] Thu, 23 July 2009 07:43 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
my requirement is this. Using oracle forms i wanted to give user an option to copy from users pc to the server. Users wont be having direct access on the folder they are copying to. so iwanted to use internally a privileged users credentails.

There is a typo in the first post i wanted to do that in pl/sql.

[Updated on: Thu, 23 July 2009 07:47]

Report message to a moderator

Re: Copy os file using pl/sql with different users credential [message #414782 is a reply to message #414769] Thu, 23 July 2009 08:00 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
To copy from a local PC to the server you'll want to look at WebUtil as the Oracle server knows nothing of client machines.
Re: Copy os file using pl/sql with different users credential (merged 6) [message #414798 is a reply to message #414329] Thu, 23 July 2009 09:10 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Webutil, i can not use different credentials thats why i was thinking of any possibility through pl/sql
Re: Copy os file using pl/sql with different users credential (merged 6) [message #414800 is a reply to message #414329] Thu, 23 July 2009 09:20 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Webutil, i can not use different credentials thats why i was thinking of any possibility through pl/sql
Since PL/SQL runs only deep inside Oracle RDBMS, how can it reach out & touch file on remote client PC?

Here is a free clue,PL/SQL never gets close to remote client PC especially when communication is done via web browser.
Previous Topic: ORA-00907: missing right parenthesis
Next Topic: Help me with this query
Goto Forum:
  


Current Time: Sun Dec 04 23:00:17 CST 2016

Total time taken to generate the page: 0.19294 seconds