Questions tagged [lob]

Lob refers to a set of web services, APIs, and tools provided by the company of the same name. You can embed direct mail (postcards, letters, checks, etc.) functionality into web and mobile applications with just a few lines of code. There are several helper libraries and resources listed below to make it easy integrate.

Documentation & Resources

Libraries / Language Support

Examples are included in each wrapper and in the API Reference.

143 questions
0
votes
0 answers

How to Convert ORACLELOB object to Image File using C#?

I have an Oracle Database Table where an image is stored in LONG Data Type. I want to retrieve this as an image file(Tiff file). According to my research, LONG data column has to be first converted to LOB object and then into image file. By using…
Raxak
  • 389
  • 3
  • 17
0
votes
0 answers

JPA: Is it possible to perform queries on a byte[] field?

i have a Measure entity with a byte[] field that contains the data of the measure. Data format changes according to public enum Format { BOOLEAN, INT, INT_ARRAY, FLOAT, FLOAT_ARRAY, TEXT } Is it possible to perform queries…
Francesco Rogo
  • 343
  • 3
  • 13
0
votes
1 answer

LOB locators from remote tables

Having exception from oracle while running following query ORA-22992: cannot use LOB locators selected from remote tables SELECT OLU.CNIC, OLU.LR_USER_NAME NAME, OLU.FATHERS_NAME, …
Salman
  • 11
  • 1
  • 4
0
votes
2 answers

How to export IXF and LOB files from dashdb

I need to copy some tables in one dashdb database over to separate dashdb database. Normally I would export the CSV file from one and load it into the other using the Web console, however one table in particular has a CLOB column and so we will need…
jpwsutton
  • 170
  • 3
  • 8
0
votes
1 answer

Reading Blob from postgres using Hibernate Mapping not using Hibernate Annotations

As i am using Hibernate Mapping , how to read the blob from database. I can able to save image in database. But reading the blob field in database creating issues. Can you guide me step by step of reading blob from postgres database without using…
0
votes
1 answer

DB2 AUDIT - LOAD into audit table

I'm trying to audit a specific User and created a audit policy which i assigned to to User. I then archived and extracted the audit data. So far so good. I then used the db2audit.dll to create the tables needed. TABNAME TABSCHEMA --------…
0
votes
1 answer

PL/SQL error while querying BLOBs. "A query with LOB's require OCI8 mode, but OCI7 mode is used"

I have a table where there is a column defined as BLOB. When i try to query the table, i am not able to view anything and a message is displayed saying "A query with LOB's require OCI8 mode, but OCI7 mode is used". I have unchecked the box "Force…
Ram
  • 5
  • 2
0
votes
1 answer

Cannot open file from oracle

I am trying to select bytes from oracle database and convert them to image file. When I wrote the oracle procedure it stops in UTL_FILE.fopen and returns a ORA-29280 error. Oracle community says that this error is caused because OS level user may…
Mlle 116
  • 1,149
  • 4
  • 20
  • 53
0
votes
1 answer

spring data native query interesting bug with Lob column

I have an entity: @Entity public class KnowledgeBase { private Long id; private String link; private String content; @Id @SequenceGenerator(name = "knowledgebase_id_generator", sequenceName = "knowledgebase_id_sequence",…
avalon
  • 2,231
  • 3
  • 24
  • 49
0
votes
0 answers

Oracle 11g: Comparing two *LOB columns of different types

I've got read-only access to a database containing two schema with tables like this: schema1.A.unique_id, schema1.A.content schema2.B.unique_id, schema2.B.content A.unique_id and B.unique_id will match while A.content and B.content are *LOB columns…
dmn
  • 965
  • 3
  • 13
  • 24
0
votes
2 answers

How to create a tablespace only for schema's LOBs in Oracle database

I have a schema S linked to a default tablespace T1 in an Oracle database. I want to create another tablespace T2 only for LOBs linked to the same schema S. Is it possible? How can I do it?
Maghio
  • 355
  • 1
  • 6
  • 18
0
votes
1 answer

Data type 0x23 is a deprecated large object, or LOB, but is marked as output parameter

I'm trying to receive a varchar(max) output param from an stored procedure but I'm getting the error above , i.e Data type 0x23 is a deprecated large object, or LOB, but is marked as output parameter when I execute the SP in vb.net I have tried…
j-j
  • 93
  • 1
  • 13
0
votes
0 answers

Can a backgroundtask be used to update a LOB universal app?

I have a LOB universal app that I want to check for updates from a web service. If there is an update I want to force the app to update. Is there a way to get the app to update itself or to use a BackgroundTask to update the app? This app would only…
jon antoine
  • 396
  • 1
  • 4
  • 16
0
votes
1 answer

Integrating Lob Node API wrapper with MeteorJs - Issue with require('fs')

I'm using Meteor 1.13 (Latest version) and they've added NPM support recently. So I added in the Lob.com NPM. I began to make a letter function and I get this error: Uncaught TypeError: fs.readdirSync is not a function This is what my function…