Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    6

    Unanswered: Prepare statement in a stored procedure.

    Is it possible to use a prepare statement in a stored procedure.

    I have a need to dynamically create a select statement, but I'm having trouble with the PREPARE statement within my Stored Procedure.

    Any suggestions?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Take at look at the following page - look at what is allowed or not allowed within the statement block:

    page

  3. #3
    Join Date
    Oct 2002
    Posts
    6
    Thanks...

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    No problemo.

Posting Permissions

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