返回
-
标题
INTERNAL: ERROR: “Can\'t call method "execute" on an undefined value at ValidateTicket.pl line 546” -
说明
An error occured while testing the Ticket System. The results are:Can\'t call method "execute" on an undefined value at ValidateTicket.pl line 546. -
原因
The database name or table name are incorrect in the SQL Command. -
解决办法
WORKAROUND
1. Verify the with the Database Administrator to confirm table name/database name are correct.2. Run SQL Plus to connect to the database and verify the SQL command syntax directly.
Expectation of the SQL CommandEnter a simple SELECT query or execute a stored procedure to return a single row result set. Substitution parameters may be entered in the command using :param: syntax. Oracle databases only support SELECT type syntax, no EXEC stored procedure for a result set. SQL Server supports SELECT and EXEC. Case sensitivity is controlled by the target database. The SELECT and EXEC statement must be written to produce a result set of exactly one row if successful. When validating ticket numbers for requests a results set of zero rows or more than one row is considered as a failed validation.NOTE: This command is executed against the target database. Please ensure that the database login has proper safeguards to prevent accidental or intentional loss of data.