salut,

am si eu eroarea asta:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'OraOLEDB.Oracle' reported an error. The provider reported an unexpected catastrophic failure.
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' ICommandText::Execute returned 0x8000ffff: The provider reported an unexpected catastrophic failure.].

are cineva idee cum se poate rezolva...de ceva ore bune tot bat netul si nu gasesc nici o solutie?!?!?!?!

toutl se intampla cand rulez asta:

select @SqlString=N'insert into #temp_ld select ID, COMMITMENTNO, LCUTYPE,
CUSTOMERID ,
convert(money, substring(AMOUNT, 5, len(AMOUNT)-9 )) ,
convert(money, COMMTAVAILAMT) ,
CURRENCY,
VALUEDATE ,
FINMATDATE ,
DDENDDATE,
convert(money, substring(AMOUNT, 5, len(AMOUNT)-9 )) - convert(money, COMMTAVAILAMT) ,
CATEGORY, CONDSPECLD, DRAWDOWNISSUEPR, substring(left(LOANAMOUNT, len(LOANAMOUNT)- 7), 14, len(LOANAMOUNT)- 7) as LOANAMOUNT,
INTRATETYPE, INTERESTRATE, FIRSTVARINT, CUSTOMERSPREAD, substring(left(SCRIPTICNO, len(SCRIPTICNO)- 7), 14, len(SCRIPTICNO)- 7), substring(left(CALCTYPE, len(CALCTYPE)- 7), 14, len(CALCTYPE)- 7) AS CALCTYPE, STATUS
from OPENQUERY(ORADEV,''select * from VWIREP_BAG_LD where CUSTOMERID = ''''' + @ClientId + ''''''') where len(ID) = 12 and STATUS != ''LIQ'''

multumesc.

alex.