[Zope-DB] retriving file in a bubble field

[Matthew T. Kromer]

Ufficio Ced wrote:

>I have an Oracle database containing word documents in bubble record
>I have created a ZSQL method that retrive the document (3 keys are
>needed to identify the single document)
>If I test the method I can see displayed all the ugly caracters that I
>see if I open the document with an ASCII editor.
>
>If I save the content in a file and I open the file it's OK
>The matter is: how can I create a link that displays "on the fly" the
>document (supposed that the browser is iexplorer and word is
>installed)
>
>I have tried enabling direct transverse
>http://...../The_sql_method/The_parameter_name/The_value
>
>but I have an oracle error
>
>I'm sorry for the length of the question but Im quite new to Zope and
>I still cannot point the problem precisely
>
>Thank you,
>Nicola Mersi
>
>  
>

Is this data in a large object (BLOB?) If so, you probably want to 
create a python script to facilitate access, that way you can:

  - pass the data to the ZSQL method

  - read the data out the LOB object

I forget if ZOracleDA has 'implicit' read support on LOBs.  I may have 
added that; but I think its one of the things that is causing you trouble.

-- 
Matt Kromer
Zope Corporation  http://www.zope.com/