Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL web strange problem

Re: PL/SQL web strange problem

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 13 Mar 2004 15:58:10 -0800
Message-ID: <meN4c.24829$BA.17315@fed1read03>


Bob Le Brocq wrote:
> On Sat, 13 Mar 2004 11:36:39 -0800, "Ana C. Dent"
> <anacedent_at_hotmail.com> wrote:
>
>

>>Bob Le Brocq wrote:
>>
>>>Hi all
>>>
>>>I've a strange problem. I have a PL/SQL procedure on my database. For
>>>testing, it simply outputs hello world using htp, and then also
>>>inserts a row into a known table (so that I know it has executed even
>>>if the answer can't be seen).
>>
>>
>>Am I correct to "assume" that you explicitly COMMIT after the INSERT?

>
>
> yes I explicitly commit after the insert. Is there a particular log
> file which I could look at to shed more light on the matter?

Since it would help if you had more/better visibility regarding what is or is not happening, you might want to consider one or more of the following:
1) enable "extensive" AUDITing
2) in initSID.ora file add the following line event="10046 trace name context forever, level 8" 3) trying adding debug visibility using UTL_FILE 4) Simplify, simplify, simplify (comment out the stuff doing web output) Received on Sat Mar 13 2004 - 17:58:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US