Home » SQL & PL/SQL » SQL & PL/SQL » ORDSYS.ORDIMAGE
ORDSYS.ORDIMAGE [message #35608] Mon, 01 October 2001 05:00 Go to next message
Suparna Saha
Messages: 10
Registered: October 2001
Junior Member
Hello,
I am facing some problem regarding ORDSYS.IMAGE
object. What I have done I am writing in detail.

>From SQLPLUS
connect system/manager;
create user suparna identified by suparna;
grant dba to suparna;
connect suparna/suparna;
create or replace directory IMGDIR as 'd:supimage';
disconnect;
connect system/manager;
grant read on directory IMGDIR to suparna;
connect suparna/suparna;

create table t_sup(
id number not null,
ename varchar2(25) not null,
photo ORDSYS.ORDImage,
constraint pk1 primary key(id)
);

insert into t_sup values(1, 'Logo',
ORDSYS.ORDImage.init());

DECLARE
Image ORDSYS.ORDImage;
ctx RAW(4000) := NULL;
BEGIN
select photo INTO Image FROM t_sup
WHERE id = 1 for UPDATE;

Image.setSource('FILE','IMGDIR','logo.gif');
Image.import(ctx);

UPDATE t_sup SET photo = Image WHERE id = 1;
COMMIT;
END;

******************************************************************

ERROR at line 1:
ORA-28575: unable to open RPC connection to external
procedure agent
ORA-06512: at "ORDSYS.ORDIMG_PKG", line 419
ORA-06512: at "ORDSYS.ORDIMAGE", line 65
ORA-06512: at "ORDSYS.ORDIMG_PKG", line 506
ORA-06512: at "ORDSYS.ORDIMAGE", line 209
ORA-06512: at line 11
**********************************************************************

How I can I solve this problem. Please send any
solution as early as possible.

Thanks,
Suparna Saha

----------------------------------------------------------------------
Re: ORDSYS.ORDIMAGE [message #35617 is a reply to message #35608] Mon, 01 October 2001 14:50 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
Seems like , your external procedure listener/extproc agent is not configured properly. If this is your first time, (trying this package call)
then check ur tnsnames.ora for
extproc_connection_data service name parameter.

To test your database configuration , use the scripts given in ur $ORACLE_HOME/plsql/demo directory

a)extproc.c
b)extproc.sql

Regards
Oraboy
Email:venkat_jobmails@yahoo.com

----------------------------------------------------------------------
Previous Topic: Re: oracle Error
Next Topic: Re: HOW to cpnvert varchar2 to NUMBER?
Goto Forum:
  


Current Time: Sat May 25 09:27:59 CDT 2024