Re: Stored Procedures

I had a similar problem calling stored procs from VB when using INTERSOLV's SEQUELINK driver - 0RA-00942 table or view not found

Problem turned out to be the Sequelink listener on the Oracle server was not fully installed. Took six weeks to trace the problem and only 5 minutes to fix.

Hope this info helps.
Dennis Wetherell
Yacov Wolfowicz <yacovw_at_ecitele.com> wrote in article <35228BB1.F00A33D5_at_ecitele.com>...
> Hi all,
>
> Can anybody help me with this one : calling an Oracle stored procedure
> from a VC++ program causes an exception ("ORA-00900: invalid SQL
> statement") while calling the same procedure from SQL* Plus yeilds the
> long awaited result : "PL/SQL procedure successfully completed."
>
> I'm using Oracle7.3.3.5.2, VC++4.2, INTERSOLV 3.01 ODBC driver, NT 4 .
>
> What's happening here?
> Thanks in advance,
> Yaki
>
> --
> Life is hard...
> and then you die
>
>
>
  Received on Thu Apr 02 1998 - 00:00:00 CEST