Error while executing sql query on database

Asked Mar 12 '20 at 08:35

Active Mar 12 '20 at 08:35

Viewed 617 times

I'm trying to read BLOB data from messages table form WhatsApp database called msgstore, I want to get the file names that are transferred. The blob data is stored in thumb_image column.

I found this query here:

SELECT dbms_lob.substr(thumb_image)
FROM messages 
WHERE _id = 3;

I also tried this query from here:

SELECT utl_raw.cast_to_varchar2(dbms_lob.substr(thumb_image)) 
FROM messages  
WHERE _id = '3;

I both cases I keep getting an error thats says:

Error while executing sql query on database 'msgstore': near "(" syntax error.

I don't understand what's wrong with the query. How can I fix this?

asked Mar 12 '20 at 08:35

Keselme

3,779
7
36
68

1

The queries you posted work for Oracle and not SQLite. – forpas Mar 12 '20 at 08:39
@forpas do you know if there's something similar to that that might work in SQLite? – Keselme Mar 12 '20 at 08:43
Use SQLite's substr(): `substr(thumb_image, 1, 100)` – forpas Mar 12 '20 at 08:56

Error while executing sql query on database

0 Answers0