where is the xyz.sql file used?? On Mon, Jan 31, 2011 at 12:20 PM, Farhan <[email protected]> wrote:
> 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 > -- 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
