如何在Google脚本中使用registerOutParameter? [英] How to use registerOutParameter in google script?

问题描述

如何在Google脚本中使用registerOutParameter(int parameterIndex，int sqlType)?

How to use registerOutParameter (int parameterIndex, int sqlType) in google script?

问题正在使用参数:sqlType. ParameterIndex不会出现问题

Problem is using parameter: sqlType. ParameterIndex does not make problems

我知道slqType应该用整数表示-

I understand that slqType should be represent by integer - see in documentation

...但是什么整数代表sqlType:Varchar，Integer ...?

 ... but what integer represents sqlType : Varchar, Integer ...?

推荐答案

可能有一种方法可以通过名称引用SQL类型，而不必记住java.sql.Types列表来获取int，但我还没有.在Google Apps脚本文档中找不到任何内容

Probably there is a way to refer to the SQL Type by name without having to remember the list of java.sql.Types to get the int but I haven't found in Google Apps Script documentation anything yet

在此期间，为了查找SQL类型，请使用以下列表

In the meantime in order to find the SQL Type use the following list

• ARRAY 2003
• BIGINT -5
• BINARY -2
• BIT -7
• BLOB 2004
• BOOLEAN 16
• CHAR 1
• CLOB 2005
• DATALINK 70
• 日期91
• DECIMAL 3
• DISTINCT 2001
• 双8
• FLOAT 6
• INTEGER 4
• JAVA_OBJECT 2000
• LONGNVARCHAR -16
• LONGVARBINARY -4
• LONGVARCHAR -1
• NCHAR -15
• NCLOB 2011
• NULL 0
• NUMERIC 2
• NVARCHAR -9
• 其他1111
• 真实7
• REF 2006
• ROWID -8
• SMALLINT 5
• SQLXML 2009
• STRUCT 2002
• 时间92
• 时间戳93
• TINYINT -6
• VARBINARY -3
• VARCHAR 12

• ARRAY 2003
• BIGINT -5
• BINARY -2
• BIT -7
• BLOB 2004
• BOOLEAN 16
• CHAR 1
• CLOB 2005
• DATALINK 70
• DATE 91
• DECIMAL 3
• DISTINCT 2001
• DOUBLE 8
• FLOAT 6
• INTEGER 4
• JAVA_OBJECT 2000
• LONGNVARCHAR -16
• LONGVARBINARY -4
• LONGVARCHAR -1
• NCHAR -15
• NCLOB 2011
• NULL 0
• NUMERIC 2
• NVARCHAR -9
• OTHER 1111
• REAL 7
• REF 2006
• ROWID -8
• SMALLINT 5
• SQLXML 2009
• STRUCT 2002
• TIME 92
• TIMESTAMP 93
• TINYINT -6
• VARBINARY -3
• VARCHAR 12

来源: http://docs.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Types

这篇关于如何在Google脚本中使用registerOutParameter?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！