Oracle: Calling stored procedures in user packets

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Zoran_Dimov
Forum Newbie
Posts: 16
Joined: Wed Jun 21, 2006 6:10 pm
Location: Macedonia
Contact:

Oracle: Calling stored procedures in user packets

Post 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
User avatar
sweatje
Forum Contributor
Posts: 277
Joined: Wed Jun 29, 2005 10:04 pm
Location: Iowa, USA

Post by sweatje »

begin dbUser.sysPacket.proc(...); end;
Post Reply