Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[4.2EA] formatter error (INSERT ... LOG ERRORS)

B.DelméeSep 29 2016 — edited Sep 29 2016

CREATE TABLE err_test ( ID INTEGER NOT NULL, VAL VARCHAR2(64));

EXEC dbms_errlog.create_error_log('ERR_TEST','ERR_TEST_ER');

INSERT INTO err_test (ID, val)

SELECT 1, 'one' FROM dual

LOG ERRORS INTO err_test_er(to_char(sysdate,'YYYY-MM-DD HH24:MI:SS')) REJECT LIMIT UNLIMITED;

formatting the insert statement results in

INSERT INTO err_test (ID, val)

SELECT 1, 'one' FROM dual

LOG ERRORS INTO err_test_er(to_char

/*** Syntax Error at line 2, column 36

LOG ERRORS INTO err_test_er(to_char(sysdate,'YYYY-MM-DD HH24:MI:SS')) REJECT LIMIT UNLIMITED;

                                    ^^^                                                      

Expected: '(',

***/(sysdate,'YYYY-MM-DD HH24:MI:SS')) REJECT LIMIT UNLIMITED;

Comments

661621
Do you want to change the linking between OIM Exchange connector and attribute proxy addresses? If you have the Exchange 9.1 connector that would be easy using attribute mapping. Could you specify the connector version.
661915
Hashtable ht = new Hashtable();
Vector msv = new Vector();
Vector msv1 = new Vector();
msv.add("SMTP:xxxx@gmail.com");
msv.add("smtp:zzzzzz@yahoo.co.in");
msv.add("X400:c=US;a= ;p=First Organizati;o=Exchange;s=gupta;g=vineet");
msv1.add("{26491CFC-9E50-4857-861B-0CB8DF22B5D7}");
ht.put("proxyAddresses", msv);
ht.put("msExchPoliciesExcluded", msv1);

and call Exchange apis passing this hashtable
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 27 2016
Added on Sep 29 2016
1 comment
152 views