触发器调用:
create or replace trigger SYNCCLIENR_TRG
after insert on T_Synchronization
for each row
declare
begin
exec SYNCCLIENT.SYNC(1233); ---这行出错end SYNCCLIENR_TRG;包头:
create or replace package SYNCCLIENT is procedure sync(newSal number);
end SYNCCLIENT;包体:
create or replace package body SYNCCLIENT as procedure sync(newSal number)
is
seg1 integer;
begin
select cp_id into seg1 from t_sync_client;
end;
end SYNCCLIENT;请高人指点一下哪里问题
create or replace trigger SYNCCLIENR_TRG
after insert on T_Synchronization
for each row
declare
begin
exec SYNCCLIENT.SYNC(1233); ---这行出错end SYNCCLIENR_TRG;包头:
create or replace package SYNCCLIENT is procedure sync(newSal number);
end SYNCCLIENT;包体:
create or replace package body SYNCCLIENT as procedure sync(newSal number)
is
seg1 integer;
begin
select cp_id into seg1 from t_sync_client;
end;
end SYNCCLIENT;请高人指点一下哪里问题
解决方案 »
- 基础查询语句咨询
- 尝试加载 Oracle 客户端库时引发 BadImageFormatException。如果在安装 32 位 Oracle 客户端组件的情况下以 64 位模式运
- 跟踪.net程序中参数有值,但传不入oracle存储过程中
- 这个oracle odbc 安装错误怎么解决?
- 怎样修改ORACLE的internal的密码为其它或者失效?
- ORA-01630: max # extents () reached in temp segment in tablespace?
- 还是字符集不匹配的问题,怎么样才能把它变成一样
- 散分!!!如何定时清空数据库的问题
- 求助sql查询
- Oracle10g db link 访问MySql数据库报错ORA-28545,有没有大神知道怎么解决啊!
- 更改表中一列的数据类型,显示无效的 ALTER TABLE 选项,是什么原因?
- sysdba登录 ORA-01017:用户名密码出错 故障排查实例
exec SYNCCLIENT.SYNC(1233); ---这行出错end SYNCCLIENR_TRG;
语法不对