ORA-01788: CONNECT BY clause required in this query block
Oracle9i 的某些Object (比如VIEW)轉移到10g後會有一些報錯現象 。如下
錯誤內容:
ORA-01788: 此查詢塊中要求 CONNECT BY 子句
說明: 執行當前 Web 請求期間,出現未處理的異常。請檢查堆疊跟蹤資訊,以瞭解有關該錯誤以及程式碼中導致錯誤的出處的詳細資訊。
異常詳細資訊: System.Data.OracleClient.OracleException: ORA-01788: 此查詢塊中要求 CONNECT BY 子句
源錯誤:
執行當前 Web 請求期間生成了未處理的異常。可以使用下面的異常堆疊跟蹤資訊確定有關異常原因和發生位置的資訊。
堆疊跟蹤:
[OracleException (0x80131938): ORA-01788: 此查詢塊中要求 CONNECT BY 子句
]
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
解決方法:
用dba身份執行以下語句:
alter system set "_allow_level_without_connect_by"=true scope=both
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-617620/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01788: CONNECT BY clause required in this query block For ORACLE 10GUIBloCOracle 10g
- 關於查詢塊query blockBloC
- Oracle - ORA-01789: Query block has incorrect number of result columnsOracleBloC
- Oracle Model ClauseOracle
- About Oracle WITH clauseOracle
- ANALYZE INDEX clauseIndex
- Oracle SQL Model ClauseOracleSQL
- [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 的問題 MySQLExpressAIMySql
- [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated cExpressAI
- ALTER SESSION ADVISE ClauseSession
- ALTER SYSTEM DISCONNECT SESSION ClauseSession
- mysql主給備賦予許可權時報錯,MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clauseMySqlExpress
- phpmysqlimysqli_query()mysqli_real_query()PHPMySql
- UNRECOVERABLE DATAFILE clause in the ALTER DATABASE CLEAR LOGFILE statementDatabase
- CSS :required 選擇器CSSUI
- Block學習①--block的本質BloC
- Query sqlSQL
- Query DSL
- reg query /?
- You can‘t specify target table ‘Person‘ for update in FROM clause
- oracle block phisical address to block#OracleBloC
- mysql 配置 General Query Log和# Slow Query LogMySql
- 表單required 必需驗證UI
- HTML5 required屬性HTMLUI
- [MONGODB]: WHEN ARBITER REQUIRED FOR REPLICA SETMongoDBUI
- It is indirectly referenced from required .class fileUI
- iOS block巢狀block中weakify的使用iOSBloC巢狀
- Unused Block Compression和Null Block CompressionBloCNull
- 深入理解Block之Block的型別BloC型別
- Block學習②--block的變數捕獲BloC變數
- list is not in GROUP BY clause and contains nonaggre的問題AI
- MS-SQL 錯誤: The offset specified in a OFFSET clause may not be negativeSQL
- MySQL Query CacheMySql
- Parallel query & viewsParallelView
- Export Parameter : QueryExport
- coca SLOW QUERY
- Oracle connect byOracle
- start with ... connect by