Skip to Main Content

Live 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!

Version/compatibility problem in LiveSQL V2

user7111641Sep 13 2025

Hello All,

The current database version of LiveSQL V2 is 23.8.0.25.04 .

However, it looks like the value of the COMPATIBLE parameter is NOT set accordingly.

Currently I cannot check the value of COMPATBLE, because using DBMS_UTILITY.GET_PARAMETER_VALUE fails dues to missing privileges, while “SHOW PARAMETER COMPATIBLE” returns error “Show parameters query failed”.

But, when I try to use features introduced with version 23.6 ( like SPARSE vectors ), I get an error:

create table my_vectors( v vector(3, int8, sparse) )
/

ORA-00406: COMPATIBLE parameter needs to be 23.6.0.0.0 or greater
ORA-00722: Feature "SQL VECTOR SPARSE format"

Thanks a lot in advance for your help !
Best Regards,
Iudith Mentzel

Comments
Post Details
Added on Sep 13 2025
0 comments
28 views