1 Reply Latest reply: Aug 3, 2011 10:40 AM by Steve.Clamage-Oracle RSS

    FORMS_DDL with select into

    115856
      Hi,

      Here my code for un dynamic query in ORACLE FORMS

      ls_query:=' select count(*) into '     ||     pkg_hist.pkg_count_pdt ||' from      FN_WAVE_PROD_HIER_DETAIL where PROD_HIER_ID='||:b_produit.PROD_HIER_ID      ||' and division ='|| :b_produit.division || pkg_and_clause ;

      Forms_ddl ( ls_query );


      /* Where pkg_and_clause contains the dynamic statement

      and pkg_hist.pkg_count_pdt is a package variable

      */

      I got the following error : ORA-24374: define not done before fetch or execute and fetch

      Does this code can works ?

      regards

      Edited by: Totem92 on 3 août 2011 07:57