Oracle預存程序根據傳入參數查詢

標籤：style   io   os   ar   strong   sp   資料   on   問題   

Oracle預存程序中根據傳入參數查詢時無效

環境:Oracle11g

需求:根據傳入的參數作為條件,查詢相關資料

問題:條件無效

代碼:

create or replace procedure XXX(associatedId in varchar,typeinfoid in varchar)

as

sheetcontent clob;

begin

select wm_concat(t.datasource) into sheetcontent from xly_associatedorder t

    where t.associatedid = associatedId and t.typeinfoid = typeinfoid;

  end XXX;

解決辦法:

create or replace procedure XXX (associatedId in varchar,typeinfoid in varchar)

as

sheetcontent clob;

p1 varchar(50);

p2 varchar(50);

begin

  p1:=associatedId;

  p2:=typeinfoid;

select wm_concat(t.datasource) into sheetcontent from xly_associatedorder t

    where t.associatedid =p1 and t.typeinfoid =p2;

  end XXX;

Oracle預存程序根據傳入參數查詢