Oracle:
DECLARE var NUMBER;
BEGIN
TEST (var, null, ‘test’, ‘test’, ‘test’, ‘test’, ‘test’, ‘test’, ‘test’, ‘test’, ‘test’);
DBMS_OUTPUT.put_line(var);
END;
SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH FROM ALL_TAB_COLUMNS WHERE TABLE_NAME=’TEST’