SQL Performance (MOSC)

MOSC Banner

Error While running SQLT-XPLAIN Method: ERROR at line 2: ORA-00905: missing keyword

edited Jul 11, 2025 7:40PM in SQL Performance (MOSC) 2 commentsAnswered

HI,

We are getting the below error message while running the SQLT - XPLAIN Method for below command

begin POR_AME_REQ_WF_PVT.Process_Beat_By_First (:v1, :v2, :v3, :v4, :v5);

end;

We added this command in the sql1.txt and trying to run the steps given in sqlt_instructions.html file in the section " XPLAIN Method " to execute sqltxplain.sql script as apps user:

Here is error:

— - - - - - - - - - - — - -

SQL>.
SQL>SET TERM OFF ECHO ON VER ON SERVEROUT OFF SUF sql;
SQL>C/;/
  2* end
SQL>0 ^^explain_plan_for.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center