어떻게하면 Tstoredproc를 이용해 Numeric형을 집어넣으려고합니다.

그런데 계속 @num not found만 나옵니다. 해결책은 없을까요.



////Program Source////

procedure TForm2.Button4Click(Sender: TObject);

begin

with datamodule3.sp1 do

begin

parambyname('@num1').Asinteger := strtoint(edit1.text);

parambyname('@name1').asstring := edit2.text;

execproc;

end;

end;



////Stored Procedure - hun1////

CREATE PROCEDURE HUN1

@NUM numeric(2), @NAME varchar(20)

with recompile as

begin transaction

insert HUN values (@NUM, @NAME)

commit transaction



////Table - hun////

num : numeric

name : varchar