context switching (attempt 2)

  • From: Backseat DBA <backseatdba@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Oct 2013 09:20:37 -0700

Say I have a procedure like so with the following calls
begin
pkg_test.get(1);

pkg_test.insert(1,2,3);

pkg_test.update(1,50);

end;

The 3 procedures, get, insert, and update are straight sql commands.  But
is it still a context switch from pl/sql to sql inbetween each procedure
call?  Or does it stay as sql since there isn’t any pl/sql in between each
procedure call.
Sorry if this a dumb question.

Thanks.

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2013