Im having some problems with the upgrade of oacs4.6.3 with an oracle DB. First I would like to know if the .sql files that I need to run for oracle are the same that are in the documentation for upgrading in postgresql?
If so, there are a couple ones that are not in the acs-kernel/sql/oracle/upgrade directory
this are:
upgrade-5.0d11-5.0d12.sql
upgrade-5.0.0a4-5.0.0a5.sql
I make the equivalent oracle file for upgrade-5.0d11-5.0d12.sql but for the second one Im having some troubles, I dont now what does the varbit type means (if is a data type) and how I can translate it to oracle.
The script creates this to functions:
------------------------------------------------------------
create or replace function tree_left(varbit) returns varbit as '
-- Create a key less than or equal to that of any child of the
-- current key.
declare
key alias for $1;
begin
if key is null then
return ''X00''::varbit;
else
return key || ''X00''::varbit;
end if;
end;' language 'plpgsql' with(iscachable);
create or replace function tree_right(varbit) returns varbit as '
-- Create a key greater or equal to that of any child of the current key.
-- Used in BETWEEN expressions to select the subtree rooted at the given
-- key.
declare
key alias for $1;
begin
if key is null then
return ''XFFFFFFFF''::varbit;
else
return key || ''XFFFFFFFF''::varbit;
end if;
end;' language 'plpgsql' with(iscachable);
-------------------------------------------------------------
If someone can help me to translate it or give me some pointers in orther to upgrade oacs in oracle I will be apreciate it a lot.
