KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm writing a procedure, and i need to check whether my select query returned an empty record or not. (In this example whether there is no x,y shelf) How can i do that? I tried this: temp shelves.loadability%TYPE := NULL; BEGIN select loadability into temp from shelves where rownumber = x and columnnumber = y; IF temp IS NOT NULL THEN /* do something when it's not empty */ ELSE /* do the other thing when it's empty */ END IF; But the second branch of the if never works... EDIT: Oh, it was so easy... temp shelves.loadability%TYPE; BEGIN select count(*) into temp from shelves where rownumber = x and columnnumber = y; IF temp != 0 THEN /* do something when it's not empty */ ELSE /* do the other thing when it's empty */ END IF; END;
Tags (comma-separated)
Save Edits
Cancel