SQL & PL/SQL

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!

error SP2-0027 while using explain plan

eporcherOct 9 2001 — edited Jun 27 2011

I'm using explain paln command in order to get the tables
acceeded by a SQL query.

When I use the command with some of them, that's OK.
But when I use it with a query of 4999 characters, it gives me
this error message:
SP2-0027: Input is too long (> 2499 characters) - line ignored

Has anybody an idea to solve this problem or to change this
limit of 2499?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2011

Added on Oct 9 2001

2 comments

726 views