Home » Developer & Programmer » Forms » Document look smear (Oracle developer form 6, OS: windows XP SP3)
icon8.gif  Document look smear [message #412749] Sat, 11 July 2009 02:55 Go to next message
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
Re: Document look smear [message #413277 is a reply to message #412749] Wed, 15 July 2009 01:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have the same problem if you scan the document into MS Paint?

David
Re: Document look smear [message #414151 is a reply to message #412749] Mon, 20 July 2009 09:47 Go to previous messageGo to next message
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
Re: Document look smear [message #414562 is a reply to message #414151] Wed, 22 July 2009 11:56 Go to previous messageGo to next message
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
Re: Document look smear [message #414858 is a reply to message #414562] Thu, 23 July 2009 19:55 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Document look smear [message #415881 is a reply to message #414858] Wed, 29 July 2009 11:09 Go to previous messageGo to next message
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
Re: Document look smear [message #415957 is a reply to message #415881] Wed, 29 July 2009 23:13 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Thanks for getting back to us. Forms I trust, the rest, well!!

David
Re: Document look smear [message #420858 is a reply to message #415957] Wed, 02 September 2009 11:45 Go to previous messageGo to next message
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
Re: Document look smear [message #420859 is a reply to message #420858] Wed, 02 September 2009 11:53 Go to previous messageGo to next message
cookiemonster
Messages: 12320
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?
Re: Document look smear [message #420861 is a reply to message #420859] Wed, 02 September 2009 12:03 Go to previous messageGo to next message
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
Re: Document look smear [message #420963 is a reply to message #420861] Thu, 03 September 2009 08:52 Go to previous messageGo to next message
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;
Re: Document look smear [message #420966 is a reply to message #420963] Thu, 03 September 2009 08:54 Go to previous messageGo to next message
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 112 times)
Re: Document look smear [message #420971 is a reply to message #420966] Thu, 03 September 2009 09:02 Go to previous messageGo to next message
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
Re: Document look smear [message #422909 is a reply to message #420971] Mon, 21 September 2009 02:54 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Document look smear [message #422989 is a reply to message #422909] Mon, 21 September 2009 11:10 Go to previous messageGo to next message
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.
Re: Document look smear [message #423091 is a reply to message #420858] Tue, 22 September 2009 01:40 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Document look smear [message #423118 is a reply to message #423091] Tue, 22 September 2009 04:09 Go to previous messageGo to next message
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 136 times)
Re: Document look smear [message #423384 is a reply to message #423118] Wed, 23 September 2009 19:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Document look smear [message #423527 is a reply to message #423384] Fri, 25 September 2009 01:56 Go to previous message
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
Previous Topic: Error FRM:18108
Next Topic: Problem using webutil functionality in 10g forms
Goto Forum:
  


Current Time: Wed Sep 28 00:36:45 CDT 2016

Total time taken to generate the page: 0.12660 seconds