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..
sql oracle plsql file-read oraclereports
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..
sql oracle plsql file-read oraclereports
asked Nov 13 at 13:11
Prabha Christ
44226
add a comment |
up vote
0
down vote
favorite
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..
sql oracle plsql file-read oraclereports
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
sql oracle plsql file-read oraclereports
asked Nov 13 at 13:11
Prabha Christ
44226
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
44226
add a comment |
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
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
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
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
up vote
0
down vote
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
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
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
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 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 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
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
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
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
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
