Bug #52865 Error code 1048

• Submitted: 15 Apr 2010 20:04
• Modified: 16 Apr 2010 5:50
• Reporter: 3 sri
• Status: Not a Bug
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 5.2.17
• OS: Windows (7 professional)
• CPU Architecture: Any

[15 Apr 2010 20:04] 3 sri

Description:
I have written a Stored Procedure for loading a table with data in MySql from another database with unknown fields.

Following is the stored procedure:

DELIMITER $$

CREATE DEFINER=`rp`@`%` PROCEDURE `getdata`()
BEGIN
        Declare column_name1 VARCHAR(255);
        Declare column_name2 VARCHAR(255);
        Declare column_name3 VARCHAR(255);
        Declare column_name4 VARCHAR(255);
        Declare column_name5 VARCHAR(255);
        Declare column_name6 VARCHAR(255);
        Declare column_name7 DECIMAL(10,2);
        Declare column_name8 DECIMAL(10,2);
        
            
                Declare CONTINUE HANDLER FOR SQLWARNING
                
                SELECT *
                INTO column_name1, column_name2, column_name3, column_name4, column_name5, column_name6, column_name7, column_name8
                FROM sap_sales_order;
    
                INSERT INTO MySql_Sales_Order
                VALUES(column_name1, column_name2,column_name3, column_name4, column_name5, column_name6, column_name7, column_name8);
    
        
END

I have used Declare Continue handler, as I was getting an error with too many results.

But now when i execute the above procedure, it gives me error code: 1048(order_no cannot be null).

Please assist in how to eradicate this. 

Thank you.

How to repeat:
i dont know..

[16 Apr 2010 5:50] Sveta Smirnova

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.