OraFAQ Forum: Forms » Document look smear

Home » Developer & Programmer » Forms » Document look smear (Oracle developer form 6, OS: windows XP SP3)

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

Document look smear [message #412749]

Sat, 11 July 2009 02:55

oracle_user1
Messages: 45
Registered: May 2008

Member

Hi to all,

I encounter a problem with new scanner Canon Scanjet G3110 which is scan the normal document(A4 paper with black and white color).

I success to scan and insert the image document in my table, but i query or display out the documnet, it looks smear.

By the way i have no problem with other model printer like Canon Scanject G3010.

Attached herewith my code and the result of the image store.

Hope you all expects there help me to find out what is the problem exist there.

Thanks you.

Regards,
oracle user

Attachment: scannew scanner.sql
(Size: 15.26KB, Downloaded 1439 times)

Report message to a moderator

Re: Document look smear [message #413277 is a reply to message #412749]

Wed, 15 July 2009 01:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do you have the same problem if you scan the document into MS Paint?

David

Report message to a moderator

Re: Document look smear [message #414151 is a reply to message #412749]

Mon, 20 July 2009 09:47

oracle_user1
Messages: 45
Registered: May 2008

Member

Thanks you advise, i will test it and will let you know the result.

Thanks.

Regards,
oracle user

Report message to a moderator

Re: Document look smear [message #414562 is a reply to message #414151]

Wed, 22 July 2009 11:56

oracle_user1
Messages: 45
Registered: May 2008

Member

Dear David,

I had try to scan the document into MS Paint. There is not look smear on the document.

So, it is mean there is not problem on the scanner right? How should i to do now ? Amend my program in order to suite the scanner ? If yes, which part of the program i need to amend.
I'm attaching my scan program here.

Hope you can give some idea to me.
Thanks.

Regards,
oracle user

Attachment: scannew scanner.txt
(Size: 15.26KB, Downloaded 1141 times)

Report message to a moderator

Re: Document look smear [message #414858 is a reply to message #414562]

Thu, 23 July 2009 19:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Can you load the image that you scanned into MS Paint into your database and see whether your form 'smears' it when it is displayed?

When you scan the same document into MS Paint using the old scanner is the saved image the same size as when you scan using the new scanner?

I have a feeling that the default settings of the new scanner are different to those on the old scanner.

David

Report message to a moderator

Re: Document look smear [message #415881 is a reply to message #414858]

Wed, 29 July 2009 11:09

oracle_user1
Messages: 45
Registered: May 2008

Member

Dear David,

My problem solved.
I had change the default setting of the new scanner.
Thanks for your advise, without your advise then my problem will still hanging there. Thanks a lot, David.

Regards,
oracle user

Report message to a moderator

Re: Document look smear [message #415957 is a reply to message #415881]

Wed, 29 July 2009 23:13

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Thanks for getting back to us. Forms I trust, the rest, well!!

David

Report message to a moderator

Re: Document look smear [message #420858 is a reply to message #415957]

Wed, 02 September 2009 11:45

oracle_user1
Messages: 45
Registered: May 2008

Member

Hi to all,

Now i have another problem.
When i change the setting scanner (HP G3110), my A4 document scan and insert into database it not look smear.
But when i want to scan photo, it have error.
I upload my program here. Hope can get help from you all.
Thanks.

Regards,
oracle user

Attachment: csp_scanfrimg.fmb
(Size: 316.00KB, Downloaded 1158 times)

Report message to a moderator

Re: Document look smear [message #420859 is a reply to message #420858]

Wed, 02 September 2009 11:53

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Don't you think it'd be an idea if you told us what the error was?

Report message to a moderator

Re: Document look smear [message #420861 is a reply to message #420859]

Wed, 02 September 2009 12:03

oracle_user1
Messages: 45
Registered: May 2008

Member

Dear cookiemonster,

I will capture the error screen and post it here tomorrow.

Thanks.

Regards,
oracle user

Report message to a moderator

Re: Document look smear [message #420963 is a reply to message #420861]

Thu, 03 September 2009 08:52

oracle_user1
Messages: 45
Registered: May 2008

Member

Hi to all,

I attaching the default setting for the scanner HP G3110.

If i using this default setting for scan photo (through my program) it's work. (successful inserted in my Oracle Database, but query ,it is look fine)
But scan document (through my program), my document look smear. (successful inserted in my Oracle Database, but query ,it is look smear)

I affaird it is causing my program.
In my program i using ORA_FFI.FUNCHANDLETYPE to compress the A4 document.
Is it causing by my program ?
Hope you all can help me and give some advise to me.

Thanks.

Regards,
Oracle user

function :

FUNCTION ff_compressa4 (fhandle ORA_FFI.FUNCHANDLETYPE, pageint PLS_INTEGER,
com_a4page IN OUT PLS_INTEGER)
RETURN PLS_INTEGER;
PRAGMA interface (C, ff_compressa4, 11265);

FUNCTION f_compressa4 (pageint PLS_INTEGER, com_a4page IN OUT PLS_INTEGER)
RETURN PLS_INTEGER IS
BEGIN
RETURN ff_compressa4 (compressa4_fhandle, pageint, com_a4page);
END;

Attachment: scaner G3110 default setting.JPG
(Size: 57.60KB, Downloaded 648 times)

Report message to a moderator

Re: Document look smear [message #420966 is a reply to message #420963]

Thu, 03 September 2009 08:54

oracle_user1
Messages: 45
Registered: May 2008

Member

Hi to all,

Cause of max. 1 file upload per message.

Here i upload my document which insert into database ,but query it look smear.

Thanks.

Regards,
oracle user

Attachment: doc smear.jpg
(Size: 148.67KB, Downloaded 976 times)

Report message to a moderator

Re: Document look smear [message #420971 is a reply to message #420966]

Thu, 03 September 2009 09:02

oracle_user1
Messages: 45
Registered: May 2008

Member

Hi to all,

Here i upload my program (scan photo and document A4)

Hope you can help me.
I encounter the problem scan document. scan photo no problem

Thanks.

Regards,
oracle user

Attachment: csp_scanfrimg.fmb
(Size: 320.00KB, Downloaded 1133 times)

Report message to a moderator

Re: Document look smear [message #422909 is a reply to message #420971]

Mon, 21 September 2009 02:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: Document look smear [message #422989 is a reply to message #422909]

Mon, 21 September 2009 11:10

oracle_user1
Messages: 45
Registered: May 2008

Member

Dear David,

My problem still not solve yet. I have looking solution thru google, but i still can't get the answer.
Hope you can help me.
Thanks.

Regards,
oracle user.

Report message to a moderator

Re: Document look smear [message #423091 is a reply to message #420858]

Tue, 22 September 2009 01:40

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

oracle_user1 wrote on Thu, 03 September 2009 02:45

When i change the setting scanner (HP G3110), my A4 document scan and insert into database it not look smear.
But when i want to scan photo, it have error.

Did you change any of your settings?

David

Report message to a moderator

Re: Document look smear [message #423118 is a reply to message #423091]

Tue, 22 September 2009 04:09

oracle_user1
Messages: 45
Registered: May 2008

Member

Dear David,

For scan Passport size Photo :-
If i follow the default setting (scanner), i can scan , save into database and display successful..

For scan A4 size document :-
But if i change the setting of the scanner then i can scan, save into database and display scuccessful the A4 document.

It's mean i need to change the setting when i want to scan and save into database. Cause the default setting of the scanner can't scan and save successfully when scan the A4. (afert i scan and save into database, it look smear.
I attaching the setting i make for the scanner for scan A4.
(i tick the 'automatically crop scanned images)

Do you have any idea about this problem.

Regards,
oracle user.

Attachment: a1.JPG
(Size: 47.84KB, Downloaded 655 times)

Report message to a moderator

Re: Document look smear [message #423384 is a reply to message #423118]

Wed, 23 September 2009 19:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I have no real idea. All I can suggest is trying different scanners and see if one gives a different result.

David

Report message to a moderator

Re: Document look smear [message #423527 is a reply to message #423384]

Fri, 25 September 2009 01:56

oracle_user1
Messages: 45
Registered: May 2008

Member

Dear David,

I using other model HP scanner is not problem at all.
But just have problem with scanner model HP G3110.

Thanks.

Regards,
oracle user

Report message to a moderator

Previous Topic:	Error FRM:18108
Next Topic:	Problem using webutil functionality in 10g forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:33:05 CDT 2024