Good stored procedures have been established, at runtime tip: such as text images-CodePudding

 create or replace procedure test_cell is 
V_endid varchar2 (6); V_celname varchar2 (61); V_dl number (4); V_ul number (5); 
CURSOR test_cursor is 
Select 
Lncel. Lncel_enb_id 
, lncel LNCEL_CELL_NAME 
, LNFDD lncel_fdd_earfcn_dl 
, LNFDD lncel_fdd_earfcn_ul 
The from 
C_LTE_LNCEL lncel, 
C_lte_lncel_fdd LNFDD, 
Ctp_common_objects cel, 
Ctp_common_objects FDD 
Where 
Lncel. Obj_gid=cel. Co_gid 
And LNFDD. Obj_gid=FDD. Co_gid 
And FDD. Co_parent_gid=cel. Co_gid 
AND lncel. Conf_id=1 
And LNFDD. Conf_id=1 
And lncel. Lncel_cell_name like 'dianxin WLCB % % %'; 
The begin 
DBMS_OUTPUT. The ENABLE (buffer_size=& gt; Null); 
The open test_cursor; 
Loop 
The fetch test_cursor into V_endid V_celname, V_dl, V_ul; 
Dbms_output. The enable (20000); 
Dbms_output. Put_line (' station number: '| | V_endid | |' village name: '| | V_celname | |' horizontal frequency point: '| | V_dl | |' horizontal frequency point: '| | V_ul); 
end loop; 
End test_cell;

CodePudding user response:

Didn't see pictures of the building Lord ah, forgot to send?

CodePudding user response:

Upload pictures after a connection

CodePudding user response:

Wrote a pga space is not enough,
But it is possible that the SQL itself has a problem linking to write what lead to the wrong,

CodePudding user response:

Is prompt PGA space is not enough, there are about more than 5000 data lines, check some information online is not a solution!