How can I see warnings from Oracle 10g?
Posted on 2012-09-18
I am trying to implement a simple user defined function. The function will return one custom defined row for a set of parameters. I have the custom type and tables being set up already, no problems. I can see that the function is compiling with warnings, but I cannot see the warning to aid me in correcting the issue. I am using SQL Developer as the query tool while I try to implement this function. I have tried going into preferences and turning the information all the way up. This is what it tells me.
FUNCTION AgentCodesAndStatus compiled
Warning: execution completed with warning
I also did Some Googling and tried
it tells me:
unknown SHOW option "warnings\g"
Any help would be appreciated.