DBA Question! TRACE with DYNAMIC PL/SQL

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Tue, 24 Aug 1999 19:55:30 GMT
Message-ID: <7putba$djh$1@nnrp1.deja.com>

Hi,

Where is this TRACE file available for inspection? i received 'ORA-03113 : end-of-file on communication channel'. All i tried to do is bind a variable in a dynamic pl/sql block. i've given the pl/sql code at the end of this mail.

What the ora error document says is:

ORA-03113: end-of-file on communication channel

Cause: An unexpected end-of-file was processed on the communication chan-nel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the inter-process communication vehicle, that is, the network or server machine went down.

Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well estab-lished, and the error is not due to a physical failure, check if a trace file was gen-erated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.

i guess in my case, there couldn't have been a failure in connection! so how do i check the TRACE now?

Any help is appreciated.

---

PL/SQL CODE create or replace procedure p_dummy (

        v_from varchar2
) as

        v_cursor_id     integer;
        v_csr_ret       integer;
        v_csr_str       varchar2(2048);
        v_from_view     varchar2(32)    := v_from;

begin

        v_cursor_id :=  DBMS_SQL.OPEN_CURSOR;
        v_csr_str   :=  'declare
          cursor  view_cursor is select * from :from_view;
           begin
           dbms_output.put_line(''hi i am executed dynamically'');
          end;';
        DBMS_SQL.BIND_VARIABLE(v_cursor_id,':from_view',v_from_view);
        DBMS_SQL.PARSE(v_cursor_id,v_csr_str,DBMS_SQL.NATIVE);
        v_csr_ret   := DBMS_SQL.EXECUTE(v_cursor_id);
        DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

EXCEPTION
        when OTHERS then
                DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

end;

--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 24 1999 - 14:55:30 CDT