Re: Stored Procedures

I have encountered this trying to use a pass-through query to execute an oracle stored procedure from Access. The fix was to make the pass-through look like a PL/SQL block.

Example:
PassThruStr = "DECLARE BEGIN MYPROC('Text1', 12) END;"

The end semi-colon may or may not be necessary.

Let me suggest that this is not the best way to do this, as it does not allow parameters to be returned from Oracle. Look up documentation on Remote Data Objects (RDO) for a more robust way of doing this.

Ben Salemi
Global Consulting Group

In article <35228BB1.F00A33D5_at_ecitele.com>,   Yacov Wolfowicz <yacovw_at_ecitele.com> wrote:
>
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 02 1998 - 00:00:00 CST