存储过程奇怪的问题
各位大虾,我遇到一个奇怪的问题:相同的oracle版本,相同的安装方法,不同的操作系统(win2k和XP),过程如下:
CREATE OR REPLACE PROCEDURE "GET_LOGBOOK_CURRENT_SUB_ENTRY" (index_number in integer)
as
type t_logbook is table of Logbook%ROWTYPE index by binary_integer;
r_logbook t_logbook;
begin
select * into r_logbook(1000) from Logbook where TestIndex = index_number and TotalPeriods = -1 and PeriodCount = (select MAX(PeriodCount) from Logbook where TestIndex = index_number and TotalPeriods = -1);
end;
调用的时候XP下面报:
call Get_Logbook_Main_Entry(101)
*
ERROR 位于第 1 行:
ORA-18008: 无法找到 OUTLN 方案
ORA-06512: 在"PRIMTH.GET_LOGBOOK_MAIN_ENTRY", line 16
ORA-06512: 在"PRIMTH.GET_LOGBOOK_MAIN_ENTRY", line 18
错误,搞不明白,望各位大虾赐教!小弟多谢了!