Adding Content to a BLOB : BLOB « Large Objects « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Large Objects
3. BLOB

SQL>
SQL> CREATE TABLE myTable (
  2    id          INTEGER PRIMARY KEY,
  3    blob_column BLOB NOT NULL
  4  );

Table created.

SQL>
SQL> INSERT INTO myTable(id, blob_column) VALUES (1, EMPTY_BLOB());

1 row created.

SQL>
SQL> UPDATE myTable
  2  SET blob_column = 'VVVVV'
  3  WHERE id = 1;
SET blob_column = 'VVVVV'
                  *
ERROR at line 2:
ORA-01465: invalid hex number


SQL>
SQL> SELECT *
  2  FROM myTable;
SP2-0678: Column or attribute type can not be displayed by SQL*Plus
SQL>
SQL> drop table myTable;

Table dropped.

SQL>