We have Java stored procedure in Oracle that make calls to functions offered by Oracle Spatial to perform spatial analysis and return results. I am looking to the same in PostGIS, is this possible?
Yes, of course, through JDBC. See the PostGIS manual for JDBC clients. You can even build custom spatial functions on the server that can be used through JDBC.