Hi All
I am currently writing an asp script to retrieve data from an oracle database and write the values using the response.write method. I am using the 0040 ole provider. This works fine for all fields except fields of the clob (or lob) data types. I then recive the following message :
Response object error 'ASP 0185 : 80020003'
Missing Default Property
/planningApplications/applicantDetails.asp, line 0
A default property was not found for the object.
I understand that this is because of the datatype clob being used. Can anyone please provide a simple example of how to retrieve a field from an oracle dynaset that is of type clob and write it using the reposne.write method (or assign it to a variable so I can write it).
If you need any more information please ask.
Many Thanks
Colin
I am currently writing an asp script to retrieve data from an oracle database and write the values using the response.write method. I am using the 0040 ole provider. This works fine for all fields except fields of the clob (or lob) data types. I then recive the following message :
Response object error 'ASP 0185 : 80020003'
Missing Default Property
/planningApplications/applicantDetails.asp, line 0
A default property was not found for the object.
I understand that this is because of the datatype clob being used. Can anyone please provide a simple example of how to retrieve a field from an oracle dynaset that is of type clob and write it using the reposne.write method (or assign it to a variable so I can write it).
If you need any more information please ask.
Many Thanks
Colin