Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    US
    Posts
    4

    Unanswered: Creating a procedure inside a procedure

    We are having a requirement where list of procedures need to be created by another procedure.

    Any pointers how to do so.

    TIA
    Sippy

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Creating a procedure inside a procedure

    Originally posted by Sippy
    We are having a requirement where list of procedures need to be created by another procedure.

    Any pointers how to do so.

    TIA
    Sippy
    Hi,
    Please test with CREATE PROCEDURE FROM....

    Gustavo.

  3. #3
    Join Date
    Mar 2004
    Location
    US
    Posts
    4
    We have a specific requuirement.
    I'm trying to create/alter tables procedured through script. Script in turn will create a sql file with all necessary statements. From script one standard procedure will be created with sql statements in the file as body. If the sql statements in temprray file contains the create procedure then thsi is not working.

    TIA,
    Sippy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •