Re: Stored procedures - executing
From: Carl Gohringer <cgohring_at_lucifer>
Date: Wed, 10 Aug 1994 13:51:16 GMT
Message-ID: <CuBntG.3F_at_nl.oracle.com>
Date: Wed, 10 Aug 1994 13:51:16 GMT
Message-ID: <CuBntG.3F_at_nl.oracle.com>
is40509_at_otago.ac.nz writes:
: there are no errors identified.
: the program attaches to the database fine.
:
: it seams that the stored procedure (insert_customer) doesn't execute.
:
No errors of any sort?
In the program, execute
ALTER SESSION SET SQL TRACE TRUE;
This will generate a trace file on the server which you can examine for more
detail on exactly what SQL is being submitted to the RDBMS.
-- regards, Carl +-----------------------------------------------------------------------------+ Carl Gohringer, Oracle UK, The Oracle Centre, The Ring, Bracknell, Berkshire, England, RG121BW Internet : cgohring_at_uk.oracle.com +-----------------------------------------------------------------------------+Received on Wed Aug 10 1994 - 15:51:16 CEST