Oracle Multimedia (MOSC)

MOSC Banner

9ORDIMAGE not working at run time on 19c ora - 06510

edited Aug 25, 2020 7:28PM in Oracle Multimedia (MOSC) 4 commentsAnswered

Dears

after move  our application database from 11g enterprise 11.2.0.4.0 64 bit  to 19c enterprise the following API give error at run time on 19 c :

---the code is working on 11g but not work on 19c show following error:

ORA-06510: unhandled user-defined exception

ORA-06512: at "ORDSYS.ORDIMAGE", line 448

ORA-06512: at  line 11

---sample table

create table blob_table

(

id_Serial number primary key,

source_image blob,

filename varchar2(1000),

file_mimetype  varchar2(1000),

file_charset varchar2(1000)

);

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

-----INSERT ANY SAMPLE IMAGE DATA ON TABLE WITH value 1 for id_Serial

declare

vsource_image blob;

begin

select source_image into vsource_image

from blob_table

where id_Serial=1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center