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

근데 ... SQL Prepare가 안먹어요..

Error없이 Seect를 못하네요..

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