Forms_ddl

user10991018

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();

Michael Ferrante-Oracle

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

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

https://community.oracle.com/tech/developers/discussion/comment/16794567#Comment_16794567

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