🚀 go-pugleaf

����һ���ĵ���������ǵ�����ˣ����Ͳ�ƥ�� ��
ORA-22275 invalid LOB locator specified
Cause: There are several causes:
1The LOB locator was never initialized
2The locator is for a BFILE and the routine expects a BLOB/CLOB/NCLOB locato
r
3The locator is for a BLOB/CLOB/NCLOB and the routine expects a BFILE locato
r
4Trying to update the LOB in a trigger body -- LOBs in trigger bodies are re
ad-only
5The locator is for a BFILE/BLOB and the routine expects a CLOB/NCLOB locato
r
6The locator is for a CLOB/NCLOB and the routine expects a BFILE/BLOB locato
r
Action: For (1), initialize the LOB locator by selecting into the locator va
riable or by setting the LOB locator to empty. For (2),(3), (5), and (6),pas
s the correct type of locator into the routine. For (4), remove the trigger 
body code that updates the LOB value.


�� �� jiddy (�ƶ���) �Ĵ������ᵽ: ��
������������̣����ڴ��ļ�����ݵ�clob��о��˰���»���û�н�չ��������̳��


������Ҳû�á�
�洢������£�
create or replace procedure FileToClob(p_Directory IN VARCHAR2,p_FileName IN 
V

ARCHAR2,p_AccNum IN varchar2) is
  v_FileLocator BFILE;
  v_CLOBLocator CLOB;
begin
   SELECT sequence    --�����У�ֱ����exception!
    INTO v_CLOBLocator
    FROM jiao.seq_info
    where accession_id = p_AccNum
    FOR UPDATE;   
   -- Initialize the BFILE locator for reading.
    v_FileLocator := BFILENAME(p_Directory, p_FileName);
    DBMS_LOB.FILEOPEN(v_FileLocator, DBMS_LOB.FILE_READONLY);

    DBMS_LOB.LOADFROMFILE(v_CLOBLocator, v_FileLocator,DBMS_LOB.GETLENGTH(v_F
i

leLocator));
   
   DBMS_LOB.FILECLOSE(v_FileLocator);
   
EXCEPTION
  when no_data_found then 
    DBMS_LOB.FILECLOSE(v_FileLocator);
  when too_many_rows then 
    DBMS_LOB.FILECLOSE(v_FileLocator);

  WHEN OTHERS THEN
    DBMS_LOB.FILECLOSE(v_FileLocator);
    
    RAISE;

end FileToClob;

���ٳ��򣬷���ִ�е�select sequence�����ֱ����no data found��exception��
��

Ȼ�󱨴�˵��ORA-06502:PL/SQL:���ֻ�ֵ����invalid LOB locator specified:ORA-
2

2275��
˭�ܰ���ң���ָ�л��
ϣ�����qq��ϵ��12826075


--



--
�� ��Դ:������δ��վ bbs.pku.edu.cn��[FROM: 61.149.135.209]