Excel VBA - Oracle SQL Datatype not supported Error

[ron011994]

Hi All,

I have been trying to download SQL Scripts through excel. It was successful at first but when I tried to run the below script it prompts a Datatype not supported error.
I am using an ADO connection for this.

Below is the code to call SQL script.


Dim sql As String
sql = ThisWorkbook.Sheets("Scripts").Cells(2, 7)
Call GetDataFromADO(sql, ThisWorkbook.Sheets("temp").Range("p2"), Sheets("temp"))
Sheets("temp").Select

and here is the SQL script.

Select PERSONPERMID,COMPANYNAME,COMPANYTITLE

from PEOPLEAUTHORITY.PERSONINFOFORCONCORDANCE

Where PERSONPERMID in (00000000)

<colgroup><col></colgroup><tbody>
</tbody>

Kindly note that when the above script is run via Oracle developer it does works.


Thanks in advance.

Ron

 

[V_Malkoti]

Did you use to_char() in your sql query? That would be the simplest fix for this problem.

Select PERSONPERMID, [COLOR=#0000ff]to_char(COMPANYNAME) company_name, to_char(COMPANYTITLE) company_title[/COLOR]
from PEOPLEAUTHORITY.PERSONINFOFORCONCORDANCE
Where PERSONPERMID in (00000000)

If that doesn't work I'll see if a change in VBA code with GetChunk helps.