How do I convert an Oracle SQL BLOB into a read-only text?

113 Views Asked by At

I need to provide some log messages to a person: for me as an admin that is just point and click stuff, but for this person is not possible unless I can extract and convert a blob and deliver that in the moment the sql process ends... problem is this is a factory code, I can only expose its boot and not the code itself, so i cannot even manipulate code and add a procedure to set this blob conversion as "part two"; besides, the person can only execute one file at a time and only in 3 (THREE) cases I actually need to convert the blob, since these three cases (for strange internal reasons) cannot be handled, do you think theres another way?

I know where tables and columns are, I know their names and can easily extract those as normal blobs, all the oracle functions I used give me the error ORA-06512, sometimes our system instead tells me it was expecting a number but got a blob(?).

Anyway, thank you!

0

There are 0 best solutions below