Skip to Main Content
Feature Request FR-3943
Product Area APIs
Status CLOSED

2 Voters

New Type APEX_T_BLOB as table of BLOB

rode.mb Public · Aug 1 2024

Idea Summary
APEX already provides some useful and reusable Types APEX_T_NUMBER, APEX_T_VARCHAR2 or APEX_T_CLOB, but i miss the type APEX_T_BLOB

Use Case
Sharing reusable code that does not depend on creating new objects.

Preferred Solution (Optional)
create or replace noneditionable type apex_240200.wwv_flow_t_blob as table of blob;

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • vincent morneau Admin OP 10 months ago

    I don't quite understand the use case. Why is this important to “Share reusable code that does not depend on creating new objects”?

  • rode.mb OP 10 months ago

    Well i would prefer to have some default types shared by sys or apex to reuse it in different application schemes. Otherwise every application has to create it's own types. That shouldn't be necessary for simple data types without business context. Most of the types exist already in APEX, so it would be easy to add them…

    Also if I send someone a code snippet (for any reason), you can execute it without having unused types in your schema after running the code.

  • vincent morneau Admin OP 10 months ago

    Thanks for clarifying. Can you expand on why APEX_T_BLOB is important to your use case? What would you do with it?

    I know it's simple and we could technically add it. But then thinking of the big picture, why not have APEX_T_TIMESTAMP or other native types.

  • rode.mb OP 10 months ago

    Yeah, why no APEX_T_-Type for every native type? I would find that very useful!

    My specific use case at the moment is a stored java procedure that uses a table of blob as a parameter. unfortunately you cannot use package types for this, which i usually prefer to use.