locked
Parameter '?/*IN' not found in the collection. (MySQL) RRS feed

  • Question

  • User1057623887 posted

    I'm sending parameters to a stored procedure in MySQL to do an insert and I'm getting an error that I don't understand:

    Parameter '?/*IN' not found in the collection.  

    Do you have any idea what this means?

    Thanks

    Friday, November 19, 2010 11:21 AM

Answers

  • User1057623887 posted

    I'm sending parameters to a stored procedure in MySQL to do an insert and I'm getting an error that I don't understand:

    Parameter '?/*IN' not found in the collection.  

    Do you have any idea what this means?

    Thanks

     

    Figured out my problem.  My parameter list looked like this:

    IN p_username             VARCHAR(100),
    IN  p_admin_user_oid      INT,
    /*IN  p_display_order     INT   not in use yet*/
    IN  p_display_title       VARCHAR(200),
    IN  p_file_name           VARCHAR(500),
    IN  p_hier_level          INT,
    IN  p_display_id          INT,
    IN  p_admin_project_oid   INT,
    IN  p_parent_id           INT,
    IN  p_admin_report_oid    INT,
    IN  p_date_filter         INT,
    OUT p_err_msg             VARCHAR(4000)
     

     

    But the parameter that's commented out can't be there.  I guess you can't have comments in the parameter list. I don't know for sure but it looks like it doesn't work if you do.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 19, 2010 12:31 PM