Recent content by colinmillar

I mean that where the stored procedures' parameters are in the form: procedure MyUpdateProc(ID in MYTABLE.ID%TYPE, AREQUIREDFIELD in MYTABLE.REQUIREDFIELD%TYPE, ANULLABLEFIELD in MYTABLE.NULLABLEFIELD%TYPE) for a table defined by: ID - number(8) - not null AREQUIREDFIELD -...

Why not modify the package wizard so that nullable fields are passed as variants, and required fields are passed using native Delphi types? This would produce type-safe code and allow nulls to be set in the database without the mess of using variants for every parameter.