Skip to Main Content

ORDS, SODA & JSON in the Database

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!

configration issues of apex listener on oracle 10g xe and glassfish

785809Jul 22 2010 — edited Aug 30 2010
HI,

I have updated successfully to apex 4 on my oracle 10xe ..and deployed apex listener 1.10. to glassfish v3 server... i think i have done it successfully since i am able to see the apex listener config page...Now when i am configuring the apex listner config page with the help of apex listener docs....its showing errors:


I am also able to set Connection settings but very confused about settings of caching , pre proccessing and others...please help about setting of others requirement of apex config.and about the procedures, schema , functions and packages I need to set ...i am new to it.



Regards.
Tanveer

Edited by: Tanveer on Jul 22, 2010 10:40 PM

Comments

MichaelS
Maybe this:
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;
/
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 27 2010
Added on Jul 22 2010
4 comments
1,743 views