Re: Pls save me

tnx ron will do tht asap.

Regards,
Dexter.

"Ron" <support_at_dbainfopower.com> wrote in message news:<QoGdne03bbIMOq_dRVn-ug_at_comcast.com>...
> Hello Dexter,
>
> If you can, please, open Oracle TAR (or ask DBA to open it) on this
> issue.
>
> Get DBAs help to research metalink as well (search for Bug 2765286).
>
> If this impacting production - open it as sev 1. to get fast response.
>
> From what I can see, you may need DBAs help to apply recommended patch
> set.
>
> Also, for bulk operations across db_links - please, check if both
> databases are at the same Oracle version (9i-9i) - check with Oracle on this
> as well (metalink Note:198842.1).
>
> Regards,
>
> Ron
> DBA Infopower
> http://www.dbainfopower.com
> Standard disclaimer:
> http://www.dbainfopower.com/dbaip_advice_disclaimer.html
>
>
>
>
> "Dexter" <dexter_at_rec-all.com> wrote in message
> news:607d10e1.0402160619.655a0ea3_at_posting.google.com...
> > Thanks ron, you r my saviour man,
> >
> > this is the version i'm using.
> >
> > SQL> select * from v$version
> > 2 ;
> >
> > BANNER
> > ----------------------------------------------------------------
> > Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
> > PL/SQL Release 9.2.0.2.0 - Production
> > CORE 9.2.0.2.0 Production
> > TNS for Solaris: Version 9.2.0.2.0 - Production
> > NLSRTL Version 9.2.0.2.0 - Production
> >
> > Bullseye i'm using DBlinks those tables are all remote table in some other
 server.
> >
> > Please get back to me with wat i need to do to resolve this problems.
> >
> > Thanks,
> > Dexter.
> >
> > "Ron" <support_at_dbainfopower.com> wrote in message
 news:<2eednZMMs_EWPrLdRVn-ug_at_comcast.com>...
> > > Hello Dexter,
> > >
> > > 1. Please check and post oracle version - there are some related bugs
 that
> > > were fixed in Patch Sets -
> > >
> > > ( on metalink look for articles like this one : 9.2.0.3 Patch Set -
 List
> > > of Bug Fixes by Problem Type)
> > >
> > > 2. Can you please check if this is a local table or remote table
> > >
> > > Example:
> > > select DB_LINK from all_synonyms where synonym_name =
 '<table_name>';
> > >
> > > There are some bugs related to bulk inserts across db_links.
> > >
> > > Please, let us know.
> > >
> > >
> > > Regards,
> > >
> > > Ron
> > > DBA Infopower
> > > http://www.dbainfopower.com
> > > Standard disclaimer:
> > > http://www.dbainfopower.com/dbaip_advice_disclaimer.html
> > >
> > >
> > >
> > > "Dexter" <dexter_at_rec-all.com> wrote in message
> > > news:607d10e1.0402150723.5f7c861a_at_posting.google.com...
> > > > Hi,
> > > >
> > > > I have a pro*c program that inserts records into a table from another
> > > > table.This was working fine until i recently upgrade from 8i to 9i.
> > > >
> > > > Now the problem is it errors out frequently with ora-1400 (cannot
> > > > insert NULL...) or 0ra-1458 (length inside Variable character...) But
> > > > when i rerun it it goes fine, for the same records!!! I'm not able to
> > > > predict its behavior.
> > > >
> > > > When i change the code to do row by row insert instead of a bulk
> > > > insert it goes fine without any problem.
> > > >
> > > > Can anybody explain way this is happening? You could be my saviour...
> > > >
> > > > Code snippet:
> > > > This errors out unpredictably..
> > > >
> > > > EXEC SQL FOR :counter
> > > > INSERT INTO TMP1 (
> > > > a,
> > > > b,
> > > > c,
> > > > d,
> > > > e,
> > > > f,
> > > > g,
> > > > h,
> > > > j,
> > > > k,
> > > > l,
> > > > VALUES (
> > > > TO_NUMBER(Id)
> > > > ,:Key
> > > > ,c1
> > > > ,d1
> > > > ,e1
> > > > ,SYSDATE
> > > > ,g1
> > > > ,SYSDATE
> > > > ,i1
> > > > ,SYSDATE
> > > > ,h1
> > > >
> > > >
> > > > When i change it to th following it works fine...
> > > >
> > > > for(i=0;i<counter;i++)
> > > > {
> > > > EXEC SQL INSERT INTO TMP1 (
> > > > a,
> > > > b,
> > > > c,
> > > > d,
> > > > e,
> > > > f,
> > > > g,
> > > > h,
> > > > j,
> > > > k,
> > > > l,
> > > > VALUES (
> > > > TO_NUMBER(Id)
> > > > ,:Key
> > > > ,c1
> > > > ,d1
> > > > ,e1
> > > > ,SYSDATE
> > > > ,g1
> > > > ,SYSDATE
> > > > ,i1
> > > > ,SYSDATE
> > > > ,h1
> > > >
> > > > }
> > > >
> > > > Thanks,
> > > > Dexter
Received on Wed Feb 18 2004 - 12:21:31 CET