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 <[email protected]> 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 <[email protected]> wrote: > >> SQL>@procedure_name.sql >> >> On Mon, Jan 31, 2011 at 1:15 PM, faisal khan <[email protected]>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 [email protected] >>> To unsubscribe from this group, send email to >>> [email protected] >>> 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 [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> 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 [email protected] > To unsubscribe from this group, send email to > [email protected] > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
