Stack Overflow
Stack Overflow

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

Using LOB data in PHP with PDO instead of OCI_Connect

I was using OCI_Connect to connect to my Oracle database. Because of some internal plicies, i need to change it to PDO. With OCI_Connect, i can read LOB data from database with "->load()" function in the result, something like this: $this->Conn =…
Andre Duarte
  • 51
  • 1
  • 5
0
votes
0 answers

Oracle Lob Operation FILEOPEN Failed I/O Error

I have an issues where my DBMS_LOB open operation which falls over where by I receive the following error message. I have double checked the file exists, that the permission on the file are open to everyone one on the destination server, the…
Tricky9132
  • 29
  • 7
0
votes
1 answer

SSIS can't convert lob fields to varchar

We've had some success with removing lob fields and avoiding row-by-row processing but with hadoop we can't seem to get around this. In some cases, the fields in question are less than 10 characters yet ssis sees them as lobs. is this an issue…
markinro
  • 21
  • 4
0
votes
0 answers

Length of LOB data to be replicated exceeds configured maximum

I'm getting the error shown in the screenshot when I try to insert a text with length 90166 in the production database. The issue is that I'm only getting this error from a specific database in the production database. When I run the same insert…
Lloyd95
  • 73
  • 7
0
votes
0 answers

get CLOB and BLOB from remote Tables

I have two problems at the moment. 1- ORA-22992: cannot use LOB locators selected from remote tables Here is the script I am running: CREATE OR REPLACE PROCEDURE merge_test(year in NUMBER) IS BEGIN MERGE INTO SID_TEST SD USING( SELECT…
Belemnogo
  • 33
  • 1
  • 4
0
votes
2 answers

Hibernate lazy loading LOBs. How to unload processed objects to stop memory consuming?

Please somebody help me with a memory issue while processing records with LOBs! So I have the following situation: I have two tables, and one of them is a table with some data. One of the columns of the table has "one-to-many" mapping to the second…
Rome Novikow
  • 11
  • 1
0
votes
2 answers

org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode Error with JBPM 4.4

We are using Jbpm 4.4 as our 3rd party Business Process Management tool with Java 6.x. However So far we used it with Oracle DB and it worked well, but now we want to run it with PostgreSQL 12.x version DB. So we integrated…
Chalitha Jayanath
  • 1
  • 1
0
votes
1 answer

How to reuse temporary lob in oracle

I am having one program in Oracle PL/SQL.The program does some batch processing ie. it sends data to another system through REST API in batches of fixed number of records. the request and response object are clob and hence i am creating temporary…
dhananjay sharma
  • 9
  • 1
0
votes
1 answer

Help with Video Upload with MySQL and PHP

I'm writing some PHP that will interact with MySQL to 1. upload and 2. display a Quicktime .mov file. I have done similar things with image formats quite easily, but this one is giving me some issues. The upload is working in the sense that data is…
codedude
  • 3
  • 2
0
votes
1 answer

Does PostgreSQL use pg_largeobject table internally?

I want to clean all large objects created by users and I'm using the following script: SELECT lo_unlink(l.loid) FROM pg_largeobject l Is it safe operation? Does postgresql use large objects for it's internal use? Thanks.
alexlys
  • 49
  • 5
0
votes
1 answer

Read/write large object from postgres using pqxx

The main pqxx API works with columns as text. So how to access binary data from large objects (LOB) using the pqxx library?
loshad vtapkah
  • 429
  • 4
  • 11
0
votes
2 answers

JPA repository findBySOMETHING, could not extract result

I'm using JPA repository for some toy project, I want to get List of object SOMETHING, but result is could not extract ResultSet; SQL[n/a]. This is my object (nothing is important, just focus on lob plz) { ... private Long id @Lob …
JKLee
  • 89
  • 9
0
votes
1 answer

Windows dev account cannot as LOB publisher ID

My customer add my windows account(xxx@yyy.com) as their LOB publisher. But they are receiving the below error message while adding my account. my userType is Member and no other Roles and other permission. Which type of account address do I need to…
Finder
  • 8,259
  • 8
  • 39
  • 54
0
votes
0 answers

How to store and display image from Database using Servlet and EJB?

Can't find out how to add a profile picture to client when regstration in data base in web application using JSP, Registration Servlet and Entity Manager JPA for Mysql. For now I did this: Registration Servlet final String username =…
K.mady
  • 13
  • 6
0
votes
1 answer

UWP application - Publish the same app in LOB and public Windows store account

I am developing UWP application.I want to publish the application as LOB application in one of my client's enterprise account. I have few questions: Will it possible to publish the same application on the windows with different package name for…
Finder
  • 8,259
  • 8
  • 39
  • 54
1 2 3
…
9 10