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!

Re: Problem providing download link for BLOB data in apex report

user3003326Oct 30 2013 — edited Oct 30 2013

Hi Don,

Your solution below worked but in the download option i only see save but not open for PDf file in the blob. Please let me know if you have any suggestion to achieve it

Thanks

Jo

Problem providing download link for BLOB data in apex report 

591953 Explorer

591953 Nov 19, 2008 1:55 PM (in response to 660436)

 

Currently Being Moderated

 

Good morning,

Here is how I have solved this problem.

1. The select statement in the sql for the report should not include the BLOB column. I decided to select only 2 columns, the column that has the key and the column with the filename.
2. On the first column ( the primary key ) I put in the format statement that was simply DOWNLOAD:TABLENAME:BLOB_COLUMN:PRIMARY_KEY

This works. I believe that the Oracle error I was getting was because I was trying to apply this format statement to the actual BLOB column.

So, it appears that you can use any of the columns in the report to hold the DOWNLOAD format statement since in the format statement, you are defining the BLOB table, BLOB column and the primary key into that column.


Hope this helps,
Don.

Comments

Aravind N

Hi,
This is a known bug and is documented in MOS document ID 784038.1

If you are not particular about using exp/imp, try expdp and impdp which would be faster as well. Else you might have to apply the patch mentioned to fix this.

-Aravind

1 person found this helpful
Paul M.
Answer 
I like to copy the data from 10.2.0.4 oracle database to 11.2.0.3 db, so i tried to fired the traditional export from 11gr2 db server throw network

Apart that you should use expdp, you can't export a database using an exp utility from an higher version, you have to export using 10g exp utility, and import using 11g imp utility.

Export done in US7ASCII character set and AL16UTF16 NCHAR character set


server uses AL32UTF8 character set (possible charset conversion)

Couldn't this be a problem ? You should set NLS_LANG environment variable before exporting and importing.

Marked as Answer by 906790 · Sep 27 2020
Mark D Powell

I agree with Paul that if you are going to use exp you must use the 10.2 version to perform the export which the 11.2 imp can then process.  If you use expdp to run the export then you should be able to use the 11.2 version providing you specify the version= parameter to identify that an older database is being read. 

HTH -- Mark D Powell --


1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 27 2013
Added on Oct 30 2013
#apex-discussions
1 comment
1,491 views