OraFAQ Forum: SQL & PL/SQL » ORA-20120:ORA-01405:fetched column value is null

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-20120:ORA-01405:fetched column value is null (toad)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-20120:ORA-01405:fetched column value is null [message #603329]

Fri, 13 December 2013 06:58

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

Report message to a moderator

Re: ORA-20120:ORA-01405:fetched column value is null [message #603337 is a reply to message #603329]

Fri, 13 December 2013 08:54

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.

Report message to a moderator

Re: ORA-20120:ORA-01405:fetched column value is null [message #603339 is a reply to message #603337]

Fri, 13 December 2013 09:02

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/

Report message to a moderator

Re: ORA-20120:ORA-01405:fetched column value is null [message #603343 is a reply to message #603329]

Fri, 13 December 2013 10:10

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 22 22:55:56 CDT 2025