Re: Pro C: Can I separate sql functions into several programs in Pro C

Jacques Raymond Kilchoer wrote:
>
> Jun Wang wrote:
>
> > Hello, Everyone,
> >
> > I am working on a huge project to access Oracle database.
> > I plan to use Pro*C. Can I put sql functions into different
> > programs and link them together?
> >
> > It looks like that Pro*C does not allow you to do so
> > because it does not exchange db_connection context among the program.
>
> I'm not sure if I understand what you are trying to say. Do you mean different
> source codes (.C files) creating different objects that are linked together in
> one executable? That's certainly possible. Not all SQL statements need to be in
> the same source code.

Ditto. I do it all the time. But if you are connecting to multiple databases within a single Pro*C program, then it gets a little tricky.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||