Sorry listers,
I spent a bit of time searching Google and quickly found my answer. I
shouldn't have rushed to post to the list. The answer is to move the INTO
clause outside of the string as shown below:
DECLARE
n_count NUMBER;
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM DUAL'
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