I have a sql quiery (with joins and all) which has 25000 characters. I am unable to paste it all in sqlplus (may b because sqlplus doesnt allow more than 'some' characters).
I saved the sqlquery as .sql and when i ran, got the following error:
Code:
SQL> @oracle.sql;
Input truncated to 7499 characters
SP2-0027: Input is too long (> 2499 characters) - line ignored
Input truncated to 7499 characters
SP2-0027: Input is too long (> 2499 characters) - line ignored
Input truncated to 7499 characters
SP2-0027: Input is too long (> 2499 characters) - line ignored
SP2-0734: unknown command beginning "FT JOIN MI..." - rest of line ignored.
SQL>
kindly help me on how can i run this sql.