查询视图时报错ORA-01730

最新推荐文章于 2024-06-21 11:02:51 发布

长大的小小

最新推荐文章于 2024-06-21 11:02:51 发布

阅读量847

点赞数

分类专栏： Oracle 文章标签： ora-01730 指定的列名数无效

本文链接：https://blog.youkuaiyun.com/qq_39722475/article/details/109364606

版权

Oracle 专栏收录该内容

8 篇文章

订阅专栏

SELECT * FROM vw_pb_user WHERE user_code = ?
在查询视图的时候，出现以下报错：ORA-01730: 指定的列名数无效

Caused by: java.sql.SQLException: ORA-01730: 指定的列名数无效
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:795)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)
	at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328)
	at net.sourceforge.jdbclogger.core.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:201)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
	... 48 more

前段时间，因项目需要，修改了本地数据库服务端的字符集编码，从gbk改为utf8，重建试图后解决。
当然，也可以恢复字符集。