Re: Executing Stored Procedures from end-user tools
From: Dave Mausner <dmausner_at_interaccess.com>
Date: 12 Apr 1994 22:44:18 GMT
Message-ID: <2of882$ec7_at_mailhost.interaccess.com>
Date: 12 Apr 1994 22:44:18 GMT
Message-ID: <2of882$ec7_at_mailhost.interaccess.com>
Recently, Steve Stansfield posted:
: However, I haven't had any luck executing this procedure from an end-user tool
: such as Q+E 5.0 or Microsoft Query. I get an invalid SQL
: statement.
: Is there a trick in executing an Oracle stored procedure from a external
: application????
unfortunately the trick is that the end-user tool has to understand pl/sql syntax, and that limits your choices largely to products offered by oracle. it is possible to write your own interface which is oracle-aware and compatible with a gui toolkit.
sybase tools work because sybase has its own stored procedure language, hence also a procedure call capability.
-- Dave Mausner / Sr Consultant / Braun Technology Group / Chicago, IL USA No opinions have been expressed. Motto: "Show me the code"Received on Wed Apr 13 1994 - 00:44:18 CEST