SP calling SPs in another pkg

[Max Tomlinson]

hi all-

Does someone have a snippet for a stored procedure that calls stored procedures in another package?

I want to write a copy function that calls a series of inserts in another package.

thank you
Max Tomlinson

[ September 09, 2005: Message edited by: Max Tomlinson ]
[ September 09, 2005: Message edited by: Max Tomlinson ]

[Avi Abrami]

Max,
Just prefix the package name to the procedure name, for example:

create or replace procedure P is
begin
  SOME_PACKAGE.SOME_PROCEDURE();
end;

Here SOME_PACKAGE is the name of the package that contains a procedure called SOME_PROCEDURE.

Or am I missing something?

Good Luck,
Avi.