Compiling Oracle Stored Procedure from VC++

[wallflowers]

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@dbstring @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

[Jim Kennedy]

Don't know about VC++. I use sqlplus and use show errors to see the error.
Jim
"wallflowers" <me*********@dbforums.com> wrote in message
news:30****************@dbforums.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@dbstring @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

[sybrandb]

wallflowers <me*********@dbforums.com> wrote in message news:<30****************@dbforums.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@dbstring @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