Home > Default > Corrupted date and string in oracle 8.1.6 (WL 8.1)

Corrupted date and string in oracle 8.1.6 (WL 8.1)

November 30Hits:0
Advertisement
i got problem inserting some date and varchar2 column in Oracle 8.1.6, using WL
8.1 (Oracle's Driver (Thin) Versions: 8.1.7,9.0.1,9.2.0)
the date and varchar column are corrupted!

Answers

limlk wrote:
i got problem inserting some date and varchar2 column in Oracle 8.1.6, using WL
8.1 (Oracle's Driver (Thin) Versions: 8.1.7,9.0.1,9.2.0)
the date and varchar column are corrupted!Show the JDBC code.
Joe

Read other 2 answers

Tags:

Related Articles

  • Corrupted date and string in oracle 8.1.6 (WL 8.1)November 30

    i got problem inserting some date and varchar2 column in Oracle 8.1.6, using WL 8.1 (Oracle's Driver (Thin) Versions: 8.1.7,9.0.1,9.2.0) the date and varchar column are corrupted!limlk wrote: i got problem inserting some date and varchar2 column in O

  • Corrupt Data - Oracle 8i - RecoveryOctober 11

    Hello, It seems that a RAID has failed on my old server and is causing the Oracle 8i database not to start. I understand this is an old product and is no longer supported but hopefully someone has some insight. I have both the two individual data MDF

  • Converting string to oracle.jbo.domain.DateNovember 30

    Hi, I am working in jdev 11.1.1.6 I am getting date as string from UCM as string.I need to convert to oracle.jbo.domain.Date.How to achieve thisu cn do by this DateFormat formatter; java.util.Date date; if(aDate!=null){ try { formatter = new SimpleDa

  • How can i Convet String to oracle.jbo.domain.DateNovember 30

    Hi all, How can i Convet String to oracle.jbo.domain.Date ? Pls help its urgent? Thanks AmitHi Try this hope this helps.         oracle.jbo.domain.Date current_date = null;         oracle.jbo.domain.Date current_date1 = null;         String date = nu

  • Generate Insert Statement Script to Extract Data from Table in Oracle 7iOctober 11

    Hi all, I have an old Oracle legacy system that is running for over 15 years.Every now and then we need to extract data from this [email protected] ORacle 7i to be imported back to Oracle 10G. My thoughts are to create a script of Insert statements in oracle 7

  • How to Get Blob data(In String Form) using OCCIOctober 11

    Hello frnds, I am new to OCCI,so i hvnt that much of master in that side. I have one problem while handling BLOb data. How to convert binary form of SDO_GEOMETRY data into string format. I am able to convert data by using PLSQL block,but its take so

  • How to delete data before insert in oracle databaseOctober 11

    Hi friends, I have one scenario.I want to send data from sap to Oracle database.Befor i am inserting data in database table,i want to clean/delete all the records in the table .This interface will run twice in a day.Can any body help me. SAP-PI-JDBC

  • How to convert BLOB data into string format.October 11

    Hi, I have problem while converting blob data into string format. for example, Select dbms_lob.substr(c.shape.Get_wkb(),4000,1) from geotable c will get me the first 4000 byte of BLOB . When i using SQL as i did above,the max length is 4000, but i ca

  • Unable to drop materialized view with corrupted data blocksNovember 30

    Hi, The alert log of our database is giving this message Wed Jan 31 05:23:13 2007 ORACLE Instance mesh (pid = 9) - Error 1578 encountered while recovering transaction (6, 15) on object 13355. Wed Jan 31 05:23:13 2007 Errors in file /u01/app/oracle/ad

  • [OT] User-Defined string Functions  Oracle PL/SQLNovember 30

    Ladies and Gentlemen, I am pleased to offer the following string functions Oracle PL/SQL: GETALLWORDS(): Inserts the words from a string into the table. GETWORDCOUNT(): Counts the words in a string. GETWORDNUM(): Returns a specified word from a strin

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.571 s.