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
