Hi You need to take your RBase blinders off ;-)
This is not the case in a myriad of other databases out there Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Troy Sosamon Sent: Thursday, September 26, 2002 12:48 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Executing Oracle PL/SQL Procedure in Tango 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 ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
