Page 1 of 1

Oracle: Calling stored procedures in user packets

Posted: Sat Jul 08, 2006 7:26 am
by Zoran_Dimov
I am logging on Oracle database as user "user". I want to call the stored procedure "proc" which is in the packet "sysPacket", and the packet is on user "dbUser".

I tried to call it as dbUser.sysPacket.proc(...), but it don't work. Can anyone tell me the correct syntax.

Thanks in advance

Posted: Sat Jul 08, 2006 7:47 am
by sweatje
begin dbUser.sysPacket.proc(...); end;