Problem solved – the symbol “(” appears when one of the following is required)

Problem solved – the symbol “(” appears when one of the following is required) the When creating a stored procedure today, I encountered a problem, as follows: www.2cto.com PROCEDURE QIUYUE.PRO_INSERT_DYNA_TABLE compile error ERROR: PLS-00103: The symbol “(” occurred when one of the following was expected: := . ) , @ % default character The symbol “:=” is replaced with “(” to continue. row: 3 Text: id in number(3) the Below is my stored procedure: [sql] create or replace procedure pro_insert_dyna_table ( www.2cto.com id in number(3), name in varchar2 ) is str_sql varchar2(500); begin str_sql :='insert into pro_create_dyna_table values(:1,:2)'; execute immediate str_sql using id,name; end pro_insert_dyna_table; the It is said to be a “(” problem, but I took a closer look, and it is still fine. Suddenly, I encountered such a problem when executing the PL program block in the morning: [sql] declare sum number; begin execute immediate 'select count(*) from stu' into sum; dbms_output.put_line(sum); –Wrong cursor position end; the ORA-06550: line 5, column 25: PLS-00103: Symbol “)” occurs when one of the following is required: ( www.2cto.com the It’s still the problem of brackets. I have been working on it for a long time in the morning, because I feel…