我的数据库是oracle9,请问高手:我下面的创建过程参数(aab)就是传不进去怎么搞啊
CREATE OR REPLACE PROCEDURE "GXCA"."UPDATE_JS" (aab in
varchar2,S in varchar2) is
begin
execute immediate 'CREATE GLOBAL TEMPORARY TABLE grjbqk_jstemp (
AAB001 VARCHAR2(8),
AAC001 VARCHAR2(10),
KH VARCHAR2(10),
AAC002 VARCHAR2(18),
AAC003 VARCHAR2(10),
AAC004 VARCHAR2(4),
JBGZ NUMBER(8, 2)
) ON COMMIT delete ROWS';
execute immediate function using v_param;
v_sql='insert into grjbqk_jstemp(AAB001,AAC001,KH,AAC003,AAC002,AAC004,JBGZ) select AAB001,AAC001,KH,AAC003,AAC002,AAC004,JBGZ from grjbqk where substr(aac050,0,1)=1 and trim(aab001)=:aab';
execute immediate v_sql using aab;
v_sql='insert into jsdata( AAB001,AAC001,KH,AAC003,AAC002,AAC004,JBGZ ) select AAB001,AAC001,KH,AAC003,AAC002,AAC004,JBGZ from grjbqk_jstemp where trim(aac001) not in(select trim(aac001) from jsdata where trim(aab001)=:aab) and trim(aab001)=:aab';
execute immediate v_sql using aab,aab;
execute immediate 'drop table grjbqk_jstemp';
commit;
end UPDATE_JS;上面的在数据库控制台里面编译出错呢。出错意思就是不可以:aab(这是我的变量)
我想问问我到底怎么传送参数进来呢。我的参数是aab。急
CREATE OR REPLACE PROCEDURE "GXCA"."UPDATE_JS" (aab in
varchar2,S in varchar2) is
begin
execute immediate 'CREATE GLOBAL TEMPORARY TABLE grjbqk_jstemp (
AAB001 VARCHAR2(8),
AAC001 VARCHAR2(10),
KH VARCHAR2(10),
AAC002 VARCHAR2(18),
AAC003 VARCHAR2(10),
AAC004 VARCHAR2(4),
JBGZ NUMBER(8, 2)
) ON COMMIT delete ROWS';
execute immediate function using v_param;
v_sql='insert into grjbqk_jstemp(AAB001,AAC001,KH,AAC003,AAC002,AAC004,JBGZ) select AAB001,AAC001,KH,AAC003,AAC002,AAC004,JBGZ from grjbqk where substr(aac050,0,1)=1 and trim(aab001)=:aab';
execute immediate v_sql using aab;
v_sql='insert into jsdata( AAB001,AAC001,KH,AAC003,AAC002,AAC004,JBGZ ) select AAB001,AAC001,KH,AAC003,AAC002,AAC004,JBGZ from grjbqk_jstemp where trim(aac001) not in(select trim(aac001) from jsdata where trim(aab001)=:aab) and trim(aab001)=:aab';
execute immediate v_sql using aab,aab;
execute immediate 'drop table grjbqk_jstemp';
commit;
end UPDATE_JS;上面的在数据库控制台里面编译出错呢。出错意思就是不可以:aab(这是我的变量)
我想问问我到底怎么传送参数进来呢。我的参数是aab。急
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货