You need a valid select statement. Try this: SELECT procedure(param1,param2) from sys_tables where limit = 1;
Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 9/26/02 12:15 am >what was the statement? > >sometimes you have to do a "CALL" or "SELECT Procedure()" in the direct dbms >examples >1. CALL Procedure(Param1,Param2) >2. SELECET Procedure(Param1,Param2) > >Ben Johansen - http://www.pcforge.com >Authorized WiTango Reseller >http://www.pcforge.com/WitangoGoodies.htm >latest beta downloads @ http://www.witango.ws > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED]]On Behalf Of P.S. Manohar >Sent: Wednesday, September 25, 2002 10:55 PM >To: Multiple recipients of list witango-talk >Subject: Witango-Talk: Executing Oracle PL/SQL Procedure in Tango > > >Hi All, > >I tried to execute an oracle procedure using DIRECT_DBMS. I got the >following error. Can anyone explain me about this problem? Is there any >other method to do the same. Kindly get back to me on this. > >Error >An error occurred while processing your request: >File: testproc.taf >Position: Direct_DBMS >Class: DBMS >Main Error Number: 900 > > >ORA-00900: invalid SQL statement > > >File: testproc.taf >Position: Direct_DBMS >Class: Internal >Main Error Number: -101 > > >General error during data source operation. > > > >Thanks in advance > >Manohar > >+--EOM--+ > >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
