I've tested it with Oracle XE 10.2.0.1.0 (10g) - (ubuntu 8.04).
Data source fields were generated with length 10 for both fields "NCHAR" and
"TCHAR" (script below):
Code:
CREATE TABLE "ORACLE_TEST" ( "PK" NUMBER(10,0), "NCHAR" VARCHAR2(10), "TCHAR" VARCHAR2(10 CHAR), CONSTRAINT "ORACLE_TEST_PK" PRIMARY KEY ("PK") ENABLE ) / CREATE OR REPLACE TRIGGER "BI_ORACLE_TEST" before insert on "ORACLE_TEST" for each row begin select "ORACLE_TEST_SEQ".nextval into :NEW.PK from dual; end; / ALTER TRIGGER "BI_ORACLE_TEST" ENABLE /
Code:
NLS_CALENDAR GREGORIAN NLS_CHARACTERSET AL32UTF8 NLS_COMP BINARY NLS_CURRENCY $ NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_DUAL_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_LANGUAGE AMERICAN NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_NCHAR_CONV_EXCP FALSE NLS_NUMERIC_CHARACTERS ., NLS_SORT BINARY NLS_TERRITORY AMERICA NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
Regards,
Alius
Leave a comment: