Re: Problem while migrating data with Memo content from VFP to Oracle

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alan C. Sheffield (_at_)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 09:57:39 -0400

What data type are you using on the oracle side to hold the memo data?
What data type is VFP mapping that to when it creates the remote view?

I did a huge project moving data from VFP 6 to oracle a few years ago and
all fo my problems could be traced back to how the field data types were
setup.

Alan

"Anand" <anandrkashyab@hotmail.com> wrote in message
news:enr53FLkEHA.3456@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I have written a tool to migrate tables from VFP 7.0 to Oracle 9.2.0.1.0.
>
> I do this with Oracle ODBC Driver 9.2.0.5.0.
>
> The tool will initially build "INSERT INTO" statements that execute in
> Oracle using SQLEXEC() in VFP and thus create the structures.
>
> For migrating the data, I open the empty table created in Oracle through
> Visual FoxPro using SQLEXEC() and set required properties to this remote
> view.
>
> I then issue 'APPEND FROM <<table name>>'. Here is where I get an error
on
> tables that have Memo fields in it.
>
> Again, this issue does not remain consistent with all tables with Memo
> fields.
>
> Some tables get migrated with Memo content while some don't.
>
> And the error message that Oracle throws to VFP also is not consistent.
>
> I get anyone of the following errors on a random basis.
>
> ORA-01747: Invalid user.table.column, table.column, or column
specification.
>
> ORA-24306: bad buffer for piece.
>
> ORA-24081: illegal parameter value in OCI lob function.
>
> Do you know how to fix this?
>
> Regards,
>
> Anand.
>
>

Relevant Pages

  • Re: Problem while migrating data with Memo content from VFP to Oracle
    ... I am using CLOB in Oracle to hold Memo data of VFP. ... Long because I have more than one Memo field in my tables. ... VFP automatically maps CLOB to Memo when interfaced through remote views. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Problem while migrating data with Memo content from VFP to Oracle
    ... If this proves to be a difficult problem, I'd look into migrating the data ... BTW, later cersions of VFP have to kinds of Memo, ordinary and Binary. ... > Oracle using SQLEXECin VFP and thus create the structures. ...
    (microsoft.public.fox.programmer.exchange)
  • Problem while migrating data with Memo content from VFP to Oracle
    ... I have written a tool to migrate tables from VFP 7.0 to Oracle 9.2.0.1.0. ... this issue does not remain consistent with all tables with Memo ... And the error message that Oracle throws to VFP also is not consistent. ...
    (microsoft.public.fox.programmer.exchange)
  • MS Access ODBC to Oracle DB- data type misread
    ... I have an Access DB connecting via ODBC to an Oracle database and it is ... reading several of the data types as "Memo". ... Access will not allow me to join on memo data type ... fields and of course will not allow me to change the data type. ...
    (microsoft.public.data.odbc)
  • RE: Multiple database(datasource) updation using single datagridvi
    ... foxpro database at a time, but here both database structures are different, ... possible to solve through some relations between Oracle DATATABLE and VFP ... Datatable, (but oracle datatable is bound to the datagridview), now how can ...
    (microsoft.public.windows.group_policy)