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

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 support the OBJECT feature ?
Goto Forum:

Current Time: Sat May 25 08:34:04 CDT 2024