Stored procedure question

Posted on 2011-10-25
Last Modified: 2012-06-21
I read in the following stored procedure:

   CREATE procedure DropIt ()
     modifies sql data
      drop table catalog;

Open in new window

The language is SQL.  Do most stored procedures use LANGUAGE SQL.  Any any written in other directives, if so what.  Can a 'C' program access the Stored procedure written above?

Question by:Los Angeles1
    1 Comment
    LVL 45

    Accepted Solution

    Hi Greensburo,

    The language that is used to write a SQL Stored Procedure has no bearing on other procedures.  If a user has the authority to run procedures A and B, then one can be in SQL, another in SQL, C, JAVA, etc.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now