I have made the function like here
Development and Deployment of a .NET Stored Function Demo (0 Bytes)Tried to deploy via VS2019 Oracle Deployment Wizard but it cannot connect to the Oracle 21c XE server.
That's why I do manually:
Copied all dlls from myproject\bin\Release\x64 to ORACLEServer: m:\app\user\product\21c\dbhomexe\bin\clr
Execute in SQL Developer
CREATE OR REPLACE LIBRARY PROJECT1_DLL AS '$ORACLE_HOME\bin\clr\Project1.dll';
-- OK
GRANT EXECUTE ON PROJECT1_DLL TO SCART;
-- OK
GRANT EXECUTE ON SYS.DBMS_CLR TO SCART;
GRANT EXECUTE ON DBMS_CLRTYPE TO PUBLIC;
GRANT EXECUTE ON DBMS_CLRPARAMTABLE TO PUBLIC;
-- these 3 were not found
CREATE OR REPLACE FUNCTION SCART.GETMENGEVIAID(LOGID BINARY_INTEGER) RETURN BINARY_INTEGER;
--
0/0 PLS-00378: invalid compilation unit for this release of PL/SQL
Errors: check compiler log
What is incorrect? How to fix?