mcl
mcl

Reputation: 97

execute function from package oracle in Explain plan window

I want to obtain the results of the execute explain plan in ORACLE for a procedure in a package.

I use this sentence but I have the error ORA-00905: missing keyword

call PK_MTMPLBO_TC_V01.FILL('MENSUAL', 'CARBON');

How can I execute the sentence? Thanks in advance!!

Upvotes: 0

Views: 641

Answers (1)

PLSQL_007
PLSQL_007

Reputation: 213

To execute a procedure syntax is as below :

Declare ....

begin PK_MTMPLBO_TC_V01.FILL('MENSUAL', 'CARBON'); end;

Upvotes: 1

Related Questions