Skip to main content

The Cool Fox

Oracle Cloud Technologies Blog

Home
Site Map
Oracle OCI
Oracle OIC
Oracle VBCS
Oracle Fusion
Oracle VBS
Oracle ADF
Oracle SOA
Oracle Apps
Oracle OAF
Oracle SQL

Showing posts with the label Oracle DB

Posts

[SQL] ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes

on January 20, 2025

Database Oracle Oracle DB

+

Get link
Facebook
X
Pinterest
Email
Other Apps

All Categories

Account Hierarchy1 Accounting Flexfields1 API2 ASCII1 BIP6 BIP Refresh Time1 BIP Report1 Call Fusion BIP Report2 Change Password1 Code Combinations2

Compute Instance1 Database2 Date Conversion1 DB Adapter2 Development1 EBS3 ESS Jobs3 Examine1 FBDI3 Fusion BIP2 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 NVL2 NVL in OIC2 OCI4 OCI Compute2 OCI Events Service1 OCI Free Tier2 OCI Notifification Service1 OIC2 OIC Mapper2 Oracle12 Oracle ADF17 Oracle APEX1 Oracle Apps57 Oracle Apps R124 Oracle BIP5 Oracle Cloud7 Oracle Cloud Free Tier1 Oracle cloud Infrastructure4 Oracle Cloud Security1 Oracle Cloud VM1 Oracle DB1 oracle ebs3 Oracle ERP1 Oracle ERP Adapter2 Oracle ERP Cloud6 Oracle financials2 Oracle Forms1 Oracle Fusion45 Oracle Fusion BIP1 Oracle Fusion ERP10 Oracle Fusion Financials10 Oracle Integration Cloud3 Oracle OAF16 Oracle OCI9 Oracle OIC20 Oracle SOA 12c10 Oracle SQL9 Oracle VBCS1 Oracle VBS2 Oracle Visual Builder Cloud Service1 Oracle Visual Builder Studio2 Oracle Workflow Notifications1 Others10 Properties1 R121 Register BIP as ESS Job1 Reset Password1 Responsibility1 REST2 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL7 SQL Queries6 SQL Query2 SSH1 Value Sets1 VBCS1 Virtual Machine1 Virtual Machines1 XML1 XSLT1

Show more Show less

Gurpreet Singh - Oracle ACE.

Total Pageviews

Search This Blog

Popular Posts

Fix java.lang.OutOfMemory Java Heap Space error in JDeveloper

Why out-of-memory error is thrown? Permanent Generation: The Permanent Generation is where class files are kept. These are the result of compiled classes and JSP pages. If this space is full, it triggers a Full Garbage Collection. If the Full Garbage Collection cannot clean out old unreferenced classes and there is no room left to expand the Permanent Space, an Out‐of‐ Memory error (OOME) is thrown and the JVM will crash. There are three basic JVM command switches that control the amount of memory in the Java heap. -XX:Xms -XX:Xmx -XX:MaxPermSize -XX:Xms used to set memory available to JVM initially. -XX:Xms used to set maximum amount of memory into which the JVM can grow . -XX:MaxPermSize are used to set size for Permanent Generation. Fixing out-of-memory error Find the location of Oracle Middleware Home. Click here to see Navigate to the location: <Oracle_Middleware_Home_Location> \ jdev\bin and open the file jdev.c...

[OIC] Trigger OIC REST Integration from Oracle Fusion BIP Report

In this post we will see how to trigger the OIC REST Integration from Oracle Fusion BIP Report. Prerequisites: Access to OIC Console to create integration. Make sure you have ServiceDeveloper or ServiceAdministrator access. OIC REST Integration which can be invoked by using Basic Authentication. Make sure you have one generic OIC user which can be used to setup OIC Connection in Oracle Fusion BIP. For this generic user we need to have username and password available and it should not be SSO user, i.e. it should be of type non-federated account. Access to Oracle Fusion BIP with Admin access to add new data sources, i.e. user must have BI Administrator Role Steps: Create an OIC REST Based Integration with Parameters and which returns XML type response. Create a Data Source for OIC Integration instance in which you need to put hostname of OIC Intance and generic user credentials Create an Oracle Fusion BIP Report with XML Feed type data set to trigger the integrat...

Clearing Oracle JDeveloper temp and cache directory with hotkeys

Oracle JDeveloper keeps on creating temp, cache and history files. So as a best practice to boost up your JDeveloper performance keep deleting the files frequently. Every time you can't go these directories to manually delete the files, so you can assign hotkeys to perform this delete operation. Follow the below steps to setup hotkeys: Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto Help -> About -> Properties Tab and search for ide.system.dir this is system directory In the system directory, there are two directories which need to be cleaned: .diagnostics and .history Now create the following batch file (.bat) with above-copied directories....

Use Fast Swap feature in Oracle Jdeveloper to speed up the development

You can use Fast Swap feature in Oracle Jdeveloper to speed up the development. To enable this feature use the below steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. Click Run -> Weblogic and select Fast Swap radio button.

Changing preference to open pages in Source View instead of Design View in Oracle jDeveloper

Whenever we open files like JSP Page Fragments, JSP Pages, HTML code, etc. they always open in Design view instead of source code which makes large files or files with many components to load slower. So, do we have any way which enables Jdeveloper to open files directly in Source Code view instead of opening the Design editor? Yes, we can change this default setting. To change this setting follow these steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. In files Files Types section, switch to Default Editors Tab. Select the file type for which you want to change the default editor and then change the editor from Default Editor drop down at the bottom. For example, here we have changed the default editor of JSP Source file type to Source. So from now whenever you open any file of type JSP Source, JDeveloper will open its source code instead of design view.

Powered by Blogger

All rights reserved