Help to look at this period of stored procedures, can be performed, but complains when calling-CodePudding

Thank you for the

CodePudding user response:

Many a colon

CodePudding user response:

reference 1st floor wmxcn2000 response:

much a colon

I remove the colon, is still the same fault

CodePudding user response:

I remove the colon, is still the same fault

CodePudding user response:

Compile the ~ ~ ~

CodePudding user response:

Then

CodePudding user response:

This problem may be the following:

1, the name of the table or column names there is no
2, insert into the back, just write the name of the table, didn't write a column name, cause do not match the actual number of columns

Or have a look at the process of specific what is wrong

CodePudding user response:

refer to 6th floor wmxcn2000 response:

this problem could be the following:

1, the name of the table or column names there is no
2, insert into the back, just write the name of the table, didn't write a column name, cause do not match the actual number of columns

Or have a look at what is the process of specific error

SQL statement is right, is combined with a stored procedure after the execution is not an error, when to call a stored procedure: the stored procedure does not exist

CodePudding user response:

reference 5 floor BiBerBang reply:

Then

Do not add in, the default is passed

CodePudding user response:

Ask, do you have a compiler? That is in the database with this process?

CodePudding user response:

The default is in, can not write a
This problem can be the first statement to execute SQL window and see if there is any error, such as the field name to write wrong,
May be the lookup table or insert table permissions problems, if there were any permissions

CodePudding user response:

references 9 f ghx287524027 response:

ask, do you have a compiler? That is in the database with this process?

Compiled, not an error, in user_error this list can't find the stored procedure is proved to be true.
But the implementation of this period of time is an error

CodePudding user response:

The

references to the tenth floor sxq129601 response:

default is in, can not write a
This problem can be the first statement to execute SQL window and see if there is any error, such as the field name to write wrong,
May be the lookup table or insert table permissions problems, whether have permission

SQL statements can be executed successfully, it is added after the stored procedure is wrong, ah

CodePudding user response:

Stored procedure under the user of the caller

CodePudding user response:

reference 13 floor sych888 reply:

stored procedure under the user of the caller?

Yes, has the power to call a stored procedure