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: How can I TRACE my dynamic SQL sent to ORACLE SERVER?

Re: How can I TRACE my dynamic SQL sent to ORACLE SERVER?

From: Martin Dick <moogle_at_callplus.co.nz>
Date: 1997/11/28
Message-ID: <65marm$310$1@taliesin.netcom.net.uk>#1/1

Write the same string you send to the server to either a file, or a temporary table is what I do.
Then you can copy the string to SQL Plus and see what's wrong.

Cho YongHo wrote in message <65m8ev$pjm$1_at_n1.HanQ.net>...
>I'm using Dynamic Type 3 written ProC..
>
>when I execute it , I've gotten the ERROR of 'ORA-00933: SQL command not
>properly ended'..
>and I wish to see exactly which statement is sent to my SERVER..
>
>Is there any way or tool I can do this with??
>
>
Received on Fri Nov 28 1997 - 00:00:00 CST

Original text of this message

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