SQL & PL/SQL

Hi Friends,

Here is my Scenario

I have a PL/SQL Package. Let us call it Baseline Package.

This Package includes a dynamically built merge Statement.

Execute Immediate v_merge_query.

I have a procedure which replaces which few Keywords from the Package Text and Creates a new one depending on Inputs I provide. (This is something like a Code generator)

Now while Creating the new package, I need to print the Value of v_merge_query.... I Need s Static Query to be Printed inside the new package and not a dynamic query.

My Question is "Is there a way to print the value of the variable inside a different PL/SQL package?

Thanks in Advance,
Mohit