Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: OCI_ERROR ORA-25123: Too many components specified in the name.
OCI_ERROR ORA-25123: Too many components specified in the name.
Posted: 2005/12/08 16:29
 
Hi,

I made a stored procedure in Oracle 8.

CREATE OR REPLACE PROCEDURE Wijzig_Regnr(goednummer IN VARCHAR,foutnummer IN VARCHAR) AS ........

I made a public synonym.

CREATE PUBLIC SYNONYM Wijzig_Regnr FOR SMI2.Wijzig_Regnr;

When I try to use the stored procedure as a normal user I got the error as shown in the subject. I'm using Delphi 5 with NCOCI8.

Anybody who knows what's wrong.

Thanks,

Daan.
RE: OCI_ERROR ORA-25123: Too many components specified in the name.
Posted: 2005/12/13 14:56
 
Hi,

I solved the problem. A normal user should have execution rights.

You can do that with 'GRANT execute ON Wijzig_regnr to <user>'.

Daan