Re: Help! Experts in pro*c and PL/SQL

In article <D1E5zI.MCG_at_mail.auburn.edu> vasudevy_at_eng.auburn.edu (Vasudev V. Yendapally) writes:

> EXEC SQL WHENEVER SQLERROR goto sql_error;
>
> EXEC SQL CONNECT :username IDENTIFIED BY :password;
>
> /******************
> I want to put a PL/SQL block here************************/
>
> EXEC SQL EXECUTE
>
> BEGIN
> spool result; /**I want to open result to spool the result into**/
> stmt; /*here I want to execute the statement */
> spool off;
> END;
>
> END-EXEC;
> /** End PL/SQL block**/

I guess I'm not reading your PL/SQL block correctly... but since when does PL/SQL support spooling? It looks more like a SQL*Plus script but a PL/SQL block! :)

For fun, you can write stmt into a flat file and try to fork()/exec() a SQL*Plus process to run the script. Then there is really no need to make a DB connection here. It can be a piece of old-fashion C code.

--
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
| Alvin Law .. Project Leader, Applications Division ... Oracle Corporation |
|  Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel