Forum OpenACS Development: Re: [OACS 5.10.0] permission::permission_p_not_cached

7: Re: [OACS 5.10.0] permission::permission_p_not_cached - Changed from returning integer to char (response to 2)

Posted by Brian Fenton on 06/07/23 11:09 AM

Hi,

since release 23c Oracle now supports the SQL boolean data type. Better late than never I suppose!

https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/Data-Types.html#GUID-285FFCA8-390D-4FA9-9A51-47B84EF5F83A

Brian

8: Re: [OACS 5.10.0] permission::permission_p_not_cached - Changed from returning integer to char (response to 7)

Posted by Gustaf Neumann on 06/07/23 02:53 PM

Brian, many thanks for the info. Good to know!

Oracle 23c is available since a couple of months. From my experience, Oracle users of OpenACS belong to the most conservative ones when it comes to updates. Forcing those to upgrade won't be an option (especially, when the database is not only used for OpenACS).

It is possible with the .xql files to write different code for newer and older Oracle versions, but this makes testing even harder... So, it will take still a while until we can converge in this respect.

Brian, has your company already upgraded to Oracle 23c?

9: Re: [OACS 5.10.0] permission::permission_p_not_cached - Changed from returning integer to char (response to 8)

Posted by Brian Fenton on 06/08/23 11:13 AM

Hi Gustaf

no, it will be a long time before we will upgrade to 23c. We have definitely been on the conservative side with doing upgrades!

Brian

Forum OpenACS Development: Re: [OACS 5.10.0] permission::permission_p_not_cached - Changed from returning integer to char