'ORDAudio Constructor - incorrect number of arguments

I wanna insert a blob into a ORDAudio Object according to all the docs I found. I created a helper table blob_helper to store the blob temporarely

CREATE TABLE BLOB_HELPER (
    id number,
    sound BLOB default EMPTY_BLOB()
)

Now I wanna insert it into a other table with a ORDAudio field, the problem I face is that I cannot get the blob into an ORDAudio Object, even this simple code here produces an error telling me that ORA-02315: incorrect number of arguments for default constructor

SELECT ORDSYS.ORDAudio(S.sound) FROM blob_helper S WHERE S.id = 1;

I am out of ideas on how to get this done, all docs I found across the internet all just mention to use the default constructor to initialize it from a blob.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source