Error Code 1329 No Data
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about no data - zero rows fetched, selected, or processed cursor Stack Overflow the company Business Learn more about hiring developers or posting ads with error 1329 pulse secure us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
Error 1329 You Are Not Allowed To Sign In
a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to get rid of “Error 1329: No data - zero rows fetched, selected,
Error 1329 Junos Pulse
or processed” up vote 20 down vote favorite 5 I have a stored procedure which does not need to return any values. It runs smoothly and without any problem. However, it outputs an error message after finishing its run: Error: No data - zero rows fetched, selected, or processed How can I get rid of this error message? CREATE PROCEDURE `testing_proc`() READS SQL DATA BEGIN DECLARE done INT DEFAULT 0; mysql declare continue handler DECLARE l_name VARCHAR(20); DECLARE my_cur CURSOR FOR SELECT name FROM customer_tbl; OPEN my_cur; my_cur_loop: LOOP FETCH my_cur INTO l_name; IF done = 1 THEN LEAVE my_cur_loop; END IF; INSERT INTO names_tbl VALUES(l_name); END LOOP my_cur_loop; CLOSE my_cur; END sql mysql stored-procedures share|improve this question edited Aug 8 '14 at 15:42 user212218 asked Aug 11 '10 at 22:15 Babibo 101113 Without details, I'll be the first to say - it could be replaced with INSERT INTO names_tbl SELECT name FROM CUSTOMER_TBL =) –OMG Ponies Aug 11 '10 at 22:21 Thanks OMG Ponies. In the actual code "INSERT INTO names_tbl VALUES(l_name);" should be replaced by 200 lines of code. I used this simplified version because I get the same error even for this simplified version. I am OK to output a varchar as the return value if it helps removing the error message. –Babibo Aug 11 '10 at 22:26 add a comment| 6 Answers 6 active oldest votes up vote 24 down vote I guess you just forgot to include the following line in your post: DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; Your code is correct, but bug/strange behaviour of mysql causes the warning to appear even if it was handled. You
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices General Information Installing
Sqlstate '02000' Mysql
and Upgrading MySQL Tutorial MySQL Programs MySQL Server Administration Security mysql cursor no data Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax Data mysql stored procedure error handling Definition Statements ALTER DATABASE Syntax ALTER EVENT Syntax ALTER FUNCTION Syntax ALTER LOGFILE GROUP Syntax ALTER PROCEDURE Syntax ALTER SERVER Syntax ALTER TABLE Syntax ALTER TABLE http://stackoverflow.com/questions/3463283/how-to-get-rid-of-error-1329-no-data-zero-rows-fetched-selected-or-process Partition Operations ALTER TABLE Online Operations in MySQL Cluster ALTER TABLE Examples ALTER TABLESPACE Syntax ALTER VIEW Syntax CREATE DATABASE Syntax CREATE EVENT Syntax CREATE FUNCTION Syntax CREATE INDEX Syntax CREATE LOGFILE GROUP Syntax CREATE PROCEDURE and CREATE FUNCTION Syntax CREATE SERVER Syntax CREATE TABLE Syntax CREATE TABLE ... LIKE Syntax CREATE https://dev.mysql.com/doc/refman/5.5/en/condition-handling.html TABLE ... SELECT Syntax Using FOREIGN KEY Constraints Silent Column Specification Changes CREATE TABLESPACE Syntax CREATE TRIGGER Syntax CREATE VIEW Syntax DROP DATABASE Syntax DROP EVENT Syntax DROP FUNCTION Syntax DROP INDEX Syntax DROP LOGFILE GROUP Syntax DROP PROCEDURE and DROP FUNCTION Syntax DROP SERVER Syntax DROP TABLE Syntax DROP TABLESPACE Syntax DROP TRIGGER Syntax DROP VIEW Syntax RENAME TABLE Syntax TRUNCATE TABLE Syntax Data Manipulation Statements CALL Syntax DELETE Syntax DO Syntax HANDLER Syntax INSERT Syntax INSERT ... SELECT Syntax INSERT DELAYED Syntax INSERT ... ON DUPLICATE KEY UPDATE Syntax LOAD DATA INFILE Syntax LOAD XML Syntax REPLACE Syntax SELECT Syntax SELECT ... INTO Syntax JOIN Syntax UNION Syntax Subquery Syntax The Subquery as Scalar Operand Comparisons Using Subqueries Subqueries with ANY, IN, or SOME Subqueries with ALL Row Subqueries Subqueries with EXISTS or NOT EXISTS Correlated Subqueries Subqueries in the FROM Clause Subquery Errors Optimizing Subqueries Rewriting Subqueries as Joins UPDATE Syntax M
log in tour help Tour Start here for a quick overview of the site Help Center Detailed http://dba.stackexchange.com/questions/25405/event-scheduler-no-data-zero-rows-fetched-selected-or-processed answers to any questions you might have Meta Discuss https://tinky2jed.wordpress.com/technical-stuff/mysql/mysql-no-data-zero-rows-fetched-how-to-code-for-it/ the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack no data Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted error code 1329 up and rise to the top Event Scheduler: No data - zero rows fetched, selected, or processed? up vote 2 down vote favorite MySQL 5.5.28 The error log keeps getting this error: 121004 12:08:59 [ERROR] Event Scheduler: [user@ip][reportingdb.tvc_bookingonline_update_status] No data - zero r ows fetched, selected, or processed 121004 12:13:59 [ERROR] Event Scheduler: [user@ip][reportingdb.tvc_bookingonline_update_status] No data - zero r ows fetched, selected, or processed 121004 12:18:59 [ERROR] Event Scheduler: [user@ip][reportingdb.tvc_bookingonline_update_status] No data - zero r ows fetched, selected, or processed The definition: mysql> show create event reportingdb.tvc_bookingonline_update_status\G *************************** 1. row *************************** Event: tvc_bookingonline_update_status sql_mode: NO_AUTO_CREATE_USER time_zone: SYSTEM Create Event: CREATE DEFINER=`user`@`ip` EVENT `tvc_bookingonline_update_status` ON SCHEDULE EVERY 5 MINUTE STARTS '2012-07-27 10:08:59' ON COMPLETION NOT PRESERVE ENABLE DO CALL `bo_tvc_booking_supdate_status_booking`( @plstbookingid_destroy) character_set_client: latin1 collation_connection: latin1_swedish_ci Database Collation: utf8_general_ci mysql> show create procedure reportingdb.bo_tvc_booking_supdate_status_booking\G *************************** 1. row *************************** Procedure: bo_tvc_booking_supdate_status_booking sql_mode: Create Procedure: CREATE DEFINER=`user`@`ip` PROCEDURE `bo_tvc_booking_supdate_status_booking`( OUT plstbookingid_des
Clausreal?Make a Veteran'sDayMy experience on the 10th anniversary of9/11Statue of Libertydiscrimination?Tails you loseWhy I do have an issue with showing up at Chick-Fil-A in opposition to MarriageRightsWhy we chose a charter school (and a localschool)PapersScripts and ProgramsFinding the Oracle session based on a UNIX/LinuxprocessHow to reference a shell variable named by another shellvariablejdesc.sql - A better describe forOraclejdesc.sql - A better describe for Oracle (version1)Linux bonding config -bondit.shLocal (non-RMAN) Backups of your pfile, spfile, and controlfileTechnical StuffDatabaseMy database account keeps getting lockedout!What is null in adatabase?MicrosoftSQL Server 2008 Express backupscriptThe Fix (?) for Windows Update hanging on Windows7MySQLMySQL 5.6 GET DIAGNOSTICS - Getting the MySQL warning, error, or exception that justoccurredMySQL check constraintequivalentMySQL IN query support islackingMySQL IN query support islackingMySQL interval math withsubqueriesMySQL No data - zero rows fetched : how to code foritOracleA better date format in Oracle RMAN (RecoveryManager)Breaking two myths about rebuilding indexes in the OracleDatabaseChanging the Oracle database default maintenance windowtimeClearing, Scrubbing, or Masking a column via Oracle Data PumpExportConfiguring HugePages for OracleDatabaseCreating an Oracle job that runs an OSexecutableDataGuard Broker NotesDealing with Oracle timestamp with timezoneconversionHow to find the number of inserts, updates, and deletes ( DML ) on an OracletableHow to load a SQL*Plus variable with data from aqueryInsufficient Privileges connecting to ASM instance as SYSASMremotelyJust for fun : Create a tracefileMy Oracle OPatch CertificationquestionORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORYOracle "alter user rename"commandOracle addNode.sh Java heap space error, audit files, gc buffer busy acquire, and loadspikesOracle ASM log file isstaleOracle blocking locks (sessions)queryOracle Data Pump export a schema minus the data for onetableOracle Flashback - A quick review / CheatSheetOracle Golden Gate commands on the wrong node if using RACHAOracle GoldenGate replication latencyreportingOracle Logon LogofffunctionalityOracle lsnrctl start = Linux Error: 13: Permission denied, lsnrctl status = Linux Error: 111: Connection