$query = "CALL .........."; $result = $wpdb->get_results($query); print_r($results);
Is returning an empty array and $wpdb->query does not return anything, how do you run stored procedures from the $wpdb class?
I am not sure about procedures, but good start will be to check if there is some reason reported for query failing.
wpdb detects the type of query and returns the result if it starts with select, else the affected rows. Since yours starts by call, it's probably mistaking it for an insert, update, delete, etc. statement.
Try this (might trick wpdb into thinking it's a select statement:
Or this (not sure the mysql parser will like it):
If all else fails (and even if not), consider opening a ticket in the wp trac.