BLOB and View

[Ura]

I have a view
{
CREATE OR REPLACE VIEW FORMSTEP
AS SELECT D.MENUITEM,D.ITEMLABEL,D.RUNFORM,D.BODYFORM,D.DATAFORM,D.OWNER FROM DEFITEMS D
}
I can't load BLOB into table through this view. D.BODYFORM is BLOB field.
I try it:
OracleDataSet1.Insert;
OracleDataSet1BODYFORM.LoadFromFile('c:\tt.txt');
OracleDataSet1.Post.

Oracle message me: Table or view dosn't exist.
Where I wrong?

 

[Marco Kalter]

Does the user have update privileges on the underlying table that contains the BLOB column? This is a requirement when writing BLOB data.

------------------
Marco Kalter
Allround Automations

 

[Ura]

You are right.