使用搜索功能查看 Kepware 的信息库,其中包含 500 多篇知识库文章。缩小搜索结果范围,或在下面的搜索字段中输入您的查询。

或者,如果您无法找到解决方案,我们还有另一个资源:我们的 PTC eSupport Portal。 如果系统提示您登录 eSupport Portal,您可以使用“我的 Kepware”凭据。需要一个“我的 Kepware”帐户吗?在此处创建

搜索解决方案结果:
View All Solutions

Kepware Knowledge Base: Solution


Is There a Limit on the Number of Characters That Can Be Used to Create Column Names in Oracle?


Last Update: 2018/11/7

Yes, there is. For the limitations according to Oracle, refer to the table below.

ComponentMaximum Size
Column Name30 Bytes
Table Name30 Bytes

When creating a table dynamically from DataLogger, the default setting will create the columns for Wide Format tables using the full item name. Periods will be replaced with underscores. For example, the item "Channel1.Device1.Tag1" would result in the column "Channel1_Device1_Tag1_value" and would be a total of 27 characters. Unfortunately, problems with the column name and character counts will not be detected when the table is created. Errors will be returned as a query failure when the DataLogger project goes into Runtime. The error "Unable to query recordset on Log Group 'KT' (Reason: 'sp_cursor: The value of the parameter 'value' is invalid')" will be returned. To resolve this error, recreate the table and edit the automatically-generated column names. Then, map the server tags to the new columns.

Related Products
DataLogger