context switching (attempt 2)
From: Backseat DBA <backseatdba_at_gmail.com>
Date: Tue, 29 Oct 2013 09:20:37 -0700
Message-ID: <CAKsxbLrefGgH5dW3uCD2rXRrR9AWi=LK-=8_YxSkV6vovcm=Pg_at_mail.gmail.com>
Say I have a procedure like so with the following calls begin
pkg_test.get(1);
Date: Tue, 29 Oct 2013 09:20:37 -0700
Message-ID: <CAKsxbLrefGgH5dW3uCD2rXRrR9AWi=LK-=8_YxSkV6vovcm=Pg_at_mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 29 2013 - 17:20:37 CET