:
Sent by: Subject: EXECUTE IMMEDIATE and PL/SQL
variables???
[EMAIL PROTECTED
This can be done using a Package Variable.
Here are the steps :-
(1) Package Specification
=
CREATE OR REPLACE PACKAGE DSQL AS
n_TestValue NUMBER;
FUNCTIONGetValue RETURN NUMBER;
END;
(2) Package Body
CREATE OR REPLACE PACKAGE BODY
Hi List,
I know someone will have a good answer to this question:
I have a large PL/SQL program to convert some data. Some tables are
created dynamically during the PL/SQL procedure using EXECUTE IMMEDIATE. I
need to query values from some of these tables (only a couple of rows, so
