Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number of allowed SQL query characters for Classic Report in APEX

SoofiFeb 6 2015 — edited Feb 9 2015

Hi All,

I am using APEX 4.2.0 with Oracle 12c DB.

When I create a Classic report with SQL Query, my query is partially pasted in the SQL Query Source Text Area.

What I need to know Is there any limitation for number of lines in writing SQL Query.

My Query has 928 Lines with 64768 Characters and 1702 words

I am getting the following error when I try to paste the above Query for my report,

ORA-01461: can bind a LONG value only for insert into a LONG Column


May I know what exactly the above error indicates?

Thanks in advance.

Regards,

Soofi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2015
Added on Feb 6 2015
#apex, #apex-discussions, #report
4 comments
953 views