Question

thinkphp 中使用oracle 可以查询，但是不能插入。同样代码 ，MYSQL就可以

这是日志[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: queryStartTime ThinkPHP.php 第 25 行.[ 2011-03-22T13:00:51 08:00 ] SQL: select a.column_name,data_type,decode(nullable,'Y',0,1) notnull,data_default,decode(a.column_name,b.column_name,1,0) pk from user_tab_columns a,(select column_name from user_constraints c,user_cons_columns col where c.constraint_name=col.constraint_name and c.constraint_type='P'and c.table_name='DEMO') b where table_name='DEMO' and a.column_name=b.column_name( ) [ RunTime:1,300,770,051.637187s ][ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: column_name DbOracle.class.php 第 270 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: column_name DbOracle.class.php 第 271 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: data_type DbOracle.class.php 第 272 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: notnull DbOracle.class.php 第 273 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: data_default DbOracle.class.php 第 274 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: pk DbOracle.class.php 第 275 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: pk DbOracle.class.php 第 276 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: column_name DbOracle.class.php 第 270 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: column_name DbOracle.class.php 第 271 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: data_type DbOracle.class.php 第 272 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: notnull DbOracle.class.php 第 273 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: data_default DbOracle.class.php 第 274 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: pk DbOracle.class.php 第 275 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: pk DbOracle.class.php 第 276 行.[ 2011-03-22T13:00:51 08:00 ] NOTIC: [8] Undefined index: queryStartTime ThinkPHP.php 第 25 行.[ 2011-03-22T13:00:51 08:00 ] SQL: SELECT * FROM (SELECT thinkphp.*, rownum AS numrow FROM (SELECT * FROM demo) thinkphp ) [ RunTime:1,300,770,051.640697s ]

Answer 1

我觉得这两个结合主要得注意一下大小写问题。如果在Tp
里面没有处理的话，必须保证在页面或者TP中保证为大写。因为oracle中字段都是被默认转化成了大写。

Answer 2

关键项没有值，怎么插入呢？