Error with public object type when describing object parameters of stored procedures

zzin32 · Post by **zzin32** » Tue 07 Nov 2006 13:45

1. db user - GLB

CREATE OR REPLACE TYPE TPS_GLB_ID AS OBJECT
(
sid varchar2(64),
id number(10)
);
create or replace public synonym TPS_GLB_ID for GLB.TPS_GLB_ID;
grant execute on TPS_GLB_ID to INK;

2. db user - INK

CREATE OR REPLACE PACKAGE I_PACK AS

PROCEDURE SET_DATA(PI_DATI TPS_GLB_ID);

END I_PACK;

CREATE OR REPLACE PACKAGE BODY I_PACK AS

PROCEDURE SET_DATA(PI_DATI TPS_GLB_ID)
IS
BEGIN
NULL;
-- process
END SET_DATA;

END I_PACK;

Error on TOraSession.ExecProc or TOraSession.ExecProcEx by execute SQL.CreateProcCall.

ORA-04043: object "PUBLIC"."TPS_GLB_ID" does not exist

Plash · Post by **Plash** » Tue 07 Nov 2006 15:42

Please provide Delphi code that you use to call the stored procedure. Also specify your versions of ODAC and Delphi.

zzin32 · Post by **zzin32** » Tue 07 Nov 2006 16:23

Delphi 6
ODAC 5.80.0.37 (previous 5.80.0.35 - not error)

Delphi example is very simple:

Set TOraSession component on the form with name OraSession1. Login as user INK.
Execute:
OraSession1.SQL.CreateProcCall('I_PACK.SET_DATA');

See error.

Plash · Post by **Plash** » Wed 08 Nov 2006 09:58

We cannot reproduce the problem. Please send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

zzin32 · Post by **zzin32** » Wed 08 Nov 2006 12:04

Example and comments to ODAC support address is sending.

zzin32 · Post by **zzin32** » Fri 10 Nov 2006 12:02

For CoreLab Team. Sorry...
Do you solve this problem?

Plash · Post by **Plash** » Fri 10 Nov 2006 12:11

We have fixed this problem. The fix will be included in next build of ODAC.

zzin32 · Post by **zzin32** » Fri 10 Nov 2006 15:18

Thank you!