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!
Hello, I need this version to a database test on red hat linux, please if somebody can help me I wil be grateful, because I know that is not available on Oracle OTN page.
BEGIN UPDATE doc_number SET doc_nbr = doc_nbr + 1 WHERE REGISTER = pregscode AND doc_code = pdoccode RETURNING TO_CHAR (doc_nbr, '0000000') INTO vdocno; IF SQL%ROWCOUNT = 0 THEN INSERT INTO doc_number VALUES (myregister, mydoc_code, mydoc_nbr ) RETURNING TO_CHAR (doc_nbr, '0000000') INTO vdocno; END IF; END; /