ATTN: OG Oracle guys

Does this seem possible?

I have a stored procedure that does a select statement that is returning a NULL and falling through to the exception.

But when I cut and paste the select into SQL and run it there, it returns the expected value.

WTF??!?!

It is the exact same select statement? How is that possible?

Funky formatting or a space before or after the code in your stored statement.

Or, you're doing it wrong.

I will go with I am doing it wrong.

Does this apply to your situation?

http://stackoverflow.com/questions/10339750/entity-framework-stored-procedure-return-value

Could be a lot of things. I remember something similar where someone had a blank line the stored procedure didn't like.

Are there any environmental variables being set when running the stored procedure? E.G. TWO_TASK or TNS_ADMIN your stored procedure could be pointing to a different DB.

this machine does not have the fix

HAVE YOU TRIED PUTTING A COVER ON YOUR TPS REPORTS?  

OK - I figured it out.

The error was kind of a red herring; the problem was way before inside the same BEGIN block, but didn't have place to error out until the exception.

Well I'm glad we could help.

You're welcome.