Geeks Talk

Prepare for your Next Interview




Execute .sql file from procedure

This is a discussion on Execute .sql file from procedure within the Oracle forums, part of the Databases category; How to execute a .sql file from a procduer in oracle ?...


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 10-04-2008
Expert Member
 
Join Date: Apr 2007
Location: Bangalore
Posts: 447
Thanks: 20
Thanked 54 Times in 54 Posts
susarlasireesha is on a distinguished road
Execute .sql file from procedure

How to execute a .sql file from a procduer in oracle ?
__________________
sireesha
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 10-04-2008
Expert Member
 
Join Date: Sep 2007
Posts: 754
Thanks: 22
Thanked 64 Times in 63 Posts
krishnaindia2007 is on a distinguished road
Re: Execute .sql file from procedure

>>how to execute a .sql file from a procduer in oracle ?

sql> ed test.sql

delete from emp where empno=7788;

create or replace procedure test_pr as
begin
@test.sql;
commit;
end;
/

sql> execute test_pr;
pl/sql procedure successfully completed.

Sql> select * from emp
2 where empno =7788;
no rows selected
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
database procedure/function/package vs forms (program unit) package/procedure/packa jkverma29 Oracle 0 09-27-2008 07:38 AM
Execute Procedure Kanvik Oracle 2 09-23-2008 03:55 AM
Difference between Build script file, execute SQL ily_saravanan PeopleSoft 1 09-07-2007 07:51 AM
How can I execute a file which include 'create table ' statement Geek_Guest Oracle 1 07-17-2007 01:33 AM


All times are GMT -4. The time now is 01:51 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved