阅读背景:

ORA-22905 - 使用select语句查询表类型时

来源:互联网 
 DECLARE
 TYPE record_AB IS RECORD
   (
      AA              VARCHAR2 (16 BYTE),
      BB    VARCHAR2 (16 BYTE)
   );

  TYPE type_tab_AB IS TABLE OF record_AB
                        INDEX BY BINARY_INTEGER;

  tab_AB   type_tab_AB;

  BEGIN
   SELECT *
    BULK COLLECT INTO tab_AB FROM...
    ..
    SELECT * FROM TABLE (tab_AB) ;
 DECLARE
 TYPE record_AB IS RECORD
   (
      A



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: