RE:SQLGLUE FOR ORACLE
Date: 1996/02/15
Message-ID: <4g02d7$6ab_at_news.ee.net>#1/1
"Hayes, Paul" <hayesp_at_uh2297p01.daytonoh.attgis.com> wrote:
>sounds interesting - Can you support stored procedures returning multiple
>result sets
>(plsql tables)
> ----------
SQLGlue is a dynamic SQL Method 4 engine, as defined by Oracle. In Shareware version 1, to be released the end of Feb. 96, the parser does not recognize PL/SQL blocks. The professional version will contain a parser which does.
This will allow dynamic PL/SQL blocks to be created and sent to SQLGlue for processing. SQLGLue does not contain a PL/SQL engine. As stated in the Oracle documentation for PL/SQL, such a host program sends the PL/SQL to the server as an anonymous PL/SQL block. The server will then parse out the PL/SQL constructs from the SQL statements and process them.
SQLGlue was designed to allow a developer to use any programming tool to perform the logic constructs provided by PL/SQL without the need for a precompiler. SQLGlue processes strings containing SQL statements -- one string one statement. With the professional version of SQLGlue a PL/SQL block is also processed as a single string statement.
So, If your question is will SQLGlue process PL/SQL tables locally, the answer is no. If your question is will SQLGlue accept PL/SQL blocks containing PL/SQL tables, the answer is yes.
Remember, PL/SQL is just a wrapper of logic around one or more SQL statements.
Think of SQLGlue's capabilities, like this, regarding your question --
if I can do it in SQL*Plus in can do it with SQLGlue.
Best wishes,
Mark
!!!!!
/'_at_ @'\
+---------------oOOo-----U-----oOOo---------------+
| Freelance software consultant specializing in |
| Oracle, C/C++, VB, Java, Win95, NT, & Internet |
| Mark Otero mpower_at_ee.net |
| MPower Your Future Today |
| 178 Beechbank Road (614) 338-1550 |
| Columbus, Ohio 43213-1261 Fax (614) 338-1553 |
+-------------------------------------------------+
| | | |
{__| |__}
Received on Thu Feb 15 1996 - 00:00:00 CET