OraFAQ Forum: Forms » webutil_file_transfer.Client_To_DB_with

Home » Developer & Programmer » Forms » webutil_file_transfer.Client_To_DB_with_progress (FORMS 10G)

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

webutil_file_transfer.Client_To_DB_with_progress [message #459014]

Thu, 03 June 2010 00:38

manish.nankar
Messages: 10
Registered: December 2008

Junior Member

Dear All,
I have one problem. i am using client_to_db function to store the file to database table.During upload of file,System showing me message "File successfully transferred to database". but when i am downloading the file from database, its not working.

please advice me in this case.

for your references, i am attaching the fmb file with this mail.

regards,
Manish n

Attachment: PEDBOM.fmb
(Size: 132.00KB, Downloaded 1440 times)

Report message to a moderator

Re: webutil_file_transfer.Client_To_DB_with_progress [message #459026 is a reply to message #459014]

Thu, 03 June 2010 01:18

manish.nankar
Messages: 10
Registered: December 2008

Junior Member

I m sorry...its working now..i m able to download file to my pc now..
actually i didn't set the database.enabled='true'

But one problem is I am not able to read the contents of blob column from table.

SELECT DBMS_lob.getlength(doc_blob)
FROM WU_TEST_TABLE
WHERE id = 1;

Above query should give me length of file that i transferred to database.But its returning null.

early response is much appreciated.

regards,
Manish N.

Report message to a moderator

Re: webutil_file_transfer.Client_To_DB_with_progress [message #459031 is a reply to message #459026]

Thu, 03 June 2010 02:03

sinida1984
Messages: 83
Registered: September 2007
Location: India

Member

hello

can you please try like

SELECT DBMS_lob.getlength("doc_blob")
FROM WU_TEST_TABLE
WHERE id = 1;

Thanks
Sinida

Report message to a moderator

Re: webutil_file_transfer.Client_To_DB_with_progress [message #459619 is a reply to message #459031]

Mon, 07 June 2010 08:22

manish.nankar
Messages: 10
Registered: December 2008

Junior Member

no dear its not working..

can anyone help me...
please its urgent.

Report message to a moderator

Re: webutil_file_transfer.Client_To_DB_with_progress [message #459644 is a reply to message #459619]

Mon, 07 June 2010 11:18

gregor
Messages: 86
Registered: March 2010
Location: Germany

Member

Hi ,
in the moment I cant't look at your PEDBOM.fmb.
But, iF your select "SELECT DBMS_lob.getlength(doc_blob) FROM WU_TEST_TABLE WHERE id = 1;" returns NULL, your doc_blob-column is empty. - Pease check your upload procedure.

Gregor

Report message to a moderator

Re: webutil_file_transfer.Client_To_DB_with_progress [message #463904 is a reply to message #459644]

Mon, 05 July 2010 02:47

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

Senior Member
Account Moderator

Sorry that I have been so long in replying. Have you solved your problem?

You did do a 'commit' didn't you? Perhaps a 'standard.commit' is needed.

David

Report message to a moderator

Previous Topic:	navigating using images
Next Topic:	How to Send mail with Attachment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:00:30 CDT 2024