'getting error in oracle forms 10G but working in SQL developer

Dear All I am writing a code which is working fine in sqlplus or toad but not working in oracle forms can please anyone give me hint where i am doing worng

    INSERT INTO PROD_CUT_ISSU_MST (TRANS_ID, LOC_ID, DATED, FORM_DEPT_CODE, TO_DEPT_CODE,
                                    FINAL_IND, ISS_NUM, BUNDLE_QTY, COMP_CODE,ACTUAL_DATE)
           VALUES ((select MAX(T.TRANS_ID)+1  from prod_cut_issu_mst t ), 2, TRUNC(SYSDATE),
                                    13, 14, 'N',(prod_validations.get_autobar('PCI', 1,2 )),5,1, TRUNC(SYSDATE));

it throws this error in oracle forms but works fine plsql or toad

encountered the symbol "select" when expecting one of the following: (-+case...

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'getting error in oracle forms 10G but working in SQL developer

Sources

Related Questions