SAP HANA ODBC 292错误，带有CREATE LOCAL TEMPORARY TABLE AS（...？...）的参数数量错误

4条回答
haha101010
1楼 · 2020-08-26 21:27.采纳回答
你好塞巴斯蒂安，
这实际上是服务器问题，因为服务器答复会通知ODBC驱动程序有关期望多少个参数，这些参数当前以0个参数进行答复。我已经为此问题提交了一个错误。
最诚挚的问候，
Jeff
派大星ヾ
2楼-- · 2020-08-26 21:14
附加了ODBC API跟踪...我在做错什么吗？！？
       
 libSQLDBCHDB 2.2.23.1499440855
 系统：Linux/X64
 建立于：2017-07-07 18:15:01
 分公司：未知
 应用：fglrun


 SQLAllocHandle 2017-09-07 14：54：02.697746
 HandleType [输入]：SQL_HANDLE_ENV
 InputHandle [输入]：0x0000000000000000
 OutputHandlePtr [输出]：0x000060d00000ac90
 SQLRETURN：SQL_SUCCESS


 SQLSetEnvAttr 2017-09-07 14：54：02.697772
 EnvironmentHandle [输入]：0x000060d00000ac90
 属性[输入]：SQL_ATTR_ODBC_VERSION
 ValuePtr [输入]：SQL_OV_ODBC3
 StringLength [in]：-5
 SQLRETURN：SQL_SUCCESS


 SQLAllocHandle 2017-09-07 14：54：02.697844
 HandleType [输入]：SQL_HANDLE_DBC
 InputHandle [输入]：0x000060d00000ac90
 OutputHandlePtr [输出]：0x000061a000010e89
 SQLRETURN：SQL_SUCCESS


 SQLConnect 2017-09-07 14：54：02.697902
 ConnectionHandle [输入]：0x000061a000010e89
 ServerName [输入]：HANADB1
 NameLength1 [in]：SQL_NTS
 用户名[输入]：hdbuser
 NameLength2 [in]：SQL_NTS
 enc：ASCII
 ODBC连接属性：
         #当地：ISO-8859-15
         数据库名称：TEST1
 SQLRETURN：SQL_SUCCESS


 SQLSetConnectAttr 2017-09-07 14：54：02.704993
 ConnectionHandle [输入]：0x000061a000010e89
 属性[输入]：SQL_ATTR_AUTOCOMMIT
 StringLength [in]：0
 enc：ASCII
 ValuePtr [输入]：SQL_AUTOCOMMIT_OFF
 SQLRETURN：SQL_SUCCESS


 SQLAllocHandle 2017-09-07 14：54：02.705015
 HandleType [输入]：SQL_HANDLE_STMT
 InputHandle [输入]：0x000061a000010e89
 OutputHandlePtr [输出]：0x000061400000e460
 SQLRETURN：SQL_SUCCESS


 SQLExecDirect 2017-09-07 14：54：02.705042
 StatementHandle [输入]：0x000061400000e460
 StatementText [in]："从m_database选择版本；"
 TextLength [in]：SQL_NTS
 enc：ASCII
 SQLRETURN：SQL_SUCCESS


 SQLBindCol 2017-09-07 14：54：02.705760
 StatementHandle [输入]：0x000061400000e460
 ColumnNumber [输入]：1
 TargetType [输入]：SQL_C_CHAR
 目标值[输入/输出]：0x00007ffdf999e7a0
 BufferLength [in]：100
 StrLen_or_IndPtr [输入/输出]：0
 SQLRETURN：SQL_SUCCESS


 SQLFetch 2017-09-07 14：54：02.705783
  -> SQLExtendedFetch
 SQLExtendedFetch 2017-09-07 14：54：02.705788
 StatementHandle [输入]：0x000061400000e460
 FetchOrientation [in]：SQL_FETCH_NEXT
 FetchOffset [输入]：0
 RowCountPtr [out]：0x0000000000000000
 RowStatusArray [输出]：0x0000000000000000
 SQLRETURN：SQL_SUCCESS
  <-SQLExtendedFetch


 SQLCloseCursor 2017-09-07 14：54：02.705821
 StatementHandle [输入]：0x000061400000e460
 SQLRETURN：SQL_SUCCESS


 SQLFreeHandle 2017-09-07 14：54：02.705843
 HandleType [输入]：SQL_HANDLE_STMT
 提手[输入]：0x000061400000e460
 SQLRETURN：SQL_SUCCESS


 SQLAllocHandle 2017-09-07 14：54：02.705973
 HandleType [输入]：SQL_HANDLE_STMT
 InputHandle [输入]：0x000061a000010e89
 OutputHandlePtr [输出]：0x000061400000e440
 SQLRETURN：SQL_SUCCESS


 SQLSetCursorName 2017-09-07 14：54：02.705994
 StatementHandle [输入]：0x000061400000e440
 CursorName [in]：scu1
 NameLength [in]：SQL_NTS
 SQLRETURN：SQL_SUCCESS


 SQLSetStmtAttr 2017-09-07 14：54：02.706128
 StatementHandle [输入]：0x000061400000e440
 属性[输入]：SQL_ATTR_NOSCAN
 StringLength [in]：SQL_NTS
 ValuePtr [输入]：SQL_NOSCAN_ON
 SQLRETURN：SQL_SUCCESS


 SQLPrepare 2017-09-07 14：54：02.706154
 StatementHandle [输入]：0x000061400000e440
 StatementText [in]："将本地临时表#tt2创建为（从t1中选择*，其中pk =？）"
 TextLength [in]：SQL_NTS
 enc：UCS2（LE）（本机）
 SQLRETURN：SQL_SUCCESS


 SQLBindParameter 2017-09-07 14：54：02.708007
 StatementHandle [输入]：0x000061400000e440
 ParameterNumber [输入]：1
 InputOutputType [输入]：SQL_PARAM_INPUT
 ValueType [输入]：SQL_C_LONG
 ParameterType [输入]：SQL_INTEGER
 ColumnSize [输入]：0
 DecimalDigits [in]：0
 ParameterValPtr [in]：0x000060200001e030
 BufferLength [输入/输出]：0
 StrLen_or_IndPtr [输入]：0x000060600000c350
 SQLRETURN：SQL_SUCCESS


 SQLExecute 2017年9月7日14：54：02.708047
 StatementHandle [输入]：0x000061400000e440
 SQLRETURN：SQL_ERROR


 SQLGetDiagRec 2017-09-07 14：54：02.714404
 HandleType [输入]：SQL_HANDLE_STMT
 处理[输入]：0x000061400000e440
 RecNumber [输入]：1
 缓冲区长度[输入]：513
 enc：ASCII
 SQLState [输出]：S1000
 NativeErrorPtr [输出]：292
 MessageText [out]：[SAP AG] [LIBODBCHDB SO] [HDBODBC]常规错误； 292个错误的参数数目
 TextLengthPtr [出]：76
 SQLRETURN：SQL_SUCCESS
 <CURRENT WRITE POSITION> <br> </pre>                                                                    <div class="appendcontent">
                                                        </div>
            </div>
       
             <div class="tool-group">
             <!-- cdn节点 回答操作 -->
