executeNonQuery method

Implementation

Future<void> executeNonQuery() async {
  if (_connection == null) {
    throw StateError('Connection not set. Call setConnection() first.');
  }

  final fullName = '$schema.$name';
  final placeholders = List.generate(
    parameters.length,
    (i) => '@param$i',
  ).join(',');

  final sql = 'CALL $fullName($placeholders)';
  final params = <String, dynamic>{};
  for (var i = 0; i < parameters.length; i++) {
    params['param$i'] = parameters[i];
  }

  await _connection!.execute(sql, parameters: params);
}