알짜 Linux 5.2에 Oracle 8.05를 얹어서 쓰고있읍니다..



근데 ... SQL.Add로 집어넣은 SQL 문장의 Parameter를 받아가질 못해요..



Source는 다음과 같습니다..



// ----------------------------------------------------------

SQL.Add('Select floor, area');

SQL.Add(' from kmbt02');

SQL.Add(' where bldg_no = :bldg_no');

SQL.Add(' order by floor');



Prepare;

ParamByName('Bldg_No').AsString := edBldgNo.Text;

// --------------------------------------------------------



이걸 SQL Monitor로 보면 아래와 같이 나와요..

Parameter를 하나도 못 가져가네요..



771 14:44:35 SQL Prepare: ORACLE - delete from kmbt02 where Bldg_No = :1

772 14:44:35 SQL Vendor: OCI 8 - OCIHandleAlloc

773 14:44:35 SQL Vendor: OCI 8 - OCIHandleAlloc

774 14:44:35 SQL Vendor: OCI 8 - OCIStmtPrepare

775 14:44:35 SQL Vendor: OCI 8 - OCIAttrGet

776 14:44:35 SQL Vendor: OCI 8 - OCIBindByPos

777 14:44:35 SQL Vendor: OCI 8 - OCIBindByPos

778 14:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 17

779 14:44:35 SQL Vendor: OCI 8 - OCIBindByPos

780 14:44:35 SQL Execute: ORACLE - delete from kmbt02 where Bldg_No = ?

781 14:44:35 SQL Vendor: OCI 8 - OCIStmtExecute

782 14:44:35 SQL Vendor: OCI 8 - OCIAttrGet(OCI_ATTR_ROWCNT)

783 14:44:35 SQL Data In: ORACLE - Rows affected = 0

784 14:44:35 SQL Stmt: ORACLE - Close