none
ORA-32036: unsupported case for inlining of query name in WITH clause ORA-06512: at RRS feed

  • 问题

  • 在程序中调用ORACLE存储过程,存储过程关键语句示例如下:

    with a as (SELECT * FROM U),B AS (SELECT * FROM C)

    SELECT * FROM A,B

    在ORACLE测试是成功的,但是用程序调用就出现以下错误:

    ORA-32036: unsupported case for inlining of query name in WITH clause
    ORA-06512: at "XXX", line 6
    ORA-06512: at line 1

    如果用WITH 一个临时表,就不会报错,如果是多个就会报此错,该问题要怎么解决

    2015年1月26日 2:56

答案

  • Hello,

    有关Oracle的数据库错误,我建议你到Oracle数据库官方论坛去问:

    https://community.oracle.com/welcome

    其实如果你用搜索引擎来搜这个错误,你应该可以发现很多类似的问题,比如在Oracle官方论坛就有对这个问题的讨论了:

    https://community.oracle.com/thread/1059498

    Regards.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    2015年1月27日 1:54
    版主