In packages the source code is compiled into p code ? how do we describe the p

In packages the source code is compiled into p code ? how
do we describe the p code

Question Posted / swapna

3 Answers
7151 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In packages the source code is compiled into p code ? how do we describe the p code..

Answer / swapna

After compiling procedures,functions and triggers(in new
versions only),Those will be stored in the form of p-code
(after parsing) in SGA(System Global Area).

The advantage of p-code is Since it was there in SGA which
can be shared by all,Whenever you execute procedure or
function,It won't be recompiled.It uses already compiled p-
code.So,time can be saved.

Is This Answer Correct ?

2 Yes

0 No

In packages the source code is compiled into p code ? how do we describe the p code..

Answer / srinu

Yes u r correct Swapna,But if we want 2 get the source code
of stored procedure,function,trigger or package ten the
query is......
SELECT text
FROM USER_SOURCE
WHERE NAME='PROCEDURE_NAME/FUNCTION_NAME/TRIGGER_NAME';

Is This Answer Correct ?

1 Yes

0 No

In packages the source code is compiled into p code ? how do we describe the p code..

Answer / arup ratan banerjee

But Swapna,,,,
Those codes get stored in ALL_SOURCE tables...
Just check this query out...
Select * from ALL_SOURCE where owner='<OWNER_NAME>'
and type='PROCEDURE'

u WILL GET THE SOURCE CODE FROM HERE

Is This Answer Correct ?

0 Yes

2 No

Post New Answer