Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how can i check if a procedure exists in a certain database version

926122May 17 2012 — edited May 18 2012
So today i became really frustrated after noticing that the Oracle SQL version on some computer I needed to work on was 10.1. The problem with that was that I needed a procedure called "xmlserialize". I browsed the documentation for it, but I didn't see anything like "since 11.0" or something similar.

So.. how can I see what is the first Oracle SQL version that supported some procedure?

For example, when I check a class definition for Java, I consult the javadoc :

http://docs.oracle.com/javase/7/docs/api/java/math/BigInteger.html

and there there's a field called "Since". For BigInteger ( it's just an example ), it says "Since: JDK1.1", so I know that if I'm using a JDK version earlier that 1.1, I won't have that class.

Is there some similar information for Oracle procedures/ functions/ features/ etc?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2012
Added on May 17 2012
6 comments
738 views