Posts

Showing posts from 2024

How many Debug Groovy Script Methods are available in Application Composer

  ----====================================================================== ******* How many Debug Groovy Script Methods are available in Application Composer ******* --====================================================================== 1. Runtime messaging 2. Put Oracle JBO validation in Groovy Script Palet ex:-  -1.--Simple Validation Message Script:--- throw new oracle.jbo.ValidationException("You don't have sufficient privileges to update the record.") // You can replace the custom message here. and you can make it dynamic with variables or fields. -2.--Multi-Line Validation Messages with less space:--- throw new oracle.jbo.ValidationException( "<html><body> <p>The Errors are listed below:  <br> You have insufficient priviliges  <br> You have entered invalid value in Status filed </p> </body></html>") -3.--Multi-Line Validation Messages with more space:--- throw new oracle.jbo.ValidationException(" ...

Understanding About Object Creation with same name | Object Overloading in PLSQL

  -- FIRST Session  =================================== XXSD_TEST_FUN(PAR_1) XXSD_TEST_FUN(PAR_1,PAR_2) XXSD_TEST_FUN(PAR_1,PAR_1_2,PAR_3) --======================================= can we create DB Object with same name  ?  how to use whenever it is required ? --======================================= ---======  TABLE --========== select * from XXMK_TEST create table XXMK_TEST ( EMPID NUMBER, EMPNAME VARCHAR2(100) ) create table XXSD.XXMK_TEST ( EMPID NUMBER, EMPNAME VARCHAR2(100) ) create table XXMK_TEST ( EMPID NUMBER ) create table XXSD.XXMK_TEST ( EMPID NUMBER ) select * from all_objects  where object_name = 'XXMK_TEST'  edit  XXMK_TEST select * from XXMK_TEST edit  XXSD.XXMK_TEST select * from XXSD.XXMK_TEST ---======  VIEW--========== create or replace view  XXMK_TEST as  select * from  APPS.XXMK_TEST create or replace view  XXSD.XXMK_TEST as  select * from  APPS.XXMK_TEST create or replace view  ...