Forum Stats

  • 3,750,513 Users
  • 2,250,187 Discussions
  • 7,866,997 Comments

Discussions

Forms_ddl

user10991018
user10991018 Member Posts: 142 Blue Ribbon

Hello,

I am trying to insert non database items to a temporary table in orcle forms.

tried to run the below query

and not inserting any information from global stint and the block.item checked value

can you please advise.

thanks.

my data in globa variable stores as follow(

0,120,130,140) need the comma separated values in a different row with checked/unchecked value from the blcok

thanks.


forms_ddl('Insert into GLOB_TEMP (EMP_ID,EMP_ID_CHK,EMP_LVL)

SELECT DISTINCT

  TRIM(regexp_substr(:global.mystring, ''[^,]+'', 1,:EMP.EMP_ID, level)) value,

  level

FROM

  dual

CONNECT BY

  regexp_substr(:global.mystring, ''[^,]+'', 1, level) IS NOT NULL

ORDER BY

  level)'

);


forms_ddl('commit');


go_block('GLOB_TEMP');


execute_query();

Answers

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,803 Employee

    So that everyone can understand the detail, please provide more info. For example:

    1. Exactly which Forms and Database version are you using? Keep in mind the version number should include the complete number and not something like 11g, 12c. These are not version numbers.
    2. You said you tried the above. What happens when you do? Does an unexpected value get returned? Does nothing happen? Is there an error? And so on...

    Any other details about what you are doing and what you expect would be helpful.

  • user10991018
    user10991018 Member Posts: 142 Blue Ribbon

    forms version is forms [32 Bit] Version 11.1.1.7.0 (Production)

    oracle database version is

    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


    what i am trying to do is

    insert the data in a temporary table when select a value using checkbox.

    so i am storing the value in a comma separated global variable and when i check or uncheck the values should insert in my temp table.

    i am using when checkbox changed trigger to select the multi record block rows

    1) eg.

    :global.empid = (120,121,134)

    :emp_chk = ('y','n','y')

    this should insert dynamically using forms_ddl in temp table.

    please advise

    thanks.

  • sgalaxy
    sgalaxy Member Posts: 5,691 Bronze Trophy

    Many 'should' but no 'what happens' when trying to execute the code you've written...