Home » SQL & PL/SQL » SQL & PL/SQL » 6502 PL/SQL: numeroc or value error
6502 PL/SQL: numeroc or value error [message #1830] Mon, 03 June 2002 05:13 Go to next message
Anthony
Messages: 48
Registered: September 2000
Member
Hi, I´ve done a search to see if these problem has occurred before on these pages, it has, but the q. wasn´t really answered enough to satisfy my query.

I have a varchar2(6000) which I am processing in a while loop (I want to replace '#' with '/#' under certain conditions).

An error is being thrown up at this line

a_lng_var := substr(a_lng_var,1, v_place_count-1)||'/'||substr(a_lng_var,v_place_count);

The message in the oracle manual for 6502 doesn´t see to make much sense either.

TIA

Anthony

Report message to a moderator

Re: 6502 PL/SQL: numeroc or value error [message #1866 is a reply to message #1830] Thu, 06 June 2002 02:23 Go to previous message
Thiyagarajan
Messages: 9
Registered: October 2000
Junior Member
Hai,

Could u pls. post the whole code?

The error could result if u are not refreshing the value of a_lng_var each time in the loop.

Alternatively, u can try the REPLACE command.

Report message to a moderator

Previous Topic: Re: Verifying if the data(one row) fulfilling a select criteria exists in the table or not
Next Topic: heu....help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 14:46:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.