Posts

Showing posts from June, 2024

Process to Insert Image into table BLOB column

Process to Insert Image into table BLOB column create  table testr13 (col1 blob); / select * from testr13; / create DIRECTORY testr13 as '\Rehman\Training\My docs'; / DECLARE     l_bfile BFILE;     l_blob  BLOB; BEGIN     -- Initialize the BLOB column     INSERT INTO testr13 (col1)     VALUES (EMPTY_BLOB())     RETURNING col1 INTO l_blob;     -- Specify the location of the image file     l_bfile := BFILENAME('XX_SHAREPOINT_TEST', 'm.jpg');     -- Open the BFILE     DBMS_LOB.fileopen(l_bfile, DBMS_LOB.file_readonly);     -- Load the BFILE data into the BLOB column     DBMS_LOB.loadfromfile(l_blob, l_bfile, DBMS_LOB.getlength(l_bfile));     -- Close the BFILE     DBMS_LOB.fileclose(l_bfile);          -- Commit the transaction     COMMIT; END; /
Post a Comment
Read more

QUERY to get DATA DEFINATION DD & DATA TEMPLATE DT Tables in apps r12

  query to get DD&DT Tables in r12  ------------------------------- select * from XDO_TEMPLATES_B where template_code = 'SITCO_PORD_RPT_V'; select * from XDO_TEMPLATES_TL where template_code = 'SITCO_PORD_RPT_V'; select * from XDO_LOBS where lob_code = 'SITCO_PORD_RPT_V'; select * from XDO_DS_DEFINITIONS_B where data_source_code = 'SITCO_PORD_RPT_V'; select * from XDO_DS_DEFINITIONS_TL where data_source_code = 'SITCO_PORD_RPT_V'; -------------------------------------------------------------------------------- script to delete DD&DT ---------------------- BEGIN DELETE FROM XDO_TEMPLATES_B WHERE template_code = 'SITCO_PORD_RPT'; DELETE FROM XDO_TEMPLATES_TL WHERE template_code = 'SITCO_PORD_RPT'; DELETE FROM XDO_LOBS WHERE lob_code = 'SITCO_PORD_RPT'; DELETE FROM XDO_DS_DEFINITIONS_B WHERE data_source_code = 'SITCO_PORD_RPT'; DELETE FROM XDO_DS_DEFINITIONS_TL WHERE data_source_code = 'SITCO_PORD_RPT';...
Post a Comment
Read more

QR code Generate From Oracle PLSQL

QR code Generate From Oracle PLSQL Here is a GITHUB link For necessary Files. https://github.com/Rehman0270/PLSQLQRcode 1) Download The required files from above link. 2) upload all jar archives in lib folder to your database  (Eample path in WINSCP to put the jar files : /u02/oracle/VIS/fs1/EBSapps/10.1.2/lib ) 3) After uploading open putty and change directory to lib folder in WINSCP and run below commands one by one cd  /u02/oracle/VIS/fs1/EBSapps/10.1.2/lib loadjava -force -genmissing -r -user username/password@database -verbose core-1.7.jar loadjava -force -genmissing -r -user username/password@database -verbose javase-1.7.jar loadjava -force -genmissing -r -user username/password@database -verbose qrgen-1.2.jar 4) Open sql developer and run this functions CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "QRCodeBean" as import oracle.sql.BLOB; import oracle.sql.*; import oracle.jdbc.driver.*; import java.sql.*; import javax.imageio.ImageIO; import java.awt.image.Buffered...
Post a Comment
Read more

how to migrate from one instance to another using FNDLOAD

How to migrate from one instance to another using FNDLOAD In the following I have discussed on how to migrate from one instance to another using FNDLOAD. Following is the list of .lct files that are used for different objects 1) Concurrent Program –> afcpprog.lct 2) Value Sets –> afffload.lct 3) Menus –> afsload.lct Download FNDLOAD apps/APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=’XXXX’ Upload FNDLOAD apps/APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt 4) Lookups –> aflvmlu.lct Download FNDLOAD apps/APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=’XXXX’ LOOKUP_TYPE=’XXXX’ Upload FNDLOAD apps/APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt 5) Flexfield –> afffload.lct Descriptive Flexfield Download FNDLOAD apps/APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX APPLICATION_S...
Post a Comment
Read more

PLSQL PROCEDURE TO CALL A REST API POST METHOD

 PLSQL PROCEDURE TO CALL A REST API POST METHOD create or replace procedure XXXCC_XXX_XXX_PROC(oredrno number) as -- varibles for running REST API   l_http_request  UTL_HTTP.req;   l_http_response UTL_HTTP.resp;   l_response_text CLOB;   l_payload       CLOB; --below 3 are non mandatroy varibales only to store data from table to paas in payload   NUM varchar2(200);   RNAME varchar2(200); BEGIN --sql query only use if you are passing values from tables into api SELECT a,b,into num,rname FROM dual where ord = oredrno; -- Create the payload l_payload := '{     "method": "add",     "data": {       "recipient_details": {         "recp_mobile": "'||NUM||'",         "recp_name": "'||RNAME||'"       },   }';   -- Initialize the HTTP request    ...
Post a Comment
Read more