Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error ORA-20100 during a function execution

User_L3ELOJan 28 2022

I have created a small NET function , then deployed it. Ok
When I execute it
select GETMENGEVIAID(2) from dual;
----------
ORA-20100: ODE-00006: AppDomain could not be created for the specified security level
ORA-06512: at "SYSTEM.DBMS_CLR", line 152
ORA-06512: at "SYSTEM.DBMS_CLR", line 42
ORA-06512: at "SYSTEM.DBMS_CLR", line 145
ORA-06512: at "SCART.GETMENGEVIAID", line 7
------
What is the reason?
How to fix it?

Comments

Billy Verreynne

This is an Oracle E-Business Suite error in its ODE module.
This is an application layer exception - not database.

User_L3ELO

Ok, and how to detect and fix it? What are these line numbers?

Billy Verreynne

The line numbers are source code references to the PL/SQL call stack at the time that the exception was raised.
The actual source code is likely obfuscated (encoded) via PL/SQL engine wrapping. As it is vendor code, there is nothing you can do to "fix" this code.
The error message indicates however that the issue is very likely on your side - an E-Business authorisation error of sorts where it seems your E-Business client session lacks privilege to successfully execute E-Business server code.
More than this, I don't know. Have never used E-Business.

User_L3ELO

Can anybody help to fix it?

Alex.UA

You might want to choose “unsafe” security level

Check the documentation Step 3: Choose the Function to Deploy
and some specific examples here https://forums.oracle.com/ords/apexds/post/net-sp-error-oraxe-11g-on-win10-9627

1 - 5

Post Details

Added on Jan 28 2022
#function, #net-stored-procedures, #windows-and-net
5 comments
831 views