Oracle 9i contains the Connect by clause query error and solution after porting to Oracle 10g

From:

Http://cache.baidu.com/c? M = Response & p = Response & newp = Response & user = baidu & fm = SC & query = java % 2 Esql % 2 ESQLException % 3A + ORA % 2D01788% 3A + % B4 % CB % B2 % E9 % D1 % AF % BF % E9 % D6 % D0 % D2 % AA % C7 % F3 + CONNECT + BY + % D7 % D3 % BE % E4 & qid = c7e8c3cf05836eb1 & p1 = 2

Error Message:

ORA-01788:The connect by clause is required in this query block.

Description:An error occurred while executing the current Web request. Check the stack trace information for details about the error and the source of the error in the code.

Exception details:System.Data.OracleClient.OracleException: ORA-01788:The connect by clause is required in this query block.

Source Error:

An unhandled exception is generated during the execution of the current Web request. You can use the following exception stack trace information to determine the cause and location of the exception.

Stack Tracing:

[OracleException (0x80131938): ORA-01788:The connect by clause is required in this query block.
]
System.Data.OracleClient.OracleConnection.CheckError (OciErrorHandle errorHandle, Int32 rc) + 203
System.Data.OracleClient.OracleCommand.Execute (OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor & rowidDescriptor, ArrayList & resultParameterOrdinals) + 1018
System.Data.OracleClient.OracleCommand.Execute (OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList & resultParameterOrdinals) + 25

Solution:

Run the following statement as a dba::

Alter system set "_ allow_level_without_connect_by" = true scope = both