this like that create or replcace procedure abc as being
select col_name into var_name from table_name; end; On Mon, Jan 31, 2011 at 1:42 PM, faisal khan <mfaks...@gmail.com> wrote: > its like this > i am having a xyz.sql file. > i want to run this file as > > create or replcace procedure abc as > being > @c:\xyz.sql; -- this is error > end; > > but i cannnot use @ in this procedure, so is there is any other way > > > > > On Mon, Jan 31, 2011 at 11:17 AM, Farhan <punjabia...@gmail.com> wrote: > >> SQL>@procedure_name.sql >> >> On Mon, Jan 31, 2011 at 1:15 PM, faisal khan <mfaks...@gmail.com>wrote: >> >>> hi all >>> >>> how can i execute a .sql file in a store procedure >>> >>> thanks >>> >>> regards >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Oracle PL/SQL" group. >>> To post to this group, send email to Oracle-PLSQL@googlegroups.com >>> To unsubscribe from this group, send email to >>> oracle-plsql-unsubscr...@googlegroups.com >>> For more options, visit this group at >>> http://groups.google.com/group/Oracle-PLSQL?hl=en >> >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to Oracle-PLSQL@googlegroups.com >> To unsubscribe from this group, send email to >> oracle-plsql-unsubscr...@googlegroups.com >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en > > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