<div class="cdn_question_answer102364"></div>
<script type="text/javascript">
  getquestioncaozuo(5,36471,102364);
</script>

                </div>
                </div>
                  
                </div>


<div class="comments-mod "
style="display: none; float: none; padding-top: 10px;"
id="comment_102364">
<div class="areabox clearfix">

<div class="input-group">
<input type="text" placeholder="请输入评论内容，不少于5个字"
AUTOCOMPLETE="off" class="comment-input form-control"
name="content" /> <input type='hidden' value='0'
name='replyauthor' /> <span class="input-group-btn"><input
type="button" value="评论" class="btn btn-green"
name="submit" onclick="addcomment(102364);" /> </span>
</div>

</div>
<ul class="my-comments-list nav">
<li class="loading text-left"><img
src='https://www.easysap.com/static/css/default/loading.gif'
align='absmiddle' />&nbsp;加载中...</li>
</ul>
</div>

</div>
         
            <div id="comment-102365" class="comment">
            <div>
                                  <div class="author">
            <a href="https://www.easysap.com/u-88.html" target="_self" class="avatar">
            <img src="https://www.easysap.com/data/avatar/000/00/00/small_000000088.jpg"  onmouseover="showInfoCard(this,'usercard',88)" onmouseout="hideInfoCard('usercard')" >
            </a>
            <div class="info">
            <a href="https://www.easysap.com/u-88.html" target="_self" class="name">
            N-Moskvin                                          </a>
            <!---->
             <div class="meta">
             <span>3楼-- · 2020-08-26 21:25</span>
             </div>
             </div>
             </div>
                          <div class="comment-wrap art-content">
             <div class="answercontent" style="max-height:10000000px">
                                                                          <p>我遇到了与</p>相同的问题
 <pre>过程" my_proc"（在i_var nvarchar（10）中）
 ...
 开始

 ...
 创建本地临时表#my_buff AS（从" sometable"中选择*，其中" somefield" = i_var）；

 ...

 结束;
 </pre>
 <p>我收到一条消息" ...参数数目错误" </p>
 <p>但是如果我将语句更改为</p>
 <pre>创建本地临时表#my_buff AS（从" sometable"中选择*，其中" somefield" =：i_var）； <br> </pre>
 <p>激活后，我收到一条消息"无法创建目录对象：无法使用参数变量。" </p>
 <p>还有一个，如果select不返回任何值，则将创建本地表，否则将出现一条消息" ...参数数量错误" </p>                                                                    <div class="appendcontent">
                                                        </div>
            </div>
       
             <div class="tool-group">
             <!-- cdn节点 回答操作 -->
<div class="cdn_question_answer102365"></div>
<script type="text/javascript">
  getquestioncaozuo(5,36471,102365);
</script>

                </div>
                </div>
                  
                </div>


<div class="comments-mod "
style="display: none; float: none; padding-top: 10px;"
id="comment_102365">
<div class="areabox clearfix">

<div class="input-group">
<input type="text" placeholder="请输入评论内容，不少于5个字"
AUTOCOMPLETE="off" class="comment-input form-control"
name="content" /> <input type='hidden' value='0'
name='replyauthor' /> <span class="input-group-btn"><input
type="button" value="评论" class="btn btn-green"
name="submit" onclick="addcomment(102365);" /> </span>
</div>

</div>
<ul class="my-comments-list nav">
<li class="loading text-left"><img
src='https://www.easysap.com/static/css/default/loading.gif'
align='absmiddle' />&nbsp;加载中...</li>
</ul>
</div>

</div>
         
            <div id="comment-102366" class="comment">
            <div>
                                  <div class="author">
            <a href="https://www.easysap.com/u-83.html" target="_self" class="avatar">
            <img src="https://www.easysap.com/data/avatar/000/00/00/small_000000083.jpg"  onmouseover="showInfoCard(this,'usercard',83)" onmouseout="hideInfoCard('usercard')" >
            </a>
            <div class="info">
            <a href="https://www.easysap.com/u-83.html" target="_self" class="name">
            奄奄一息的小鱼                                          </a>
            <!---->
             <div class="meta">
             <span>4楼-- · 2020-08-26 21:19</span>
             </div>
             </div>
             </div>
                          <div class="comment-wrap art-content">
             <div class="answercontent" style="max-height:10000000px">
                                                                          <p> 在HANA 2.0 SPS03（修订版30）和更高版本的服务器中已得到修复。</p> <p>请注意，在其他有效情况下，客户端仍然可以看到此错误消息。</p> <p>最诚挚的问候，</p>  <p> Jeff </p>                                                                    <div class="appendcontent">
                                                        </div>
            </div>
       
             <div class="tool-group">
             <!-- cdn节点 回答操作 -->
<div class="cdn_question_answer102366"></div>
<script type="text/javascript">
  getquestioncaozuo(5,36471,102366);
</script>

                </div>
                </div>
                  
                </div>


<div class="comments-mod "
style="display: none; float: none; padding-top: 10px;"
id="comment_102366">
<div class="areabox clearfix">

<div class="input-group">
<input type="text" placeholder="请输入评论内容，不少于5个字"
AUTOCOMPLETE="off" class="comment-input form-control"
name="content" /> <input type='hidden' value='0'
name='replyauthor' /> <span class="input-group-btn"><input
type="button" value="评论" class="btn btn-green"
name="submit" onclick="addcomment(102366);" /> </span>
</div>

</div>
<ul class="my-comments-list nav">
<li class="loading text-left"><img
src='https://www.easysap.com/static/css/default/loading.gif'
align='absmiddle' />&nbsp;加载中...</li>
</ul>
</div>

</div>
<div class="pages"></div>

</div>
</div>
<div></div>
</div>
<!-- cdn 问答邀请 -->
<div class="cdn_question_invate"></div>		
<script type="text/javascript">
getquestioncaozuo(7,36471);
</script><div class="new-answer bb">
<h3 class="title">
一周热门 <a href="https://www.easysap.com/content/solve.html" target="_blank" class="more">更多<font>&gt;
</font></a>
</h3>
<div class="inf-list">
<ul class="clearfix">
</ul>
</div>
</div>

</div>
</div>


</div>

</div>

<div class="col-md-7  aside "><div class="ad_vip" style="margin-bottom: 10px;">
<a href="javascript:login()"><img style="width: 100%;"
src="https://www.easysap.com/static/images/ad_vip.png" /></a>
    <h6>点击此处--->
                <a target="_blank" href="https://qm.qq.com/cgi-bin/qm/qr?k=0G3L9uZTbor8h6vhI8-lICNXNjgwRScW&jump_from=webapi"><img border="0" src="//pub.idqqimg.com/wpa/images/group.png" alt="EasySAP.com" title="EasySAP.com"></a>
                一起学习S4 HANA ...</h6>
</div><div class="standing">
<div class="positions bb" id="rankScroll">
<h3 class="title">相关问答</h3>
<ul><li class="no-video"><a
href="https://www.easysap.com/q-109172.html"
title="适用于SAP HANA的HANA Express 1 SP12 AWS SAP WebIDE-Builder'mtabuilder'不适用于工作区"> 适用于SAP HANA的HANA Express 1 SP12 AWS SAP WebIDE-Builder'mtabuilder'不适用于工作区 </a>
<div class="num-ask">
<a href="https://www.easysap.com/q-109172.html" class="anum">
4 个回答</a>
</div></li> <li class="no-video"><a
href="https://www.easysap.com/q-109165.html"
title="如何获取SAP HANA Express的di-space-enablement-ui"> 如何获取SAP HANA Express的di-space-enablement-ui </a>
<div class="num-ask">
<a href="https://www.easysap.com/q-109165.html" class="anum">
4 个回答</a>
</div></li> <li class="no-video"><a
href="https://www.easysap.com/q-108667.html"
title="我的WebIDE有什么问题"> 我的WebIDE有什么问题 </a>
<div class="num-ask">
<a href="https://www.easysap.com/q-108667.html" class="anum">
2 个回答</a>
</div></li> <li class="no-video"><a
href="https://www.easysap.com/q-108211.html"
title="HANA CDS关联阻止ODBC正常工作"> HANA CDS关联阻止ODBC正常工作 </a>
<div class="num-ask">
<a href="https://www.easysap.com/q-108211.html" class="anum">
2 个回答</a>
</div></li> <li class="no-video"><a
href="https://www.easysap.com/q-108046.html"
title="SAP HANA XSA WebIDE 2.0 SP 1：监视器-管理工具-审核日志"> SAP HANA XSA WebIDE 2.0 SP 1：监视器-管理工具-审核日志 </a>
<div class="num-ask">
<a href="https://www.easysap.com/q-108046.html" class="anum">
10 个回答</a>
</div></li> <li class="no-video"><a
href="https://www.easysap.com/q-107879.html"
title="HANA Express Binery安装失败"> HANA Express Binery安装失败 </a>
<div class="num-ask">
<a href="https://www.easysap.com/q-107879.html" class="anum">
8 个回答</a>
</div></li> <li class="no-video"><a
href="https://www.easysap.com/q-107715.html"
title="HANA Express版虚拟机2版的区别"> HANA Express版虚拟机2版的区别 </a>
<div class="num-ask">
<a href="https://www.easysap.com/q-107715.html" class="anum">
2 个回答</a>
</div></li> <li class="no-video"><a
href="https://www.easysap.com/q-107449.html"
title="需要有关SAP HANA 2 ODBC客户端的ISO8859-X和UTF-8编程的帮助"> 需要有关SAP HANA 2 ODBC客户端的ISO8859-X和UTF-8编程的帮助 </a>
<div class="num-ask">
<a href="https://www.easysap.com/q-107449.html" class="anum">
2 个回答</a>
</div></li> </ul>
</div>
</div><!--广告位5--></div>
</div>
</div>

<div class="modal fade" id="dialogadopt">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
<span aria-hidden="true">×</span><span class="sr-only">关闭</span>
</button>
<h4 class="modal-title">采纳回答</h4>
</div>
<div class="modal-body">

<form class="form-horizontal" name="editanswerForm" method="post">
<input type="hidden" value="36471" id="adopt_qid"
name="qid" /> <input type="hidden" id="adopt_answer" value="0"
name="aid" />
<table class="table ">
<tr valign="top">
<td>向帮助了您的网友说句感谢的话吧!</td>
</tr>
<tr>
<td>
<div class="inputbox mt15">
<textarea class="form-control" id="adopt_txtcontent"
name="content">非常感谢!</textarea>
</div>
</td>
</tr>
<tr>
<td><button type="button" id="adoptbtn" class="btn btn-success">确&nbsp;认</button></td>
</tr>
</table>
</form>

</div>

</div>
</div>
</div>
<script>

function checkpay(_qid,_aid){

var url="https://www.easysap.com/answerpay/poppay/"+_qid+"/"+_aid+".html";
var myModalTrigger = new $.zui.ModalTrigger({url:url});
myModalTrigger.show({
'backdrop':'static'
});


}
if(typeof($(".work-show-box").find("img").attr("data-original"))!="undefined"){
var imgurl=$(".work-show-box").find("img").attr("data-original");
$(".work-show-box").find("img").attr("src",imgurl);
}
$(".work-show-box,.answercontent").find("img").attr("data-toggle","lightbox").attr("data-lightbox-group",Date.parse( new Date() ).toString());
var postadopt=false;
$("#adoptbtn").click(function(){
  var data={
    			content:$("#adopt_txtcontent").val(),
    			qid:$("#adopt_qid").val(),
    			aid:$("#adopt_answer").val()

    	}
  	if(postadopt){
  	  	return false;
  	}
  postadopt=true;
$.ajax({
    //提交数据的类型 POST GET
    type:"POST",
    //提交的网址
    url:"https://www.easysap.com/question/ajaxadopt.html",
    //提交的数据
    data:data,
    //返回数据的格式
    datatype: "json",//"xml", "html", "script", "json", "jsonp", "text".
    //在请求之前调用的函数
    beforeSend:function(){},
    //成功返回之后调用的函数
    success:function(data){
    	var data=eval("("+data+")");
       if(data.message=='ok'){
    	   new $.zui.Messager('采纳成功!', {
    		   type: 'success',
    		   close: true,
       	    placement: 'center' // 定义显示位置
       	}).show();
    	   setTimeout(function(){
               window.location.reload();
           },1500);
       }else{
    	   new $.zui.Messager(data.message, {
        	   close: true,
        	    placement: 'center' // 定义显示位置
        	}).show();
       }


    }   ,
    //调用执行后调用的函数
    complete: function(XMLHttpRequest, textStatus){
     	postadopt=true;
    },
    //调用出错执行的函数
    error: function(){
        //请求出错处理
    	postadopt=false;
    }
 });
})

</script>
</div>
<!-- 编辑标签 -->

<div class="modal fade" id="dialog_tag">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
<span aria-hidden="true">×</span><span class="sr-only">关闭</span>
</button>
<h4 class="modal-title">编辑标签</h4>
</div>
<div class="modal-body">

<form onsubmit=" return checktagsubmit()" class="form-horizontal"
name="edittagForm" action="https://www.easysap.com/question/edittag.html" method="post">
<input type="hidden" value="36471" name="qid" />

<p>最多设置5个标签!</p>

<div class="inputbox mar-t-1">
<div class=" dongtai ">
<div class="tags"><div class="tag">
<span tagid="122">SAP HANA, express edition</span><i
class="fa fa-close"></i>
</div>
<div class="tag">
<span tagid="2381">        odbc</span><i
class="fa fa-close"></i>
</div>
<div class="tag">
<span tagid="13628">create local temporary table</span><i
class="fa fa-close"></i>
</div>
<div class="tag">
<span tagid="13629">sqlbindparameter</span><i
class="fa fa-close"></i>
</div>
</div>
<input type="text" autocomplete="off" data-toggle="tooltip"
data-placement="bottom" title=""
placeholder="检索标签，最多添加5个,添加标签更容易被回答"
data-original-title="检索标签，最多添加5个" name="topic_tagset" value=""
class="txt_taginput"> <i class="fa fa-search"></i>
<div class="tagsearch"></div>

</div>

<input type="hidden" class="form-control" id="qtags" name="qtags"
value="" />
</div>

<div class="mar-t-1">

<button type="submit" class="btn btn-success">保存</button>
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
</div>
</form>

</div>

</div>
</div>
</div><!-- 举报 -->
<div class="modal fade panel-report" id="dialog_inform">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
<span aria-hidden="true">×</span><span class="sr-only">关闭</span>
</button>
<h4 class="modal-title">举报内容</h4>
</div>
<div class="modal-body">

<form id="rp_form" class="rp_form" action="https://www.easysap.com/inform/add.html"
method="post">
<input value="" type="hidden" name="qid" id="myqid"> <input
value="" type="hidden" name="aid" id="myaid"> <input value=""
type="hidden" name="qtitle" id="myqtitle">
<div class="js-group-type group group-2">
<h4>检举类型</h4>
<ul>
<li class="js-report-con"><label><input type="radio"
name="group-type" value="1"><span>检举内容</span></label></li>
<li class="js-report-user"><label><input type="radio"
name="group-type" value="2"><span>检举用户</span></label></li>
</ul>
</div>
<div class="group group-2">
<h4>检举原因</h4>
<div class="list">
<ul>
<li><label class="reason-btn"><input type="radio" name="type"
value="4"><span>广告推广</span></label></li>
<li><label class="reason-btn"><input type="radio" name="type"
value="5"><span>恶意灌水</span></label></li>
<li><label class="reason-btn"><input type="radio" name="type"
value="6"><span>回答内容与提问无关</span> </label></li>
<li><label class="copy-ans-btn"><input type="radio" name="type"
value="7"><span>抄袭答案</span></label></li>
<li><label class="reason-btn"><input type="radio" name="type"
value="8"><span>其他</span></label></li>
</ul>
</div>
</div>
<div class="group group-3">
<h4>检举说明(必填)</h4>
<div class="textarea">
<ul class="anslist"
style="display: none; line-height: 20px; overflow: auto; height: 171px;">
</ul>
<textarea name="content" maxlength="200"
placeholder="请输入描述200个字以内">
</textarea>
</div>
</div>
<div class="mar-t-1">

<button type="submit" id="btninform" class="btn btn-success">提交</button>
<button type="button" class="btn btn-default mar-ly-1"
data-dismiss="modal">关闭</button>
</div>
</form>


</div>

</div>
</div>
</div>

<!-- 微信分享 -->
<div class="modal share-wechat animated" style="display: none;">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" data-dismiss="modal" class="close">×</button>
</div>
<div class="modal-body">
<h5>打开微信“扫一扫”，打开网页后点击屏幕右上角分享按钮</h5>
<div data-url="https://www.easysap.com/q-36471.html" class="qrcode"
title="https://www.easysap.com/q-36471.html">
<canvas width="170" height="170" style="display: none;"></canvas>
<div id="qr_wxcode"></div>
</div>
</div>
<div class="modal-footer"></div>
</div>
</div>
</div>

<!-- 设置付费金额 -->
<div class="modal pay-money animated" style="display: none;">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">

<button type="button" data-dismiss="modal" class="close">×</button>
</div>
<div class="modal-body">
<h5>付费偷看金额在0.1-10元之间</h5>
<div class="mar-t-1">

<input type="number" value="0" id="chakanjine" class="form-control" />

</div>
<button id="comfirm_pay" class="btn btn-success mar-t-1">确定</button>
</div>
<div class="modal-footer"></div>
</div>
</div>
</div>

<!-- 邀请回答 -->

<div class="modal fade" id="dialog_invate">
<div class="modal-dialog" style="width: 700px; top: -30px;">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
<span aria-hidden="true">×</span><span class="sr-only">关闭</span>
</button>
<h4 class="modal-title"></h4>
<div class="m_invateinfo">
<span class="m_i_text""> 您已邀请<span class="m_i_persionnum">15</span>人回答
</span> <span data-toggle="popover" data-tip-class="popover-info"
data-html="ture" data-placement="bottom" data-content=""
title="我的邀请列表" class="m_i_view">查看邀请</span>

<div class="m_i_warrper">
<input data-qid="36471" type="text"
id="m_i_searchusertxt" class="m_i_search" placeholder="搜索你想邀请的人">
<i class="fa fa-search"></i>
</div>

</div>
</div>
<div class="modal-body">
<!-- 邀请回答 -->
<ul class="trigger-menu m_invate_tab"
data-pjax-container="#list-container">
<li class="active" data-qid="36471" data-item="1"><a
href="javascript:">擅长该话题的人</a></li>
<li class="" data-qid="36471" data-item="2"><a
href="javascript:"> 回答过该话题的人</a></li>
<li class="" data-qid="36471" data-item="3"><a
href="javascript:">我关注的人</a></li>

</ul>
<!-- 邀请回答列表 -->
<div class="m_invatelist"></div>

</div>

</div>
</div>
</div>
   <link rel="stylesheet" type="text/css" href="https://www.easysap.com/static/js/neweditor/code/styles/tomorrow-night-eighties.css">
    <script src="https://www.easysap.com/static/js/neweditor/code/highlight.pack.js" type="text/javascript"></script>
<script>hljs.initHighlightingOnLoad();</script>

<script>
    function setcode(){
        var _html='';
    	  document.querySelectorAll('pre code').forEach((block) => {
        	  var _tmptext=$.trim($(block).text());
        	  if(_tmptext!=''){
        		  _html=_html+_tmptext;
        		  console.log(_html);
        	  }
    		 
    		  
    		 
      	  });
    	  $("#tpl_content").val(_html);

    }
 
</script>
<script>
  getquestioncaozuo(1,36471);
  getquestioncaozuo(2,36471);
  getquestioncaozuo(3,36471);
  getquestioncaozuo(4,36471);
  $(".btnshowall").click(function(){
    $(".shortquestioncontent").toggle();
    $(".hidequestioncontent").toggle();
  });


  $("#normal-comment-list .answercontent").each(function(){
if($(this).height()>150){
$(this).parent().find(".readmore").show();
}else{
$(this).parent().find(".readmore").hide();
}
});

    var needcode=0;
      var g_id = 6;
  var qid = 36471;
  function listertext(){
  	 var _content=$("#anscontent").val();
  	 if(_content.length>0&&g_id!=1){

  		 $(".code_hint").show();
  	 }else{
  		 $(".code_hint").hide();
  	 }
  }
    var mobile_localyuyin=0;
  //  var userAgent = window.navigator.userAgent.toLowerCase();
//  $.browser.msie8 = $.browser.msie && /msie 8\.0/i.test(userAgent);
 // if($.browser.msie8==true){
//  var mobile_localyuyin=0;
 // }
  var targetplay=null;
  function checktagsubmit(){
if(gettagsnum()<=0){
alert("请设置标签");
return false;
}
if(gettagsnum()>5){
    alert("最多添加5个标签");
    return false;
}
 var _tagstr=gettaglist();
 $("#qtags").val(_tagstr);
 
  }
  $(".txt_taginput").on(" input propertychange",function(){
 var _txtval=$(this).val();
 if(_txtval.length>1){

 //检索标签信息
 var _data={tagname:_txtval};
 var _url="https://www.easysap.com/tags/ajaxsearch.html";
 function success(result){
 console.log(result)
 if(result.code==200){
 console.log(_txtval)
  $(".tagsearch").html("");
for(var i=0;i<result.taglist.length;i++){

 var _msg=result.taglist[i].tagname
 
           $(".tagsearch").append('<div class="tagitem" tagid="'+result.taglist[i].id+'">'+_msg+'</div>');
}
$(".tagsearch").show();
$(".tagsearch .tagitem").click(function(){
var _tagname=$.trim($(this).html());
var _tagid=$.trim($(this).attr("tagid"));
if(gettagsnum()>=5){
alert("标签最多添加5个");
return false;
}
if(checktag(_tagname)){
alert("标签已存在");
return false;
}
$(".dongtai .tags").append('<div class="tag"><span tagid="'+_tagid+'">'+_tagname+"</span><i class='fa fa-close'></i></div>");
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
$(".tagsearch").html("");
$(".tagsearch").hide();
$(".txt_taginput").val("");
});
        
 }
 
 }
 ajaxpost(_url,_data,success);
 }else{
$(".tagsearch").html("");
$(".tagsearch").hide();
 }
})
function checktag(_tagname){
var tagrepeat=false;
$(".dongtai .tags .tag span").each(function(index,item){
var _tagnametmp=$.trim($(this).html());
if(_tagnametmp==_tagname){
tagrepeat=true;
}
})
return tagrepeat;
}
function gettaglist(){
var taglist='';
$(".dongtai .tags .tag span").each(function(index,item){
var _tagnametmp=$.trim($(this).attr("tagid"));
taglist=taglist+_tagnametmp+",";

})
taglist=taglist.substring(0,taglist.length-1);

return taglist;
}
function gettagsnum(){
      return $(".dongtai .tags .tag").length;
}
$(".tagsearch .tagitem").click(function(){
var _tagname=$.trim($(this).html());
if(gettagsnum()>=5){
alert("标签最多添加5个");
return false;
}
if(checktag(_tagname)){
alert("标签已存在");
return false;
}
$(".dongtai .tags").append('<div class="tag"><span>'+_tagname+"</span><i class='fa fa-close'></i></div>");
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
$(".tagsearch").html("");
$(".tagsearch").hide();
$(".txt_taginput").val("");
});
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
  $(".yuyinplay").click(function(){
  	targetplay=$(this);
  	var _serverid=targetplay.attr("id");
  	   if(_serverid == '') {
  			alert('语音文件丢失');
             return;
         }
  	   $(".wtip").html("免费偷听");
  	   targetplay.find(".wtip").html("播放中..");
  	   if(mobile_localyuyin==1){
  		 $(".htmlview").removeClass("hide");
   $(".ieview").addClass("hide");

  		   var myAudio =targetplay.find("#voiceaudio")[0];
  	  	  // myAudio.pause();
  	  	   //myAudio.play();
  	  	   if(myAudio.paused){
  	  		   targetplay.find(".wtip").html("播放中..");
  	             myAudio.play();
  	         }else{
  	      	   targetplay.find(".wtip").html("暂停..");
  	             myAudio.pause();
  	         }
  	  	   function endfun(){ targetplay.find(".wtip").html("播放结束");alert("播放结束!")}
  	  	   var   is_playFinish = setInterval(function(){
  	             if( myAudio.ended){

  	          	   endfun();
  	  	                    window.clearInterval(is_playFinish);
  	             }
  	     }, 10);
  	   }else{

  		 $(".ieview").removeClass("hide");
  		   $(".htmlview").addClass("hide");
  	   }




  })
