in oracle store procedure the select statements like "select col from table where ..." are not allowed.
you should be including in "into" like this:
"select col into v_clo from table where ..."look into some pl/sql reference book.
you should be including in "into" like this:
"select col into v_clo from table where ..."look into some pl/sql reference book.
如果要查多条记录,那就要用游标