Re: PRO*C & Stored Procedures

Check if you have access to run the procedure on the development box. You might need to create a public synonym.
Michael Plakus <grendel_at_technologist.com> wrote in article <692rtt$24k$0_at_208.10.2.144>...
> I would like to write a PRO*C program to call a stored procedure. I've
> got it to work, but I have to specify the database name as part of the
> call. When I do this and run on our development box it works fine,
> however the database name on the production box is different than the
> database name on the developement box. When I copy the compiled code to
> the development box it won't run. I've tried changing the name of the
> database on the development box, but PRO*C must validate, because I get
> a compiler error reporting the stored procedure is not there. Is there a
> way to code this so I don't have to put the database name in the
> program?
>
> Thanks.
>
> --
> Bright images flashing by
> Like windshields towards the fly
>
>
>
Received on Mon Jan 12 1998 - 00:00:00 CET