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

whbilly

The landlord's name is wrong


SQL> EXECUTE TEST ('AA');

AA

PL / SQL procedure successfully completed


Not TEXT

sanshuimei

Where did you execute the stored procedure

There should be no errors

idpublic

The name is wrong
EXECUTE TEST ('AA');

idpublic

The name is wrong
EXECUTE TEST ('AA');

wang7498

Where did you execute the stored procedure

There should be no errors
....Strange...
I will describe it again.
I use PL / SQL. Then create a new SQL form ...
Then execute
CREATE OR REPLACE PROCEDURE "TEST"
(CODE IN CHAR)
AS
BEGIN
  DBMS_OUTPUT.put_line (CODE);
END;
Then execute
EXECUTE TEST ('AA')
Then a dialog box appears: ORA-00900 invalid SQL statement
strange...

idpublic

EXECUTE "TEST" ('AA')


Your stored procedure is enclosed in double quotes

wang7498

Certainly not ... "TEST"
Just like [] in SQL SERVER ...

idpublic

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;

idpublic

wang7498
 
 
   Certainly not ... "TEST"
Just like [] in SQL SERVE ...
  
 
-
Did you test it
The above is my code, the test passed

idpublic

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;