当在VBA中调用Oracle的存储过程时,如果有个SYS_REFCURSOR的Output参数,则必须在connection string中加上下面这项:
Extended Properties='PLSQLRSet=1'
Private Const ConnectionString As String = "Provider=OraOLEDB.Oracle; User ID=" + USERNAME + "; Password=" + PWD + "; Data Source=" + DataSource + "; Extended Properties='PLSQLRSet=1'"
否则可能会报错