| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with DBMS_SQL.PARSE when called from Repots2.5
In article <5eg7uc$7hj$1_at_newsin-1.starnet.net>,
Adam Tadj <vahidt_at_vahidtpc.vitek.com> wrote:
>I am trying to run the following PL/SQL code from the Reports2.5 :
>===================================================
<snip>
> DBMS_SQL.PARSE
> (cursor_handle, 'SELECT 2+2 from DUAL' , DBMS_SQL.V7);
<snip>
>==================================================
>and I am getting the following error message:
>"component V7 must be declare".
>(cursor stops at DBMS_SQL.V7 as marked "^^^") and fails to compile.
> ^^^
>But when I compile/run a very similar code from Procedure Builder or
>SQL> prompt it works just fine. Any remedies or hints?
The same thing happens in Forms, and I believe it is because Forms uses PL/SQL V1 instead of V2. Use the number 1 in place of DBMS_SQL.V7, and it should compile.
You can see that 1 is the same as DBMS_SQL.V7 by looking through the script that creates the DBMS_SQL package.
HTH
Steve Cosner
 |
 |