Solution to the Problem -- the symbol "(" one of the following is required) encountered a problem during the creation of the stored PROCEDURE today: www.2cto.com procedure qiuyue. PRO_INSERT_DYNA_TABLE compilation error: PLS-00103: Symbol "(" when the following is required: = .), @ % default character symbol ": =" replaced with "(" to continue. Row: 3 text: id in number (3) 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; it is a question of "(", but I have carefully looked at it and it is still good. I suddenly encountered this problem when I executed the PL program block in the morning: [SQL] declare sum number; begin execute immediate 'select count (*) from stu 'into sum; -- Note: into words cannot be placed in quotation marks dbms_output.put_line (sum); -- the end of the incorrect cursor position; ORA-06550: 5th rows, 25th columns: PLS-00103: sign ")" when you need the following: (www.2cto.com is still a question of parentheses. It took a long time in the morning because I felt that there was no error due to ")" in a simple sentence. Afterwards, I suddenly realized that sum is the keyword. So ...... So is the same afternoon? To avoid this problem, I changed the id and name to id1 and name1, but the result is still like this, dizzy! Because of the sudden thought, I realized that when creating a stored procedure, the parameter data type cannot be specified, such as the use of number, number (2) cannot be used in the stored procedure ). Conclusion: 1. When defining a variable name, you must note that the variable name cannot be a keyword. 2. When creating a stored procedure, the exact data type cannot be specified for the parameter data type. For example, you can only use number and varchar2, but not varchar2 (4) Author yang15225094594.