RE: dbms_sql URGENT

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Mon, 31 Jul 2000 10:31:49 -0400
Message-Id: <10575.113365@fatcity.com>

Try posting your code .... that might help solve problem ...

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

-----Original Message-----
From: Jorge Luiz Alves [mailto:jalves_at_mdic.gov.br] Sent: Friday, July 28, 2000 4:19 PM
To: Multiple recipients of list ORACLE-L Subject: dbms_sql URGENT

Hi all,

I wrote a storage procedure that create a update statement, parse and execute using dbms_sql. My problem consist that, if i take a genated sql statment and execute in the sqlplus it runs quikly and wait for a commit command, but i the storage procedure it takes a long time like two hours and do nothing. What probably happen. If someone could help me...

Thanks in advance.

Jorge Alves.

-- 
Author: Jorge Luiz Alves
  INET:

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jul 31 2000 - 09:31:49 CDT