Bing Ads API v9到v10 [英] Bing Ads API v9 to v10
问题描述
我有这样的错误。
java.sql.SQLSyntaxErrorException:ORA-00947:没有足够的值
$
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun。 doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
nt.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)< br / >
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at com.netelixir.api .bulkDownloadUpload.BulkDownloadThreadNew.run(BulkDownloadThreadNew.java:297)
at com.netelixir.processhandler.ThreadPool $ PooledThread.run( ThreadPool.java:201)
java.sql.SQLSyntaxErrorException: ORA-00947: not enough values
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at com.netelixir.api.bulkDownloadUpload.BulkDownloadThreadNew.run(BulkDownloadThreadNew.java:297)
at com.netelixir.processhandler.ThreadPool$PooledThread.run(ThreadPool.java:201)
以下是代码:
int tmp = insertSt.executeUpdate(finalsql); //主查询
int tmp = insertSt.executeUpdate(finalsql);//main query
finalsql =" insert into" + strTableName +"(" + cmpsitelink_column1 +")" + cmpsitelinkSql; // finalsql查询
finalsql="insert into " + strTableName + "(" + cmpsitelink_column1 + ") " + cmpsitelinkSql; //finalsql query
cmpsitelinkSql ="选择distinct 6作为comp_Type来自GLE_CAMPAIGN CMP,gle_cmp_adExtension CMPEXTN其中CMPEXTN.ppc_id = 2468和CMPEXTN.CAMPAIGN_ID in('109444','109436 ','109434','109445','109435','109446')和CMP.CAMPAIGN_ID = CMPEXTN.CAMPAIGN_ID和
CMP.status<>'已删除'和CMPEXTN.status<>'已删除'和CMPEXTN.feed_status<>'已删除'的顺序由cmpextn.loc_ad_ext_id"
cmpsitelinkSql="Select distinct 6 as comp_Type from GLE_CAMPAIGN CMP,gle_cmp_adExtension CMPEXTN where CMPEXTN.ppc_id=2468 and CMPEXTN.CAMPAIGN_ID in ('109444','109436','109434','109445','109435','109446') and CMP.CAMPAIGN_ID=CMPEXTN.CAMPAIGN_ID and CMP.status<>'Deleted' and CMPEXTN.status<>'deleted' and CMPEXTN.feed_status<>'deleted' order by cmpextn.loc_ad_ext_id "
我收到的错误就是价值不够。
i have getting an error like not enough values.
请帮助我这个
推荐答案
这似乎是一个SQL问题,其中第一组值(插入into)不等于第二组值(选择不同的6)。此
中报告了类似的问题
堆栈溢出线程。
我希望这有帮助!
这篇关于Bing Ads API v9到v10的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!