| ORDSYS.ORDIMAGE [message #35608] |
Mon, 01 October 2001 05:00  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
