Hi,

I'm trying to do just that. I've successfully managed to perform inserts, updates, deletes etc through a PTQ but I'm calling a working Stored Procedure in our Oracle 9i dbase and getting the following error message:

   ODBC--CAll Failed
   [Oracle][ODBC]Syntax error or access violation (#0)

Any ideas?

Thanks,

Aha!

After a couple of days of searching I found the answer! And after only minutes of posting on here...

No need to answer, but for those that need this VERY elusive command, here it is. It's not simply execute stored_proc, its...:

  {call tablespace.stored_proc};

Including the brackets!

Thanks for reading lol!!