DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VarChar2 datatype in VB6

412688Jan 9 2004 — edited Jan 20 2004

I am calling a stored procedure on an Oracle server using OraOLEDB.Oracle, but I have found conflicting information on what ADODataTypeEnum to use when calling:
cmd.CreateParameter...

http://www.able-consulting.com/ADODataTypeEnum.htm
http://www.w3schools.com/ado/ado_datatypes.asp
These say to use adVariant for VarChar2 parameters.

MSDN (http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860)
This says "adVariant is currently not supported by ADO. Usage may cause unpredictable results"

adVariant seems to work, but I don't want "unpredictable results" . I also don't really want to specify the size of the variable, so would like to avoid using adVarChar if possible.

Is adVariant appropriate & safe or not?

Cheers.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2004

Added on Jan 9 2004

#oracle-provider-for-ole-db, #windows-and-net

4 comments

1,898 views