Savepoints

From: <bhogak_at_my-dejanews.com>
Date: Tue, 15 Sep 1998 00:26:18 GMT
Message-ID: <6tkc79$a4g$1@nnrp1.dejanews.com>

Dear all,

Is there anyway to create savepoint using Procedures/functions within a pl/sql block? Something like this: create procedure set_sp(spname in varchar2) as begin set savepoint spname; end; I wish to call this proc inside other procedures to set the savepoint.
Is there anyway to call a sql file from pl/sql block? I usually need to use the SET commands,(serveroutput etc).

Thanks in advance.
Kumar

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 14 1998 - 19:26:18 CDT