I think that this require a deeper investigation.
Last night I tried to use alter system sql_trace=true and it did not work
either.
I had to put sql_trace=true in init.ora and to bounce the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
prefix it with sys.
ie:
EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE);
Yechiel Adar <[EMAIL PROTECTED]>wrote:
I think that this require a deeper investigation.Last night I tried to use alter system sql_trace=true and it did not workeither.I had to put sql_trace=true in init.ora
I attended Cary's and Jeff's Hotsos Clinic last week. It was really
good. I wrote a short review, which probably doesn't do the course
justice, at the following URL:
http://www.oreillynet.com/pub/wlg/2111
I also wrote a short article last week about an aspect of Oracle's
newly-supported SQL92
hi
well i think i did this once, you can read
the output of the SQL query into shell variables by
first redirecting the output of the SQL query to an
OS file and then reading the file and loading
the data in the file into shell variables.
/* here is sample code to redirect the output of sql