By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,323 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,323 IT Pros & Developers. It's quick & easy.

Compiling Oracle Stored Procedure from VC++

P: n/a

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
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.