Oracel BRM: How to query the BLOB columns

 In BRM, there are very few tables which stores data in the BLOB format, Invoice_Formats_Buf_t is one among them. The following query helps to search for a particular string in the BLOB column.

SELECT *
FROM Invoice_formats_buf_t
WHERE INSTR(
    UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(buffer_buf, 4000, 1)),
    'your_search_string'
) > 0;

Comments

Post a Comment

Popular posts from this blog

Oracle BRM: Some Important Utilities

  Refer to the oracle documentation for the complete description of each utility. The knowledge of these utilities helps developers when to utilize them effectively and how these configurations change the behavior of BRM. Note: The following are the most used utilities, there are plenty other utilities as well. So, it is always better to revise the online documentation for the complete list of utilities. load_pin_beid -v pin_beid -  Documentation Link load_pin_rum -v pin_rum -  Documentation Link load_pin_ach -v pin_ach  load_pin_notify -v pin_notify pin_bus_params -v bus_params_billing.xml pin_bus_params -v bus_params_AR.xml pin_bus_params -v bus_params_customer.xml pin_bus_params -v bus_params_subscription.xml pin_bus_params -v bus_params_rating.xml pin_bus_params -v bus_params_Invoicing.xml load_config_provisioning_tags -dv pin_config_provisioning_tags.xml load_pin_billing_segment -dv pin_billing_segment.xml load_pin_bill_suppression -dv pin_bill_suppression.xml l...
Read more

Oracle BRM: Learn step by step by following youtube channel

 It is the age of learning based on pictures and videos. https://youtube.com/shorts/vX6x-bFw62k 🚀 Welcome to the Oracle BRM Mastery Series! 🚀 Are you ready to dive into the world of Oracle Billing and Revenue Management like never before? You've stumbled upon a goldmine! 🌟 This channel is the FIRST of its kind, offering hands-on Oracle BRM training that you won't find anywhere else. From zero to hero, we're taking you on an unparalleled journey through Oracle BRM, all within a Linux VM environment, crafted from scratch. 🔍 Nowhere else on the internet will you find such a dedicated series to hands-on Oracle BRM training. We're here to transform you from a curious learner to a BRM wizard, armed with knowledge and skills to conquer the demanding telecommunications BSS space. What's in Store for You? Prepare to embark on a series of meticulously crafted videos, each forming a piece of the Oracle BRM puzzle. Our playlist will serve as your roadmap, guiding you th...
Read more

Oracle BRM: Utilize the BRM's MTA framework to use a file instead of searching the database

The BRM MTA's framework supports three search options:  Search for objects stored in the BRM database Search for objects stored in a file Passing objects directly to the search opcode. You specify the search option in the PIN_FLD_SEARCH_FLIST substruct in the global flist. To search for objects in a file, you specify the name of the file where the objects are stored. For example: 0 PIN_FLD_SEARCH_FLIST    SUBSTRUCT [0]  1     PIN_FLD_FILENAME          STR [0] "file name"  1    PIN_FLD_COUNT             INT [0] 2  Important: The file specified in PIN_FLD_FILENAME  must  be a text file and  must  have the same format as the search results flist. The following is an example of the text file: 0 PIN_FLD_RESULTS          ARRAY [0]  1    PIN_FLD_ACCOUNT_OBJ       POID [0] "/account" 123 0  0 PIN_FLD_RESULTS...
Read more