Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upload a file / attachments to the server

AntillesJan 22 2014 — edited Jan 22 2014

Hi

We have a requirement to be able to upload files (word documents, PDFs, images etc) through an Apex application and store in a folder on the server. I can already load files into a BLOB column in a table quite easily but we now want to upload them directly onto a server. I also need to capture the path we upload to and store this in the database so we can retrieve the files later.

Can anyone suggest a way to achieve this?

Comments

Kalpataru

Try this

crlf varchar2(2) := chr(10)||chr(13);

it will work.

HamidHelal

What is your database version ?

Did you give privilege SYS UTL_ENCODE,UTL_SMTP and UTL_TCP to the user ? Are you assign the Mail serve port ?

Hamid

Hmusman

i user oracle 10 g and tell me way how to assign privileges to user

Kalpataru

Hi Hmusman,

Which privilege you are talking about.

If you want to give privilege to user connect to sys as sysdba give grant.

grant execute on FSC.SEND_MAIL to scott; <--scott is the username i have taken scott. You change according to your's username.

grant execute on UTL_ENCODE to scott;

grant execute on UTL_SMTP to scott;

grant execute on UTL_TCP to scott;

Hmusman

i use oracle express edition so i cant i find

.SEND_MAIL , UTL_ENCODE, UTL_SMTP, UTL_TCP

HamidHelal 
Hmusman wrote:




i use oracle express edition so i cant i find


.SEND_MAIL , UTL_ENCODE, UTL_SMTP, UTL_TCP

This are the content of SYS. I don't remember Oracle XE has this.

Just connect SYS as SYSDBA and

issue

grant execute on UTL_ENCODE to <user_name>;

grant execute on UTL_SMTP to <user_name>;

grant execute on UTL_TCP to <user_name>;


Hope this helps


Hamid

1 person found this helpful
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 19 2014
Added on Jan 22 2014
#apex, #apex-discussions, #server
1 comment
183 views