ORA-00984 column not allowed here
Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.
Action: Check the syntax of the statement and use column names only where appropriate.
Insert 语句有问题,再检查一下写成
insert into T_WordMode (ModeName,Dept,ModeText)
values (strModeName,strDept,empty_blob())
行不行
Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.
Action: Check the syntax of the statement and use column names only where appropriate.
Insert 语句有问题,再检查一下写成
insert into T_WordMode (ModeName,Dept,ModeText)
values (strModeName,strDept,empty_blob())
行不行
似乎是这样,
insert into T_WordMode (ModeName,Dept,ModeText)
values ('''+strModeName+''','''+strDept+''',empty_blob())
不过,如果其中有个变量是数值开型,我不知道怎么办,好象是一个单引号,
又好象是两个单引号!真难搞!
sql.Add('insert into T_WordMode values('''+strModeName+''','''+strDept+''',empty_blob())');
sql.Add('select ModeName,Dept,dbms_lob.substr(ModeTextfromT_WordMode) ModeTextfromT_WordMode');
sql.add('where ModeName='''+strModeName+''' and Dept='''+strDept+'''');