long sql query

[erajraj]

Hi all,

i have some sql query which is more than 316 char now the problem is when i try to run this command in oracle sqlplus then it gives me below error:

SP2-0734: unknown command beginning "ERATION li..." - rest of line ignored.

the command is correct i can run same command by using some file .

i think sqlplus is not able to read all character of this command.

so even i set set linesize 200 also but all are vain

so if any one have any information then plz help me.

Many thanks in advance.

[debasisdas]

kindly psot your code here for reference of our experts.

[EVH316]

what if write your query in a sql script then execute it in SQL*Plus. Use DBMS_OUTPUT to display the results of your query. I hope this help

[r035198x]

Surely you don't expect us to help when we haven't seen the code that gave the error.