Question

求助大神，oracle存储过程表达式类型错误:pls 00382

在PL/SQL中执行后，提示这一行错误，open result for ycdata;说表达式类型错误，但是我就是想让返回一个浮点型的值呀
定义包如下：

create or replace package pkg_test
as
type type_cursor is ref cursor;
procedure read_rows (result out type_cursor);
end pkg_test;
包实现：
create or replace package body pkg_test
as
procedure read_rows (result out type_cursor)
is
ycdata float;
begin
ycdata := 'select h0 into ycdata from ycdata201308 where bujianleixingid = 19 and bujianid = 172024 and bujiancanshuid = 4';
open result for ycdata;
end read_rows;
end pkg_test;

Answer 1

ycdata float; // 在此处定义了一个数字类型
begin
ycdata := 'select h0 into ycdata from ycdata201308 where bujianleixingid = 19 and bujianid = 172024 and bujiancanshuid = 4'; // 但是此处给这个变量的值是字符串，这个不行
open result for ycdata;

Answer 2

返回成 number 不行吗？float在oracle比较不合适