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 September 28th, 2004, 11:19 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Oracle problem

Hi everyone,

I have an Oracle data write question. I want to write some information to an Oracle 8.1.7 database, as per the code below.

When I call test() - the information written to the table is corrupt.

Its a VB6 program, running under WinXp. Can anyone suggest a way of resolving this problem - any help would be much appreciated!

Thanks,
Jon.

Code:
-----

Public Sub test()

Dim dynaX As Object
Dim odoSesX As Object
Dim odoDbX As Object

Set odoSesX = CreateObject("OracleInProcServer.XORASession")
Set odoDbX = odoSesCLT.OpenDatabase("DEVX", "DEVXUSRNM" & "/" & "DEVXPWD", 1)

Set dynaX = odoDbX.CreateDynaset("select * from table_x where status_ind = 'x'", 0)

dynaX.MoveFirst

odoSesX.BeginTrans
dynaX.Edit
dynaX("brand_code") = "TEST"
dynaX("id_num") = "123456"

dynaX.Update
odoSesX.CommitTrans

End Sub
__________________
Jon Buckham





Similar Threads
Thread Thread Starter Forum Replies Last Post
oracle log on problem Hafiz Muhammad Mushtaq Oracle 1 October 18th, 2007 08:24 AM
weird Oracle problem! pankaj_daga Oracle 2 July 12th, 2004 09:33 PM
oracle problem cs02wyw Oracle 1 May 28th, 2004 05:16 AM
oracle Date Problem haahoou Oracle 0 January 19th, 2004 05:43 AM
Problem with Oracle provider ohanus Classic ASP Databases 0 September 9th, 2003 09:48 AM





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