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
5
votes
3 answers

Mapping a long text string in Oracle and NHibernate

Using NHibernate 3.1 with both SQL Server and Oracle DBs, we need to store a text string that is longer than 4000 characters. The text is actually XML, but that is not important - we just want to treat it as raw text. With SQL Server, this is easy.…
Brian Berns
  • 15,499
  • 2
  • 30
  • 40
5
votes
1 answer

What is difference between empty_clob and createtemporary in Oracle?

Can anyone please tell what is the basic difference between empty_clob and createtemporary. Here is my code. /*empty_clob vs createtemporary()*/ DECLARE elob CLOB; tlob CLOB; BEGIN IF elob IS NULL THEN …
Aman Singh Rajpoot
  • 1,451
  • 6
  • 26
5
votes
3 answers

Obtaining smallest key in a std::map

I need to get the smallest element in a std::map. I'm aware that there is plenty of documentation available; however, I can't seem to get any to work. I have two maps, bid and ask, both of which are properties of the Book class. Each is a map of…
pingwing
  • 61
  • 1
  • 1
  • 4
5
votes
1 answer

Spring MVC + Oracle LOBs + Streaming

I have to send a binary stream of a blob by means of a ServletOutputStream. I'm using the following technologies and software: Oracle 11, WebSphere 7, Springframework 2.5.5, Hibernate 3.3.SP1. There are two Oracle databases. The first one contains…
szhem
  • 4,672
  • 2
  • 18
  • 30
5
votes
1 answer

JDODetachedFieldAccessException: You have just attempted to access field "attachment" yet this field was not detached when you detached the object

Entity class: public class CustomerSurvey implements Serializable { @Id @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="CUSTOMER_SURVEY_SEQUENCE") @Column(name = "SURVEYID", nullable = false) private String…
beetri
  • 1,039
  • 11
  • 24
  • 40
4
votes
3 answers

JPA with Postgres anomalously writes text in @Lob column as a number

I am trying to use a @Lob column with a Java String type to map its content to TEXT inside Postgres. Here is the relevant entity: @Entity(name="metadata") public class Metadata { @Id @GeneratedValue(strategy=GenerationType.IDENTITY) …
Tim Biegeleisen
  • 502,043
  • 27
  • 286
  • 360
4
votes
0 answers

Caused by: org.postgresql.util.PSQLException: ERROR: large object 'some_number' does not exist

We are exporting and importing data from postgres database using the pg tools from one server instance to another server instance: eg: Export : pg_dump.exe --file "my_table.sql" --host %connectionHost% --port "5432" --no-owner --username…
ryaliscs
  • 123
  • 9
4
votes
3 answers

How to fix RuntimeError: deque mutated during iteration in Python

I'm trying to implement market simulation for algorithmic trading and I've found this code on github https://github.com/DrAshBooth/PyLOB. The problem is when I'm running my code for small window, for example, 2 days, everything is fine and I get my…
Mitra
  • 157
  • 2
  • 12
4
votes
2 answers

How to shrink secure file LOBs in Oracle

I noticed today that SQL command that is used to shrink LOBs in oracle does not work in 12c. ALTER TABLE SAMPLE_TABLE MODIFY lob (LOB_COLUMN) (SHRINK SPACE) This returns oracle error ORA-10635: Invalid segment or tablespace type In the oracle…
pragan
  • 143
  • 2
  • 11
4
votes
0 answers

How to map LOB in Hibernate and Postgresql to clean up unused space

If you have lob type @Column(name = "xml") @Lob private String xml; then in PostgreSQL you get column with type text \d tablename Column | Type | Modifiers ----------------+-----------------------------+----------- …
sasha
  • 63
  • 7
3
votes
1 answer

Merge with select with multiple rows

I have a query which every time runs, selects the rows of user_triggers which are related to a table(p_table_name_in). I want to run this procedure every day and I want to just insert new rows, not all rows again. but when I install this oackage , I…
mona shiri
  • 57
  • 8
3
votes
1 answer

SQL Server - Deleting/Updating LOB data in a Heap

I have a SQL Server 2016 database with RCSI enabled that is literally a heap of heaps. With the exception of one table, every other table in the database is a heap and the largest heap is ~200GB which makes up over 50% of the total size of the…
Fza
  • 223
  • 2
  • 5
3
votes
1 answer

Storing a Deep/Nested Structure

SAP rather sensibly prohibits you from including deep structures in database tables. For a new project however I have a deeply nested structure that I want to store persistently. This structure includes another dozen structures with each of those…
Lilienthal
  • 4,327
  • 13
  • 52
  • 88
3
votes
1 answer

dbms_lob.append bug in function or am I doing it wrong

I created following function function lob_replace( p_lob in out clob,p_what in varchar2,p_with in clob ) return clob as l_temp_number number; l_temp_number_1 number; l_temp_clob clob; l_return_clob clob; …
Nuwan Dammika
  • 587
  • 9
  • 20
3
votes
1 answer

How to use require in the browser

I am trying to use RequireJS to use the require() function in the browser. For context, I am trying to work with the Node wrapper for the Lob API: https://github.com/hisankaran/lob-node. Here's the relevant code: define (function (require) { …
Alex Schiff
  • 101
  • 1
  • 7
1
2
3
…
9 10