Hi Ben,
I tried using execute <Procedure Name>('<Parameter>') Which resulted me in
the below error.
When I tried using call <Procedure Name>('<Paramenter>') I got the same
error.
Could you please give me an example by using Select statement to execute a
query in DIRECT_DBMS.
Thanks
Manohar
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ben Johansen
Sent: Thursday, September 26, 2002 11:45 AM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: Executing Oracle PL/SQL Procedure in Tango
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
