把你的function 贴出来看看。
解决方案 »
- Oracle如何使用窗口函数实现这样的查询
- 全文索引的几个问题
- 如何用PL/SQL语言引用JAVA类?
- pl/sql developer中能不能不显示查询结果而将结果导出到excel或文本文件中
- 请教一个存储过程
- Oracle AS 10g HA Solution Workshop中HA是什么意思?
- 还是imp导入问题
- 帮我入门
- Oracle装好后,是否除了system和sys用户外,其它用户都可以删除,比如OUTLN,DBSNMP
- 在TRIGGER中定义一个变量。类型和某个表的字段保持一致。怎么定义?
- 关于更新 如何对 两个表关联后查出的记录的某个表栏位进行更新???
- 字符串与字符串变量的连接问题,谢谢!
把那条SQL单独执行是只返回一条个记录啊
ORA-01422
因为我只能远程操作这个数据库,不能够把内容给COPY下来~
不知道给的这点信息够用不?
Cause: The number specified in exact fetch is less than the rows returned.
Action: Rewrite the query or change number of rows requested.
还是返回太多行
omc_id in neobject.omc_id%TYPE,
object_class neobject.object_class%TYPE)
return objects.int_id%type isResult objects.int_id%type;
temp1 objects.int_id%type;
temp2 objects.int_id%type;begin
SELECT int_id INTO temp1
FROM neobject
WHERE
omc_id = omc_id
AND object_class = object_class; SELECT int_id INTO temp2
FROM objects
WHERE object_class =100
AND omc_id=omc_id;
RESULT := temp1
if temp1 is null then RESULT := temp2;
end if;
return (Result);
end get_value;
是什么?你们在那查到那样的说明呢?
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing the exception or write an exception handler
for this condition. Or you may need to contact your application administrator
or database administrator.你的邮箱,给你发个
FROM neobject
WHERE
omc_id = omc_id
AND object_class = object_class;
SELECT max(int_id) INTO temp2
FROM objects
WHERE object_class =100
AND omc_id=omc_id;