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

wang7498

Write a stored procedure that is too simple. There are many questions.
 CREATE OR REPLACE PROCEDURE TEST
(CODE IN CHAR)-Here I specified why CHAR cannot specify the length (VARCHAR seems to be the same): CHAR (2)?
AS
BEGIN
  DBMS_OUTPUT.put_line (CODE);-Is there a similar method as PRINT of SQL Server ...... you can type a few words less.
END;


EXECUTE TEST ('AA'); --- how to prompt here that SQL is wrong ...

Hey. So many questions for the first time. How does SQL Server feel good?

wang7498

Checked the jars.Is it necessary to do PRO in Oracle?
set serveroutput on
exec TEST ('AA');

Tried it still SQL error.
Refer to the following:
CREATE OR REPLACE PROCEDURE HELLO_PRO (STR VARCHAR2) AS
 BEGIN
 DBMS_OUTPUT.PUT_LINE (STR);
 END;

SQL> set serveroutput on
SQL> exec hello_pro ('he');

wang7498

Ha ha. Thank you. I just checked the information and said that the stored procedure should be added with OWNER,
EXECUTE SYS.TEST ('AA');
Same error.

panda_ren

SQL> CREATE OR REPLACE PROCEDURE HELLO_PRO (STR VARCHAR2) AS
  2 BEGIN
  3 DBMS_OUTPUT.PUT_LINE (STR);
  4 END;
  5 /

Procedure created

SQL> set serveroutput on
SQL> exec hello_pro ('he');
he

PL / SQL procedure successfully completed

wang7498

SQL> CREATE OR REPLACE PROCEDURE HELLO_PRO (STR VARCHAR2) AS
  2 BEGIN
  3 DBMS_OUTPUT.PUT_LINE (STR);
  4 END;
  5 /
correct.

set serveroutput on;
exec hello_pro ('he');
error.

cxs3214

wang7498
There is no semicolon ';' after this set serveroutput on

wang7498

Yes, it is definitely not the problem.

whbilly

set serveroutput on
No semicolon

海蓝之谜

It ’s natural to get used to it.

Can you post your specific error message to see it?

wang7498

CREATE OR REPLACE PROCEDURE "SYS". "TEST"
(CODE IN CHAR)
AS
BEGIN
  DBMS_OUTPUT.put_line (CODE);
END;
This is right.
Then execute the part:

EXECUTE TEST ('AA')
Error message: ORA-00900: invalid SQL statement
or
EXECUTE SYS.TEST ('AA');
Same error message.