ORA-00936: 缺少表达式。一直报这个错,快疯了!

public DataSet Exchange(DateTime date1, DateTime date2)
{
string connString = ConfigurationManager.ConnectionStrings["connString"].ToString();
using(OleDbConnection conn = new OleDbConnection(connString))
{
conn.Open();
string select = "SELECT E.RQ 日期,C.XM 医生姓名,E.ID 医生工号,E.YZJE 西药总金额,E.ZZJE 中成药总金额,E.CZJE 草药总金额 FROM YSCFJE_TEST E,ZGXX C WHERE E.ID=C.ID AND (E.RQ BETWEEN @date1 AND @date2) ORDER BY E.RQ";
OleDbCommand cmd2 = new OleDbCommand(select,conn);
cmd2.Parameters.Add("@date1", OleDbType.Date);
cmd2.Parameters.Add("@date2", OleDbType.Date);
cmd2.Parameters["@date1"].Value = date1;
cmd2.Parameters["@date2"].Value = date2;
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd2;
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}
连接字符串写在配置文件里了,是没有问题的。大神们帮我看看到底哪儿错了,万分感激。

2个回答

问题解决了。
最后才发现我用的是Oracle数据库,参数前应该加:才对,@好像是sql server...
哇 我是真的菜。。。

看样子 SQL系列的数据库
字段别名 试试 单引号 或 双引号 包起来。

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
ORA-00936: 缺少表达式 求大神解答

![图片说明](https://img-ask.csdn.net/upload/201811/13/1542096076_204573.jpg) <insert id="insertOne" parameterType="java.util.List"> INSERT INTO MESSAGE (APPROVAL_NUMBER,HEADLINE,APPROVAL_STATUS,APPROVAL_RESULT,JOB_NUMBER,OVER_USERID <!-- ,APPROVAL_BETIME,APPROVAL_FITIME --> <!-- OVER_NAME,OVER_DEPT,APPROVER,APPROVAL_RECORD,CONDUCTOR, --> <!-- TIME_CONSUMING --> <!-- ,BEGIN_TIME,FINISH_TIME , --> <!-- DURATION --> ) SELECT majorKey.NEXTVAL MESSAGE_ID, A.* FROM( <foreach collection="list" item="item" index="index" separator="UNION ALL"> SELECT #{item.approvalNumber,jdbcType=VARCHAR} APPROVAL_NUMBER,#{item.headline,jdbcType=VARCHAR} HEADLINE,#{item.approvalStatus,jdbcType=VARCHAR} APPROVAL_STATUS,#{item.approvalResult,jdbcType=VARCHAR} APPROVAL_RESULT,#{item.jobNumber,jdbcType=VARCHAR} JOB_NUMBER,#{item.overUserid,jdbcType=VARCHAR} OVER_USERID, <!-- #{item.approvalBetime,jdbcType=VARCHAR} APPROVAL_BETIME, --> <!-- #{item.approvalFitime,jdbcType=VARCHAR} APPROVAL_FITIME, --> <!-- #{item.overName,jdbcType=VARCHAR} OVER_NAME, --> <!-- #{item.overDept,jdbcType=VARCHAR} OVER_DEPT, --> <!-- #{item.approvalr,jdbcType=VARCHAR} APPROVER, --> <!-- #{item.approvalRecord,jdbcType=VARCHAR} APPROVAL_RECORD, --> <!-- #{item.conductor,jdbcType=VARCHAR} CONDUCTOR, --> <!-- #{item.timeConsuming,jdbcType=VARCHAR} TIME_CONSUMING, --> <!-- #{item.beginTime,jdbcType=VARCHAR} BEGIN_TIME, --> <!-- #{item.finishTime,jdbcType=VARCHAR} FINISH_TIME, --> <!-- #{item.duration,jdbcType=VARCHAR} DURATION, --> <!-- #{item.overCause,jdbcType=VARCHAR} OVER_CAUSE --> FROM dual </foreach>

java.sql.SQLException: ORA-00936: 缺失表达式

sql语句可以在sqlserver运行,但在mybatis中报错。有碰到这种情况的大神吗? ![图片说明](https://img-ask.csdn.net/upload/201711/02/1509621626_473198.png) ![图片说明](https://img-ask.csdn.net/upload/201711/02/1509621644_171619.png) mybatis文件 <select id="findByTemperature" parameterType="Map" resultType="Map"> SELECT ROUND(AVG(${id}),2) e,CONVERT(date,time,110) time FROM( SELECT top 100 percent ${id} ,time FROM dcurrent WHERE time &lt;= CONVERT(date,time-14,110) ORDER BY time )s group by CONVERT(date,s.time,110) order by CONVERT(date,s.time,110) </select>

老是提示ORA-00936: 缺失表达式,找不出问题,麻烦各位大神给看看

select t1.name,ROUND(NVL(t2.SCORE,0),2) SCORE from( select * from sys_area_b where parent_id='440100000000') t1 left join ( select u.addvcd_area,avg(a.score)+60 SCORE from USER_SCORE_B_187 a left join sys_user_b u on u.id=a.user_id where u.river_type in(${riverType}) <![CDATA[and to_date(to_char(a.create_Date,'yyyy-mm-dd'),'yyyy-mm-dd') >= to_date(#{strTm},'YYYY-MM-DD') and to_date(to_char(a.create_Date,'yyyy-mm-dd'),'yyyy-mm-dd') < to_date(#{endTm},'YYYY-MM-DD') ]]> and a.user_id in ( select a.id from sys_user_b a left join rm_riverchief_section_r section on section.user_id=a.id left join rm_river_lake lake on lake.id=section.river_section_id where section.del_flags='0' and a.del_flag='0' and a.IS_RIVERCHIEF='Y' <if test='isHeiChou=="0"'> and lake.IS_HC152 is not null </if> <if test='isHeiChou=="1"'> and lake.IS_HC35 is not null </if> ) group by u.addvcd_area )t2 on t1.id=t2.addvcd_area order by ROUND(NVL(t2.SCORE,0),2) desc

PB 调用这个数据窗口,报select error:ORA-00936:缺乏表达式

SELECT "L_HYXM"."HYID", "L_HYXM"."HYXM", "L_HYXM"."KSDM", "L_HYXM"."DJ", "L_HYXM"."SYXM", "L_HYXM"."SL", "L_HYXM"."YLXH", "L_HYXM"."SRM1", "L_HYXM"."SRM2", "L_HYXM"."SRM3", "L_HYXM"."INUREDATE", "L_HYXM"."OPERATOR", "L_HYXM"."FLAG", "L_HYXM"."NOTE", "L_HYXM"."DEFRESULT", "L_HYXM"."EMERGENCY", "L_HYXM"."SFXM", "L_HYXM"."XMDH", "L_HYXM"."XMXH", "L_HYXM"."YBLX", "L_HYXM"."BGSJ_DD", "L_HYXM"."DJSJ_DD", "L_HYXM"."USEDNOW", "L_HYXM"."XMLBA", "L_HYXM"."XMLBB", "L_HYXM"."SJXMLB", "L_HYXM"."JBLB", "L_HYXM"."LCYY", "L_HYXM"."FHLX", "L_HYXM"."BQLX", "L_HYXM"."GBXM", "L_HYXM"."STBH", "L_HYXM"."FYMC", "L_HYXM"."ZHPB", "L_HYXM"."HISLB", "L_HYXM"."BBFS", "L_HYXM"."USENOW", "L_HYXM"."SHOW_GZ", "L_HYXM"."SHOW_BG", "L_HYXM"."ZHLB", "L_HYXM"."XZKS", "L_HYXM"."XZLB", "L_HYXM"."QTZH", "L_HYXM"."TQBJSJ", "L_HYXM"."NEEDYY", "L_HYXM"."JJRXM", "L_HYXM"."HYXMBM", "L_HYXM"."LCCSTYPE", "L_HYXM"."ISCFKD", "L_HYXM"."CSTC", "L_HYXM"."CSSM", "L_HYXM"."SQKD" FROM "L_HYXM", "L_TESTDESCRIBE" WHERE "L_TESTDESCRIBE"."TESTID" IN (:ar_testid) AND "L_HYXM"."USENOW" = 1 AND "L_HYXM"."YLXH" = "L_TESTDESCRIBE"."YLXH" AND "L_HYXM"."YLXH" > 0 AND ("L_HYXM"."ZHPB" = 0 OR "L_HYXM"."ZHPB" IS NULL)

本地oracle每次登录都报错(ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exit)

本地oracle数据库每次登录都会报错(ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exit 每次使用oracle数据库时,服务启动了,每次都报错(ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exit) 每次想要成功连接数据库,都要如下这样做,才能连接oracle数据库 ![图片说明](https://img-ask.csdn.net/upload/201905/29/1559109795_489782.png) ![图片说明](https://img-ask.csdn.net/upload/201905/29/1559109804_668698.png) ![图片说明](https://img-ask.csdn.net/upload/201905/29/1559109816_614784.png) ![图片说明](https://img-ask.csdn.net/upload/201905/29/1559109829_333291.png) 不知道谁有什么彻底的方法解决这个问题?不吝赐教

java.sql.SQLSyntaxErrorException: ORA-00936: 式がありません。

![图片说明](https://img-ask.csdn.net/upload/201910/16/1571206388_198584.png) ## 求助各位大佬们。这个东西我库里是有的,报错找不到怎么办? ![图片说明](https://img-ask.csdn.net/upload/201910/16/1571206187_840615.png)

Oracle Rman错误 ORA-17629:/ORA-17627:/ ORA-01017:

两边oracle是同版本11.2.0的,但平台一个是redhat 一个window。 [oracle@testdb ~]$ rman target sys/root@orcl auxiliary sys/oracle@ORCL2 Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 28 14:52:32 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1451001194) connected to auxiliary database: ORCL (not mounted) RMAN> duplicate target database for standby from active database; Starting Duplicate Db at 28-OCT-16 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=193 device type=DISK contents of Memory Script: { backup as copy reuse targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format 'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ; } executing Memory Script Starting backup at 28-OCT-16 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=191 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 10/28/2016 14:56:00 RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 14:56:00 ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-01017: invalid username/password; logon denied ORA-17629: Cannot connect to the remote database server RMAN> duplicate target database for standby from active database; Starting Duplicate Db at 28-OCT-16 using channel ORA_AUX_DISK_1 contents of Memory Script: { backup as copy reuse targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format 'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ; } executing Memory Script Starting backup at 28-OCT-16 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 10/28/2016 15:05:13 RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 15:05:13 ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-01017: invalid username/password; logon denied ORA-17629: Cannot connect to the remote database server

mysql ORA-00979: 不是 GROUP BY 表达式

-- 学生表 CREATE TABLE XS ( XSDM NUMBER(10) PRIMARY KEY, XSMC VARCHAR(30) ); -- 成绩表 CREATE TABLE CJ ( XSDM NUMBER(10), --学生代码 XKDM NUMBER(10), --学科代码 CJ NUMBER(3)--成绩 ); 语句: SELECT CJ.XSDM, XS.XSMC, sum(CJ.CJ) FROM XS LEFT JOIN CJ ON XS.XSDM = CJ.XSDM GROUP BY CJ.XSDM; 报错:[42000][979] ORA-00979: 不是 GROUP BY 表达式

使用expdp 导出数据库报错ORA-39127: unexpected error from call to export_string

ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.GRANT_EXP(194041,1,...) ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2865 ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 53 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2865 ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 53 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_METADATA", line 10663 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 求教这是什么原因导致的,该如何处理。小白求问 我的导出命令如下 expdp system/password@crmcadb4_229 directory=dump_dir dumpfile=${today}_full_crmcadb4_229.dm logfile=${today}_full_crmcadb4_229.log full=y buffer=2048000

ORA-17627: ORA-12577: Message 12577 not found;

**rman target sys/oracle@orcl auxiliary sys/oracle@ORCL2** Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 31 10:09:17 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1451001194) connected to auxiliary database: ORCL (not mounted) **RMAN> duplicate target database for standby from active database;** Starting Duplicate Db at 31-OCT-16 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=131 device type=DISK contents of Memory Script: { backup as copy reuse targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format 'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ; } executing Memory Script Starting backup at 31-OCT-16 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=131 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 10/31/2016 10:09:30 RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/31/2016 10:09:30 ORA-17627: ORA-12577: Message 12577 not found; product=RDBMS; facility=ORA

{"ORA-06550: PLS-00306: 调用 '**' 时 错误 ORA-06550:

{"ORA-06550: 第 1 行, 第 7 列: PLS-00306: 调用 'PROC_GETDATA' 时参数个数或类型错误 ORA-06550: 第 1 行, 第 7 列: PL/SQL: Statement ignored "} 这是我的程序调用代码 ''' <summary> ''' 获取数据的万能存储过程,查询返回结果集的存储过程调用 ''' Author:Jones.Vale ''' Datetime:20160127 ''' </summary> ''' <param name="strProcName">存储过程名</param> ''' <param name="pa">传入的参数数组,第一列为参数名,第二列为参数值</param> ''' <returns></returns> ''' <remarks></remarks> Public Function ExecStoredProcData(ByVal strProcName As String, ByVal objHashtable As Hashtable) As DataSet Dim mydt As New DataSet Dim myCommand As OracleCommand Dim objOracleParameter As IDictionaryEnumerator = objHashtable.GetEnumerator() Dim iii As Integer iii = 30 myCommand = myORACLEConnection.CreateCommand While objOracleParameter.MoveNext() Dim tempValue As String = TypeName(objOracleParameter.Value) Dim myParameter As New OracleParameter '定义一个参数 If tempValue = "Date" Then myParameter.DbType = DbType.Date '赋参数类型 ElseIf tempValue = "Integer" Then myParameter.DbType = DbType.Int32 '赋参数类型 ElseIf tempValue = "Double" Or tempValue = "Float" Or tempValue = "NUMBER" Then myParameter.DbType = DbType.Double '赋参数类型 Else myParameter.DbType = DbType.String '赋参数类型 End If myParameter.ParameterName = objOracleParameter.Key myParameter.Value = objOracleParameter.Value myCommand.Parameters.Add(myParameter) '加入参数列表 End While myCommand.CommandText = strProcName myCommand.CommandType = CommandType.StoredProcedure Dim dataAdapter As New OracleDataAdapter dataAdapter.SelectCommand() = myCommand dataAdapter.Fill(mydt) Return mydt End Function 以下是在plSQL中执行测试结果没有任何问题。 存储过程代码: CREATE OR REPLACE PROCEDURE PROC_GetData ( v_dateTime date, v_tiger number, p_cur out SYS_REFCURSOR---游标返回 ) as v_sql varchar2(2000) := ' '; begin if v_tiger = 2 then v_sql :='select t.branchno,sum(t.reportloss)/10000 as RV from bhresvfee.t_resv_claim_bhsys t where t.insuranceclass like (''7%'') and casestate<>''9'' group by t.branchno order by t.branchno'; end if; OPEN p_cur FOR v_sql; end PROC_GetData; 高手请指点一下这个问题是什么引起的。怎么处理才有效,谢谢!

PL/SQL: ORA-00942: table or view does not exist

DECLARE CURSOR c_tab IS SELECT * FROM user_tables; v_row user_tables%ROWTYPE; v_count INTEGER; BEGIN OPEN c_tab; LOOP FETCH c_tab INTO v_row; EXIT WHEN c_tab%NOTFOUND; dbms_output.put_line(v_row.table_name); SELECT COUNT(*) INTO v_count FROM v_row.table_name; IF v_count<>0 THEN dbms_output.put_line(v_row.table_name||'is not null'); END IF; END LOOP; CLOSE c_tab; END; ORA-06550: line 12, column 52: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 12, column 12: PL/SQL: SQL Statement ignored 请各位大神指导,游标的值最终给了变量,但是说找不到这表

每次使用oracle数据库时,服务启动了,每次都报错ORA-01034: ORACLE not available

每次使用oracle数据库时,服务启动了,每次都报错ORA-01034: ORACLE not available 每次解决了ORA-01034: ORACLE not available这个问题,我下次用数据库的时候,又报ORA-01034: ORACLE not available这个问题 有什么办法能彻底解决这个问题吗? 如下图: ![图片说明](https://img-ask.csdn.net/upload/201905/21/1558442118_265.png) 每次都要如下这样做,才能连接oracle数据库 ![图片说明](https://img-ask.csdn.net/upload/201905/21/1558443091_949004.png) ![图片说明](https://img-ask.csdn.net/upload/201905/21/1558443103_596996.png) ![图片说明](https://img-ask.csdn.net/upload/201905/21/1558443296_722118.png)

客户端有时提示 ORA-12170: TNS:Connect timeout occurred,多次刷新连接后又可以连接,这是为什么?

客户端程序有时会提示ORA-12170: TNS:Connect timeout occurred,多次刷新后又可以连接。 PLsql也是,有时登录后提示ORA-12170,重新登录二次或三次,又可以连接。我用的是笔记本,连接的是内网数据库,有知道的原因的吗? 另外我装的是客户端odbc,C:\instantclient,tnsping也是没有找到,提示 'tnsping' 不是内部或外部命令,也不是可运行的程序,有知道为什么的吗?

Oracle连接显示ERROR:ORA-01031: insufficient privileges

安装后,在DOS上输入sqlplus / as sysdba 出现ERROR: ORA-01031: insufficient privileges让输入用户名进入,可以直接输入 sys as sysdba (还以超级用户的进入) 密码为你安装时设置的密码,就可以进入特权用户下解锁其他用户使用。请问谁有解决ERROR: ORA-01031: insufficient privileges让的办法吗?配置是NTS,这里没有错。

spring mvc+ibatis+oracle ORA-02289: 序列不存在

代码是从svn更新下来的,在别人机器的运行环境下都可以正常运行,在我的环境下就水土不服了,请大神指点 sql如下: <select id="Manage.getSeq" resultClass="string"> select SEQ_SIAPP_COUPON_NO.nextval from dual </select> 错误信息如下: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.paic.mhis.siapp.core.rps.proxy.MethodInvoker.invoke(MethodInvoker.java:27) at com.paic.mhis.siapp.core.rps.proxy.MethodInvoker$$FastClassByCGLIB$$91548d27.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.paic.mhis.siapp.admin.general.logging.aop.LoggerInterceptor.invoke(LoggerInterceptor.java:45) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) at com.paic.mhis.siapp.admin.general.logging.aop.SmsMethodInvoker$$EnhancerByCGLIB$$c201eac9.invoke(<generated>) at com.paic.mhis.siapp.core.rps.protocol.Receiver.invoke(Receiver.java:32) at com.paic.mhis.siapp.core.rps.transport.server.RpsHttpServer.handleRequest(RpsHttpServer.java:19) at com.paic.mhis.siapp.core.rps.transport.server.RpsHttpServlet.doPost(RpsHttpServlet.java:126) at com.paic.mhis.siapp.core.rps.transport.server.RpsHttpServlet.doPost(RpsHttpServlet.java:90) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3594) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at weblogic.work.ExecuteThread.run(ExecuteThread.java:173) Caused by: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlmaps/market/sqlmap-mapping-couponManage.xml. --- The error occurred while applying a parameter map. --- Check the couponManage.getCouponNoSeq-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLSyntaxErrorException: ORA-02289: 序列不存在 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203) at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:279) at com.paic.pafa.biz.dao.BaseDAO._getObject(Unknown Source) at com.paic.pafa.biz.dao.BaseDAO._queryForObject(Unknown Source) at com.paic.mhis.siapp.common.integration.dao.impl.CommonDaoImpl.get(CommonDaoImpl.java:121) at com.paic.mhis.oaccount.market.service.impl.CouponManageServiceImpl.getCouponNo(CouponManageServiceImpl.java:89) ... 31 more Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlmaps/market/sqlmap-mapping-couponManage.xml. --- The error occurred while applying a parameter map. --- Check the couponManage.getCouponNoSeq-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLSyntaxErrorException: ORA-02289: 序列不存在 at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:114) at org.springframework.orm.ibatis.SqlMapClientTemplate$2.doInSqlMapClient(SqlMapClientTemplate.java:281) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200) ... 36 more Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: 序列不存在 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62) at $Proxy223.execute(Unknown Source) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186) at com.paic.pafa.app.lwc.service.persistence.dao.ibatis.PafaSqlExecutor.doSuperExecuteQuery(Unknown Source) at com.paic.pafa.app.lwc.service.persistence.dao.ibatis.PafaSqlExecutor.executeQuery(Unknown Source) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) ... 41 more [03/30 10:53:27] [WARN] RpsHttpServlet: rollback <2017-3-30 上午10时53分27秒 CST> <Error> <HTTP> <BEA-101020> <[ServletContext@9937403[app:siapp-sms-app module:siapp-sms-app path:/siapp-sms-app spec-version:2.5]] Servlet failed with Exception java.lang.NullPointerException at com.paic.mhis.siapp.core.rps.transport.server.RpsHttpServlet.doPost(RpsHttpServlet.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) Truncated. see log file for complete stacktrace

ORA-03001:未实施的功能 和 ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值

我现在一个存储过程中报错“ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值”,我怀疑是clob限制的问题,但是做实验时遇到下面的错误 我是写了一个很简单的存储过程,准备验证普通表中clob字段存储有没有大小限制,查资料好像说最大4G,我想验证一下。但是写存储过程将大量数据插入clob字段时报标题错误: 版本: SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production 语句: 建表: create table t_wll_clob(mobile clob); 建存储过程: create or replace procedure p_wll_clob as v_clob clob; begin for v_11 in(select allcode from T_BUSI_MAIN_PRESEND3 where main1status='0') loop --allcode字段为clob类型,存储的是用逗号分隔的手机号码。for一共500条记录,每条200个用逗号分隔的手机号 v_clob := v_11.allcode||','||v_clob; end loop; insert into t_wll_clob(mobile) values v_clob; end ; 报错: insert into t_wll_clob(mobile) values v_clob; ORA-03001:未实施的功能 求高手解答。 另外我想知道: 1.普通表中clob字段最大限制是多少 2.存储过程中clob变量最大限制是多少 3.如果clob有限制,那么超过限制报错一般是怎么解决,是限制数据的大小还是?

ORA-00905: 缺失关键字

<p> </p> <pre name="code" class="sql">CREATE OR REPLACE PROCEDURE P_OPERATIONNAMEREFCOUNT( tablesName varchar2, columnName varchar2, columnVals varchar2, numsresult OUT INTEGER )as p_num INTEGER; f_sql varchar(1000); cursor curs IS ( SELECT b.column_name pkcolumn_name,c.table_name fktable_name,c.column_name fkcolumn_name FROM user_cons_columns b LEFT JOIN (SELECT constraint_name, r_constraint_name FROM user_constraints WHERE constraint_type='R' ) a ON b.constraint_name=a.r_constraint_name LEFT JOIN user_cons_columns c ON c.constraint_name=a.constraint_name WHERE c.position =b.position AND b.table_name = upper(''||tablesName||'') UNION select 'OPERATIONNAME','DESIGNTASK','TASKNAME' from dual ); begin p_num:=0; for cur in curs loop f_sql := 'select count(*) into '||p_num||' from '||upper(tablesName)||' b inner join '||cur.fktable_name||' d ON b.'||cur.pkcolumn_name||'=d.'||cur.fkcolumn_name||' where b.'||upper(columnName)||' like '''||columnVals||''''; execute immediate f_sql; numsresult:=p_num+numsresult; --dbms_output.put_line(f_sql||';'); end loop; END P_OPERATIONNAMEREFCOUNT;</pre> <p> </p> <p>此存储过程报如下错误:</p> <p> </p> <p> </p> <p>连接到数据库 orcl-eman。</p> <p>ORA-00905: 缺失关键字</p> <p>ORA-06512: 在 "EMAN.P_OPERATIONNAMEREFCOUNT", line 22</p> <p>ORA-06512: 在 line 11</p> <p>进程已退出。</p> <p>从数据库 orcl-eman 断开连接。</p> <p> </p> <p> </p> <p>我将:</p> <p> </p> <pre name="code" class="sql">f_sql := 'select count(*) into '||p_num||' from '||upper(tablesName)||' b inner join '||cur.fktable_name||' d ON b.'||cur.pkcolumn_name||'=d.'||cur.fkcolumn_name||' where b.'||upper(columnName)||' like '''||columnVals||'''';</pre> <pre name="code" class="sql">改变成:</pre> <pre name="code" class="sql"><pre name="code" class="sql">f_sql := 'select count(*) into from '||upper(tablesName)||' b inner join '||cur.fktable_name||' d ON b.'||cur.pkcolumn_name||'=d.'||cur.fkcolumn_name||' where b.'||upper(columnName)||' like '''||columnVals||'''';</pre> 是可以成功运行,但问题是为什么不能将值into p_num中呢,如何才能做到?</pre>

间歇性出现:ora-01483:DATE或NUMBER赋值变量的长度无效

clob字段 间歇性的出现insert报错问题,驱动也对过了,编码也都统一的gbk,间歇的出现,所以我该怎么查一下,麻烦大神教导一下,谢谢昂。 ```Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO tableA(ID,s_ID,SIGN,T_NO,SP_SN,SM,SP_STATUS)VALUES ( ?,?,?,?,?,?,?)]; SQL state [72000]; error code [1483]; ORA-01483: DATE 或 NUMBER 绑定变量的长度无效 [175]; nested exception is java.sql.SQLException: ORA-01483: DATE 或 NUMBER 绑定变量的长度无效 后来解决了,是weblogic部署了同一个domain的问题,按道理是可以部署两个domain的,后来换成tomcat服务就好了,具体原因没有再去细查了,如果正常的服务再有出现这个现象的话,可以找中间件上的原因看看。

YOLOv3目标检测实战:训练自己的数据集

YOLOv3目标检测实战:训练自己的数据集

150讲轻松搞定Python网络爬虫

150讲轻松搞定Python网络爬虫

实用主义学Python(小白也容易上手的Python实用案例)

实用主义学Python(小白也容易上手的Python实用案例)

我说我不会算法,阿里把我挂了。

不说了,字节跳动也反手把我挂了。

立方体线框模型透视投影 (计算机图形学实验)

计算机图形学实验 立方体线框模型透视投影 的可执行文件,亲测可运行,若需报告可以联系我,期待和各位交流

2019 AI开发者大会

2019 AI开发者大会

组成原理课程设计(实现机器数的真值还原等功能)

实现机器数的真值还原(定点小数)、定点小数的单符号位补码加减运算、定点小数的补码乘法运算和浮点数的加减运算。

C/C++跨平台研发从基础到高阶实战系列套餐

一 专题从基础的C语言核心到c++ 和stl完成基础强化; 二 再到数据结构,设计模式完成专业计算机技能强化; 三 通过跨平台网络编程,linux编程,qt界面编程,mfc编程,windows编程,c++与lua联合编程来完成应用强化 四 最后通过基于ffmpeg的音视频播放器,直播推流,屏幕录像,

MFC一站式终极全套课程包

该套餐共包含从C小白到C++到MFC的全部课程,整套学下来绝对成为一名C++大牛!!!

软件测试2小时入门

软件测试2小时入门

三个项目玩转深度学习(附1G源码)

三个项目玩转深度学习(附1G源码)

计算机图形学-球的光照模型课程设计

计算机图形学-球的光照模型,有代码完美运行,有课程设计书

Linux常用命令大全(非常全!!!)

Linux常用命令大全(非常全!!!) 最近都在和Linux打交道,感觉还不错。我觉得Linux相比windows比较麻烦的就是很多东西都要用命令来控制,当然,这也是很多人喜欢linux的原因,比较短小但却功能强大。我将我了解到的命令列举一下,仅供大家参考: 系统信息 arch 显示机器的处理器架构 uname -m 显示机器的处理器架构 uname -r 显示正在使用的内核版本 d...

因为看了这些书,我大二就拿了华为Offer

四年了,四年,你知道大学这四年我怎么过的么?

深度学习原理+项目实战+算法详解+主流框架(套餐)

深度学习系列课程从深度学习基础知识点开始讲解一步步进入神经网络的世界再到卷积和递归神经网络,详解各大经典网络架构。实战部分选择当下最火爆深度学习框架PyTorch与Tensorflow/Keras,全程实战演示框架核心使用与建模方法。项目实战部分选择计算机视觉与自然语言处理领域经典项目,从零开始详解算法原理,debug模式逐行代码解读。适合准备就业和转行的同学们加入学习! 建议按照下列课程顺序来进行学习 (1)掌握深度学习必备经典网络架构 (2)深度框架实战方法 (3)计算机视觉与自然语言处理项目实战。(按照课程排列顺序即可)

fakeLocation13.5.1.zip

fakeLocation13.5.1 虚拟定位 ios13.5.1的最新驱动下载,iPhone/iPad免越狱虚拟定位工具Location-cleaned驱动已更新

UnityLicence

UnityLicence

Python可以这样学(第一季:Python内功修炼)

Python可以这样学(第一季:Python内功修炼)

Python+OpenCV计算机视觉

Python+OpenCV计算机视觉

土豆浏览器

土豆浏览器可以用来看各种搞笑、电影、电视剧视频

【数据结构与算法综合实验】欢乐连连看(C++ & MFC)案例

这是武汉理工大学计算机学院数据结构与算法综合实验课程的第三次项目:欢乐连连看(C++ & MFC)迭代开发代码。运行环境:VS2017。已经实现功能:开始游戏、消子、判断胜负、提示、重排、计时、帮助。

php+mysql学生成绩管理系统

学生成绩管理系统,分三个模块:学生,教师和管理员。 管理员模块:负责学生、老师信息的增删改;发布课程信息的增删改,以便让学生选课;审核老师提交的学生成绩并且打印成绩存档;按照课号查询每个课号的学生成绩

多功能数字钟.zip

利用数字电子计数知识设计并制作的数字电子钟(含multisim仿真),该数字钟具有显示星期、24小时制时间、闹铃、整点报时、时间校准功能

推荐24个国外黄色网站欣赏

在中国清朝,明黄色的衣服只有皇子才有资格穿,慢慢的黄色在中国就成了高贵的颜色。在人们的色彩印象中,黄色也表现为暂停。所以当你的网页设计采用黄色的时候,会让人们在你的网页前停留。 黄色,就像橙色和红色,黄色也是一个暖色。它有大自然、阳光、春天的涵义,而且通常被认为是一个快乐和有希望的色彩。黄色是所有色相中最能发光的颜色,给人轻快,透明,辉煌,充满希望的色彩印象。 黄色是一个高可见的色...

u-boot-2015.07.tar.bz2

uboot-2015-07最新代码,喜欢的朋友请拿去

一学即懂的计算机视觉(第一季)

一学即懂的计算机视觉(第一季)

学生成绩管理系统(PHP + MYSQL)

做的是数据库课程设计,使用的php + MySQL,本来是黄金搭配也就没啥说的,推荐使用wamp服务器,里面有详细的使用说明,带有界面的啊!呵呵 不行的话,可以给我留言!

Windows版YOLOv4目标检测实战:训练自己的数据集

Windows版YOLOv4目标检测实战:训练自己的数据集

C++语言基础视频教程

C++语言基础视频教程

玩转Python-Python3基础入门

玩转Python-Python3基础入门

相关热词 c# 开发接口 c# 中方法上面的限制 c# java 时间戳 c#单元测试入门 c# 数组转化成文本 c#实体类主外键关系设置 c# 子函数 局部 c#窗口位置设置 c# list 查询 c# 事件 执行顺序
立即提问
相关内容推荐