I can't find any documentation to justify my findings. While the error codes may have been useless to you, it is quite possible that someone else has seen them before and knows what they mean. We are using these methods throughout our code, and it has worked fine in 7. So I suspect there is something else at play here. I have found the cause of our problem is what appears to be a tightened restriction enforced in 10g. Our application has many procedures upgraded from 8i to 9i, and now to 10g.
The code that was working in both 8i and 9i is now raising the error "variable not in select list" in 10g. I have been able to duplicate the issue, comparing 9i to 10g, and we now understand the issue and the areas that need review and correction.
Thanks for the responses. Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Close Box. Log In Come Join Us! Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. Thanks for your answer. Is that the only way to check a if a record is null? It's weird to me that we can assign null to a record, but can't check if a record is null.
Good workaround! I use assignment of NULL to record and this is the way to make check! Instead why not just raise an exception when there's no data there: I realise that the others in the exception is highly naughty but it'll only really catch my table disappearing when it shouldn't and nothing else. Ben Ben Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. October 18, - am UTC. Tom I'm trying to pass table rowtype as a parameter for a record construction. Is there a way to do this? Thanks a lot. March 15, - am UTC. Your plsql code between the begin and end would not be able to access it!!
Now, what could your code between begin and end do???? So, let us step back for a minute, instead of asking "how do I do something", why don't you tell us "what I am trying to do is My idea of implementing a generic procedure to handle any table was foolish. It can not be done in this way too generic..
Many thanks a lot for your input. Hi Tom, Tried a lot but still nothing. Also, the result should be in appropriate order like name,id,value. I have to ensure that the code works fine when column order changes. Many Thanks Amit. April 28, - am UTC. That way, you cannot go wrong on the fetch. Hi, i'm thinking of using the technique you have presented to get the values of a rowtype object. My question is, wether setting the rowtype to a public variable in the packege may cause problems with concurrency between sessions or users.
What happens if other executions overwrite the public value before the reading the first one?. October 25, - pm UTC. You don't expect your global variables in java to be overwritten by other processes - database sessions are like processes. You have your own data segment. Sri, November 03, - am UTC. To maintain the versions, in each and every table a new not null field but with a default value was decided to be added not my idea!
0コメント