It seems like the IBM tools (Rational Software Architect & Rational Application Developer) aren’t very good at communicating with an Oracle database. I’m in the ‘Data’ view, attempting to create a stored procedure. When I ‘CREATE’ the procedure, I was getting warnings but no message about what the warning/error actually was. I fought with the tool for a little while before giving up and installing Oracle SQL Developer which immediately showed me the error.
It turns out my errors were due to syntax.
Update: I just wanted to add that I was also unable to see any of my stored procedures in the database explorer view.