Re: DBMS_SQL problem
Date: Wed, 01 Jul 1998 16:03:46 GMT
Message-ID: <6ndml1$ece$1_at_nnrp1.dejanews.com>
Forms 4.5 uses PL/SQL version 1, which cannot handle package variables like the "dbms_sql.v7" in your parse call. I get around this by using the number 1 in place of dbms_sql.v7. I think it is the value of the variable that you want to pass to the parse procedure.
As for another response recommending Forms_DDL, that command is fine unless you need to get something back from the database. Forms_DDL is a one-way street.
Hope this helps.
Steve Cosner
http://members.aol.com/stevec5088
Downloadable QA Utility Form: Display and update any table.
In article <35992917.6402432_at_nntp.uunet.ca>,
tomas_at_cmic.ca (Tomas CIRIP) wrote:
>
> Hi all,
>
> following code is ok when I am running in SQL*Plus. But when I try to
> compile it in Form Designer 4.5, I am getting error 302:
> Component v7 must be declared.
>
> dbms_sql.parse( Cursor_Id , t_select, dbms_sql.v7 );
>
> Thanks for help
>
> ---
> Tomas Cirip
> cviro_at_hotmail.com
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 01 1998 - 18:03:46 CEST