1 Reply Latest reply on Oct 12, 2012 7:15 AM by Nicolas.Gasparotto

    Re: PeopleSoft returns an ORA-1858 error msg when retrieving a VARCHAR(30)  Fld

      Have received a similar error - created a view utilizing a dblink - six fields - 4 from dblink and 2 from local database. The view and data is accessible thru PL/SQL Developer with no errors. When attempting to access thru a page/component utilizing the view in peoplecode, receive the same error. Error Return: 1858 - ORA-01858: a non-numeric character was found where a numeric was expected ORA-02063: preceding line from ORA_FIN_EBIZ. Our other dblinks see to work successfully, except this one. Has anyone responded at this time?