序列:
CREATE SEQUENCE sequ_arrearage_his INCREMENT BY 1 START WITH 1 MAXVALUE 999999999999;触发器:
CREATE OR REPLACE TRIGGER trigger_arrearage_his BEFORE
UPDATE OR DELETE ON fin_bill_arrearage
FOR EACH ROWBEGIN
insert into his_fin_bill_arrearage(HistoryID, Bill_ID, BillType, SubOrderTable, SubOrder_ID,
SerialNumber, AccountMoney, AccountScale, BalanceMoney, Content,
Re, PassStaff_ID, Staff_id, owner_id, State, Update_date, Create_date)
values(:sequ_arrearage_his.nextval, :old.Bill_ID, :old.BillType, :old.SubOrderTable, :old.SubOrder_ID,
:old.SerialNumber, :old.AccountMoney, :old.AccountScale, :old.BalanceMoney, :old.Content,
:old.Re, :old.PassStaff_ID, :old.Staff_id, :old.owner_id, :old.State, :old.Update_date, :old.Create_date);END;现在序列已创建成功。到创建触发器时,SQL Plus老报错:警告: 创建的触发器带有编译错误。请问是哪里不对啦?顺便问一下,对触发器怎么进行调试?谢啊
CREATE SEQUENCE sequ_arrearage_his INCREMENT BY 1 START WITH 1 MAXVALUE 999999999999;触发器:
CREATE OR REPLACE TRIGGER trigger_arrearage_his BEFORE
UPDATE OR DELETE ON fin_bill_arrearage
FOR EACH ROWBEGIN
insert into his_fin_bill_arrearage(HistoryID, Bill_ID, BillType, SubOrderTable, SubOrder_ID,
SerialNumber, AccountMoney, AccountScale, BalanceMoney, Content,
Re, PassStaff_ID, Staff_id, owner_id, State, Update_date, Create_date)
values(:sequ_arrearage_his.nextval, :old.Bill_ID, :old.BillType, :old.SubOrderTable, :old.SubOrder_ID,
:old.SerialNumber, :old.AccountMoney, :old.AccountScale, :old.BalanceMoney, :old.Content,
:old.Re, :old.PassStaff_ID, :old.Staff_id, :old.owner_id, :old.State, :old.Update_date, :old.Create_date);END;现在序列已创建成功。到创建触发器时,SQL Plus老报错:警告: 创建的触发器带有编译错误。请问是哪里不对啦?顺便问一下,对触发器怎么进行调试?谢啊
解决方案 »
- OracleDBConsoleorcl无法启动 错误997 重叠i/o操作在进行中
- 请问如何获取除DB_NAME以外的ORACLE服务器信息,如IP地址
- 连续的回复不能超过3次.....
- where 1=1 或者 where 1<>1是在什么时候用
- 高分求简单问题>>sqlplus能登陆,但plsql却不能登陆.
- 请教存储过程里,对象的名称是参数则么写法。
- 行归并的问题
- oracle8i有没有桌面版的(在win98中用的)?
- 请教高手:oracle如何导入?(在线等待,解决马上给分)
- 如何列出当前用户下可见的所有表名
- Oracle里如何编写大小写不区分的查询语句?
- 错误号:ORA-06550;如何获取存储过程中游标型TYPE rcsIMPROVE_AIRLINE IS REF CURSOR;的out参数返回的数据集?
:sequ_arrearage_his.nextval应为sequ_arrearage_his.nextval使用pl/sql developer及toad都可以很好的进行调试。
问题解决了,多谢各位啊,谢谢!!!to hrb_qiuyb(大森林) :再问一下,你所说的那几个工具我在oracle的安装目录上没找到,要另外装的吗?哪里有的下啊?谢谢.