executing parsed PLSQL block statement at a time
From: Gregory S. Lipman <gregl59_at_nfi.com>
Date: 1996/06/22
Message-ID: <31CC5E74.9DF_at_nfi.com>#1/1
Date: 1996/06/22
Message-ID: <31CC5E74.9DF_at_nfi.com>#1/1
Hi there
What i am doing is parsing PLSQL block or
body of stored procedure and executing it one
statement at a time in PB4 dynamic SQL.
Of course statements from such a block do not live in
vacuum, the may reference input params and local vars,
so basically i have to keep them alive during a life of
connection. In SQL*Plus i try in the begining of session
to DECLARE a variable BUT it would not accept it as a
separate statement. PowerBuilder also returns error if you send
only DECLARE var .. alone.
Question : Is there such a thing in ORACLE as variable for a
session, not just block.
Question : Does dynamic SQL in PB allow to send PLSQL block in
one stroke.
Thank, Gregory
Received on Sat Jun 22 1996 - 00:00:00 CEST