oracle中是否存在阻止clob数据交换clob数据的限制？

Question

procedure save_assessment1(
pClientID  IN number, 
pQuestionaire     IN clob,
pAnswers          IN clob, 
pClientID_res     OUT number,
pQuestionaire_res OUT clob,
pAnswers_res      OUT clob) is
begin 
      pClientID_res := pClientID;
      pQuestionaire_res := pQuestionaire;
      pAnswers_res  := pAnswers;
end save_assessment1;

我正在尝试获取输入clob(Json)并输出相同的内容，即clob(json)，但它返回空值

Answer 1

你的手术过程看起来很好(在我看来也很好)。

SQL> create or replace
  2  procedure save_assessment1(
  3    pClientID  IN number,
  4    pQuestionaire     IN clob,
  5    pAnswers          IN clob,
  6    pClientID_res     OUT number,
  7    pQuestionaire_res OUT clob,
  8    pAnswers_res      OUT clob) is
  9  begin
 10        pClientID_res := pClientID;
 11        pQuestionaire_res := pQuestionaire;
 12        pAnswers_res  := pAnswers;
 13  end save_assessment1;
 14  /

Procedure created.

SQL>
SQL> variable x1 clob
SQL> variable x2 clob
SQL> variable n number
SQL>
SQL> begin
  2    save_assessment1(
  3    pClientID=>1,
  4    pQuestionaire=>'some input',
  5    pAnswers=>'some answers',
  6    pClientID_res=>:n,
  7    pQuestionaire_res=>:x1,
  8    pAnswers_res=>:x2
  9    );
 10  end;
 11  /

PL/SQL procedure successfully completed.

SQL> print n

         N
----------
         1

SQL> print x1

X1
-----------------------------------------------------
some input

SQL> print x2

X2
-----------------------------------------------------
some answers