OraFAQ Forum: SQL & PL/SQL » Copy os file using pl/sql with different users credential (merged 6)

Home » SQL & PL/SQL » SQL & PL/SQL » Copy os file using pl/sql with different users credential (merged 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copy os file using pl/sql with different users credential (merged 6) [message #414329]

Tue, 21 July 2009 12:03

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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?

Report message to a moderator

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do not repeat your question but answer BlackSwan's ones.

Is this SQL*Plus or PL/SQL?

Regards
Michel

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

STOP repeating your question twice per hour.

Regards
Michel

Report message to a moderator

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

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

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

joy_division
Messages: 4963
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.

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	ORA-00907: missing right parenthesis
Next Topic:	Help me with this query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 11:34:37 CST 2025