REP-0606 unable to read linked file check link file format in oracle reports

up vote
0
down vote

favorite

I am reading a image file and showing it in Oracle reports 6i. Below coding is for your reference.

function cf_imageFormula return Char is



out_file Text_IO.File_Type; 

image_1 varchar2(2000);`enter code here`



begin

  select   'Q:syimg'||:pyempcde||'.' || 'jpg'  into image_1

from dual;





out_file :=Text_IO.Fopen('Q:syimg'||:pyempcde||'.' || 'jpg', 'r'); 



return ('Q:syimg'||:pyempcde||'.' || 'jpg');



exception 

when no_data_found then 

return('Q:syimgno_image.jpg'); 

when others then 

return('Q:syimgno_image.jpg');

end;

The image also showing successfully in report for the first record, from second record the subjected error is showing. Please help me with solution..

edited Nov 13 at 13:51

asked Nov 13 at 13:11

Prabha Christ

44226

add a comment |

up vote
0
down vote

favorite

I am reading a image file and showing it in Oracle reports 6i. Below coding is for your reference.

function cf_imageFormula return Char is



out_file Text_IO.File_Type; 

image_1 varchar2(2000);`enter code here`



begin

  select   'Q:syimg'||:pyempcde||'.' || 'jpg'  into image_1

from dual;





out_file :=Text_IO.Fopen('Q:syimg'||:pyempcde||'.' || 'jpg', 'r'); 



return ('Q:syimg'||:pyempcde||'.' || 'jpg');



exception 

when no_data_found then 

return('Q:syimgno_image.jpg'); 

when others then 

return('Q:syimgno_image.jpg');

end;

The image also showing successfully in report for the first record, from second record the subjected error is showing. Please help me with solution..

edited Nov 13 at 13:51

asked Nov 13 at 13:11

Prabha Christ

44226

add a comment |

up vote
0
down vote

favorite

I am reading a image file and showing it in Oracle reports 6i. Below coding is for your reference.

function cf_imageFormula return Char is



out_file Text_IO.File_Type; 

image_1 varchar2(2000);`enter code here`



begin

  select   'Q:syimg'||:pyempcde||'.' || 'jpg'  into image_1

from dual;





out_file :=Text_IO.Fopen('Q:syimg'||:pyempcde||'.' || 'jpg', 'r'); 



return ('Q:syimg'||:pyempcde||'.' || 'jpg');



exception 

when no_data_found then 

return('Q:syimgno_image.jpg'); 

when others then 

return('Q:syimgno_image.jpg');

end;

The image also showing successfully in report for the first record, from second record the subjected error is showing. Please help me with solution..

edited Nov 13 at 13:51

asked Nov 13 at 13:11

Prabha Christ

44226

I am reading a image file and showing it in Oracle reports 6i. Below coding is for your reference.

function cf_imageFormula return Char is



out_file Text_IO.File_Type; 

image_1 varchar2(2000);`enter code here`



begin

  select   'Q:syimg'||:pyempcde||'.' || 'jpg'  into image_1

from dual;





out_file :=Text_IO.Fopen('Q:syimg'||:pyempcde||'.' || 'jpg', 'r'); 



return ('Q:syimg'||:pyempcde||'.' || 'jpg');



exception 

when no_data_found then 

return('Q:syimgno_image.jpg'); 

when others then 

return('Q:syimgno_image.jpg');

end;

The image also showing successfully in report for the first record, from second record the subjected error is showing. Please help me with solution..

sql oracle plsql file-read oraclereports

edited Nov 13 at 13:51

asked Nov 13 at 13:11

Prabha Christ

44226

edited Nov 13 at 13:51

asked Nov 13 at 13:11

Prabha Christ

44226

edited Nov 13 at 13:51

asked Nov 13 at 13:11

Prabha Christ

44226

asked Nov 13 at 13:11

Prabha Christ

44226

asked Nov 13 at 13:11

Prabha Christ

44226

add a comment |

1 Answer
1

active

oldest

votes

up vote
0
down vote

As far as I can tell, image size might be the issue. Reports isn't capable of displaying (too) large images (in size, [KB], not centimeters). If that's the case, there's nothing much you can do about it, unless you resize images and make them much smaller (regarding what you've said - it displays only one image ... that's close to nothing).

Just wondering: how large are those images? How many of them are you supposed to display in the report?

answered Nov 13 at 18:26

Littlefoot

18.5k51333

I want to display more than 30 images and that is one image for each page.. each image size is nearly 1.2 M.
– Prabha Christ
Nov 14 at 5:34

I presume that that's too large. I've had to print some signed contracts, where signature was a scanned image. For ~300 contracts, when the image was larger than 20 KB (KB! not MB), the report failed so I had to shrink image size. Try to do the same; there are tools (available on the Internet) that let you resize images all-at-once. See what happens. Don't forget to save a backup copy of the original images!
– Littlefoot
Nov 14 at 7:35

I made the report to call one image for one time.. thanks
– Prabha Christ
Nov 14 at 10:53

Hi littlefoot, now I am trying to show only one image then also its showing the same error.. may be image size is more.. can we have any option to resize the image
– Prabha Christ
Nov 15 at 8:25

It is done at operating system level; use any image viewer, it should have that capability.
– Littlefoot
Nov 15 at 8:59

|
show 1 more comment

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53281755%2frep-0606-unable-to-read-linked-file-check-link-file-format-in-oracle-reports%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

