PL/SQL (MOSC)

MOSC Banner

Seeing error "PLS-00302: component 'STPTRX9' must be declared"

edited Jul 25, 2024 10:29AM in PL/SQL (MOSC) 8 commentsAnswered

Creating the Stored procedure and calling it using SQL developer throws the below error -
"PLS-00302: component 'STPTRX9' must be declared"

Below are the commands that are executed -

CREATE TABLE "DSFLOWSUSER"."TRXTEST9"
( "C1" NUMBER,
"C2" VARCHAR2(20)
);

CREATE OR REPLACE PROCEDURE "DSFLOWSUSER"."STPTRX9"(COL_IN IN TRXTEST9.C1%TYPE, COL_OUT OUT TRXTEST9.C2%TYPE)
AS
BEGIN
SELECT C2 INTO COL_OUT from "DSFLOWSUSER"."TRXTEST9" where C1=COL_IN;
END;

insert into "DSFLOWSUSER"."TRXTEST9" ("C1", "C2") values(1, 'aa');

declare
v_c1 number := 1;
v_c2 varchar2(20);
begin
"DSFLOWSUSER"."STPTRX9"(v_c1, v_c2);
dbms_output.put_line('The output column value is : ' || v_c2);

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