Compiling Oracle Stored Procedure from VC++

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • wallflowers
    #1

    Compiling Oracle Stored Procedure from VC++


    Hi,

    I would like to know , how do I compile an oracle stored procedure or
    trigger from Visual C++ environment. I entered the sqlplus
    username/password@dbstri ng @filename command in the
    Custom Build step under Project Settings dialog box. Although I
    am able to
    submit the file to the server I am not able to get the errors.
    Since it just
    says that procedure was compiled with errors
    just as it would in an sqlplus session , where you would use show errors
    to
    display the errors. Is there any to compile from VC++ and still get the
    errors directly in the VC++ output window.
    Any advice is highly appreciated.
    I need to set this coz, we need to use source safe for version control.

    Thanks,
    Hari

    --
    Posted via http://dbforums.com
    Tags: None
    • Jim Kennedy
      #2
      Re: Compiling Oracle Stored Procedure from VC++

      Don't know about VC++. I use sqlplus and use show errors to see the error.
      Jim
      "wallflower s" <member32010@db forums.comwrote in message
      news:3047577.10 56653621@dbforu ms.com...
      >
      Hi,
      >
      I would like to know , how do I compile an oracle stored procedure or
      trigger from Visual C++ environment. I entered the sqlplus
      username/password@dbstri ng @filename command in the
      Custom Build step under Project Settings dialog box. Although I
      am able to
      submit the file to the server I am not able to get the errors.
      Since it just
      says that procedure was compiled with errors
      just as it would in an sqlplus session , where you would use show errors
      to
      display the errors. Is there any to compile from VC++ and still get the
      errors directly in the VC++ output window.
      Any advice is highly appreciated.
      I need to set this coz, we need to use source safe for version control.
      >
      Thanks,
      Hari
      >
      --
      Posted via http://dbforums.com

        Comment

        • sybrandb@yahoo.com
          #3
          Re: Compiling Oracle Stored Procedure from VC++

          wallflowers <member32010@db forums.comwrote in message news:<3047577.1 056653621@dbfor ums.com>...
          Hi,
          >
          I would like to know , how do I compile an oracle stored procedure or
          trigger from Visual C++ environment. I entered the sqlplus
          username/password@dbstri ng @filename command in the
          Custom Build step under Project Settings dialog box. Although I
          am able to
          submit the file to the server I am not able to get the errors.
          Since it just
          says that procedure was compiled with errors
          just as it would in an sqlplus session , where you would use show errors
          to
          display the errors. Is there any to compile from VC++ and still get the
          errors directly in the VC++ output window.
          Any advice is highly appreciated.
          I need to set this coz, we need to use source safe for version control.
          >
          Thanks,
          Hari
          Toad supports Visual Source Safe.
          There is no need to misuse VC++ to compile SPs.

          Sybrand Bakker
          Senior Oracle DBA

            Comment

            Previous template Next
            Working...