Problem solving-occurrence Symbol & quot; (& quot; when the following is required)

Source: Internet
Author: User
Tags sql using


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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.