Just wondering: how large are those images? How many of them are you supposed to display in the report?

answered Nov 13 at 18:26

Littlefoot

18.5k51333

I want to display more than 30 images and that is one image for each page.. each image size is nearly 1.2 M.
– Prabha Christ
Nov 14 at 5:34

I presume that that's too large. I've had to print some signed contracts, where signature was a scanned image. For ~300 contracts, when the image was larger than 20 KB (KB! not MB), the report failed so I had to shrink image size. Try to do the same; there are tools (available on the Internet) that let you resize images all-at-once. See what happens. Don't forget to save a backup copy of the original images!
– Littlefoot
Nov 14 at 7:35

I made the report to call one image for one time.. thanks
– Prabha Christ
Nov 14 at 10:53

Hi littlefoot, now I am trying to show only one image then also its showing the same error.. may be image size is more.. can we have any option to resize the image
– Prabha Christ
Nov 15 at 8:25

It is done at operating system level; use any image viewer, it should have that capability.
– Littlefoot
Nov 15 at 8:59

|
show 1 more comment

up vote
0
down vote

Just wondering: how large are those images? How many of them are you supposed to display in the report?

answered Nov 13 at 18:26

Littlefoot

18.5k51333

I want to display more than 30 images and that is one image for each page.. each image size is nearly 1.2 M.
– Prabha Christ
Nov 14 at 5:34

I presume that that's too large. I've had to print some signed contracts, where signature was a scanned image. For ~300 contracts, when the image was larger than 20 KB (KB! not MB), the report failed so I had to shrink image size. Try to do the same; there are tools (available on the Internet) that let you resize images all-at-once. See what happens. Don't forget to save a backup copy of the original images!
– Littlefoot
Nov 14 at 7:35

I made the report to call one image for one time.. thanks
– Prabha Christ
Nov 14 at 10:53

Hi littlefoot, now I am trying to show only one image then also its showing the same error.. may be image size is more.. can we have any option to resize the image
– Prabha Christ
Nov 15 at 8:25

It is done at operating system level; use any image viewer, it should have that capability.
– Littlefoot
Nov 15 at 8:59

|
show 1 more comment

up vote
0
down vote

Just wondering: how large are those images? How many of them are you supposed to display in the report?

answered Nov 13 at 18:26

Littlefoot

18.5k51333

Just wondering: how large are those images? How many of them are you supposed to display in the report?

answered Nov 13 at 18:26

Littlefoot

18.5k51333

answered Nov 13 at 18:26

Littlefoot

18.5k51333

answered Nov 13 at 18:26

Littlefoot

18.5k51333

answered Nov 13 at 18:26

Littlefoot

18.5k51333

I want to display more than 30 images and that is one image for each page.. each image size is nearly 1.2 M.
– Prabha Christ
Nov 14 at 5:34

I presume that that's too large. I've had to print some signed contracts, where signature was a scanned image. For ~300 contracts, when the image was larger than 20 KB (KB! not MB), the report failed so I had to shrink image size. Try to do the same; there are tools (available on the Internet) that let you resize images all-at-once. See what happens. Don't forget to save a backup copy of the original images!
– Littlefoot
Nov 14 at 7:35

I made the report to call one image for one time.. thanks
– Prabha Christ
Nov 14 at 10:53

Hi littlefoot, now I am trying to show only one image then also its showing the same error.. may be image size is more.. can we have any option to resize the image
– Prabha Christ
Nov 15 at 8:25

It is done at operating system level; use any image viewer, it should have that capability.
– Littlefoot
Nov 15 at 8:59

|
show 1 more comment

I want to display more than 30 images and that is one image for each page.. each image size is nearly 1.2 M.
– Prabha Christ
Nov 14 at 5:34

I presume that that's too large. I've had to print some signed contracts, where signature was a scanned image. For ~300 contracts, when the image was larger than 20 KB (KB! not MB), the report failed so I had to shrink image size. Try to do the same; there are tools (available on the Internet) that let you resize images all-at-once. See what happens. Don't forget to save a backup copy of the original images!
– Littlefoot
Nov 14 at 7:35

I made the report to call one image for one time.. thanks
– Prabha Christ
Nov 14 at 10:53

Hi littlefoot, now I am trying to show only one image then also its showing the same error.. may be image size is more.. can we have any option to resize the image
– Prabha Christ
Nov 15 at 8:25

It is done at operating system level; use any image viewer, it should have that capability.
– Littlefoot
Nov 15 at 8:59

I want to display more than 30 images and that is one image for each page.. each image size is nearly 1.2 M.
– Prabha Christ
Nov 14 at 5:34

I presume that that's too large. I've had to print some signed contracts, where signature was a scanned image. For ~300 contracts, when the image was larger than 20 KB (KB! not MB), the report failed so I had to shrink image size. Try to do the same; there are tools (available on the Internet) that let you resize images all-at-once. See what happens. Don't forget to save a backup copy of the original images!
– Littlefoot
Nov 14 at 7:35

I made the report to call one image for one time.. thanks
– Prabha Christ
Nov 14 at 10:53

Hi littlefoot, now I am trying to show only one image then also its showing the same error.. may be image size is more.. can we have any option to resize the image
– Prabha Christ
Nov 15 at 8:25

It is done at operating system level; use any image viewer, it should have that capability.
– Littlefoot
Nov 15 at 8:59

|
show 1 more comment

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfrgtkky