Forum Stats

  • 3,768,004 Users
  • 2,252,739 Discussions
  • 7,874,407 Comments

Discussions

URL Encoded SQL length exceeds allowed 32k limit ?

SaQ-Orcl
SaQ-Orcl Member Posts: 84 Blue Ribbon
edited Oct 10, 2017 10:23AM in Database Cloud Service

Hi,

I am trying to create a view in DbaS through the apex, and while hitting the query encountering the error "URL Encoded SQL length exceeds allowed 32k limit ".  After walked through the Oracle document got to know this is a limitation of the apex( We cannot execute query which is exceeding the size 32k)

Any workaround suggestion?

Thanks,

Best Answer

  • SaQ-Orcl
    SaQ-Orcl Member Posts: 84 Blue Ribbon
    edited Oct 10, 2017 10:21AM Accepted Answer

    Here is alternate way to achieve in apex, if query is exceeding size of 32k

    SQL Workshop --> SQL Script

    2> hit on the 'Create' button

    3> Paste the query and named the script

    4> click on Run button

    5> Confirm 

    SaQ-Orcl

Answers

  • SaQ-Orcl
    SaQ-Orcl Member Posts: 84 Blue Ribbon
    edited Oct 10, 2017 10:21AM Accepted Answer

    Here is alternate way to achieve in apex, if query is exceeding size of 32k

    SQL Workshop --> SQL Script

    2> hit on the 'Create' button

    3> Paste the query and named the script

    4> click on Run button

    5> Confirm 

    SaQ-Orcl
  • PallabDutta
    PallabDutta Member Posts: 19 Red Ribbon

    In Autonomous Database APEX, by using the same , still not working for a package body which has 8500 lines.

    SQL Workshop --> SQL Script

    2> hit on the 'Create' button

    3> Paste the query and named the script

    4> click on Run button

    5> Confirm 

    Did we find anything lately?

  • SaQ-Orcl
    SaQ-Orcl Member Posts: 84 Blue Ribbon

    Please try to remove blank spaces/comment/ any thing which is not require from query.

    try to reduce the size of query.

This discussion has been closed.