I was in contact with ORCALE for the first time today.

idpublic

sqlserver oracle is different
Don't mix together

wang7498

Hey ... can't hold it ... how complicated it is ... hey.
Again.

CREATE OR REPLACE PROCEDURE MYTEST
(CODE VARCHAR2)
AS
BEGIN
  DBMS_OUTPUT.PUT_LINE (CODE);
END;
I execute this first, the test directly using PL / SQL can pass, and the output is correct.
Then I want to execute this through the statement.
EXECUTE MYTEST ('AA')
Then the same error is prompted. I didn't understand the one you wrote ET_STATISTICS. "TEST_ll" (CODE);
Ha ha.

I have always used SQL SERVER .. Ha ha. Suddenly not used to it.

idpublic

Then the same error is prompted. I didn't understand the one you wrote ET_STATISTICS. "TEST_ll" (CODE);
-------------------------
CREATE OR REPLACE PROCEDURE "TEST"

Your original stored procedure definition uses double quotes
Therefore, double quotes should also be used when executing
================================================== ===============
I have never used the PL / SQL tool
Test it like this
begin
EXECUTE MYTEST ('AA');
end;

wang7498

COPY your code. Nothing changed.
CREATE OR REPLACE PROCEDURE "TEST_ll"
(CODE IN CHAR)
AS
BEGIN
  DBMS_OUTPUT.PUT_LINE (CODE);
END;

/
toad test
DECLARE
  CODE VARCHAR2 (200);

BEGIN
  CODE: = 'AA';

  ET_STATISTICS. "TEST_ll" (CODE);
  
  COMMIT;
END;

Execution error.
Prompt error:
ORA-06550: row 7, column 3
PLS-00201: The identifier 'ET_STATISTICS.TEST_ll' must be stated
ORA-06550: row 7, column 3
PL / SQL: Statement ignored

After working hard for decades, I went back to liberation overnight,

idpublic

idpublic

toad test
DECLARE
  CODE VARCHAR2 (200);

BEGIN
  CODE: = 'AA';

  ET_STATISTICS. "TEST_ll" (CODE);
  
  COMMIT;
END;

--- ET_STATISTICS is a user on my side, you can change to your own user

idpublic

toad test
DECLARE
  CODE VARCHAR2 (200);

BEGIN
  CODE: = 'AA';

  "TEST_ll" (CODE);
  
  COMMIT;
END;

wang7498

CREATE OR REPLACE PROCEDURE MYTEST
(CODE VARCHAR2)
AS
BEGIN
  DBMS_OUTPUT.PUT_LINE (CODE);
END;

EXECUTE MYTEST ('AA');
Execution error, prompt: ORA-00900 invalid SQL statement
I also feel strange. How can something very simple go wrong?

The statement should be all right ... I don't know what's going on.

idpublic

I have never used the PL / SQL tool
Test it like this
begin
EXECUTE MYTEST ('AA');
end;

-Isn't that alright?

idpublic

CREATE OR REPLACE PROCEDURE TEST_ll_01
(CODE IN CHAR)
AS
BEGIN
  DBMS_OUTPUT.PUT_LINE (CODE);
END;

sqlplus test

set serveroutput on;
begin
user.test_ll_01 ('aa'); --user is replaced with your own user
end;

Test passed
The result is aa