Re: How to kill a session (Script)

From: David A. Levy <david.a.levy_at_rogers.com>
Date: Wed, 30 Jan 2002 00:42:26 GMT
Message-ID: <SjH58.8958$bIE.2609_at_news1.bloor.is>

Hi Geoffrey,

What version of Oracle are you working with? EXECUTE IMMEDIATE works fine on my version (8.1.7), but it is a pretty new feature, not sure how many versions back it is available. In previous versions, dynamic SQL was available, but through the DBMS_SQL package. Check out DBMS_SQL.OPEN_CURSOR and DBMS_SQL.EXECUTE to open a cursor for your SQL statement and then execute it.

David. Received on Wed Jan 30 2002 - 01:42:26 CET

This message: [ Message body ]
Next message: Sree Pillai: "Java Stored procedure - Oracle 8i MalformedURLException: unknown protocol : https"
Previous message: Geoffrey: "Re: How to kill a session (Script)"
Maybe in reply to: Geoffrey: "How to kill a session (Script)"
Next in thread: Jim Kennedy: "Re: How does Oracle handles indexing?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message