# `sp_cursor_test` (procedure)


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

_No parameters._

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `sp_cursor_test`'`._

## Narrative

**Business context:** Developer scratch — narrowly-scoped `sp_cursor_CardEdit` variant filtering `elematerials` to `sMakePerson='系统管理员' AND sMaterialsType='corrugated' AND dGuidePrice=0` — i.e. system-created 瓦楞纸 (corrugated) rows with no guide price set. Body comments in English-mixed-Chinese (`/*First: Delcare a cursor*/`) confirm it's a coder template.

**What it does:** Opens cursor `cur1` over the filtered `elematerials.sId`, uses `CONTINUE HANDLER FOR NOT FOUND` to drive a manual fetch-loop, and per row calls `Sp_elematerials_AfterUpdateCard_Edit(p_sId)`. No tenant filter, no params, no return values.

**Invocation:** Status: appears orphaned. No caller in any channel — no form-master, no `gdsmodule` hook, no other routine references, no xly-src reference. The name `sp_cursor_test` + the boilerplate comments mark this as a developer test/template, not production code. Candidate for cleanup.
