Recent content by KitJackson

I'm working on an application where all changes to data are done by means of stored procedures. This means that I have a lot of code of the form:- with OracleQuery do begin Close; SQL.Clear; DeleteVariables; SQL.Add('PLSQLstatement'); DeclareVariable('Variable1'...

CREATE SEQUENCE EMP_SEQ; CREATE TABLE EMP( EMPNO NUMBER(4), ENAME VARCHAR2(10), JOB VARCHAR2(9), LAST_UPDATE DATE, LAST_USER VARCHAR2(30)); These tables are maintained using stored procedures of the form CREATE PROCEDURE EMP_ADD( V_EMPNO NUMBER, V_ENAME VARCHAR2, V_JOB VARCHAR2) AS V_SEQ...