Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 15th, 2004, 10:44 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Corruption on data write to Oracle table (string)


Hello,

Has anyone come across this problem before - I could really use some help please!

I am testing a VB application for Windows Xp compatibility, which works under its previous NT environment.

The problem I have occurs when the program attempts to write some information to the loraDockets dynaset (see the relevant SQL string). There is no problem if the data type of the loraDocket is Int/Date - the only issue is where the data is of type "string". If this is the case, then the data written is corrupt (usually "?"s and some other random control characters!).

The (what I think are) relevant parts of the code are as follows:

Dim loraDockets As Object
Public odoSesCLT As Object
Public odoDbCLT As Object

Set odoSesCLT = CreateObject("OracleInProcServer.XORASession")

Set odoDbCLT = odoSesCLT.OpenDatabase(SQLNetName, Username & "/" & Password, 1)

Set loraDockets = odoDbCLT.CreateDynaset("select * from clt_client_docket where status_ind = 'S'", 0)

'The problem occurs here: (after we have found the relevant docket to
'process - ie, loraDockets.moveFirst / other code has been executed)

odoSesCLT.BeginTrans
loraDockets.Edit
loraDockets("brand_code") = "TEST"

'Here brand_code is a field on the Oracle table, of type String, size4.


I hope you can help,
thanks

Jon Buckham
__________________
Jon Buckham





Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk insertion from a data table to oracle databas Alexkure ASP.NET 1.0 and 1.1 Professional 0 November 12th, 2008 03:24 AM
Need help in write application using VB and Oracle b3kool VB Databases Basics 3 December 11th, 2006 03:17 PM
How to Read Oracle Data without Oracle being insta badrinarayanang Oracle 1 October 6th, 2005 06:34 AM
(oracle 8i)Alter Table <table> coalesce partition combo Oracle 3 October 13th, 2004 09:35 AM
XML Write to a string dkb XML 0 December 16th, 2003 12:38 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.