Manage

Reading a binary field in an Oracle database with LotusScript

Use this LotusScript code to read a binary field in an Oracle database, allowing you to find Microsoft Word documents, spreadsheets, PDFs and JPEG files.

Rodrigo Oliveira

Published: 22 Jul 2008

This LotusScript code can be used to read a binary field from an Oracle database. This field can generally contain any type of file, for example:

Related resources from SearchDomino.com:

An introduction to Lotus Enterprise Integrator (LEI)

Top 10 LotusScript tips

LotusScript Reference Center

Microsoft Word documents (.doc)

Excel spreadsheets (.xls)

PDF files (.pdf)

JPEG images (.jpg)

The following code shows how to recover a JPEG image (.jpg file).

(Click on code for enlarged view and script download.)

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Rodrigo Oliveira. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Dig Deeper on LotusScript

Troubleshoot agents by displaying LotusScript variables online If your Web users are triggering agents, you may want to find out what's going on. Apply this LotusScript to display and easily troubleshoot triggered agent variables. Learn all the steps.

LotusScript code pluralizes singular nouns automatically Use this LotusScript code to automatically pluralize a singular English-language noun. One benefit of the code is that Lotus Notes/Domino users will receive an alternative to generic messages like, "You have # something(s)."

LotusScript sorts a Lotus Notes document collection This LotusScript code shows how to sort a Lotus Notes document collection in ascending order using a specified field (text/date/number) as the key. The code is customizable, so you can easily change it to meet your needs.

Programmatically replace the design of Lotus Notes databases Trying to programmatically replace the design of several Lotus Notes databases, but can't find an out-of-the box solution? This LotusScript code can help.

Top 10 LotusScript tips Get our top ten LotusScript tips for Domino developers to update rich-text fields, import data from Excel, view and edit Lotus Notes documents and more.

Create a personalized greeting for Lotus Notes database users Create a personalized note using LotusScript code and a PostOpen event to greet Lotus Notes database users by first name and time of day upon logging on.

SearchWindowsServer

December Patch Tuesday resolves Windows zero-day

Microsoft delivers the final batch of security fixes for the year with a Windows zero-day vulnerability getting top billing for ...

What admins need to know about Azure Stack HCI

Microsoft put its branding on a relatively new hyper-converged infrastructure offering that capitalizes on the software-defined ...

How to manage Exchange hybrid mail flow rules

Duplicating your existing transport rule collection won't work when you move to an Exchange hybrid deployment. Learn how to set ...

Search400

iSeries tutorials

Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

V6R1 upgrade planning checklist

When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

Connecting multiple iSeries systems through DDM

Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

Refresh your data center cooling lexicon

As the data center industry moves to improve energy efficiency, refresh your knowledge on the available cooling technology and ...

Comparing Linux distributions: Red Hat vs. Ubuntu

Before selecting a Linux distribution, compare Red Hat Enterprise Linux and Ubuntu when it comes to features, ease of use, ...

Get eco-friendly with LEED data center certification

The U.S. Green Building Council helps companies make existing and new data centers eco-friendly. HVAC, lighting and monitoring ...

SearchContentManagement

DNA as a content storage device is closer than you think

Storing content in DNA may one day be possible, but today, it's neither practical nor cost-effective. Here's where this ...

Acquia acquisition of AgilOne CDP signals CX platform expansion

Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...

Personalization engines help engage and retain customers

Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...

Reading a binary field in an Oracle database with LotusScript

Use this LotusScript code to read a binary field in an Oracle database, allowing you to find Microsoft Word documents, spreadsheets, PDFs and JPEG files.

Dig Deeper on LotusScript

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

December Patch Tuesday resolves Windows zero-day

What admins need to know about Azure Stack HCI

How to manage Exchange hybrid mail flow rules

Search400

iSeries tutorials

V6R1 upgrade planning checklist

Connecting multiple iSeries systems through DDM

SearchDataCenter

Refresh your data center cooling lexicon

Comparing Linux distributions: Red Hat vs. Ubuntu

Get eco-friendly with LEED data center certification

SearchContentManagement

DNA as a content storage device is closer than you think

Acquia acquisition of AgilOne CDP signals CX platform expansion

Personalization engines help engage and retain customers

Dig Deeper on LotusScript

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.