Home » SQL & PL/SQL » SQL & PL/SQL » Re: Stored Procedure Problems
Re: Stored Procedure Problems [message #36857] Fri, 28 December 2001 02:33
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
You create a notepad and save it as a filename.sql and don't forget to select All Files from Save as Type .

And from sql prompt
SQL>@<path><filename>

And if you need to fire any DDL statement through procedure then you will have to go for Dynamic SQL . I hoep this will solve your problem .

Actually we have DB in Oracle and i am getting too many problems in converting the DB in SQL SERVER , not at programming level but at Administration .Do you know any message board for SQL Server .

----------------------------------------------------------------------
Previous Topic: Re: Mutating Trigger...More thoughts
Next Topic: Does Oracle 8.0.0.5 support the OBJECT feature ?
Goto Forum:
  


Current Time: Fri Mar 29 04:57:11 CDT 2024