function deleteanswer(current_aid){
  if(confirm("是否删除此回答?")){
window.location.href=g_site_url + "index.php" + query + "question/deleteanswer/"+current_aid+"/36471";

  }

}
  function adoptanswer(aid) {

      $("#adopt_answer").val(aid);

      $('#dialogadopt').modal('show');
}
  //编辑标签
  function edittag() {
 	 $('#dialog_tag').modal('show');

 }
  if(typeof($(".show-content").find("img").attr("data-original"))!="undefined"){
var imgurl=$(".show-content").find("img").attr("data-original");
$(".show-content").find("img").attr("src",imgurl);
}

$(".show-content,.answercontent").find("img").attr("data-toggle","lightbox").attr("data-lightbox-group",Date.parse( new Date() ).toString());

  var category1 = [["42","S/4HANA"],["17","Fiori"],["45","UI5"],["20","HANA"],["2","ABAP"],["16","FICO"],["47","SD"],["26","MM"],["36","PP"],["34","PM"],["37","PS"],["54","WM"],["38","QM"],["12","CRM"],["8","BPC"],["9","BPM"],["11","BW"],["7","BO"],["32","PI"],["44","PO"],["6","Basis"],["46","SCM"],["49","SRM"],["21","HCM"],["24","Logistics Execution"],["33","PLM"],["15","EWM"],["41","RPA"],["4","Ariba"],["50","SuccessFactors"],["55","Workflow"],["3","APO"],["5","B1"],["10","BSP"],["13","DATA"],["22","HTML5"],["53","Web Dynpro"],["18","GRC"],["43","SAP Cloud"],["19","GTS"],["23","Hybris"],["25","Lumira"],["27","Mobile"],["28","NetWeaver"],["1","SAP Industry Solutions"],["35","PORTAL"],["48","SOLMAN"],["52","UI"],["59","Machine Learning"],["56","Big Data"],["57","Blockchain"],["58","Training"],["31","Others"]];
  var category2 = [];
  var category3 = [];
  var selectedcid = "20,0,0";
  //修改分类
  function change_category() {
      var category1 = $("#category1 option:selected").val();
              var category2 = $("#category2 option:selected").val();
              var category3 = $("#category3 option:selected").val();
              if (category1 > 0) {
      $("#categoryid").val(category1);
      }
      if (category2 > 0) {
      $("#categoryid").val(category2);
      }
      if (category3 > 0) {
      $("#categoryid").val(category3);
      }
      $("#catedialog").model("hide");
              $("form[name='editcategoryForm']").submit();
      }
  //投诉
  function openinform(qid ,qtitle,aid) {
  $("#myqid").val(qid);
  $("#myqtitle").val(qtitle);
  $("#myaid").val(aid);
 	 $('#dialog_inform').modal('show');

 }
  $(".showcommentid").each(function(){
       var dataid=$(this).attr("data-id");
       show_comment(dataid);
  });
  function show_comment(answerid) {
      if ($("#comment_" + answerid).css("display") === "none") {
      load_comment(answerid);
              $("#comment_" + answerid).slideDown();
      } else {
      $("#comment_" + answerid).slideUp();
      }
      }
  //添加评论
  function addcomment(answerid) {
  var content = $("#comment_" + answerid + " input[name='content']").val();
  var replyauthor = $("#comment_" + answerid + " input[name='replyauthor']").val();
 
  if (g_uid == 0){
  
      login();
      return false;
  }
  if (bytes($.trim(content)) < 5){
  alert("评论内容不能少于5字");
          return false;
  }
  $.ajax({
  type: "POST",
          url: "https://www.easysap.com/answer/addcomment.html",
          data: "content=" + content + "&answerid=" + answerid+"&replyauthor="+replyauthor,
          success: function(status) {
          if (status == '1') {
          $("#comment_" + answerid + " input[name='content']").val("");
                  load_comment(answerid);
          }else{
          	if(status == '-2'){
          		alert("问题已经关闭，无法评论");
          	}
          }
          }
  });
  }
  
  //删除评论
  function deletecomment(commentid, answerid) {
  if (!confirm("确认删除该评论?")) {
  return false;
  }
  $.ajax({
  type: "POST",
          url: "https://www.easysap.com/answer/deletecomment.html",
          data: "commentid=" + commentid + "&answerid=" + answerid,
          success: function(status) {
              
          if (status == '1') {
          load_comment(answerid);
          }else{
                alert(status);
          }
          
          }
  });
  }
  //加载评论
  function load_comment(answerid){
  $.ajax({
  type: "GET",
          cache:false,
          url: "https://www.easysap.com/index.php?answer/ajaxviewcomment/" + answerid,
          success: function(comments) {
          $("#comment_" + answerid + " .my-comments-list").html(comments);
          }
  });
  }

  function replycomment(commentauthorid,answerid){
      var comment_author = $("#comment_author_"+commentauthorid).attr("title");
      $("#comment_"+answerid+" .comment-input").focus();
      $("#comment_"+answerid+" .comment-input").val("回复 "+comment_author+" :");
      $("#comment_" + answerid + " input[name='replyauthor']").val(commentauthorid);
  }
$(function(){
  initcategory(category1);
          fillcategory(category2, $("#category1 option:selected").val(), "category2");
          fillcategory(category3, $("#category2 option:selected").val(), "category3");
        	var qrurl="https://www.easysap.com/q-36471.html";
//微信二维码生成
$('#qr_wxcode').qrcode(qrurl);
     //显示微信二维码
     $(".share-weixin").click(function(){
    	 $(".share-wechat").show();
     });
     //关闭微信二维码
     $(".close").click(function(){
    	 $(".share-wechat").hide();
    	 $(".pay-money").hide();
     });
  


})


                </script>
<div id="usercard" style="position:absolute;z-index:999999999;"></div>
   <script src="https://www.easysap.com/static/js/jquery.lazyload.min.js" type="text/javascript"></script>
<script>

   

                    $("img.lazy").lazyload({effect: "fadeIn" });

</script>

  <div class="side-tool" id="to_top"><ul><li data-placement="left" data-toggle="tooltip" data-container="body" data-original-title="回到顶部" >
    <a href="#" class="function-button"><i class="fa fa-angle-up"></i></a>
    </li>



      </ul></div>
      <script>
window.onload = function(){
  $(".edui-upload-video").attr("preload","");
  var oTop = document.getElementById("to_top");

  var screenw = document.documentElement.clientWidth || document.body.clientWidth;
  var screenh = document.documentElement.clientHeight || document.body.clientHeight;
  window.onscroll = function(){
    var scrolltop = document.documentElement.scrollTop || document.body.scrollTop;
 
    if(scrolltop<=screenh){
    	oTop.style.display="none";
    }else{
    	oTop.style.display="block";
    }
    if(scrolltop>30){
     
    	$(".scrollshow").show();
    }else{
    	$(".scrollshow").hide();
    }
  }
  oTop.onclick = function(){
    document.documentElement.scrollTop = document.body.scrollTop =0;
  }
}

</script>

    <footer id="footer">
        <div class="footer-wrapper">
            <div class="footer-wrapper-top">
                <div class="footer-wrapper-top-left">
                    <a href="https://www.easysap.com/tags.html"><i class="hide"></i>标签大全</a>
                    <a href="https://www.easysap.com/new.html" >站内问题</a>
                    <a href="https://www.easysap.com/topic/default.html" >专栏文章</a>
                    <a href="https://www.easysap.com/expert/default.html">站内专家</a>
                    <a href="https://www.easysap.com/category/viewtopic/hot" >站内话题</a>
                    <a href="https://www.easysap.com/note/list.html" >站内公告</a>
                     <a href="https://www.easysap.com/rule/index.html">财富值规则</a>
                       <script>
var _hmt = _hmt || [];
(function() {
  var hm = document.createElement("script");
  hm.src = "https://hm.baidu.com/hm.js?91cd836d35676d254ee158461ecf506f";
  var s = document.getElementsByTagName("script")[0]; 
  s.parentNode.insertBefore(hm, s);
})();
</script>                     
                </div>
               
            </div>
            
                        
         
           
            <div class="footer-wrapper-bottom space-footer-bottom">
                <a href="http://www.12377.cn/" target="_blank">网上有害信息举报专区</a>
                    <i></i>
                    <a href="https://beian.miit.gov.cn/" target="_blank">京ICP备2021023650号</a>
                <i></i>
                <span ><a href="https://www.easysap.com/rss/articlelist.xml" target="_blank">站内文章地图xml</a></span>
                <i></i>
                <span><a href="https://www.easysap.com/rss/list.xml" target="_blank">站内问答地图xml</a></span>
                <i></i>
                <span><a href="https://www.easysap.com/rss/userspace.xml" target="_blank">站内作者地图xml</a></span>
               <i></i>
                <span><a href="https://www.easysap.com/rss/tag.xml" target="_blank">站内标签地图xml</a></span>
            
              <!--<span class="copyrightLink">Copyright © 2024 <a href="https://www.easysap.com/" target="_blank">EasySAP</a></span>-->
              <span class="copyrightLink">Copyright © 2024 <a href="https://www.easysap.com/" target="_blank">EasySAP</a></span>
            </div>
        </div>
    </footer>

</div>

</body>
</html>
SAP HANA ODBC 292错误，带有CREATE LOCAL TEMPORARY TABLE AS（...？...）的参数数量错误

点击此处---> 群内免费提供SAP练习系统（在群公告中）

点击此处---> 群内免费提供SAP练习系统（在群公告中）
