FromWKB() and FromWKT() should support the SRID param on Oracle

[Jacob Walls]

The source for FromWKB() and FromWKT() ​says that the srid param will be ignored on Oracle, but it ​exists on both since Oracle19c, so we should just add support.

[Jacob Walls]

​PR

[Natalia Bidart]

Thanks Jacob! Though I can't confirm that the srid param exists in Oracle 19c GA, the link you shared is for 26 I think. I tried confirming via LLMs and all I got was:

The linked docs are for 26ai. The current 19c reference (​https://docs.oracle.com/en/database/oracle/oracle-database/19/spatl/SDO_UTIL-reference.html) also lists the srid argument for both functions, but the 21c docs only show the single-argument form, which suggests it was added in a 19c release update rather than in 19c GA. Do we know the minimum 19c Release Update that supports it?

I can't tell either from the Jenkins run since the Oracle (GIS) tests have setUpClass failures. Am I missing something?

[Jacob Walls]

Good point about the support possibly missing in GA, let's ask Loïc. In other ​cases, we've just raised the minimum version to the point where we have certainty.

Loïc, would you know when the srid parameter was first available on these functions?

[Loïc LEFEVRE]

First I can tell you these srid parameters are still not present in the latest Release Update of 21c (21.23). Moreover 21c being an innovation release, do not count of having these changes provided inside 21c. Note that the support will end by 31st July 2027 and no extended support will be provided (because again this is an innovation release and not a long term release like 19c or 26ai).

I'm looking now for the precise Release Update where this was introduced in 19c...

[Loïc LEFEVRE]

The introduction of these srid parameters was done in RU 19.25.

[Jacob Walls]

Thanks. (We should probably discuss separately dropping support for 21c in Django 6.2.)

[Natalia Bidart]

Given #37391, I'm accepting this for 6.2 assuming we increase the minimum support of Oracle to 26.