Home » SQL & PL/SQL » SQL & PL/SQL » ORA-20120:ORA-01405:fetched column value is null (toad)
ORA-20120:ORA-01405:fetched column value is null [message #603329] Fri, 13 December 2013 06:58 Go to next message
sravanim
Messages: 1
Registered: December 2013
Location: chennai
Junior Member
In toad i have written selet query to retrive the data from a table but i got the below error message


ORA-20120:ORA-01405:fetched column value is null
ORA-06512:at "Table Name",line number

Please assist me to resolve the error
Re: ORA-20120:ORA-01405:fetched column value is null [message #603337 is a reply to message #603329] Fri, 13 December 2013 08:54 Go to previous messageGo to next message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
Have a look at this link.

I think you can adjust your code with that information.
Re: ORA-20120:ORA-01405:fetched column value is null [message #603339 is a reply to message #603337] Fri, 13 December 2013 09:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: ORA-20120:ORA-01405:fetched column value is null [message #603343 is a reply to message #603329] Fri, 13 December 2013 10:10 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Obviously you call a function in your query and this function contains a WHEN OTHERS clause.
Remove this clause, re-execute and post the whole query and function code.

Previous Topic: num_rows blank
Next Topic: PLS-00103: Encountered the symbol "end-of-file" ...
Goto Forum:
  


Current Time: Thu Mar 28 17:07:35 CDT 2024