ORACLE如何取出LONG类型字段前10个字符:
declare
locator_var LONG;
amount_var integer;
offset_var integer;
output_var varchar2(10);
begin
amount_var :=10;
offset_var := 1;
select TAGSERIESVALUES into locator_var from V_SERIES WHERE SERIESINSTANCEID=1000000000;
DBMS_LOB.read(locator_var,10,1,output_var);
DBMS_OUTPUT.PUT_LINE(locator_var);
End;
/
报 调用 'READ' 时参数数量或类型错误
怎么回事
declare
locator_var LONG;
amount_var integer;
offset_var integer;
output_var varchar2(10);
begin
amount_var :=10;
offset_var := 1;
select TAGSERIESVALUES into locator_var from V_SERIES WHERE SERIESINSTANCEID=1000000000;
DBMS_LOB.read(locator_var,10,1,output_var);
DBMS_OUTPUT.PUT_LINE(locator_var);
End;
/
报 调用 'READ' 时参数数量或类型错误
怎么回事
(ID number,
longdata long
)insert into test select 1,lpad('B',6000,'B') from dual;declare
lon long;
str1 varchar2(20);
begin
select longdata into lon from test where id=1;
str1:=substr(lon,1,10);
dbms_output.put_line(sql1);
end;