2 Replies Latest reply on Jul 3, 2018 1:48 PM by Beauty_and_dBest

    How to change LONG to BLOB?

    Beauty_and_dBest

      EBS 12.1.3

      12c

       

       

      Hi ALL,

       

       

      SQL> SELECT package_name,object_name,argument_name,data_type FROM all_arguments WHERE (package_name,object_name) IN (SELECT call_package,call_procedure FROM hr_api_hook_calls) AND data_type = 'LONG';

       

      DATA_TYPE

      ------------------------------

      PSB_HR_POPULATE_DATA_PVT

      INSERT_POSITION_TXN_INFO

      P_COMMENTS

      LONG

       

       

       

      How do I change the datatype LONG to BLOB?

      The docs just keep pointing to another documents which makes time consuming to the reader, instead of just putting the command after it.

       

      https://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T580873.htm#T609999

       

       

      Kind regards,

      jc